PHP mysqli query() Function

by tutorialsw3.com - May 23, 2019

Definition and Usage

The query() / mysqli_query() function performs a query against a database.

Syntax

Object oriented style:

Procedural style:

Example - Object Oriented style

Perform query against a database:

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

// Check connection
if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}

// Perform query
if ($result = $mysqli -> query("SELECT * FROM Persons"))  {
echo "Returned rows are: " . $result -> num_rows;
// Free result set
$result -> free_result();
}

$mysqli -> close();
?>

Definition The mysqli_query() function performs a query against the database. · Syntax PHP mysqli_query() Function has the following syntax. mysqli_query( ...

mysqli_query create table, mysqli_query or die, mysqli_query result, mysqli_query to array, insert

mysqli_query create table, mysqli_query or die, mysqli_query result, mysqli_query to array, insert