我有一个名为books的表,这个表将存储每本书的数据。每本书只有5页,每一页都有不同的细节,属于同一本书。存储在名为";jalad";并且存储在名为"的列中的页面;sanad";
我想要PHP允许我在完全完成第一本书的插入后插入一本新书,这本书有五页,如果我输入的页面少于5页,那么将阻止我在完成第一本之前插入新书。有什么想法吗。我使用了这个代码,但它并不完美。请帮忙。
此处表格:
代码:
<?php
// connect to the database
// $serverName = "";
//$database = "";
$serverName = "";
$database = "";
$connectionInfo = array( "Database"=>$database );
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn )
{
echo "Connection established.n";
}
else
{
echo "Connection could not be established.n";
die( print_r( sqlsrv_errors(), true));
}
$x= $_POST['x'];
$y= $_POST['y'];
$sql = "SELECT count(x) as countnumber FROM books where x='$x' ";
$stmt = sqlsrv_query( $conn, $sql );
while($row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)) {
$rowc= $row['countnumber'];
echo $rowc;
if ($rowc <=5) {
$sql = "INSERT INTO books (x,x)
VALUES ('$x','$x' )";
// echo $sql;
if (sqlsrv_query($conn, $sql)) {
echo "your data saved";
}
else {echo "error";}
}
else {
echo"You have to complete the page of the current book";
}
}
?>
您需要选择最后一本上传书籍的"jalad"。您可以随心所欲地执行此操作,但假设您将列值存储在名为$jalad_last 的变量中
你只需要像这个一样做出你的if声明
if ($rowc == 0 || $rowc < 5 && $jalad1 == $jalad_last) {
YOUR INSERT CODE HERE
} elseif ($rowc == 5) {
echo 'this book is already completed';
} else {
echo 'you have to complete...';
}