PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
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')
Copy Clear
Copy Format Clear
<?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); var_dump($result); // Free the result set mysqli_free_result($result); // Close the database connection mysqli_close($mysqli);
Show:  
Copy Clear