我希望从表中获得发票ID的递增结果
简单地说,如果我的代码已经在数据库中,比如E-0000007,我想获取它并在E-0000008上加上+1
很可能我写错了两次if语句,
我到处都找过了(可能不多,因为我不知道我应该找什么),如果你理解我想要实现的东西,请考虑帮助我
我的代码.php
<?php
if(isset($_POST['post']))
{
$invoiceid = mysqli_real_escape_string($con,$_POST['invoiceid']);
$sql="INSERT INTO `student`(`invoiceid`) VALUES ('$invoiceid')";
$result=mysqli_query($con,$sql);
$row = mysqli_fetch_array($result);
$lastid = $row['invoiceid'];
if(empty($lastid))
{
$number = "E-0000001";
}
else
{
$idd = str_replace("E-", "", $lastid);
$id = str_pad($idd + 1, 7, 0, STR_PAD_LEFT);
$number = 'E-'.$id;
}
if($result)
{
$success="Post has been added successfully";
} else
{
$error="Something went wrong!";
}
$invoiceid = '';
}
?>