/    Sign up×
Community /Pin to ProfileBookmark

updating values

Copy linkTweet thisAlerts:
Nov 26.2006

i want the members to update their page from a member page. The problem that i am having is that after the user login when they click on update

the database is not showing any values or is updating anything

all i have is the HTML form

here is my link from member page

[code=php]

echo “<a href=”update.php?update”>update</a>”;
[/code]

here is my update page codes

[code=php]

<?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’]: ”);

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}’,`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” value=”<?php 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” />
<input type=”reset” value=”Reset fields” />
</div><td>
</form>

</table>

</td>
<td width=”6%” valign=”top” bgcolor=”#FFFFFF”>&nbsp;</td>
</tr>
</table>
</td>
</table>
</tr>

<?
}

else {
echo “Record Updated”;
}
?>

<body>
[/code]

help please

I am trying to update

to post a comment
PHP

7 Comments(s) ↴

Copy linkTweet thisAlerts:
@so_is_thisNov 26.2006 — Have you checked your site and/or server error logs for messages pertaining to this problem? Some sites don't display error messages back to the client. Instead, such error messages are placed in a log file.
Copy linkTweet thisAlerts:
@franknuauthorNov 26.2006 — i am running on my local computer. I really thing that the probles is with my coding the is something that i am missing but i can't see it..
Copy linkTweet thisAlerts:
@so_is_thisNov 26.2006 — Even on your local computer there could be error logs. Have you ever seen PHP error messages returned in your browser before -- when running from your local computer?
Copy linkTweet thisAlerts:
@franknuauthorNov 26.2006 — i have in my browser, but here i dont have any error messages..

i have my html forms which is empty. and when i click on submit bottom it takes me back to the same form
Copy linkTweet thisAlerts:
@so_is_thisNov 26.2006 — Well, I see one problem in the HTML. You have a <body> tag after all of your content. This could certainly confuse the browser. You gotta make sure your HTML is valid before you look at anything else.
Copy linkTweet thisAlerts:
@franknuauthorNov 26.2006 — it is updating the problem that i have now is that it is replacing all the data that was there. i need to show the data that is there already
Copy linkTweet thisAlerts:
@theRamonesNov 27.2006 — 
  • - This line :

  • 1. echo "<a href="update.php?update">update</a>";

  • - You want to update records using this

  • 2. if(isset($_GET['update'])) {//updating}


    • The (2.) statement will not execute, because $_GET value of update on line (1.) is false.

    you need to give some value to "update", may line (1.) become

    1. echo "<a href="update.php?update=true">update</a>";
    ×

    Success!

    Help @franknu spread the word by sharing this article on Twitter...

    Tweet This
    Sign in
    Forgot password?
    Sign in with TwitchSign in with GithubCreate Account
    about: ({
    version: 0.1.9 — BETA 5.19,
    whats_new: community page,
    up_next: more Davinci•003 tasks,
    coming_soon: events calendar,
    social: @webDeveloperHQ
    });

    legal: ({
    terms: of use,
    privacy: policy
    });
    changelog: (
    version: 0.1.9,
    notes: added community page

    version: 0.1.8,
    notes: added Davinci•003

    version: 0.1.7,
    notes: upvote answers to bounties

    version: 0.1.6,
    notes: article editor refresh
    )...
    recent_tips: (
    tipper: @AriseFacilitySolutions09,
    tipped: article
    amount: 1000 SATS,

    tipper: @Yussuf4331,
    tipped: article
    amount: 1000 SATS,

    tipper: @darkwebsites540,
    tipped: article
    amount: 10 SATS,
    )...