 |  |  |  |  |  |  |  |
UPDATE query not working properly...
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
Ive done several echo's and such to make sure info is in my variables before. When i do the first update on the page, i think the second one is running too. Either way, my record is being deleted for whatever reason...
Aside from some help with the current setup, i would like to know if there is another way of splitting up the sumbits, or if the current way i am doing this is sufficient enough.
[php]<?
// editusernew.php
// by Ryan Wood
// TODO: Gets a user name then sets all of the information in input boxes to be UPDATED.
// REQUIRES //
require ($_SERVER["DOCUMENT_ROOT"]."/backend/config.php");
$connection = @mysql_connect($server, $db_user, $db_password) or die("Error: Could not connect to MySQL server");
mysql_select_db($database, $connection);
require_once($_SERVER['DOCUMENT_ROOT'].'/backend/checklogin.php');
// END REQUIRES //
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Edit User</title>
</head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<form action="<?php echo $PHP_SELF; ?>" method="get">
User : <input name="user" type="text" maxlength="64"><br><br>
<input value="Submit" type="submit">
</form>
<?
$user = $_GET["user"];
$query = "SELECT * FROM userinfo WHERE user_name ='$user'";
$result = mysql_query($query);
$id = 0;
if(mysql_num_rows($result) > 0)
{
$row = mysql_fetch_object($result);
$id = $row->autoID;
?>
<form action='<?php echo $PHP_SELF; ?>' method='post'>
Username : <input name='txt_username' type='text' maxlength='64' value="<? echo $row->user_name; ?>">
<br><br>
Password : <input name='txt_password' type='text' maxlength='64'>
<br><br>
Email : <input name='txt_email' type='text' maxlength='64' value="<? echo $row->user_email; ?>">
<br><br>
Percent Complete : <input name='txt_percentcomplete' type='text' maxlength='64' value="<? echo $row->percentcomplete; ?>"> <br><br>
Temporary Price : <input name='txt_tempprice' type='text' maxlength='64' value="<? echo $row->tempprice; ?>">
<br><br>
Amount Paid : <input name='txt_amountpaid' type='text' maxlength='64' value="<? echo $row->amountpaid; ?>">
<br><br>
Date for completion : <input name='txt_datecomplete' type='text' maxlength='64' value="<? echo $row->dateforcomplete; ?>"> <br><br>
<input value='Update' type='submit'>
</form>
<br>
<?
}
$txt_username = $_POST["txt_username"];
$txt_email = $_POST["txt_email"];
$txt_percentcomplete = $_POST["txt_percentcomplete"];
$txt_tempprice = $_POST["txt_tempprice"];
$txt_amountpaid = $_POST["txt_amountpaid"];
$txt_datecomplete = $_POST["txt_datecomplete"];
/*if( ($txt_username != $row->user_name) ||
($txt_email != $row->user_email) ||
($txt_percentcomplete != $row->percentcomplete) ||
($txt_tempprice != $row->tempprice) ||
($txt_amountpaid != $row->amountpaid) ||
($txt_datecomplete != $row->dateforcomplete) )
{*/
$query2 = "UPDATE userinfo SET user_name='$txt_username' WHERE autoID='$id'";
mysql_query($query2, $connection);
//}
?>
</font>
</body>
</html>
[/php]
Aside from some help with the current setup, i would like to know if there is another way of splitting up the sumbits, or if the current way i am doing this is sufficient enough.
[php]<?
// editusernew.php
// by Ryan Wood
// TODO: Gets a user name then sets all of the information in input boxes to be UPDATED.
// REQUIRES //
require ($_SERVER["DOCUMENT_ROOT"]."/backend/config.php");
$connection = @mysql_connect($server, $db_user, $db_password) or die("Error: Could not connect to MySQL server");
mysql_select_db($database, $connection);
require_once($_SERVER['DOCUMENT_ROOT'].'/backend/checklogin.php');
// END REQUIRES //
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Edit User</title>
</head>
<body>
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<form action="<?php echo $PHP_SELF; ?>" method="get">
User : <input name="user" type="text" maxlength="64"><br><br>
<input value="Submit" type="submit">
</form>
<?
$user = $_GET["user"];
$query = "SELECT * FROM userinfo WHERE user_name ='$user'";
$result = mysql_query($query);
$id = 0;
if(mysql_num_rows($result) > 0)
{
$row = mysql_fetch_object($result);
$id = $row->autoID;
?>
<form action='<?php echo $PHP_SELF; ?>' method='post'>
Username : <input name='txt_username' type='text' maxlength='64' value="<? echo $row->user_name; ?>">
<br><br>
Password : <input name='txt_password' type='text' maxlength='64'>
<br><br>
Email : <input name='txt_email' type='text' maxlength='64' value="<? echo $row->user_email; ?>">
<br><br>
Percent Complete : <input name='txt_percentcomplete' type='text' maxlength='64' value="<? echo $row->percentcomplete; ?>"> <br><br>
Temporary Price : <input name='txt_tempprice' type='text' maxlength='64' value="<? echo $row->tempprice; ?>">
<br><br>
Amount Paid : <input name='txt_amountpaid' type='text' maxlength='64' value="<? echo $row->amountpaid; ?>">
<br><br>
Date for completion : <input name='txt_datecomplete' type='text' maxlength='64' value="<? echo $row->dateforcomplete; ?>"> <br><br>
<input value='Update' type='submit'>
</form>
<br>
<?
}
$txt_username = $_POST["txt_username"];
$txt_email = $_POST["txt_email"];
$txt_percentcomplete = $_POST["txt_percentcomplete"];
$txt_tempprice = $_POST["txt_tempprice"];
$txt_amountpaid = $_POST["txt_amountpaid"];
$txt_datecomplete = $_POST["txt_datecomplete"];
/*if( ($txt_username != $row->user_name) ||
($txt_email != $row->user_email) ||
($txt_percentcomplete != $row->percentcomplete) ||
($txt_tempprice != $row->tempprice) ||
($txt_amountpaid != $row->amountpaid) ||
($txt_datecomplete != $row->dateforcomplete) )
{*/
$query2 = "UPDATE userinfo SET user_name='$txt_username' WHERE autoID='$id'";
mysql_query($query2, $connection);
//}
?>
</font>
</body>
</html>
[/php]
•
•
Join Date: Jul 2006
Posts: 155
Reputation: 
Solved Threads: 10
Junior Poster
Hi Woobag,
you should use
instead of There is no problem with your UPDATE statement since php echo it nicely,but you've used $PHP_SELF incorrectly.
I hope this help you.
Good luck.
you should use
•
•
•
•
'<?php echo $_SERVER['PHP_SELF']; ?>'
•
•
•
•
'<?php echo $PHP_SELF; ?>'
I hope this help you.
Good luck.
Last edited by mostafadotnet; Aug 25th, 2006 at 9:41 am.
Thanks for the help mostafadotnet, but my problem appeared to be not the actual update query itself. Once i hit the first submit button the query was running with an "empty" value because it had not gotten the values from the POST. Therefore i simply adding an if statement correcting this flaw. Took me a week of on and off debugging to find that thing!
|
Similar Threads
- How can i update a query that have more than 3 tables using adodc in vb? (Visual Basic 4 / 5 / 6)
- CD - DVD ROM Drive not working properly (Storage)
- Need a Serial to usb driver (USB Devices and other Peripherals)
- Need update query--Remove the coma "," (PHP)
- Error while trying the update query (ASP)
- Intel D815EEA PCI cards are not working properly (Windows NT / 2000 / XP)
Other Threads in the PHP Forum
- Previous Thread: Can't open any xml file
- Next Thread: Help Guys!
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
ajax apache api array beginner binary body broken cakephp checkbox class cms code cookies cron curl database date date/time display dynamic ebooks echo email error file files folder form forms function functions google href htaccess html image include insert interactive ip javascript job joomla js limit link login mail mediawiki menu mlm mobile msqli_multi_query multiple mycodeisbad mysql navigation oop outofmemmory paging parse paypal pdf php problem procedure query radio ram random recursion regex remote script search server sessions sms source space sql stored subdomain syntax system table tutorial unicode update upload url validator variable video web webapplications websitecontactform xml youtube
