php update not working?

Question

0.00/5 (No votes)

See more:

i have this code and it doesn't show any errors but it did not update the record.

why is that? a little help please.

PERL

<?php
include('connect_db.php');

if (isset($_POST['submit']))
{
mysql_query("UPDATE indigo21IT SET LastName='$_POST[lastname]', GivenName='$_POST[givenname]', MiddleName='$_POST[middlename]' WHERE ID='$id'")
or die(mysql_error());

header("Location: main.php");
}

$id = $_GET['id'];

$result = mysql_query("SELECT * FROM indigo21IT where ID=$id");
?>

kind regards

Posted 17-Sep-12 0:07am

bnvelarde

Add a Solution

Comments

Er. Tushar Srivastava 25-Sep-12 9:32am

You have included connect_db.php can I see the file....

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SquidSK · Answer 1 · 2012-09-19T09:58:00

Solution 1

Unless you have other php on the page that isn't included in the question, at the point where you're running the query the variable $id does not have a value. The record won't update because the query likely will not find a record with a blank id number.

I also notice that you are retrieving data from both the $_GET and $_POST, normally you'd only be retrieving stuff from one or the other but not usually both.

Posted 19-Sep-12 9:58am

SquidSK

Comments

Mohibur Rashid 19-Sep-12 20:53pm

Good catch with id value empty thing and also bad comment about either GET or POST

you can easily send post data to www.something.com?somevar=somevalue and php will accept somevar as get method and also post value.

SquidSK 21-Sep-12 10:32am

You're probably thinking about $_RESPONSE not $_POST. No post value is ever visible to a user on the url. You can retrieve a value from both $_GET and $_RESPONSE or you can retrieve a value from $_POST and $_RESPONSE, but not from $_GET and $_POST since they are filled by HTTP GET method and HTTP POST method respectively, which are not equivalent.

See http://www.w3schools.com/php/php_post.asp

Mohibur Rashid 21-Sep-12 21:37pm

nope, $_RESPONSE is out of my thinking. ...
bye the way I already showed an example in my comment. if you don't understand that. ask me.