所以,当我为所有四行选择批准或拒绝按钮并单击提交按钮时,它应该根据选择以及根据我的表中的作业名称和所需作业将我的数据库列状态更新为批准或拒绝,我是 php 的新手,请帮助...
数据库 -->项目数据库
表 -->作业详细信息
no(AI)|jobname|desiredjob|jobexpectations|req1|req2|req3|req4|req5|status.
.PHP
<?php
//connect to the server
$link = mysql_connect('localhost', 'guest', 'guest');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
//connect to the database
mysql_select_db('projectdb');
//query the database
$query = mysql_query("SELECT * FROM jobdetails WHERE status='In Progress...'");
//fetch the results / convert results into an array
$jobname=array();
$desiredjob=array();
$jobexpectations=array();
$req1=array();
$req2=array();
$req3=array();
$req4=array();
$req5=array();
WHILE($rows = mysql_fetch_assoc($query)){
$jobname[] = $rows['jobname'];
$desiredjob[] = $rows['desiredjob'];
$jobexpectations[] = $rows['jobexpectations'];
$req1[] = $rows['req1'];
$req2[] = $rows['req2'];
$req3[] = $rows['req3'];
$req4[] = $rows['req4'];
$req5[] = $rows['req5'];
}
?>
<form method="post" action="">
<tr id="1">
<td class="type-info" style="width:10%"><?=$jobname[0]?><a class="anchorjs-link" href="#h3.-bootstrap-heading"><span class="anchorjs-icon"></span></a></td>
<td class="type-info" style="width:10%"><?=$desiredjob[0]?><br></br></td>
<td class="type-info" style="width:35%"><?=$jobexpectations[0]?><br></br></td>
<td class="type-info" style="width:35%"><ul><li><?=$req1[0]?></li><li><?=$req2[0]?></li><li><?=$req3[0]?></li><li><?=$req4[0]?></li><li><?=$req5[0]?></li></ul><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Approved" id="status"> Approve</label></div><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Denied" id = "status"> Deny</label></div><br></br></td>
</tr>
<tr id ="2">
<td class="type-info" style="width:10%"><?=$jobname[1]?><a class="anchorjs-link" href="#h3.-bootstrap-heading"><span class="anchorjs-icon"></span></a></td>
<td class="type-info" style="width:10%"><?=$desiredjob[1]?><br></br></td>
<td class="type-info" style="width:35%"><?=$jobexpectations[1]?><br></br></td>
<td class="type-info" style="width:35%"><ul><li><?=$req1[1]?></li><li><?=$req2[1]?></li><li><?=$req3[1]?></li><li><?=$req4[1]?></li><li><?=$req5[1]?></li></ul><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Approved" name="status" id="status"> Approve</label></div><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Denied" name="status" id = "status"> Deny</label></div><br></br></td>
</tr>
<tr id="3">
<td class="type-info" style="width:10%"><?=$jobname[2]?><a class="anchorjs-link" href="#h3.-bootstrap-heading"><span class="anchorjs-icon"></span></a></td>
<td class="type-info" style="width:10%"><?=$desiredjob[2]?><br></br></td>
<td class="type-info" style="width:35%"><?=$jobexpectations[2]?><br></br></td>
<td class="type-info" style="width:35%"><ul><li><?=$req1[2]?></li><li><?=$req2[2]?></li><li><?=$req3[2]?></li><li><?=$req4[2]?></li><li><?=$req5[2]?></li></ul><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Approved" id="status"> Approve</label></div><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Denied" id = "status"> Deny</label></div><br></br></td>
</tr>
<tr id="4">
<td class="type-info"><?=$jobname[3]?><a class="anchorjs-link" href="#h3.-bootstrap-heading"><span class="anchorjs-icon"></span></a></td>
<td class="type-info"><?=$desiredjob[3]?><br></br></td>
<td class="type-info"><?=$jobexpectations[3]?><br></br></td>
<td class="type-info"><ul><li><?=$req1[3]?></li><li><?=$req2[3]?></li><li><?=$req3[3]?></li><li><?=$req4[3]?></li><li><?=$req5[3]?></li></ul><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Approved" id="status"> Approve</label></div><br></br></td>
<td class="type-info" style="width:5%"><input type="checkbox" value="Denied" id = "status"> Deny</label></div><br></br></td>
<td class="type-info" style="width:5%"><button type="submit" name="submit" class="styled-button-2" onClick="myFunction()" value="submit">Confirm</button></td>
</td>
</tr>
</body>
</table>
确保为特定行选择一个checkbox
。
[注意:您的脚本面临 SQL 注入攻击的风险。使用mysqli_*
或PDO
]
<?php
//connect to the server
$link = mysql_connect('localhost', 'guest', 'guest');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
//connect to the database
mysql_select_db('projectdb');
?>
<form method="post" action="somePage.php">
<table>
<?php
$query = mysql_query("SELECT * FROM jobdetails WHERE status='In Progress...'");
while($rows = mysql_fetch_assoc($query))
{?>
<tr id="<?=$rows['no']?>">
<td class="type-info" style="width:10%">
<?=$rows['jobname']?>
<a class="anchorjs-link" href="#h3.-bootstrap-heading">
<span class="anchorjs-icon"></span>
</a>
</td>
<td class="type-info" style="width:10%"><?=$rows['desiredjob']?><br></br></td>
<td class="type-info" style="width:35%"><?=$rows['jobexpectations']?><br></br></td>
<td class="type-info" style="width:35%">
<ul>
<li><?=$req1['req1']?></li>
<li><?=$req2['req2']?></li>
<li><?=$req3['req3']?></li>
<li><?=$req4['req4']?></li>
<li><?=$req5['req5']?></li>
</ul>
<br></br>
</td>
<td class="type-info" style="width:5%">
<input type="checkbox" name="approve[]" value="<?=$rows['no']?>"><label> Approve</label><br></br>
</td>
<td class="type-info" style="width:5%">
<input type="checkbox" name="deny[]" value="<?=$rows['no']?>"><label> Deny</label>
<br></br>
</td>
</tr>
<?php }?>
</table>
</form>
</body>
某页.php
<?php
// Approved Rows
$countApprove = sizeof($_POST['approve']);
for($i=0;$i<$countApprove;$i++)
{
$id = $approve[$i];
mysql_query("UPDATE jobdetails SET status='Approved' WHERE no='$id'");
}
// Denied Rows
$countDeny = sizeof($_POST['deny']);
for($i=0;$i<$countDeny;$i++)
{
$id = $deny[$i];
mysql_query("UPDATE jobdetails SET status='Denied' WHERE no='$id'");
}
?>