php - Echoing a mysqli query

Question

770 votes

1 answers

php - Echoing a mysqli query

Get the solution ↓↓↓

Undefined answered · Answer 1 · 2022-02-5

Answer

Solution:

when using mysqli you should read result bymysqli_fetch_row or something like that.
and suggest you use mysql_pdo instead.

<?php
//if error happend,this will display error on page
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$conn = mysqli_connect($servername, $username, $password, $dbname);

$result = mysqli_query($conn, "SELECT field_name FROM table_name");

//print result like this
while($row = mysqli_fetch_row($result)){
    print_r($row);
}

Popular technologies

Latest questions:

php - Echoing a mysqli query

Answer