PHPize Online / SQLize Online  /  SQLtest Online

<?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);