我有一个从名为'submittbl‘的数据库动态生成的表。每一行都有一个动态生成的复选框。
我希望能够将选中的行插入到名为'marktbl‘的数据库中。到目前为止,我只尝试将第一行保存到数据库中,而不是我选中/选择的行。但是如果我检查所有行,所有行都会被正确地保存。如何插入勾选的行?
我尝试了许多解决方案,但都没有奏效。
//to get records from database dynamically
<?php
if(isset($_POST['find_btn']))
{
if(empty($_POST['s_lev']) && empty($_POST['s_sem']))
{
$msgerr = "<b>Notice: </b>" . "No categories selected.";
}
else
{
$selev=$_POST['s_lev'];
$sesem=$_POST['s_sem'];
$sql = "SELECT *FROM submittbl WHERE CourseCode = ? AND Level = ? AND Semester = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("sss",$pcode, $plevel, $psems);
$pcode = $_SESSION['ccode'];
$plevel = $selev;
$psems = $sesem;
$stmt->execute();
$result = $stmt->get_result();
$num_rows = $result->num_rows;
if($num_rows>0)
{
while($rows = $result->fetch_assoc())
{
$sn = $rows['SN'];
$name = $rows['StudentName'];
$regno = $rows['RegNo'];
$asmid = $rows['AssignmentID'];
$code = $rows['CourseCode'];
$lev = $rows['Level'];
$sem = $rows['Semester'];
$det = $rows['SubmissionDate'];
$doc = $rows['Document'];
$score = $rows['Score'];
?>
<tr>
<td><input type='checkbox' name='delChk[]' value='<?php echo $sn; ?>'><?php echo $sn; ?></input></td>
<td><?php echo $name; ?></td>
<td><?php echo $regno; ?></td>
<td><?php echo $asmid; ?></td>
<td><?php echo $det; ?></td>
<input type='hidden' name='sn' value='<?php echo $sn; ?>'></input>
<input type='hidden' name='name[]' value='<?php echo $name; ?>'></input>
<input type='hidden' name='regno[]' value='<?php echo $regno; ?>'></input>
<input type='hidden' name='asmid[]' value='<?php echo $asmid; ?>'></input>
<input type='hidden' name='ccode[]' value='<?php echo $code; ?>'></input>
<input type='hidden' name='level[]' value='<?php echo $lev; ?>'></input>
<input type='hidden' name='semester[]' value='<?php echo $sem; ?>'></input>
<input type='hidden' name='det[]' value='<?php echo $sub; ?>'></input>
<input type='hidden' name='doc[]' value='<?php echo $doc; ?>'></input>
<input type='hidden' name='score[]' value='<?php echo $score; ?>'></input>
<td><?php echo "<a href='download_submitted.php?id=$asmid'><img src=img/downloads.png width=10% height=10% alt='download'>Download</a>"; ?></td>
</tr>
<?php
}
}
else
{
$msgerr = "<b>Notice: </b>" . "Oops! No records found for the selected categories.";
}
}
}
?>
//to insert into markedtbl database
//this is where I'm having the whole problem
<?php
if(isset($_POST['upload']))
{
if(!isset($_POST['delChk']))
{
$msgerr = "<b>Notice: </b>" . "No records selected - select/mark records to upload.";
}
else
{
//-------------------get all IDs in checkbox by loop------------------
$checked = $_POST['delChk'];
foreach($checked as $k=>$v)
{
if($checked[$k] == TRUE)
{
$chkrow = $checked[$k];
$name = $_POST['name'];
$regno = $_POST['regno'];
$asmid = $_POST['asmid'];
$code = $_POST['ccode'];
$level = $_POST['level'];
$sems = $_POST['semester'];
$det = $_POST['det'];
$doc = $_POST['doc'];
$score = $_POST['score'];
//-------------prepare sql query to update score in database------------------------
$sql = "INSERT INTO marktbl(NSN, StudentName, RegNo, AssignmentID, CourseCode, Level, Semester, DateSubmitted, Document, Score)
VALUES(?,?,?,?,?,?,?,?,?,?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ssssssssss", $pcount, $pname, $pregno, $pasmid, $pcode, $plevel, $psems, $pdet, $pdoc, $pscore);
$pcount = $chkrow;
$pname = $name[$k];
$pregno = $regno[$k];
$pasmid = $asmid[$k];
$pcode = $code[$k];
$plevel = $level[$k];
$psems = $sems[$k];
$pdet = $det[$k];
$pdoc = $doc[$k];
$pscore = $score[$k];
$stmt->execute();
}
}
if($conn->error)
{
$msgerr = $conn->error;
}
else
{
echo "<script> alert('Assignment uploaded for marking.')</script>";
}
}
//}
}
?>
<?php echo "<span class='err'>" . $msgerr . "</span>"; ?><br>
<td class='td'>
<button class='upload' name='upload' onclick="return confirm('Are you sure you want to upload selected assignments for marking?')"
>Upload for Marking</button>
</td>
</form>发布于 2020-10-23 17:06:06
所以我会试着写一个你的想法的样本,希望能行得通。因此对于我的示例,您有一个用户数组,其中包含四个键
$users = [
0 => [
'selected' => true,
'name' => 'Name 1',
],
1 => [
'selected' => false,
'name' => 'Name 2',
],
2 => [
'selected' => true,
'name' => 'Name 3',
],
3 => [
'selected' => false,
'name' => 'Name 4',
],
];
foreach ($users as $user) {
if (!$user['selected]) {
continue;
}
$sql = "INSERT INTO marktbl(
NSN,
StudentName,
RegNo,
AssignmentID,
CourseCode,
Level,
Semester,
DateSubmitted,
Document,
Score
) VALUES(
:name,
:lastname,...
)";
$stmt = $conn->prepare($sql);
$params = [
':name' => $user['name'],
':lastname' => $user['lastname'],...
];
try {
$stmt->execute($params);
} catch(Exception $e) {
echo $e->getMessage();
}
}我认为你的代码应该是这样的。您可以轻松地为每个选定的元素设置一个标志,然后根据该标志过滤数据。
https://stackoverflow.com/questions/64496139
复制相似问题