PHP: [ Select all ]
$mysqli = new mysqli("host", "username", "password", "dbname");
$result = $mysqli->query("SELECT * FROM users");
while($row = $result->fetch_assoc()) {
echo $row['username'];
}
$result->close();
$mysqli->close();
PHP: [ Select all ]
$conn = mysqli_connect("host", "username", "password", "dbname");
$result = mysqli_query($conn, "SELECT * FROM users");
while($row = mysqli_fetch_assoc($result)) {
echo $row['username'];
}
mysqli_free_result($result);
mysqli_close($conn);