mysqli_fetch_assoc
<?php
/* Connect to your database */
$con = mysqli_query("hostname", "username", "pwd", "database");
/* Select Columns from table*/
$sql = "SELECT * FROM `TABLE`";
/* Query your SQL code to SQLDatabase */
$result = mysqli_query($con, $sql);
/* Find rows in table*/
$check = mysqli_num_rows($result);
if($check > 0){
while($data= mysqli_fetch_assoc($result)){
/* Print all of your data*/
echo $data["ColName"];
}
}
?>mysqli fetch row assoc
$sql = "SELECT Lastname, Age FROM Persons ORDER BY Lastname";
$result = mysqli_query($con, $sql);
/*MYSQLI_ASSOC
MYSQLI_NUM (this is default)
MYSQLI_BOTH
*/
// Fetch all
mysqli_fetch_all($result, MYSQLI_ASSOC);Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
