updating database from members page

franknu · 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 28

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 29

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 30

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 31

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 32

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 33

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 34

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 35

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 36

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 37

Notice: Undefined variable: row in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 38

Notice: Undefined variable: Member_Status in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 53

Notice: Undefined variable: User_Name in c:\program files\easyphp1-8\home\townsfinder\authorization\update.php on line 58

Warning: 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]

ataria · 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...)

franknu · 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

Sign In

updating database from members page

Recommended Posts

franknu

Link to comment

Share on other sites

ataria

Link to comment

Share on other sites

franknu

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information