Hàm mysqli_connect() trong PHP - PHP Function
Code $link = mysqli_connect('localhost', 'root', '', 'lmgo'); if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } echo 'Success... ' . mysqli_get_host_info($link) . " "; mysqli_close($link);;
Hàm mysql_close() trong PHP - PHP Function
Code $link = @mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link);
Hàm mysql_connect() trong PHP - PHP Function
Code $link = @mysql_connect('localhost', 'roor', ''); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link);
Hàm mysqli_affected_rows() trong PHP - PHP Function
Code //trước khi chạy code, bạn phải tạo csdl lmgo với bảng chuyenmuc $con=mysqli_connect("localhost","root","","lmgo"); if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // thực hiện câu truy vấn mysqli_query($con,"SELECT * FROM ...
Hàm mysqli_change_user() trong PHP - PHP Function
Code $con=mysqli_connect("localhost","root","","lmgo"); if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // Reset all and select a new database mysqli_change_user($con, "my_user", "my_password", "my_test"); mysqli_close($con);
Hàm mysqli_connect_errno() trong PHP - PHP Function
Code $con=mysqli_connect("localhost","abcd","wrong_pass","lmgo"); die("Connection error: " . mysqli_connect_errno());
Hàm mysqli_connect_error() trong PHP - PHP Function
Code $con=mysqli_connect("localhost","abcd","wrong_pass","lmgo"); echo "Connection error: " . mysqli_connect_errno() . "<br />"; echo "Connection error: " . mysqli_connect_error();
Hàm mysqli_errno() 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(); } // Perform a query, check for error if (!mysqli_query($con,"INSERT INTO wrong_table (FirstName) VALUES ...
Hàm mysqli_error_list() 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(); } // Perform a query, check for error if (!mysqli_query($con,"INSERT INTO wrong_table (FirstName) VALUES ...
Hàm mysqli_error() 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(); } // Perform a query, check for error if (!mysqli_query($con,"INSERT INTO Persons (FirstName) VALUES ...
Hàm mysqli_fetch_all() 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"; $result=mysqli_query($con,$sql); ...
Hàm mysqli_fetch_array() 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"; $result=mysqli_query($con,$sql); ...
Hàm mysqli_fetch_assoc() 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"; $result=mysqli_query($con,$sql); ...
Hàm mysqli_fetch_field() 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_fetch_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,$sq ...
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 = ...
