problem with an if else statement

Howlin1 · December 9, 2010

My code is as follows

<?php
// Include the Sessions options
require_once('inc/session_admin.inc.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Change Record form</title>
<style type="text/css">
td {font-family: tahoma, arial, verdana; font-size: 10pt }
</style>


</head>
<body bgcolor="#64b1ff">
<div align="center">
<?php
echo '<p>Hello <b>' .($_SESSION['username']) .'</b> <a href="logging_out.php">Logout</a></p>';

$Username=$_POST['Username'];

if ($Username = $Username)
{
// Include connecting to the database
require_once('inc/connect_to_users_db.inc.php');

$query=" SELECT * FROM userinfo WHERE Username='$Username'";
$result=mysql_query($query);
$num=mysql_num_rows($result);

$i=0;
while ($i < $num) {
$FirstName=mysql_result($result,$i,"FirstName");
$LastName=mysql_result($result,$i,"LastName");
$Address1=mysql_result($result,$i,"Address1");
$Address2=mysql_result($result,$i,"Address2");
$Address2=mysql_result($result,$i,"Address2");
$Address3=mysql_result($result,$i,"Address3");
$Gender=mysql_result($result,$i,"Gender");
$Country=mysql_result($result,$i,"Country");
$MobileNumber=mysql_result($result,$i,"MobileNumber");
$EmailAddress=mysql_result($result,$i,"EmailAddress");
?>
<table width="300" cellpadding="5" cellspacing="0" border="1">
<tr align="center" valign="top">
<td align="center" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Edit and Submit</h3>
<form method="post" action="update_a_user_script.php">
<input type="hidden" name="update_a_user_script" value="<?php echo "$Username" ?>" />
<table cellpadding="0" cellspacing="0"  border="0">
<tr align="center" valign="top">
<td>Username:</td>
<td><input type="text" name="Username" readonly="readonly" value="<?php echo "$Username" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>First Name:</td>
<td><input type="text" name="FirstName" value="<?php echo "$FirstName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Last Name:</td>
<td><input type="text" name="LastName" value="<?php echo "$LastName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Address:</td>
<td><input type="text" name="Address1" value="<?php echo "$Address1" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td> </td>
<td><input type="text" name="Address2" value="<?php echo "$Address2" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td> </td>
<td><input type="text" name="Address3" value="<?php echo "$Address3" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Gender:</td>
<td><input type="text" name="Gender" value="<?php echo "$Gender" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Country:</td>
<td><input type="text" name="Country" value="<?php echo "$Country" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>MobileNumber:</td>
<td><input type="text" name="MobileNumber" value="<?php echo "$MobileNumber" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Email Address:</td>
<td><input type="text" name="EmailAddress" value="<?php echo "$EmailAddress" ?>" /></td>
</tr>
</table>
<input type="submit" value="Update" />
</form>
<form method="post" action="update_a_user_form.php">
<input type="submit" value="Update a Different Record" />
</form>
<form method="post" action="display_users.php">
<input type="submit" value="List all users" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td></tr></table>
<?php
++$i;
}
?>
<?php
}
else
{
echo 'Username not found!. Please try again';
?>
<table width="300" cellpadding="5" cellspacing="0" border="2">
<tr align="center" valign="top">
<td align="left" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Insert Username</h3>
<form method="post" action="update_a_user_form2.php">
Enter Username: <input type="text" name="Username" size="30" /><br />
<br />
<input type="submit" value="Submit" /><input type="reset" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td>
</tr>
</table>
<?php
}
?>
</div>
</body>
</html>

It will display what it's meant to display if I have a username that is in the database, however if the username doesn't exist in the database, it's meant to say "Username not found!. Please try again" and show the search box again. However if I put in a Username that doesn't exist. I get a blank page (well at the top of the page the page I do get Hello Howlin1 Logout)

What am I doing wrong?

litebearer · December 9, 2010

This ...

if ($Username = $Username)

will always be true so the ELSE will never run. As such when there is no such username in the db, none of the form(s) will be displayed.

Capice?

Howlin1 · December 9, 2010

Ah Duh! Thanks

I changed it to

<?php
echo '<p>Hello <b>' .($_SESSION['username']) .'</b> <a href="logging_out.php">Logout</a></p>';

// Include connecting to the database
require_once('inc/connect_to_users_db.inc.php');

$Username=$_POST['Username'];


$sql="SELECT * FROM userinfo WHERE Username='$Username'";
$result=mysql_query($sql) or die(mysql_error());

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $Username, table row must be 1 row

if ($count == "0")
{

echo 'Username not found!. Please try again';
?>
<table width="300" cellpadding="5" cellspacing="0" border="2">
<tr align="center" valign="top">
<td align="left" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Insert Username</h3>
<form method="post" action="update_a_user_form2.php">
Enter Username: <input type="text" name="Username" size="30" /><br />
<br />
<input type="submit" value="Submit" /><input type="reset" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td>
</tr>
</table>
<?php
}
else
{

$query=" SELECT * FROM userinfo WHERE Username='$Username'";
$result=mysql_query($query);
$num=mysql_num_rows($result);

$i=0;
while ($i < $num) {
$FirstName=mysql_result($result,$i,"FirstName");
$LastName=mysql_result($result,$i,"LastName");
$Address1=mysql_result($result,$i,"Address1");
$Address2=mysql_result($result,$i,"Address2");
$Address2=mysql_result($result,$i,"Address2");
$Address3=mysql_result($result,$i,"Address3");
$Gender=mysql_result($result,$i,"Gender");
$Country=mysql_result($result,$i,"Country");
$MobileNumber=mysql_result($result,$i,"MobileNumber");
$EmailAddress=mysql_result($result,$i,"EmailAddress");
?>
<table width="300" cellpadding="5" cellspacing="0" border="1">
<tr align="center" valign="top">
<td align="center" colspan="1" rowspan="1" bgcolor="#64b1ff">
<h3>Edit and Submit</h3>
<form method="post" action="update_a_user_script.php">
<input type="hidden" name="update_a_user_script" value="<?php echo "$Username" ?>" />
<table cellpadding="0" cellspacing="0"  border="0">
<tr align="center" valign="top">
<td>Username:</td>
<td><input type="text" name="Username" readonly="readonly" value="<?php echo "$Username" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>First Name:</td>
<td><input type="text" name="FirstName" value="<?php echo "$FirstName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Last Name:</td>
<td><input type="text" name="LastName" value="<?php echo "$LastName" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Address:</td>
<td><input type="text" name="Address1" value="<?php echo "$Address1" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td> </td>
<td><input type="text" name="Address2" value="<?php echo "$Address2" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td> </td>
<td><input type="text" name="Address3" value="<?php echo "$Address3" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Gender:</td>
<td><input type="text" name="Gender" value="<?php echo "$Gender" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Country:</td>
<td><input type="text" name="Country" value="<?php echo "$Country" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>MobileNumber:</td>
<td><input type="text" name="MobileNumber" value="<?php echo "$MobileNumber" ?>" /></td>
</tr>
<tr align="center" valign="top">
<td>Email Address:</td>
<td><input type="text" name="EmailAddress" value="<?php echo "$EmailAddress" ?>" /></td>
</tr>
</table>
<input type="submit" value="Update" />
</form>
<form method="post" action="update_a_user_form.php">
<input type="submit" value="Update a Different Record" />
</form>
<form method="post" action="display_users.php">
<input type="submit" value="List all users" />
</form>
<form method="post" action="index.php">
<input type="submit" value="Administrator Interface" />
</form>
</td></tr></table>
<?php
++$i;
}
}
?>

and it works! Thanks a lot!

Sign In

problem with an if else statement

Recommended Posts

Howlin1

Link to comment

Share on other sites

litebearer

Link to comment

Share on other sites

Howlin1

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information