updating database
Posted: Fri Oct 06, 2006 11:19 am
I been trying to update my database after the user type in his/her password
this is my code:
this is what i am displaying
any idea how i can fix this....
thank you
this is my code:
Code: Select all
<?
$host = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";
$db = mysql_connect($host, $username, $password);
mysql_select_db($database);
$BusinessName = (isset($_POST['BusinessName']));
$Slogan = addslashes(isset($_POST['Slogan']));
$Business_Address = addslashes (isset($_POST['Business_Address']));
$Tel = addslashes(isset($_POST['Tel']));
$Website = addslashes(isset($_POST['Website']));
$Email = addslashes(isset($_POST['Email']));
$Member_Status = addslashes(isset($_POST['Member_Status']));
$Fax =addslashes(isset($_POST['Fax']));
$type = addslashes(isset($_POST['type']));
$make = addslashes(isset($_POST['make']));
$Categories = addslashes(isset($_POST['Categories']));
$Keyword = addslashes (isset($_POST['Keyword']));
$Picture1 = addslashes (isset($_POST['Picture1']));
$Headline = addslashes (isset($_POST['Headline']));
$Slogan2 = addslashes (isset($_POST['Slogan2']));
$Description1 = addslashes (isset($_POST['Description1']));
$Description2 = addslashes (isset($_POST['Description2']));
$Description3= addslashes (isset($_POST['Description3']));
$Contact2 = addslashes (isset($_POST['Contact2']));
$Picture2 = addslashes (isset($_POST['Picture2']));
$Picture3 = addslashes (isset($_POST['Picture3']));
$Picture4 = addslashes (isset($_POST['Picture4']));
$User_Name = addslashes (isset($_POST['User_Name']));
$Password = addslashes (isset($_POST['Password']));
$User_Name = mysql_query("SELECT `Password` FROM `Business_Info` WHERE `User_Name` == '$User_Name'");
if($Password == $Password[0])
{
$query = "UPDATE `Business_Info` SET `BusinessName`= '$BusinessName', `Slogan`='$Slogan',
`Business_Address`='$Business_Address',
`Tel`='$Tel', `Website`='$Website', `Email`='$Email', `Member_Status`='$Member_Status',
`Fax`='$Fax', `type`='$type', `make`='$make', `Categories`='$Categories', `Keyword`='$Keyword',
`picture1`='$Picture1', `Headline`='$Headline', `Slogan2`='$Slogan2', `Description1`='$Description1',
`Description2`='$Description2', `Description3`= '$Description3', `Contact2`='$Contact2', `Picture2`='$Picture2',
`Picture3`='$Picture3', `Password`='$Password' WHERE `User_Name`='$User_Name'";
$result = mysql_query($query) or die(mysql_error());
}
else
{
echo "Incorrect Password or User Name Try again ";
exit;
}
echo "$query";
?>this is what i am displaying
Code: Select all
UPDATE `Business_Info` SET `BusinessName`= '', `Slogan`='', `Business_Address`='', `Tel`='', `Website`='', `Email`='', `Member_Status`='', `Fax`='', `type`='', `make`='', `Categories`='', `Keyword`='', `picture1`='', `Headline`='', `Slogan2`='', `Description1`='', `Description2`='', `Description3`= '', `Contact2`='', `Picture2`='', `Picture3`='', `Password`='1' WHERE `User_Name`=''thank you