问如何在mysql中调用该值，然后将其转换为变量

EN

<?php
    require("db.php");
    $datetoday = date("Y-m-d");
    if (isset($_POST['submit']))
    {      
        include 'db.php';
        $loginid =$_REQUEST['loginid'];

        if (!$loginid) {header("location:../index.php");   }    

        $result = mysql_query("SELECT * FROM info WHERE id  = '$loginid'");
        $test = mysql_fetch_array($result);
        $testid=$test['id'];
        $fnameloginsuccess1=$test['firstname'];
        $mnameloginsuccess1=$test['middlename'];
        $lnameloginsuccess1=$test['lastname'];
        $departmentloginsuccess1=$test['department'];
        echo'<input type="text" name="fname" value="'.$fnameloginsuccess1.'"/></td>';

        $natureofleave =$_POST['group1'];
        $datestart=$_POST['startofleave'];
        $dateend=$_POST['endofleave'];
        $reason=$_POST['reason'];
        $status= 'pending';

        mysql_query("INSERT INTO `request` (id, natureofleave, dateofleavestart, dateofleaveend, reasons, datesubmitted,department,status,firstname,middlename,lastname) VALUES('$log','$natureofleave','$datestart','$dateend','$reason','$datetoday','$departmentloginsuccess1','$status','$fnameloginsuccess1','$mnameloginsuccess1','$lnameloginsuccess1')");

    }

?>

<?php
require_once("db.php");
$datetoday = date("Y-m-d");

if ($_SERVER['REQUEST_METHOD'] == "POST")
{
    $loginid = $_REQUEST['loginid'];
    if (!$loginid)
    {
        header("Location: ../index.php");
        exit;
    }

    $result = mysql_query("SELECT * FROM `info` WHERE `id`  = '$loginid'");
    $user   = mysql_fetch_array($result);
    $id     = $user['id'];
    $first  = $user['firstname'];
    $middle = $user['middlename'];
    $last   = $user['lastname'];
    $dept   = $user['department'];
    $nature = $_POST['group1'];
    $start  = $_POST['startofleave'];
    $end    = $_POST['endofleave'];
    $reason = $_POST['reason'];
    $status = 'pending';

    $sql = <<<SQL
        INSERT INTO `request` 
            (`id`, `natureofleave`, `dateofleavestart`, `dateofleaveend`, `reasons`, `datesubmitted`, `department`, `status`, `firstname`, `middlename`, `lastname`)
        VALUES 
            ('$id', '$nature', '$start', '$end', '$reason', '$datetoday', '$department', '$status', '$first', '$middle', '$last');
SQL;
    mysql_query($sql) or die ('There was an error processing your data.');
}
?>