我的問題是我想更新該行，但是當我編輯該行時，它會添加新行并且一些數據不會檢索回數據庫。有誰知道我錯過了什么？我應該添加一些循環嗎？我正在使用按鈕提交，在按鈕提交中，我只想要同一行的函數 editGroup（更新）。這意味著，用戶可以編輯行并單擊按鈕提交并更新行。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'];}有人對此有意見嗎？
1 回答
qq_笑_17
TA貢獻1818條經驗 獲得超7個贊
要更新表的行，您只需要執行UPDATE查詢，INSERT之后無需使用。
這意味著不需要使用這部分代碼
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); }
此外，如果你想（你應該是）INSERT一個新行，如果表中沒有現有行，你應該只在對表執行檢查后才這樣做。
例如 ：
$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 關注
- 138 瀏覽
添加回答
舉報
0/150
提交
取消