我正在嘗試使用 PHP 執(zhí)行刪除功能，需要Connection String并在其中創(chuàng)建 SQL 查詢。這是我的PHP代碼：function deleteEntry(){ require_once('connectionstring/connectionstring.php'); $conn = SQLServerConnection(); if( isset( $_POST['Delete'])){ try { $loginID = $_POST['deleteFormID']; $query = "UPDATE <table> SET <column>.active_flag = '0' WHERE <table>.login_cred_id = ?"; $parms = $loginID; $result = sqlsrv_query($conn, $query, $parms) or die (print_r ( sqlsrv_errors(), true)); } catch (Exception $ex) { echo $ex->getMessage(); } }}當(dāng)我回顯 $parms 時，它會顯示應(yīng)該傳遞的正確 ID。當(dāng)我嘗試將 PHP 參數(shù)傳遞給 SQL Query 時出現(xiàn)錯誤，即使我已經(jīng)使用正確的 ID 設(shè)置了參數(shù)。這是錯誤：Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -14 [code] => -14 [2] => An invalid parameter was passed to sqlsrv_query. [message] => An invalid parameter was passed to sqlsrv_query. ))
2 回答
交互式愛情
TA貢獻(xiàn)1712條經(jīng)驗(yàn) 獲得超3個贊
參數(shù)，即使只有一個參數(shù)，也必須在數(shù)組中傳遞。
所以改變這一行來做$parms一個數(shù)組
$parms = [$loginID];
嗶嗶one
TA貢獻(xiàn)1854條經(jīng)驗(yàn) 獲得超8個贊
Params 應(yīng)該是一個數(shù)組試試下面的代碼：
function deleteEntry()
{
require_once('connectionstring/connectionstring.php');
$conn = SQLServerConnection();
if( isset( $_POST['Delete'])){
try {
$loginID = $_POST['deleteFormID'];
$query = "UPDATE <table>
SET <column>.active_flag = '0'
WHERE <table>.login_cred_id = ?";
$parms[] = $loginID;
$result = sqlsrv_query($conn, $query, $parms) or die (print_r ( sqlsrv_errors(), true));
} catch (Exception $ex) {
echo $ex->getMessage();
}
}
}
- 2 回答
- 0 關(guān)注
- 257 瀏覽
添加回答
舉報(bào)
0/150
提交
取消