$mysql = new mysqli('localhost', 'root', '', 'factotum_base');
if ($mysql) {
echo ":)";
} else {
echo ":(";
}
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysql = new mysqli('localhost', 'root', '', 'factotum_base');
if ($res == false) {
printf("Ошибка при выполнении запроса\n"); //вылетает ошибка :(
} else {
printf("Запрос выполнен :)");
}
$ids = explode(",", $ids);
$in = str_repeat('?,', count($ids) - 1) . '?';
return $this->db->row("SELECT * FROM cources WHERE id IN ($in)", $ids);
$stmt = $connection->prepare("INSERT INTO `users` (`username`, `email`, `password`) VALUES (?,?,?)");
$stmt->bind_param("sss", $username, $email, $password);
$stmt->execute();
$smsg="Регистрация прошла успешно";
$data = [
['foo@example.com', password_hash('password1', PASSWORD_DEFAULT)],
['bar@example.com', password_hash('password2', PASSWORD_DEFAULT)],
];
$stmt = $mysqli->prepare("INSERT INTO users VALUES (null,?,?)");
$mysqli->begin_transaction();
foreach ($data as $row) {
$stmt->bind_param("ss", ...$row);
$stmt->execute();
}
$mysqli->commit();