Keep last inserted record in the input field using php

Question

I want to keep my last inserted record in the same input field after pressing submit button.

How can retrive last record from database?

I also could not keep the record in the same input field after refresh the page.

<?php
include 'db.php';
$qq=mysqli_query($connect,"select * from tbl_route");
?>
Route:
<select name="route" id="route">
    <option value="" disabled selected> : : Select : : </option>
    <?php
    $n=1;
    while($a=mysqli_fetch_array($qq))
    {
        ?>
        <option  value="<?php echo $a['r_id']; ?>"><?php echo   $a['route1']; ?></option>
        <?php
        $n++;
    }
    ?>
</select>
Driver:
<input type="text" name="driver" id="driver" value="<?php isset($_POST['driver']) echo $_POST['driver']; ?>">

insertion coding

<?php
if(isset($_POST['submit']))
{
    session_start();   
    include 'db.php';

    $route = $_POST['route'];
    $driver = $_POST['driver'];
    $driver_name = $_POST['driver_name'];
    $vehicle = $_POST['vehicle'];
    $passenger = $_POST['passenger'];
    $date=date('Y-m-d H:i:s');
    $status=1;

    $query = mysqli_query($connect,"INSERT INTO `motorpark-db`.`tbl_trip`  (`route`, `dm`, `dn`, `vehicle`, `passenger`, `t_status`,  `trip_date`)VALUES('$route', '$driver', '$driver_name', '$vehicle', '$passenger', '$status', '$date')");
    $q=mysqli_query($connect,"select * from tbl_trip where route='$route' and dm='$driver'");

    $row=mysqli_fetch_array($q);
    $route=$row['route'];
    $dm=$row['dm'];
    $dn=$row['dn'];

    $_SESSION['route']=$route;
    $_SESSION['dm']=$dm;
    $_SESSION['dn']=$dn;

    if($query)
    {
        header('location:trip_details.php');    
    }
    else
    {
        header('location:trip_details.php');
    }
}
?>

Possible duplicate of [How do I get the last inserted ID of a MySQL table in PHP?](http://stackoverflow.com/questions/1685860/how-do-i-get-the-last-inserted-id-of-a-mysql-table-in-php) — giorgio, Jan 27 '16 at 08:56
u can get like that, but after insertion u need to save in input field??? — devpro, Jan 27 '16 at 08:57
have you tried posting back to the page? you could then add value="$_POST['index']" to the input field and you'd keep the right data — Florian Humblot, Jan 27 '16 at 10:42

Sinto · Accepted Answer · 2016-01-27T11:46:31.587

this might help you.

$query = mysqli_query($connect,"INSERT INTO `motorpark-db`.`tbl_trip`  (`route`, `dm`, `dn`, `vehicle`, `passenger`, `t_status`,  `trip_date`)VALUES('$route', '$driver', '$driver_name', '$vehicle', '$passenger', '$status', '$date')");
$last_inserted-id = mysqli_insert_id($connect);
$get_record = mysqli_query($connect,"select * from tbl_trip where id = '$last_inserted-id'");
$row=mysqli_fetch_array($get_record);
if($query)
{
    header("location:trip_details.php?vals=" . urlencode(serialize($row)));
}

In view page:

    if (isset($_GET['vals'])) {
        $Values = unserialize(urldecode($_GET['vals']));
    }
    <select name="route" id="route">
    <?php
    $n=1;
    while($a = mysqli_fetch_array($qq))
    {
        ?>
        <option  value="<?php echo $a['r_id']; ?>" <?php if (isset($Values['route'])) { if ($Values['route'] == $a['r_id']) { ?> selected <?php } }?>><?php echo $a['route1']; ?></option>
        <?php
        $n++;
    }
    ?>
</select>
    <input type="text" name="driver" id="driver" value="<?php (isset($Values['driver']))? $Values['driver'] : '' ?>">

score 0 · Answer 2 · answered Nov 24 '17 at 11:30

0

mysqli_query($conn, $sql)) 
$last_id = mysqli_insert_id($conn);

answered Nov 24 '17 at 11:30

Pradip G. Vanparia

43
1
1
5

Please describe where this code has to be put and what it does. – Al0x Nov 24 '17 at 12:04
To improve the quality of this Answer, please include an explanation of how your suggestion works, as well as a larger sample of code that will more clearly identify where your code should be placed in relation to their code - perhaps even include a copy of their code modified to use your suggestion. – toonice Nov 24 '17 at 12:44
While this code may answer the question, providing additional context regarding why and/or how this code answers the question improves its long-term value. – Isma Nov 24 '17 at 13:19

Keep last inserted record in the input field using php

2 Answers2