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(255), `user_pass` varchar(255))
;
INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES ('user', 'password');
INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES ('user1', 'password');
INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES ('user2', 'password')
<?php
$q = mysqli_prepare(
$mysqli,
"INSERT INTO `user_value` (`user_name`, `user_pass`) VALUES ('user', 'password')"
);
// $q->bind_param("ss", $user_names, $user_pass);
$q->execute();
$query = "SELECT * FROM user_value";
$result = mysqli_query($mysqli, $query);
while ($row = mysqli_fetch_array($result)) {
// Access the values using numeric or associative keys
$value2 = $row['user_name']; // Access by column name
// Output the values
echo $value1 . ' ' . $value2 . '<br>';
}
// Free the result set
mysqli_free_result($result);
// Close the database connection
mysqli_close($mysqli);