我的問(wèn)題是我想更新該行，但是當(dāng)我編輯該行時(shí)，它會(huì)添加新行并且一些數(shù)據(jù)不會(huì)檢索回?cái)?shù)據(jù)庫(kù)。有誰(shuí)知道我錯(cuò)過(guò)了什么？我應(yīng)該添加一些循環(huán)嗎？我正在使用按鈕提交，在按鈕提交中，我只想要同一行的函數(shù) editGroup（更新）。這意味著，用戶(hù)可以編輯行并單擊按鈕提交并更新行。PHP更新function editGroup(){global $ehorsObj;$employeeID = $_SESSION['employeeID'];$propertyID = $_SESSION['propertyID'];$accountID = (isset($_POST['accountID']) ? $_POST['accountID'] : '');$accountLedgerID = (isset($_POST['accountLedgerID']) ? $_POST['accountLedgerID'] : '');$accountNo = (isset($_POST['accountNo']) ? $_POST['accountNo'] : '');$accountName = (isset($_POST['accountName']) ? $_POST['accountName'] : '');//$accountMain = (isset($_POST['accountMain']) ? $_POST['accountMain'] : '');$openingBalance = (isset($_POST['openingBalance']) ? $_POST['openingBalance'] : '');$openingBalanceDate = (isset($_POST['openingBalanceDate']) ? $_POST['openingBalanceDate'] : '');$selectable = (isset($_POST['selectable']) ? $_POST['selectable'] : '');$popUp = (isset($_POST['popUp']) ? $_POST['popUp'] : '');$accountChar = (isset($_POST['accountChar']) ? $_POST['accountChar'] : '');$active = (isset($_POST['active']) ? $_POST['active'] : '');$sqlCount = "SELECT COUNT(*) AS TOTAL FROM tblAccAccounts WHERE accountID = '" . $accountID . "'";$GetResult = $ehorsObj->FetchData($sqlCount, $ehorsObj->DEFAULT_PDO_CONNECTIONS);while ($row = $GetResult->fetch()){ $total = $row ['TOTAL'];}有人對(duì)此有意見(jiàn)嗎？
1 回答
qq_笑_17
TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超7個(gè)贊
要更新表的行，您只需要執(zhí)行UPDATE查詢(xún)，INSERT之后無(wú)需使用。
這意味著不需要使用這部分代碼
accountID= $ehorsObj->EHORS_PK(tblAccAccounts);
$sqlAdd = "INSERT INTO tblAccAccounts
SET accountID = '" . $accountID . "',
accountLedgerID = '" . $accountLedgerID . "',
accountNo = '" . $accountNo . "',
accountName = '" . $accountName . "',
openingBalance = '" . $openingBalance . "',
openingBalanceDate = '" . $openingBalanceDate . "',
selectable = '" . $selectable . "',
popUp = '" . $popUp . "',
accountChar = '" . $accountChar . "',
active = 'y',
employeeID = '" . $employeeID . "',
propertyID = '" . $propertyID . "',
dateTimeEmployee = NOW() ";
$ehorsObj->ExecuteData($sqlAdd, $ehorsObj->DEFAULT_PDO_CONNECTIONS); }
此外，如果你想（你應(yīng)該是）INSERT一個(gè)新行，如果表中沒(méi)有現(xiàn)有行，你應(yīng)該只在對(duì)表執(zhí)行檢查后才這樣做。
例如 ：
$sql=mysqli_query($conn, "SELECT * FROM tblAccAccounts WHERE AccountID = $accountID");
if (mysqli_num_rows($sql) > 0) // table returned some rows
{
$sqlUpdate= <YOUR UPDATE COMMAND HERE>;
mysqli_query($conn,$sqlUpdate);
}
else { // no such row exists.
$sqlInsert=<YOUR INSERT COMMAND HERE>;
mysqli_query($conn,$sqlInsert);
}
- 1 回答
- 0 關(guān)注
- 139 瀏覽
添加回答
舉報(bào)
0/150
提交
取消