我嘗試在 while 循環(huán)內(nèi)運行多個查詢，但沒有任何反應，沒有顯示錯誤，也沒有顯示成功。任何人都可以解釋或幫助我解決這個問題嗎？這是我的代碼<?phpinclude('config.php'); $sql = 'SELECT * FROM inventory_masuk_dummy';$query = mysqli_query($conn, $sql); while($row = mysqli_fetch_array($query)) { $jumlah = $row['jml']; $size = $row['size']; $nama_barang = $row['nama_barang']; $status = $row['status']; $sql2 = "UPDATE inventory_dummy SET jumlah = jumlah+$jumlah WHERE nama_barang = '$nama_barang' AND size = '$size'"; $sql3 = "UPDATE inventory_masuk_dummy SET status = '2' WHERE status='1'"; while($row = mysqli_fetch_array($sql2) && $row = mysqli_fetch_array($sql3)) { echo "Berhasil di ubah, anda akan segera dialihkan"; }} echo "Nothing..."; ?>
1 回答
滄海一幻覺
TA貢獻1824條經(jīng)驗 獲得超5個贊
問題是您的代碼不執(zhí)行$sql2and $sql3，您可以使用再次執(zhí)行它mysqli_query
<?php
include('config.php');
$sql = 'SELECT * FROM inventory_masuk_dummy';
$query = mysqli_query($conn, $sql);
while($row = mysqli_fetch_array($query)) {
$jumlah = $row['jml'];
$size = $row['size'];
$nama_barang = $row['nama_barang'];
$status = $row['status'];
$sql2 = "UPDATE inventory_dummy SET jumlah = jumlah+$jumlah WHERE nama_barang = '$nama_barang' AND size = '$size'";
$sql3 = "UPDATE inventory_masuk_dummy SET status = '2' WHERE status='1'";
if ( mysqli_query($conn, $sql2) && mysqli_query($conn, $sql3) ) {
echo "Berhasil di ubah, anda akan segera dialihkan";
}
}
echo "Nothing...";
- 1 回答
- 0 關注
- 122 瀏覽
添加回答
舉報
0/150
提交
取消