PHP - MySQLi

Connector

<?php

    $db_host="localhost";

    $db_name="mydb";

    $db_user="root";

    $db_password="12345";

?>

Connection

$con=mysqli_connect($db_host,$db_user,$db_password,$db_name);  

SQL

$sql="SELECT * FROM t_user";

Query data

$query= mysqli_query($con,$sql);

if($query)

{

    while($row=mysqli_fetch_array($query))  

    {

    }

}    

Close Connection

    unset($row);

    mysqli_free_result($query);

    mysqli_close($con);

Get row count

$sql_count="SELECT COUNT(ID) AS TotalRow FROM t_user ";

$con=mysqli_connect($db_host,$db_user,$db_password,$db_name);              

$query= mysqli_query($con,$sql);

if($query)

{

    $row=mysqli_fetch_assoc($query);

    echo $row["TotalRow"];

}

mysqli_close($con);

Get Rows Number

$num_rows = mysqli_num_rows($query);