How can i return back the id from a post method using php?

Question

I need to go back to the page id after update. How can I get back the id.

    <?php
    include '/dbconn.php';
    $title=  mysql_real_escape_string($_REQUEST['title']);
    $body=  mysql_real_escape_string($_REQUEST['body']);
    $ID=  mysql_real_escape_string($_REQUEST['save']);
    $sql="UPDATE itemDB SET title='$title', body='$body' WHERE ID='$ID'";
    mysql_query($sql) or die(mysql_error());
    // Is where I need your help
    // I tried this echo ID; but it's still not working
    header('location:././lookup.php?ItemID=$ID');
    ?>

Error message:

Parse error: syntax error, unexpected 'echo' (T_ECHO) in C:\xampp\htdocs\saving.php on line 10

You should use double quotes in the `header()` instead of single quotes — frz3993, Dec 23 '15 at 21:15
Don't use mysql_ functions, they are deprecated. Your code is vulnerable to SQL injection. — trincot, Dec 23 '15 at 21:19

score 0 · Answer 1 · answered Dec 23 '15 at 21:19

0

You have to use double-quotes ("), otherwise $ID won't be replaced. Also, ././ as a path doesn't make that much sense to me.

Try it with header("Location: lookup.php?ItemID=$ID"); (if it's in the same directory)

answered Dec 23 '15 at 21:19

aw31n

161
1
3

How can i return back the id from a post method using php?

1 Answers1