Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE users (
Id INT,
name VARCHAR(255),
email VARCHAR(255)
);
INSERT INTO users(Id, name, email) VALUES(3, 'Almog', 'email@email');
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$select = $mysqli->prepare('SELECT * FROM users WHERE email=?');
$select->bind_param('s', ...['email@email']);
$select->execute();
$result = $select->get_result();
$row = $result->fetch_assoc();
$newemail = 'newemail';
$newname = 'newname';
$query = "UPDATE users SET name=?, email=? WHERE id=?";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("ssi", $newname, $newemail, $row['Id']);
$stmt->execute();
$select = $mysqli->prepare('SELECT * FROM users WHERE email=?');
$select->bind_param('s', ...['newemail']);
$select->execute();
$result = $select->get_result();
$row = $result->fetch_assoc();
var_dump($row);