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 user_value
(`user_name` varchar(4), `user_pass` varchar(3))
;
SELECT * FROM user_value;
<?php
$q = mysqli_prepare(
$mysqli,
"INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES (?, ?)"
);
$user = "mounir";
$pass = "pass";
$q->bind_param("ss", $user, $pass);
$q->execute();
$result = mysqli_query($mysqli, "SELECT * FROM `user_value`");
$data = mysqli_fetch_all($result);
print_r($data);