[RESOLVED] Data output to forms

OmegaB

When I try to output the data to the HTML forms, I just get a blank page with no tables or anything,
here is the code:

<?php
session_start();
if (isset($_SESSION['access']))
{
    if ($_SESSION['access'] == 1) 
	{
	if(!mysql_connect('server', 'user' , 'pass'))
	{
	echo 'Connection failed. Please try again.';
	exit;
	}
	else
	{
	$db_link = mysql_connect('server', 'user', 'pass');
		if (!mysql_select_db('database', $db_link))
		{
		echo 'Error selecting database.';
		exit;
		}
	}	
	$sql = 'SELECT * FROM `tutorinfo` WHERE \'UWO_NUM\' = \'416922\' LIMIT 0, 30'; 
	$result = mysql_query($sql,$db_link);
	}

else
{
echo 'You are not logged in.';
exit;
}
}
while ($row = mysql_fetch_assoc($result))
{


?>
<html>
<form method="post" action="<?php echo $PHP_SELF;?>">
    <table border="0" cellspacing="5" cellpadding="0">
        <tr>
            <td>UWO Number:</td>
            <td><input type="text" size="12" maxlength="20" name="UWO_NUM" value = "<?echo $row['UWO_NUM'];?>"  ></td>
        </tr>
        <tr>
            <td>Last Name:</td>
            <td><input type="text" size="12"  name="Last_Name" value = "<?echo $row['Last_Name'];?>"></td>
        </tr>
        <tr>
            <td>First Name:</td>
            <td><input type="text" size="12" name="First_Name" value = "<?echo $row['Phone_Num'];?>"> </td>
        </tr>
        <tr>
            <td>Phone Number:</td>
            <td><input type="text" size="12" maxlength="10" name="Phone_Num" value = "<?echo $row['Extension'];?>"></td>
        </tr>
        <tr>
            <td>Extension:</td>
            <td><input type="text" size="12" maxlength="10" name="Extension" value = "<?echo $row['Hide_Num'];?>"></td>
        </tr>
        <tr>
            <td>Hide Number?</td>
            <td><input type="radio" value="Yes" name="Hide_Num"> Yes <input type="radio" value="No" name="Hide_Num"> No</td>
        </tr>
        <tr>
            <td>Email Address:</td>
            <td><input type="text" size="12" name="Email_Address" value = "<?echo $row['Email_Address'];?>"></td>
        </tr>
        <tr>
            <td>Faculty:</td>
            <td><input type="text" size="12" name="Faculty" value = "<?echo $row['Faculty'];?>"></td>
        </tr>
        <tr>
            <td>Program Name:</td>
            <td><select name="Program_Name">
                    <option value="Science">Science</option>
                    <option value="MIT">MIT</option>
                    <option value="SocialSci">Social Science</option>
            </select></td>
        </tr>
        <tr>
            <td>Year:</td>
            <td><select name="Years_Study">
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
            </select></td>
        </tr>
        <tr>
            <td>Bio:</td>
            <td><textarea rows="5" cols="20" name="Bios" wrap="physical">Tell us something about yourself!</textarea></td>
        </tr>
        <tr>
        	<td></td>
        	<td><input type="submit" value="Submit" name="submit"></td>
    </table>
</form>
</html>
<?php
}
?>

Can anyone tell me what's wrong? Thanks.😕

bradgrafelman

Well if $_SESSION['access'] isn't set then you aren't outputting anything, so... have you verified that the variable does indeed exist?

Also, your SQL query has an impossible WHERE condition, as you're comparing the string 'UWO_NUM' to see if it's equal to the string '416922', which it never is. Perhaps you meant the column UWO_NUM? If so, the backtick (`) is the default identifier in MySQL - single quotes are used to delimit strings.

OmegaB

Yeah I meant the column lol

I still can't get the query right though...

$sql = "SELECT * FROM `tutorinfo` WHERE `UWO_NUM` = '$_POST['tutorid']' LIMIT 0, 30";

What I want to do is select everything from the tutorinfo table, where the UWO_NUM equals the tutorid submitted by a form in a previous page through post.

I get this error :

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\XAMPP\htdocs\update.php on line 21

and yeah i think I did confirm the session existed since I wrote that it should exit if $_session[access] was not equal to 1.

bradgrafelman

Your parse error is being caused by the fact that you've got a quoted array index inside of a string. There are a few different ways you can fix that; use complex syntax, remove the quotes around the array index, split the string up and use concatenation, etc. See the manual page for [man]string[/man] for more information/examples.

OmegaB

Okay, now that the parse error is fixed (fixed by storing the array value into a variable), the thing is that the page keeps coming up blank.

<?php
session_start();
if (isset($_SESSION['access']))
{
    if ($_SESSION['access'] == 1) 
	{
	if(!mysql_connect('*****', '*****' , '*****'))
	{
	echo 'Connection failed. Please try again.';
	exit;
	}
	else
	{
	$db_link = mysql_connect('*****', '*****', '*****');
		if (!mysql_select_db('******', $db_link))
		{
		echo 'Error selecting database.';
		exit;
		}
	}
	$uwonum= $_POST['tutorid'];
	$sql = 'SELECT * FROM `Tutor_Info` WHERE `UWO_NUM` = \'$uwonum\' ';
	$result = mysql_query($sql,$db_link);
        var_dump($result);
	}

else
{
echo 'You are not logged in.';
exit;
}
}
while ($row = mysql_fetch_assoc($result))
{


?>
<html>
<form method="post" action="<?php echo $PHP_SELF;?>">
    <table border="0" cellspacing="5" cellpadding="0">
        <tr>
            <td>UWO Number:</td>
            <td><input type="text" size="12" maxlength="20" name="UWO_NUM" value = "<?echo $row['UWO_NUM'];?>"  ></td>
        </tr>
        <tr>
            <td>Last Name:</td>
            <td><input type="text" size="12"  name="Last_Name" value = "<?echo $row['Last_Name'];?>"></td>
        </tr>
        <tr>
            <td>First Name:</td>
            <td><input type="text" size="12" name="First_Name" value = "<?echo $row['Phone_Num'];?>"> </td>
        </tr>
        <tr>
            <td>Phone Number:</td>
            <td><input type="text" size="12" maxlength="10" name="Phone_Num" value = "<?echo $row['Extension'];?>"></td>
        </tr>
        <tr>
            <td>Extension:</td>
            <td><input type="text" size="12" maxlength="10" name="Extension" value = "<?echo $row['Hide_Num'];?>"></td>
        </tr>
        <tr>
            <td>Hide Number?</td>
            <td><input type="radio" value="Yes" name="Hide_Num"> Yes <input type="radio" value="No" name="Hide_Num"> No</td>
        </tr>
        <tr>
            <td>Email Address:</td>
            <td><input type="text" size="12" name="Email_Address" value = "<?echo $row['Email_Address'];?>"></td>
        </tr>
        <tr>
            <td>Faculty:</td>
            <td><input type="text" size="12" name="Faculty" value = "<?echo $row['Faculty'];?>"></td>
        </tr>
        <tr>
            <td>Program Name:</td>
            <td><select name="Program_Name">
                    <option value="Science">Science</option>
                    <option value="MIT">MIT</option>
                    <option value="SocialSci">Social Science</option>
            </select></td>
        </tr>
        <tr>
            <td>Year:</td>
            <td><select name="Years_Study">
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
            </select></td>
        </tr>
        <tr>
            <td>Bio:</td>
            <td><textarea rows="5" cols="20" name="Bios" wrap="physical">Tell us something about yourself!</textarea></td>
        </tr>
        <tr>
        	<td></td>
        	<td><input type="submit" value="Submit" name="submit"></td>
    </table>
</form>
</html>
<?php

}
?>

With the vardump, I only get

resource(3) of type (mysql result)

, on the page.
I don't see what's going wrong here, because a mysql result is fetched, and this should activate the while loop, since there is something. Additionally, the html should be displayed too since it is in the while loop.

bradgrafelman

You should really learn to indent your code properly so that it's easier to read.

OmegaB wrote:
mysql result is fetched, and this should activate the while loop

Not necessarily; just because a result set is retrieved doesn't mean that a non-empty result set was sent back.

OmegaB

Ok sorry, I hope this is better.
I changed the sql query a little, (removed the \, I think what happened was that it added literal apostrophes to the query, found none, returned a blank result and thus the while loop didn't run.) Now the while loop does run, but the php code does not echo out the variables in the array properly. Instead.... I get something like this:

http://imgur.com/tOKf6.jpg

And here's the code:

<?php
session_start();
if (isset($_SESSION['access']))
{
    if ($_SESSION['access'] == 1) 
	{

	if(!mysql_connect('***', '****' , '*****'))
	{
	echo 'Connection failed. Please try again.';
	xit;
	}
		else
		{
		$db_link = mysql_connect('***', '***', '***');
			if (!mysql_select_db('*****', $db_link))
			{
			echo 'Error selecting database.';
			exit;
			}
		}
$uwonum= $_POST['tutorid'];
$sql = "SELECT * FROM `Tutor_Info` WHERE `UWO_NUM` = '$uwonum' ";
$result = mysql_query($sql,$db_link);
var_dump($result);
}
				else
				{
				echo 'You are not logged in.';
				exit;
				}
}


while ($row = mysql_fetch_assoc($result))
{


?>
<html>
<form method="post" action="<?php echo $PHP_SELF;?>">
    <table border="0" cellspacing="5" cellpadding="0">
        <tr>
            <td>UWO Number:</td>
            <td><input type="text" size="12" maxlength="20" name="UWO_NUM" value = "<? echo $row['UWO_NUM'];?>"  ></td>
        </tr>
        <tr>
            <td>Last Name:</td>
            <td><input type="text" size="12"  name="Last_Name" value = "<? echo $row['Last_Name'];?>"></td>
        </tr>
        <tr>
            <td>First Name:</td>
            <td><input type="text" size="12" name="First_Name" value = "<? echo $row['Phone_Num'];?>"> </td>
        </tr>
        <tr>
            <td>Phone Number:</td>
            <td><input type="text" size="12" maxlength="10" name="Phone_Num" value = "<? echo $row['Extension'];?>"></td>
        </tr>
        <tr>
            <td>Extension:</td>
            <td><input type="text" size="12" maxlength="10" name="Extension" value = "<? echo $row['Hide_Num'];?>"></td>
        </tr>
        <tr>
            <td>Hide Number?</td>
            <td><input type="radio" value="Yes" name="Hide_Num"> Yes <input type="radio" value="No" name="Hide_Num"> No</td>
        </tr>
        <tr>
            <td>Email Address:</td>
            <td><input type="text" size="12" name="Email_Address" value = "<? echo $row['Email_Address'];?>"></td>
        </tr>
        <tr>
            <td>Faculty:</td>
            <td><input type="text" size="12" name="Faculty" value = "<? echo $row['Faculty'];?>"></td>
        </tr>
        <tr>
            <td>Program Name:</td>
            <td><select name="Program_Name">
                    <option value="Science">Science</option>
                    <option value="MIT">MIT</option>
                    <option value="SocialSci">Social Science</option>
            </select></td>
        </tr>
        <tr>
            <td>Year:</td>
            <td><select name="Years_Study">
                    <option value="1">1</option>
                    <option value="2">2</option>
                    <option value="3">3</option>
                    <option value="4">4</option>
                    <option value="5">5</option>
            </select></td>
        </tr>
        <tr>
            <td>Bio:</td>
            <td><textarea rows="5" cols="20" name="Bios" wrap="physical">Tell us something about yourself!</textarea></td>
        </tr>
        <tr>
        	<td></td>
        	<td><input type="submit" value="Submit" name="submit"></td>
    </table>
</form>
</html>
<?php

}
?>

bradgrafelman

That would seem to suggest that your PHP installation has the short_tags directive disabled (which it should be!). As such, you should be sure to always use the full '<?php' tag and never use the '<?' short tag for PHP code.

OmegaB

Oh I see, that worked thank you!

Okay the whole thing is fixed, if anyone(newbies) is interested in an example of how to make a mysql data output form, its here:

<?php
session_start();
if (isset($_SESSION['access']))
{
    if ($_SESSION['access'] == 1) 
	{

	if(!mysql_connect('******', '******' , '******'))
	{
	echo 'Connection failed. Please try again.';
	exit;
	}
		else
		{
		$db_link = mysql_connect('*****', '******', '****');
			if (!mysql_select_db('*****', $db_link))
			{
			echo 'Error selecting database.';
			exit;
			}
		}
$uwonum= $_POST['tutorid'];
$sql = "SELECT * FROM `Tutor_Info` WHERE `UWO_NUM` = '$uwonum' ";
$result = mysql_query($sql,$db_link);

}
				else
				{
				echo 'You are not logged in.';
				exit;
				}
}


while ($row = mysql_fetch_assoc($result))
{




?>
<html>
<form method="post" action="<?php echo $PHP_SELF;?>">
    <table border="0" cellspacing="5" cellpadding="0">
        <tr>
            <td>UWO Number:</td>
            <td><input type="text" size="12" maxlength="20" name="UWO_NUM" value = "<?php echo $row['UWO_NUM'];?>"  ></td>
        </tr>
        <tr>
            <td>Last Name:</td>
            <td><input type="text" size="12"  name="Last_Name" value = "<?php echo $row['Last_Name'];?>"></td>
        </tr>
        <tr>
            <td>First Name:</td>
            <td><input type="text" size="12" name="First_Name" value = "<?php echo $row['First_Name'];?>"> </td>
        </tr>
        <tr>
            <td>Phone Number:</td>
            <td><input type="text" size="12" maxlength="10" name="Phone_Num" value = "<?php echo $row['Phone_Num'];?>"></td>
        </tr>
        <tr>
            <td>Extension:</td>
            <td><input type="text" size="12" maxlength="10" name="Extension" value = "<?php echo $row['Extension'];?>"></td>
        </tr>

<?php

	if ($row['Hide_Num'])
	{
            $row = array("Hide_Num" => "checked");
	}

?>
        <tr>
			<td>Hide Number?<input type="checkbox" name="" value="1" <?php echo $row['Hide_Num']?> /></td>
        </tr>
<?php
	}
mysql_data_seek($result, 0);
while ($row = mysql_fetch_assoc($result))
{
?>
        <tr>
            <td>Email Address:</td>
            <td><input type="text" size="12" name="Email_Address" value = "<?php echo $row['Email_Address'];?>"></td>
        </tr>
        <tr>
            <td>Faculty:</td>
            <td><input type="text" size="12" name="Faculty" value = "<?php echo $row['Faculty'];?>"></td>
        </tr>
        <tr>
            <td>Program Name:</td>
            <td><select name="Program_Name">
                    <option value="Science">Science</option>
                    <option value="MIT">MIT</option>
                    <option value="SocialSci">Social Science</option>
            </select></td>
        </tr>
        <tr>
            <td>Years Studied:</td>
			<td><input type="text" size="12" name="Years_Study" value = "<?php echo $row['Years_Study'];?>"></td>
        </tr>
        <tr>
            <td>Bio:</td>
            <td><textarea rows="5" cols="20" name="Bios" wrap="physical"><?php echo $row['Bios'];?></textarea></td>
        </tr>
        <tr>
        	<td></td>
        	<td><input type="submit" value="Submit" name="submit"></td>
    </table>
</form>
</html>
<?php
}

?>

Thanks again!

bradgrafelman

Glad I could help. Don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.