note 127976 added to mysqli.prepare
| From: | urso at email dot cz | Date: | Sat, 03 Dec 2022 10:31:46 +0000 |
| Subject: | note 127976 added to mysqli.prepare | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-219932@lists.php.net to get a copy of this message | ||
Unfortunately, the use "/* bind result variables */
$stmt->bind_result($district);" is obsolete and condemned.
<?php
$mysqli = new mysqli("localhost", "test", "test", "test");
if ($mysqli->character_set_name()!="utf8mb4") {
$mysqli->set_charset("utf8mb4"); }
$secondname = "Ma%";
$types = "s";
$parameters = array($secondname);
$myquery = "select * from users where secondname like ?";
if ($stmt = $mysqli->prepare($myquery)) {
$stmt->bind_param($types, ...$parameters);
$stmt->execute();
$result = $stmt->get_result();
$stmt->close();
$numrows = $result->num_rows;
while($row = $result->fetch_assoc()) {
echo $row['firstname']." ".$row['secondname']."<br
/>";
}
}
$mysqli->close();
?>
Also, instead of '$stmt->bind_param("s", $city);', use
"$stmt->bind_param($types, ...$parameters);" with array. Here the advantage of using an
array ($parameters) is already obvious, instead of 5 variables, one array of 5 elements is used.
<?php
$mysqli = new mysqli("localhost", "test", "test", "test");
if ($mysqli->character_set_name()!="utf8mb4") {
$mysqli->set_charset("utf8mb4"); }
$uid = intval($_POST['uid']);
$length=15; $account = mb_substr(trim($_POST['account']),0,$length,"utf-8");
$account=strip_tags($account);
$length=50; $password = mb_substr(trim($_POST['password']),0,$length,"utf-8");
$password = password_hash($password, PASSWORD_DEFAULT);
$length=25; $prijmeni = mb_substr(trim($_POST['prijmeni']),0,$length,"utf-8");
$prijmeni=strip_tags($prijmeni);
$length=25; $firstname = mb_substr(trim($_POST['firstname']),0,$length,"utf-8");
$firstname=strip_tags($firstname); $firstname =
str_replace(array(">","<",'"'),
array("","",""), $firstname);
$dotaz = "UPDATE users SET account = ?, password = ?, secname = ?, firstname = ? WHERE uid =
?";
$types = "ssssi";
$parameters = array($account,$password,$prijmeni,$firstname,$uid);
if ($stmt = $mysqli->prepare($dotaz)) {
$stmt->bind_param($types, ...$parameters);
$stmt->execute();
echo $stmt->affected_rows;
$stmt->close();
}
$mysqli->close();
?>
----
Server IP: 45.112.84.4
Probable Submitter: 45.91.159.161 (proxied: 81.161.72.82)
----
Manual Page -- https://php.net/manual/en/mysqli.prepare.php
Edit -- https://main.php.net/note/edit/127976
Del: integrated -- https://main.php.net/note/delete/127976/integrated
Del: useless -- https://main.php.net/note/delete/127976/useless
Del: bad code -- https://main.php.net/note/delete/127976/bad+code
Del: spam -- https://main.php.net/note/delete/127976/spam
Del: non-english -- https://main.php.net/note/delete/127976/non-english
Del: in docs -- https://main.php.net/note/delete/127976/in+docs
Del: other reasons-- https://main.php.net/note/delete/127976
Reject -- https://main.php.net/note/reject/127976
Search -- https://main.php.net/manage/user-notes.php