如何在php中显示自动增量数据表格mysql

问题描述：

在我的大学数据库项目中，我的SQL中有一个自动增量字段滚动编号。我想要的是，当新录取发生并插入学生记录时，它会在同一页面上显示所有发现，包括卷号。然而，尽管我尽了最大的努力，但它在卷号中返回0。如何在php中显示自动增量数据表格mysql

下面是代码：

<?php 

$con = mysqli_connect("localhost", "root", "") or die("conection error"); 
mysqli_select_db($con, "hamdard university") or die("dbase error"); 

if (isset($_POST['subbtn'])) { 

    $r  = "SELECT RollNo FROM admission_form"; 
    $result = mysqli_query($con, $r); 
    if (mysqli_query($con, $r)) { 
     $last_id = mysqli_insert_id($con); 
    } 


    $n = $_POST['txtname']; 
    $f = $_POST['txtfac']; 
    $s = $_POST['txtsem']; 

    $sql = "insert into admission_form(name,faculty,semester)values    ('$n','$f','$s')"; 
    mysqli_query($con, $sql); 



    echo "<table border=1> 
      <th>RollNo</th> 
      <th>Name</th> 
      <th>Faculty</th> 
      <th>Semester</th>"; 



    echo "<tr>"; 

    echo "<td>"; 
    echo $last_id; 
    echo "</td>"; 

    echo "<td>"; 
    echo $n; 
    echo "</td>"; 

    echo "<td>"; 
    echo $f; 
    echo "</td>"; 

    echo "<td>"; 
    echo $s; 
    echo "</td>"; 

    echo "<br>"; 


} 
?> 

<html> 

<head></head> 

<body> 
    <form name="f1" action="" method="POST"> 
     RollNo: 
     <input type="text" name="txtroll" readonly> Name: 
     <input type="text" name="txtname"> Faculty: 
     <input type="text" name="txtfac"> Semester: 
     <input type="text" name="txtsem"> 
     <input type="submit" value="done" name="subbtn"> 
    </form> 
</body> 

</html>

恶魔？也许你的意思是朋友？如果是这样，友谊记录如何？ – Strawberry

答

你需要得到$ last_id INSERT查询

$sql="insert into admission_form(name,faculty,semester)values ... 
mysqli_query($con,$sql); 
$last_id = mysqli_insert_id($con);

答

您遗失插入查询后。更改为：

<?php 

$con=mysqli_connect("localhost","root","")or die("conection error"); 
mysqli_select_db($con,"hamdard university")or die("dbase error"); 

if(isset($_POST['subbtn'])) 
{ 

$sql="insert into admission_form(name,faculty,semester)values    ('$n','$f','$s')"; 

if (mysqli_query($con, $sql)) 
{ 
$last_id = mysqli_insert_id($con); 
} 


$n=$_POST['txtname']; 
$f=$_POST['txtfac']; 
$s=$_POST['txtsem']; 



$r="SELECT RollNo FROM admission_form"; 
$result=mysqli_query($con, $r); 


echo  "<table border=1> 
     <th>RollNo</th> 
     <th>Name</th> 
     <th>Faculty</th> 
     <th>Semester</th>"; 



    echo "<tr>"; 

    echo "<td>"; 
    echo $last_id; 
    echo "</td>"; 

    echo "<td>"; 
    echo $n; 
    echo "</td>"; 

    echo "<td>"; 
    echo $f; 
    echo "</td>"; 

    echo "<td>"; 
    echo $s; 
    echo "</td>"; 

    echo "<br>"; 


} 
?> 

<html> 
<head></head> 
<body> 

<form name="f1" action="" method="POST"> 

RollNo:<input type="text" name="txtroll" readonly> 
Name:<input type="text" name="txtname"> 
Faculty:<input type="text" name="txtfac"> 
Semester:<input type="text" name="txtsem"> 
<input type="submit" value="done" name="subbtn"> 

</form> 
</body> 
</html>

答

试试这个：

$mysqli = new mysqli(SQLI_SERVER, MYSQLI_USER, MYSQLI_PWD, MYSQLI_DBNAME); 
if ($result = $mysqli->query("INSERT INTO admission_form(name, facility,semester) VALUES..) { 
    echo 'The ID is: '.$mysqli->insert_id; 
}

答

您在本页面的一些问题。

如前所述，INSER查询必须在select之前。
如果您执行“SELECT RollNo FROM admission_form”，您将在admission_form中获得所有现有的RollNo，而不是最新的RollNo。如果这是一个带有自动增量的int（该接缝），则应该执行“SELECT max（RollNo）FROM admission_form”。
您不需要执行上述选择，因为mysqli_insert_id获取插入到最后一个查询中的ID。
您可能无法在表格中看到结果，因为它位于HTML头部，但它应该位于页面的正文中。
您创建的表格不是“关闭”的。

你应该很好地去与代码波纹管。

<HTML> 
<HEAD></HEAD> 
<BODY> 
<?php 
$con=mysqli_connect("localhost","root","")or die("conection error"); 
mysqli_select_db($con,"hamdard university")or die("dbase error"); 

if(isset($_POST['subbtn'])) 
{ 
    $n=$_POST['txtname']; 
    $f=$_POST['txtfac']; 
    $s=$_POST['txtsem']; 

    $sql="insert into admission_form(name,faculty,semester) values    ('$n','$f','$s')"; 

    if (mysqli_query($con, $r)) 
    { 
    $last_id = mysqli_insert_id($con); 
    } 

echo  "<table border=\"1\"><th>RollNo</th> <th>Name</th> <th>Faculty</th> <th>Semester</th>"; 

    echo "<tr>"; 

    echo "<td>"; 
    echo $last_id; 
    echo "</td>"; 

    echo "<td>"; 
    echo $n; 
    echo "</td>"; 

    echo "<td>"; 
    echo $f; 
    echo "</td>"; 

    echo "<td>"; 
    echo $s; 
    echo "</td>"; 

    echo "</tr></table>"; 


} 
?> 

<form name="f1" action="" method="POST"> 

RollNo:<input type="text" name="txtroll" readonly> 
Name:<input type="text" name="txtname"> 
Faculty:<input type="text" name="txtfac"> 
Semester:<input type="text" name="txtsem"> 
<input type="submit" value="done" name="subbtn"> 

</form> 
</body> 
</html>

如何在php中显示自动增量数据表格mysql

相关推荐