Hàm mysqli_free_result() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="SELECT Lastname,Age FROM Persons ORDER BY Lastname"; if ($result=mysqli_query($con,$ ...
Hàm mysqli_get_charset() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } var_dump(mysqli_get_charset($con)); mysqli_close($con);
Hàm mysqli_get_client_stats() trong PHP - PHP Function
Code echo "<pre>"; print_r(mysqli_get_client_stats()); echo "</pre>";
Hàm mysqli_get_client_version() trong PHP - PHP Function
Code echo "<pre>"; print_r(mysqli_get_client_version()); echo "</pre>";
Hàm mysqli_get_connection_stats() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } print_r(mysqli_get_connection_stats($con)); mysqli_close($con);
Hàm mysqli_get_host_info() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo mysqli_get_host_info($con); mysqli_close($con);
Hàm mysqli_get_proto_info() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo mysqli_get_proto_info($con); mysqli_close($con);
Hàm mysqli_get_server_info() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo mysqli_get_server_info($con); mysqli_close($con);
Hàm mysqli_get_server_version() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } echo mysqli_get_server_version($con); mysqli_close($con);
Hàm mysqli_info() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Perform queries $sql1="CREATE TABLE testPersons LIKE Persons"; mysqli_query($con,$sql1); ...
Hàm mysqli_init() trong PHP - PHP Function
Code $con = mysqli_init(); if (!$con){ die("mysqli_init failed"); } if (!mysqli_real_connect($con,"localhost","my_user","my_password","my_db")){ die("Connect Error: " . mysqli_connect_error()); } mysqli_close($con);
Hàm mysqli_multi_query() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "SELECT Lastname FROM Persons ORDER BY LastName;"; $sql .= "SELECT Country FROM ...
Hàm mysqli_next_result() trong PHP - PHP Function
Code $con =m ysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "SELECT Lastname FROM Persons ORDER BY LastName;"; $sql .= "SELECT Country FROM ...
Hàm mysqli_num_fields() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="SELECT Lastname,Age FROM Persons ORDER BY Lastname"; if ($result=mysqli_query($con,$ ...
Hàm mysqli_num_rows() trong PHP - PHP Function
Code $con=mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql="SELECT Lastname,Age FROM Persons ORDER BY Lastname"; if ($result=mysqli_query($con,$sq ...
Hàm mysqli_options() trong PHP - PHP Function
Code $con=mysqli_init(); if (!$con){ die("mysqli_init failed"); } mysqli_options($con,MYSQLI_READ_DEFAULT_FILE,"myfile.cnf"); if (!mysqli_real_connect($con,"localhost","my_user","my_password","my_db")){ die("Connect Error: " . mysqli_connect_error()); } mysqli_close($c ...
Hàm mysqli_ping() trong PHP - PHP Function
Code $con=mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Check if server is alive if (mysqli_ping($con)){ echo "Connection is ...
Hàm mysqli_query() trong PHP - PHP Function
Code <?php $con = mysqli_connect("localhost","my_user","my_password","my_db"); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Perform queries mysqli_query($con,"SELECT * FROM Persons"); mysqli_query($con ...
Hàm mysqli_real_connect() trong PHP - PHP Function
Code $con=mysqli_init(); if (!$con){ die("mysqli_init failed"); } if(!mysqli_real_connect($con,"localhost","my_user","my_password","my_db")){ die("Connect Error: " . mysqli_connect_error()); } mysqli_close($con);
Hàm mysqli_refresh() trong PHP - PHP Function
Code $con = mysqli_connect("localhost","root","","lmgo"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } mysqli_refresh($con,MYSQLI_REFRESH_GRANT); mysqli_close($con);
