•Now that we have setup our connection to the database, lets run a query on our database to extract some information from sample table in tecwallet database

 

•Storing the query that we want to run in the variable $query

  $query = "SELECT * FROM sample" or die("Error in the consult.." . mysqli_error($link));

 

•Performing a query against the database using mysqli_query() function and storing the result in $result variable

  $result = mysqli_query($link, $query);

 

•Fetching the output in array format and displaying that using while loop

 

  while($row = mysqli_fetch_array($result)) {

  echo $row["name"] . " lives at " .   $row["address"] . " " . $row["city"] . " " .   $row["country"] . "<br/>";

  }

 

•mysqli_fetch_array fetches a result row as an associative, a numeric array, or both