我非常接近解决我的问题,这就是:
while ($row = mysqli_fetch_array($r,MYSQLI_ASSOC))
{
echo <tr><td align="left"> .
$row[ title ] . </td><td align="left">
. $row[ genre ] . </td><td align="left">
. $row[ length ] . </td><td align="left">
. $row[ created ] . </td><td align="left">
. $row[ views ] . </td><td align="left"> //. var_dump($row) //dump row value for testing
. <input type="checkbox" name="checkbox[]" value= " .$row[ upload_id ]. " . /> . </td> . </tr> ;
}
echo </table> ; // Close the table
和删除职能:
function submit_delete() {
if(!is_null($_POST[ delete ]) && !is_null($_POST[ checkbox ])) { //Check to see if a delete command has been submitted.
//This will dump your checkbox array to your screen if the submit works.
//You can manually check to see if you re getting the correct array with values
var_dump($_POST[ checkbox ]);//Comment this out once it s working.
deleteUploads($id_array);
}
else {
echo "Error: submit_delete called without valid checkbox delete.";var_dump($_POST[ checkbox ]);
}
}
function deleteUploads ($id_array) {
if (count($id_array) <= 0) { echo "Error: No deletes in id_array!"; var_dump($_POST[ checkbox ]); return; }//bail if its empty
$delete_success = false;
foreach ($id_array as &$id) {
$sql = "DELETE FROM `upload` WHERE `upload_id`=$id AND `owner_id`={$_SESSION[ user_id ]}";
$result = $mysqli->query($sql) or die(mysqli_error($mysqli));
if ($result) { $delete_success = true; }
}
if($delete_success) {
header( Location: newwriter_profile.php );
} else {
echo "Error: ".mysqli_error();
}
}
//Test deleteUploads (remove once you know the function is working)
//$test_ids = array();
//$test_ids[] = 5;//make sure this id is in the db
//$test_ids[] = 7;//this one too
submit_delete();
//deleteUploads($id_array);//should remove ids 10 and 9//
mysqli_close($dbc);
我已确定<代码>id_array。 核对箱没有获得正确的<代码>_POST值。 蒸汽显示,它有正确的上载胎,然后是I vardump id_array
,并显示UNL。 任何帮助都将受到高度赞赏。
CURRENTLY:
function submit_delete() {
if(!is_null($_POST[ delete ]) && !is_null($_POST[ checkbox ])) { //Check to see if a delete command has been submitted.
//This will dump your checkbox array to your screen if the submit works.
//You can manually check to see if you re getting the correct array with values
// var_dump($_POST[ checkbox ]);//Comment this out once it s working.
$id_array = $_POST[ checkbox ];
var_dump($id_array);
deleteUploads($id_array);
}
else {
echo "Error: submit_delete called without valid checkbox delete.";//var_dump($_POST[ checkbox ]);
}
}
function deleteUploads ($id_array) {
if (count($id_array) <= 0) { echo "Error: No deletes in id_array!"; return; }//bail if its empty
$delete_success = false;
foreach ($id_array as $id) {
$sql = "DELETE FROM `upload` WHERE `upload_id`=$id AND `owner_id`={$_SESSION[ user_id ]}";
$result = $mysqli->query($sql) or die(mysqli_error($mysqli));
if ($result) { $delete_success = true; }
}
if($delete_success) {
header( Location: newwriter_profile.php );
} else {
echo "Error: ".mysqli_error();
}
}
我在提一下“传说”后,正在得到正确选择,但在我提交删除之后,来文方表示,在我结束发言之后,没有人读过(路边和脚步消失)。 目前没有报告错误。