ansaurus

Question

How to update mysql data in php properly

Answer 1

+1 A:

Your forms are correct. Few things are missing.

First your update query update records according to user first name which is wrong as (there might be more than one records whose first name are same), so use user primary key.(For Example UserID).

Another important thing is before updating check that Is the request is GET or POST.

Adeel 2010-02-17 12:06:55

I tried using a primary to update the data but still won't work.

2010-02-17 12:25:14

try to print query and manually execute in mysql console.

Adeel 2010-02-17 12:43:49

Answer 2

A:

Why have you got two apostrophes before the values for TELNUM and FNAME in the SQL? That will make the values zero length strings followed by rubbish which will invalidate the query.

jsc42 2010-02-17 12:23:04

Answer 3

A:

You are trying to do multiple things, make your approach a little simple

Create a form that asks for user's first name

then post this name to a php script which then fetches the details based on the username

and then finally display the page that updates user record.

search for the user firstname
like this:

if(isset($_POST['search']))
{
    $con = mysql_connect("localhost","root","");
      if (!$con)
       {
         die('Could not connect: ' . mysql_error());
      }
    mysql_select_db("Hospital", $con);
    $result = mysql_query("SELECT * FROM t2 WHERE FIRSTNAME='".$_POST['fname']."');

    $data = mysql_fetch_assoc($result);
}

FORM FOR DISPLAYING THE RECORDS GOES HERE

then post this form to a new script (update.php) which updates user's records. Let me know if you are facing problems.

Gaurav Sharma 2010-02-17 12:40:55

it's finally working, thanks to all your help! without your guide I could have done nothing. Now I'm ready to deal with the sql injection that people in here are always talking about when I post my codes which they say are vulnerable to sql injections

2010-02-17 13:39:04

you're welcome.

Gaurav Sharma 2010-02-18 06:17:01

ansaurus

tags:

views:

answers:

How to update mysql data in php properly

related questions