PHP: mysqli_result::fetch_array - Manual (original) (raw)

`<?php

mysqli_report

(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); mysqli=newmysqli("localhost","myuser","mypassword","world");mysqli = new mysqli("localhost", "my_user", "my_password", "world");mysqli=newmysqli("localhost","myu​ser","myp​assword","world");query = "SELECT Name, CountryCode FROM City ORDER BY ID LIMIT 3"; result=result = result=mysqli->query($query);/* numeric array / row=row = row=result->fetch_array(MYSQLI_NUM);
printf("%s (%s)\n", row[0],row[0], row[0],row[1]);/ associative array / row=row = row=result->fetch_array(MYSQLI_ASSOC);
printf("%s (%s)\n", row["Name"],row["Name"], row["Name"],row["CountryCode"]);/ associative and numeric array */ row=row = row=result->fetch_array(MYSQLI_BOTH);
printf("%s (%s)\n", row[0],row[0], row[0],row["CountryCode"]);`

`<?php

mysqli_report

(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT); mysqli=mysqliconnect("localhost","myuser","mypassword","world");mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");mysqli=mysqlic​onnect("localhost","myu​ser","myp​assword","world");query = "SELECT Name, CountryCode FROM City ORDER by ID LIMIT 3"; result=mysqliquery(result = mysqli_query(result=mysqliq​uery(mysqli, $query);/* numeric array / row=mysqlifetcharray(row = mysqli_fetch_array(row=mysqlif​etcha​rray(result, MYSQLI_NUM);
printf("%s (%s)\n", row[0],row[0], row[0],row[1]);/ associative array / row=mysqlifetcharray(row = mysqli_fetch_array(row=mysqlif​etcha​rray(result, MYSQLI_ASSOC);
printf("%s (%s)\n", row["Name"],row["Name"], row["Name"],row["CountryCode"]);/ associative and numeric array */ row=mysqlifetcharray(row = mysqli_fetch_array(row=mysqlif​etcha​rray(result, MYSQLI_BOTH);
printf("%s (%s)\n", row[0],row[0], row[0],row["CountryCode"]);`

Kabul (AFG) Qandahar (AFG) Herat (AFG)