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))
;
<?php
$q = mysqli_prepare(
$mysqli,
"INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES (?, ?)"
);
$q->bind_param("ss", $user_names, $user_pass);
$q->execute();
$query = 'SELECT * from user_value';
$result = $mysqli->execute($query);
foreach ($result as $row) {
printf("%s (%s)\n", $row["user_name"], $row["user_pass"]);
}