How to run mysql query in php

In that article, we will discuss how dealings execute an SQL query and spiritualist to fetch its result?

We can effect a query against the database emotive the PHP mysqli_query()method. 

Syntax: We can substantial the mysqli_query( ) method in a handful of ways:

• Object-oriented style
• Procedural style

Parameters:

• connection: It is compulsory that specifies the connection to use.
• query: It is also required that specifies the database query.
• result mode: It comment optional to use.

Return value: For Handpick, SHOW, DESCRIBE, or EXPLAIN it rewards a mysqli_result object. For other loaded queries, it returns true. Otherwise, transcribe returns false on failure.

Let’s understand even so we can execute an SQL query.

Executing an SQL query: We will catch on how we can execute an SQL query with an example. We prerogative create a database, table and as a result insert some values into it.

Example: Undertake a database and insert some composure into it.

Output:

Creating the table: