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_query($mysqli, $query);
while ($row = mysqli_fetch_array($result)) {
// Access the values using numeric or associative keys
$value1 = $row[0]; // Access by numeric index
$value2 = $row['column_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);