Send user to page

Question

I am using a PHP script to send data to my database.

Here is my script:

<?php session_start(); $correct = true; $_SESSION['user_id']; $firstname = $_POST['firstname'] ; $lastname = $_POST['lastname'] ; if($correct){ $db = new PDO('mysql:host=localhost;dbname=database', 'root', ''); $query = "INSERT INTO names(user_id, firstname, lastname) VALUES (?, ?, ?)"; $stmt = $db->prepare($query); $stmt->execute(array($_SESSION['user_id'], $firstname, $lastname)); header('Location: ../names.php'); } else { echo "<p>Error</p>"; } ?>

The script is working fine but after the SQL statement is executed I want to send the user to a page where the user can see the data he entered.

In the current state the script is sending the user to names.php. I want to send the user to names.php?id=8.

The id column is auto increment.

Does someone know how I can send the user to the id of the executed statement?

itay · Accepted Answer · 2017-06-02 10:36:44Z

3

after your excecute do:

header('Location: ../names.php?id='.$db->lastInsertId);

PDO::lastInsertId

edited Jun 2, 2017 at 10:36

answered Jun 2, 2017 at 10:34

itay

3574 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Catalyst Over a year ago

I guess you meant header('Location: ../names.php?id=' . $db->lastInsertId);

Darshana Rana · Accepted Answer · 2017-06-02 10:38:07Z

2

You can get last inserted id by this,

$id = $db->lastInsertId();

and then you can pass it to header method. Like below,

header('Location: ../names.php?id='.$id);

edited Jun 2, 2017 at 10:38

answered Jun 2, 2017 at 10:36

Darshana Rana

1451 silver badge13 bronze badges

1 Comment

Catalyst Over a year ago

You forgot a . for string concatenation... :)

L. Z. · Accepted Answer · 2017-06-02 10:36:36Z

You can try to do another query for Select id from table where user_id=$_SESSION['user_id'] after Insert statement.

Then You can use result on your link names.php?id=[result from Select]

Collectives™ on Stack Overflow

Send user to page

3 Answers 3

1 Comment

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Related