我有一個(gè)pdo語(yǔ)句的片段，我想將其用作mysqli語(yǔ)句，但是我似乎并沒有得到它的幫助。我試圖將mysqli-> execute（array（））從pdo語(yǔ)句轉(zhuǎn)換為mysqli語(yǔ)句。據(jù)我了解，有execute（）語(yǔ)句，它不希望使用mysqli參數(shù)，但使用PDO則需要一個(gè)參數(shù)？這是代碼，我想將其轉(zhuǎn)換為mysqli語(yǔ)句：$sql = "SELECT * FROM users WHERE username = :username"; $sth = $GLOBALS["DB"]->prepare($sql); $sth->execute(array(":username" => $username)); $result = $sth->fetchAll(); if (!empty($result)) { $privUser = new PrivilegedUser(); $privUser->user_id = $result[0]["user_id"]; $privUser->username = $username; $privUser->password = $result[0]["password"]; $privUser->email_addr = $result[0]["email_addr"]; $privUser->initRoles(); return $privUser; } else { return false; }這是我當(dāng)前的代碼是：$sql = "SELECT * FROM users WHERE user_id = ?"; $stmt = $mysqli -> prepare($sql); $stmt->bind_param('s', $user_id);// line below is what i need to convert to a mysqli statement $stmt->execute(array(":user_id" => $user_id)); //$stmt->store_result(); $result = $stmt->fetchAll(); if (!empty($result)) { $privUser = new PrivilegedUser(); $privUser->user_id = $result[0]["user_id"]; $privUser->username = $user_id; $privUser->password = $result[0]["password"]; $privUser->email_addr = $result[0]["email_addr"]; $privUser->initRoles(); return $privUser; } else { return false; }
1 回答
慕尼黑的夜晚無(wú)繁華
TA貢獻(xiàn)1864條經(jīng)驗(yàn) 獲得超6個(gè)贊
就像上面的Nigel Ren所說(shuō)，Quote：“在mysqli中，對(duì)bind_param（）的調(diào)用是鏈接綁定變量的唯一方法，因此對(duì)execute（）的調(diào)用實(shí)際上就是$ stmt-> execute（）;”。
- 1 回答
- 0 關(guān)注
- 188 瀏覽
添加回答
舉報(bào)
0/150
提交
取消