PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE user_value (`user_name` varchar(4), `user_pass` varchar(3)) ;
Copy Clear
Copy Format Clear
<?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($connection);
Show:  
Copy Clear