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);
?> `