fetch_array(MYSQLI_ASSOC) code example

Example 1: 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"];
    }
    }
?>

Example 2: mysqli load result into array

$resource = $db->query("SELECT * FROM users WHERE userid = '".$userid."'");
while($row = $resource->fetch_array()) { $the_rows[] = $row; }
		/// later use like:
		//	foreach($the_rows as $row)
		//	{
		//		echo $row['product'];
		//	}