query( "DROP TABLE IF EXISTS friends");$mysqli->query( "CREATE TABLE friends (id int, name varchar(20))");$mysqli->query( "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");$mysqli->real_query("SELECT * FROM friends");if ($mysqli->field_count) {    /* this was a select/show or describe query */    $result = $mysqli->store_result();/* process resultset */    $row = $result->fetch_row();/* free resultset */    $result->close();}/* close connection */$mysqli->close();?>">

Returns the number of columns for the most recent query (original) (raw)

`<?php mysqli=newmysqli("localhost","myuser","mypassword","test");mysqli = new mysqli("localhost", "my_user", "my_password", "test");mysqli=newmysqli("localhost","myuser","mypassword","test");mysqli->query( "DROP TABLE IF EXISTS friends"); mysqli−>query("CREATETABLEfriends(idint,namevarchar(20))");mysqli->query( "CREATE TABLE friends (id int, name varchar(20))");mysqli>query("CREATETABLEfriends(idint,namevarchar(20))");mysqli->query( "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");$mysqli->real_query("SELECT * FROM friends");

if (

$mysqli->field_count) {
/* this was a select/show or describe query / result=result = result=mysqli->store_result();/ process resultset / row=row = row=result->fetch_row();/ free resultset /
$result->close();
}/
close connection */
$mysqli->close();
?> `

`<?php link=mysqliconnect("localhost","myuser","mypassword","test");mysqliquery(link = mysqli_connect("localhost", "my_user", "my_password", "test");mysqli_query(link=mysqliconnect("localhost","myuser","mypassword","test");mysqliquery(link, "DROP TABLE IF EXISTS friends");
mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))");mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");mysqli_real_query($link, "SELECT * FROM friends");

if (

mysqli_field_count($link)) {
/* this was a select/show or describe query / result=mysqlistoreresult(result = mysqli_store_result(result=mysqlistoreresult(link);/ process resultset / row=mysqlifetchrow(row = mysqli_fetch_row(row=mysqlifetchrow(result);/ free resultset /
mysqli_free_result($result);
}/
close connection */
mysqli_close($link);
?> `