query php
<?php // MySqli connection $mysqli = new mysqli("localhost", "my_username", "my_password", "my_database"); // Errors if($mysqli->connect_error) { echo "<b>Failed to connect to MySQL: </b>" . $mysqli->connect_error; } // Query $selectQuery = $mysqli->prepare("SELECT * FROM my_table"); $selectQuery->execute(); $selectQueryResult = $selectQuery->get_result(); // Loop while($selectQueryRow = $selectQueryResult->fetch_array()) { echo $selectQueryRow['my_column']; } // Example $selectUsername = $mysqli->prepare("SELECT * FROM users"); $selectUsername->execute(); $selectUsernameResult = $selectUsername->get_result(); while($selectUsernameRow = $selectUsernameResult->fetch_array()) { echo $selectUsernameRow['username']; }