Hàm mysqli_fetch_lengths() 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 * FROM Persons ORDER BY Lastname"; if ($result=mysqli_query($con,$sql)){ $row ...
Hàm mysqli_fetch_object() 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_fetch_row() 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,$s ...
Hàm mysqli_field_count() 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(); } mysqli_query($con,"SELECT * FROM Friends"); // Get number of columns - will always return ...
Hàm mysqli_field_seek() 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 = ...
Hàm mysqli_field_tell() 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_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,$ ...
