franknu Posted November 23, 2006 Share Posted November 23, 2006 ok, I have a member page where i want the users to update their rows, i have the member page and the update page here is my link to update from member page:[code=php:0]$update = $row['update']; echo "<a href=\"update.php?update\">update</a>";[/code]this is the update page [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= $row['BusinessName'];$Keyword =$row['Keyword']; $Picture1 = $row['Picture1']; $Headline = $row['Headline']; $Slogan2 = $row['Slogan2']; $Description1 =$row['Description1']; $Description2 = $row['Description2']; $Description3= $row['Description3']; $Contact2 = $row['Contact2']; $Picture2 = $row['Picture2']; $Picture3 = $row['Picture3']; $Business_Address=$row['Business_Address'];$make=$row['make'];$type=$row['type'];$Tel=($row['Tel']);$Website= $row['Website'];if(isset($_GET['update'])){$update = ($_GET['update']);} else {die ("No business selected");}$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', `User_Name` ='$User_Name', " . "`Password`='$Password' WHERE `User_Name`='$User_Name'";$result = mysql_query($query) or die (mysql_error()); $row = mysql_fetch_assoc($result); ?><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%"><div align="center"> <?PHP include("../includefiles/logo.php"); ?></div></td> </tr> </table> </div></td> </tr> <tr> <td><div align="center"></div></td> </tr> <tr> <td>< <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"></td> <td width="16%">Status</td> <td width="45%"><input type="text" name="Member_Status"></td> </tr> <tr> <td>Slogan</td> <td><input type="text" name="Slogan"></td> <td>Website</td> <td><input type="text" name="Website"></td> </tr> <tr> <td>Tel</td> <td><input type="text" name="Tel"></td> <td>Key Words</td> <td><input type="text" name="Keyword"></td> </tr> <tr> <td>Fax</td> <td><input type="text" name="Fax"></td> <td>Address</td> <td><input type="text" name="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"> </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"></td> </tr> <tr> <td>Slogan </td> </tr> <tr> <td><input type="text" name="Slogan2"></td> </tr> <tr> <td>Description1 </td> </tr> <tr> <td><TEXTAREA ROWS=5 COLS=65 NAME="Description1"></TEXTAREA></td> </tr> <tr> <td>Description2</td> </tr> <td><table width="100%" border="1" cellspacing="1" cellpadding="1"> <tr> <td>User Name</td> <td><input type="text" name="User_Name"></td> <td>Password</td> <td><input type="text" name="Password"></td> </tr> </table></td> </tr> </table> </td> </tr> <tr> <td background="../images/fondo2.jpg"> <div align="right"> <input type="submit" value="Store in database" /> <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]here is my error display[code=php:0]Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 28Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 29Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 30Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 31Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 32Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 33Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 34Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 35Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 36Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 37Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 38Notice: Undefined variable: Member_Status in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 53Notice: Undefined variable: User_Name in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 58Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 62[/code] Link to comment https://forums.phpfreaks.com/topic/28253-updating-database-from-members-page/ Share on other sites More sharing options...
ataria Posted November 23, 2006 Share Posted November 23, 2006 $business = $row['business'];and the other ones.. need to go AFTER the $row = mysql_fetch_assoc();.and then try putting a '{' infront of each variable, and, a } after.Like so..$query = "UPDATE business_info SET `BusinessName`= '{$BusinessName}', `Slogan`='{$Slogan}', " . "`Business_Address`='{$Business_Address}', `Tel`='{$Tel}', (I'm not too sure on this...) Link to comment https://forums.phpfreaks.com/topic/28253-updating-database-from-members-page/#findComment-129222 Share on other sites More sharing options...
franknu Posted November 23, 2006 Author Share Posted November 23, 2006 here is my new code:[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']: '');$user = (isset($_POST['User_Name']) ? $_POST['User_Name']:'');if(isset($_GET['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}', `User_Name` ='{$User_Name}', `Password`='{$Password}' WHERE `User_Name`='{$User_Name}'";$result = mysql_query($query) or die (mysql_error()); $row = mysql_fetch_assoc($result); } ?> <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%"><div align="center"> <? include("../includefiles/logo.php"); ?> </div></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 enctype="multipart/form-data" action="update.php" method="Post"> <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"> </td> <td width="16%">Status</td> <td width="45%"><input type="text" name="Member_Status"> </td> </tr> <tr> <td>Slogan</td> <td><input type="text" name="Slogan"></td> <td>Website</td> <td><input type="text" name="Website"></td> </tr> <tr> <td>Tel</td> <td><input type="text" name="Tel"></td> <td>Key Words</td> <td><input type="text" name="Keyword"></td> </tr> <tr> <td>Fax</td> <td><input type="text" name="Fax"></td> <td>Address</td> <td><input type="text" name="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"> </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"></td> </tr> <tr> <td>Slogan </td> </tr> <tr> <td><input type="text" name="Slogan2"></td> </tr> <tr> <td>Description1 </td> </tr> <tr> <td><TEXTAREA ROWS=5 COLS=65 NAME="Description1"></TEXTAREA></td> </tr> <tr> <td>Description2</td> </tr> <tr> <td><TEXTAREA ROWS=5 COLS=65 NAME="Description2"></TEXTAREA></td> </tr> <tr> <td>Description3</td> </tr> <tr> <td><TEXTAREA ROWS=5 COLS=65 NAME="Description3"></TEXTAREA></td> </tr> <tr> <td>Contact Name <TEXTAREA ROWS=1 COLS=25 NAME="Contact2"></TEXTAREA></td> </tr> <tr> <td> Picture1 <input name="Picture1" type="file"> </td> </tr> <tr> <td>Picture 2 <input name="Picture2" type="file"> </td> </tr> <tr> <td>Picture 3 <input name="Picture3" type="file"></td> </tr> <tr> <td> Audio <input name="Audio" type="file"></td> </tr> <tr> <td> Video <input name="video" type="file"></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"></td> <td>Password</td> <td><input type="text" name="Password"></td> </tr> </table></td> </tr> </table> </td> </tr> <tr> <td background="../images/fondo2.jpg"> <div align="right"> <input type="submit" value="Store in database" /> <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]well now nothing is really happening, when i click update it shows me the page with nothing on the fields and when i hit store i just take me back to the same any help please Link to comment https://forums.phpfreaks.com/topic/28253-updating-database-from-members-page/#findComment-129246 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.