How to update a mysql row and display the updated row using PHP

Question

1.00/5 (1 vote)

See more:

I need to update row and display the updated row.

In my below code update query is working. But cannot display.

What I have tried:

<?php
include_once 'db.php'

if(isset($_GET['PID'])){

$id=$_GET['PID'];

$sql = "UPDATE assign t2,
( SELECT PID,pname,pemail,ph_no,experience
FROM addpandit
) t1
SET t2.PID = t1.PID,t2.pname = t1.pname,t2.pemail = t1.pemail,t2.ph_no = t1.ph_no,t2.experience = t1.experience
WHERE t2.PID='' AND t1.PID=$id";
$insert_user=$conn->query($sql);

$sql1="SELECT * FROM assign WHERE PID=$id";
$result=$connect->query($sql1);
$rows=$result->fetch_assoc();
echo ($rows['AID']);

}
?>

Posted 7-Jun-17 23:25pm

Member 13208162

Updated 8-Jun-17 2:42am

Add a Solution

2 solutions

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)

Jochen Arndt · Answer 1 · 2017-06-08T00:37:00

We don't have your database or even know how it is organised. So only you can find the problem.

Is there an AID field in the assign table?

Add error checks for each call and report errors.
For debugging you might also report success for each command like

PHP

if ($result) {
    echo "Found recordset\n";
} else {
    echo "Recordset not found\n";
}

W∴ Balboos, *GHB* · Answer 2 · 2017-06-08T02:42:00

Another thing about php returns from SQL queries: They're in the form of an array of rows - even if you only get one row.

Thus, your data request:

echo ($rows['AID']);

would need to look like:

echo ($rows[0]['AID']);

Best way to see if you're getting what you think you're getting?

print_r($rows)

and see what data was returned and how it's indexed in the array.

How to update a mysql row and display the updated row using PHP

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0