showing values for an update form

franknu · November 28, 2006

i want to show the values for an update form, i think that my problem has to be on the form or select statement. the form updates the values i just cant see what is already there so whatever is there already doesnt get replace please help
[code=php:0]
<?php
$host = "localhost";
$username = "localhost";
$password = "abc123";
$database = "contacts";

$db = mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$BusinessName = (isset($_POST['BusinessName']) ? $_POST['BusinessName'] : '');
$Slogan = (isset($_POST['Slogan']) ? $_POST['Slogan']:'');
$Business_Address = (isset($_POST['Business_Address']) ? $_POST['Business_Address']:'');
$Tel = (isset($_POST['Tel']) ? $_POST['Tel']:'');
$Website = (isset($_POST['Website']) ? $_POST['Website']:'');
$Email = (isset($_POST['Email']) ? $_POST['Email']:'');
$Member_Status = (isset($_POST['Member_Status']) ? $_POST['Member_Status']:'');
$Fax =(isset($_POST['Fax']) ? $_POST['Fax']:'');
$type = (isset($_POST['type']) ? $_POST['type']:'');
$make = (isset($_POST['make']) ? $_POST['make']:'');
$Categories = (isset($_POST['Categories']) ? $_POST['Categories']:'');
$Keyword = (isset($_POST['Keyword']) ? $_POST['Keyword']:'');
$Picture1 = (isset($_POST['Picture1']) ? $_POST['Picture1']:'');
$Headline = (isset($_POST['Headline']) ? $_POST['Headline']:'');
$Slogan2 = (isset($_POST['Slogan2']) ? $_POST['Slogan2']:'');
$Description1 = (isset($_POST['Description1']) ? $_POST['Description1']:'');
$Description2 = (isset($_POST['Description2']) ? $_POST['Description2']:'');
$Description3= (isset($_POST['Description3']) ? $_POST['Description3']:'');
$Contact2 = (isset($_POST['Contact2']) ? $_POST['Contact2']:'');
$Picture2 = (isset($_POST['Picture2']) ? $_POST['Picture2']:'');
$Picture3 = (isset($_POST['Picture3']) ? $_POST['Picture3']:'');
$Picture4 = (isset($_POST['Picture4']) ? $_POST['Picture4']:'');
$User_Name = (isset($_POST['User_Name']) ? $_POST['User_Name']:'');
$Password = (isset($_POST['Password']) ? $_POST['Password']: '');

$query = "SELECT * FROM business_info WHERE `BusinessName`= '$BusinessName'
AND `User_Name`='$User_Name'";

$result = mysql_query($query) or die (mysql_error());
$res2 = mysql_fetch_assoc($result);

echo "$BusinessName";

if(isset($_POST['update']))
{

$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());
}

?>

<table width="83%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div align="left"><br>
<table width="96%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>

<td width="91%">
<?

include("../includefiles/logo.php");
?>
</td>
</tr>
</table>
</div></td>
</tr>
<tr>
<td><div align="center"></div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>

<td width="94%">

<table width="100%" border="0" cellpadding="0" cellspacing="0" background="../images/top_center_back2.jpg" bgcolor="#FFFFFF">
<tr>
<td>
<table width="100%" height="125" border="0" cellpadding="1" cellspacing="1">
<form name="form" method="Post" action="" >
<tr>
<td background="../images/fondo2.jpg" bgcolor="#999966"><div align="center"><strong>Business Info</strong></div></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="17%">Business Name</td>
<td width="22%"><input type="text" name="BusinessName" <? echo "$BusinessName"; ?> > </td>

</tr>
<tr>
<td>Slogan</td>
<td><input type="text" name="Slogan" value="<?php echo"$Slogan"; ?>"></td>
<td>Website</td>
<td><input type="text" name="Website " value="<?php echo "$Website"; ?>"></td>
</tr>
<tr>
<td>Tel</td>
<td><input type="text" name="Tel" value="<?php echo "$Tel"; ?>"></td>
<td>Key Words</td>
<td><input type="text" name="Keyword value="<?php echo "$Keyword"; ?>"> </td>
</tr>
<tr>
<td>Fax</td>
<td><input type="text" name="Fax" value="<?php echo "$Fax"; ?>"> </td>
<td>Address</td>
<td><input type="text" name="Business_Address" value="<?php echo "$Business_Address"; ?> "> </td>
</tr>
</table></td>
</tr>
<tr>
<td>

<table width="101%" height="35" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="13%">State</td>
<td width="7%"> <select name="make" style="width:160px;"></td>

<td width="16%">City</td>
<td width="8%"><select name="type" style="width:160px;">
</select>

</td>
<td width="9%">Category</td>
<td width="16%"> <TEXTAREA rows=3 name="Categories" value="<?php echo "$Categories";?>"> </TEXTAREA> </td>

</tr>
</table><br>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td background="../images/fondo2.jpg" bgcolor="#CCCCCC"><div align="center"><strong><font color="#000000">Business
Webpage</font></strong></div></td>
</tr>
<tr>
<td>Headline</td>
</tr>
<tr>
<td><input type="text" name="Headline" value="<?php echo "$Headline"; ?>"> </td>
</tr>
<tr>
<td>Slogan </td>
</tr>
<tr>
<td><input type="text" name="Slogan2" value="<?php echo "$Slogan2"; ?>" ></td>
</tr>
<tr>
<td>Description1 </td>
</tr>
<tr>
<td><TEXTAREA ROWS=5 COLS=65 NAME="Description1" value="<?php echo" $Description1"; ?>" > </TEXTAREA></td>
</tr>
<tr>
<td>Description2</td>
</tr>
<tr>
<td><TEXTAREA ROWS=5 COLS=65 NAME="Description2" value="<?php echo "$Description2"; ?>"></TEXTAREA></td>
</tr>
<tr>
<td>Description3</td>
</tr>
<tr>
<td><TEXTAREA ROWS=5 COLS=65 NAME="Description3" value="<?php echo "$Description3" ?> "></TEXTAREA></td>
</tr>
<tr>
<td>Contact Name
<TEXTAREA ROWS=1 COLS=25 NAME="Contact2" value="<?php echo "$Contact2"; ?>"> </TEXTAREA></td>
</tr>
<tr>
<td>

Picture1
<input name="Picture1" type="file" value="<?php echo "$Picture1"; ?>">

</td>
</tr>
<tr>
<td>Picture 2
<input name="Picture2" type="file" value="<?php echo $Picture2 ?>">
</td>
</tr>
<tr>
<td>Picture 3 <input name="Picture3" type="file" value="<?php echo $Picture3?>"></td>
</tr>
<tr>
<td>
Audio
<input name="Audio" type="file" value="<?php echo $Audio?>"> </td>
</tr>
<tr>
<td>
Video
<input name="video" type="file" value="<?php echo $video?>"></td>
</tr>
<tr>
<td><table width="100%" border="1" cellspacing="1" cellpadding="1">
<tr>
<td>User Name</td>
<td><input type="text" name="User_Name"value="<?php echo $User_Name?>"></td>
<td>Password</td>
<td><input type="text" name="Password" value="<?php echo $Password?>"></td>
</tr>
</table></td>
</tr>
</table> </td>
</tr>
<tr>
<td background="../images/fondo2.jpg"> <div align="right">
<input type="submit" value="Update my database" name="update" />
<input type="reset" value="Reset fields" />
</div><td>
</form>

</table>

</td>
<td width="6%" valign="top" bgcolor="#FFFFFF"> </td>
</tr>
</table>
</td>
</table>
</tr>

</body>
[/code]

kenrbnsn · November 28, 2006

Do you want to display the values currently in the database or re-display the values that were submitted?

Ken

franknu · November 28, 2006

the one that are currenly in the database

kenrbnsn · November 28, 2006

You're currently using the values that were POSTed from the form. To display the values in the DB you need to get thoses out of the $res array. Also, when displaying a value for a <textarea> you do not use the 'value="' clause. You put the value between the <textarea> and </textarea> tags.

Ken

Sign In

showing values for an update form

Recommended Posts

franknu

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

franknu

Link to comment

Share on other sites

kenrbnsn

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information