php 通过电子邮件从数据库中获取您的详细信息

Question

我想制作一个文本字段和按钮，允许用户在文本字段上获取他的详细信息，而不是每次他想进行新预订时都写下他的详细信息。

就像这张图: http://oi41.tinypic.com/23ie70j.jpg

我试着用我的代码做到这一点，但给了我两种形式，一种有细节，一种没有。

<form method="post" action="reserv page.php">
enter  the email: <input type = "text"  name = "email"/>   
<input type = "submit"  name = "submit"  value="submit" />  
</form>
<?php  
mysql_connect("localhost","userName","password");
mysql_select_db("database_Name");

if(isset($_POST['submit']))
{
$email = $_POST['email']; 
$q  = "SELECT * FROM tabe WHERE the_email  = '$email'"; 
$run = mysql_query($q );

while($row = mysql_fetch_array($run))
{ 
?>

</br></br>

<form action="payment.php" method="post" >
First Name:<input name="fName" type="text" value="<?php echo $row[1];   ?>" />
Last Name: <input name="lNamet" type="text" value="<?php echo $row[2];   ?>" />
User Name: <input name="uName" type="text" value="<?php echo $row[3];   ?>"/>
Email:     <input name="email" type="text" value="<?php echo $row[4];   ?>" />
password:  <input name="pass" type="password" value="<?php echo $row[5];  ?>"/>  
contact:   <input name="number" type="text" value="<?php echo $row[6];   ?>" />

<input name="confirm" type="submit" value="Confirm" />
</form>

</br></br>

<?php
}}
?>

<form action="payment.php" method="post" >
First Name:<input name="fName" type="text"  />
Last Name: <input name="lNamet" type="text" />
User Name: <input name="uName" type="text" />
Email:     <input name="email" type="text"  />
password:  <input name="pass" type="password" />  
contact:   <input name="number" type="text"  />

<input name="confirm" type="submit" value="Confirm" />
</form>   

Answer 1

<form method="post" action="reserv page.php">
enter  the email: <input type = "text"  name = "email"/>   
<input type = "submit"  name = "submit"  value="submit" />  
</form>
<?php  
mysql_connect("localhost","userName","password");
mysql_select_db("database_Name");

if(isset($_POST['submit']))
{
    $email = $_POST['email']; 
    //limit the query to one entry :)
    $q  = "SELECT * FROM tabe WHERE the_email  = '$email' LIMIT 1"; 
    $run = mysql_query($q );

    //check if email is registered
    if(mysql_num_rows($run)>0) 
    {
        //display filled up form
        while($row = mysql_fetch_array($run))
        { 
        ?>

        </br></br>

        <form action="payment.php" method="post" >
        First Name:<input name="fName" type="text" value="<?php echo $row[1];   ?>" />
        Last Name: <input name="lNamet" type="text" value="<?php echo $row[2];   ?>" />
        User Name: <input name="uName" type="text" value="<?php echo $row[3];   ?>"/>
        Email:     <input name="email" type="text" value="<?php echo $row[4];   ?>" />
        password:  <input name="pass" type="password" value="<?php echo $row[5];  ?>"/>  
        contact:   <input name="number" type="text" value="<?php echo $row[6];   ?>" />

        <input name="confirm" type="submit" value="Confirm" />
        </form>

        </br></br>

        <?php
        }
    }
    //display blank form
    else{
        ?>

        <form action="payment.php" method="post" >
        First Name:<input name="fName" type="text"  />
        Last Name: <input name="lNamet" type="text" />
        User Name: <input name="uName" type="text" />
        Email:     <input name="email" type="text"  />
        password:  <input name="pass" type="password" />  
        contact:   <input name="number" type="text"  />

        <input name="confirm" type="submit" value="Confirm" />
        </form>   
        <?php
    }
}
?>