Introduction
In this article I describe the PHP MySQLi functions mysqli_commit, mysqli_connect_errno, mysqli_connect, mysqli_connect_error and mysqli_data_seek. To learn some other MySQLi functions, go to:
- MySQLi Function in PHP: Part 1
PHP mysqli_commit() Function
The PHP MySQLi "mysqli_commit" function commits the current transactions and this function returns true on success or false on failure.
Syntax
Parameter in mysqli_commit function
The parameter of the function is:
Parameter |
Description |
connection |
It specifies the MySQL connection to use. |
Example
An example of the function is:
<?php
$con=mysqli_connect("localhost","root","","mysql");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_autocommit($con,FALSE);
mysqli_query($con,"INSERT INTO emp VALUES (106, 'Atul', 656456)");
echo "Affected rows: " . mysqli_affected_rows($con);
/*........For Fetch data of Emp Table
.......*/
//mysql_select_db("mysql", $con);
print "<h2>MySQL: Data of Emp table</h2>";
$result =mysqli_query($con,"SELECT * FROM emp");
echo "<table border='1'>
<tr>
<th>Id</th>
<th>Name</th>
<th>Salary</th>
</tr>";
while($rowval = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $rowval['id'] . "</td>";
echo "<td>" . $rowval['name'] . "</td>";
echo "<td>" . $rowval['salary'] . "</td>";
echo "</tr>";
}
echo "</table>";
/*........For Fetch data of Emp Table
.......*/
mysqli_commit($con); // commits the current transaction
mysqli_close($con);
?>
Output
PHP mysqli_connect_error_no() Function
The PHP MySQLi "mysqli_connect_error_no" function returns the error code from the last connected call, if an error occurs.
Syntax
Example
An example of the function is:
<?php
$con=mysqli_connect("localhost","root","","mysql");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_errno();
}
mysqli_close($con);
?>
No problem; the code above will be run, so now I am changing the code above. Suppose that the MySQL database has no password, and I am trying to pass a password in the mysqli_connect(), so what will happen? Let's see:
<?php
$con=mysqli_connect("localhost","root","sharad","mysql");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_errno();
}
mysqli_close($con);
?>
Output
PHP mysqli_connect() Function
The PHP MySQLi "mysqli_connect" function opens a new connection to the MySQL server and this function returns a MySQL link identifier on success or false on failure.
Syntax
mysqli_connect(hostname,username,password,dbname,port,socket) |
Parameters in the mysqli_connect function
The parameters of the function are:
Parameter |
Description |
host |
It specifies a host name or an IP address. |
username |
It specifies the MySQL username. |
password |
It specifies MySQL password. |
dbname |
It specifies the default database to be used when performing queries. |
port |
It specifies the port number to attempt to connect to MySQL server. |
socket |
It specifies the socket or named pipe to be used. |
Example
An example of the function is:
<?php
$con=mysqli_connect("localhost","root","","mysql");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else
{
echo "No error!, <b>connection has been established.</b>";
}
mysqli_close($con);
?>
Output
PHP mysqli_connect_error() Function
The PHP MySQLi mysqli_connect_error function returns a string description of the last connect error or say this function returns a string that describes the error on success and returns null if no error occurred.
Syntax
Example
An example of the function is:
<?php
$con=mysqli_connect("localhost","root","sharad","mysql");
if (mysqli_connect_error($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
mysqli_close($con);
?>
Output
PHP mysqli_data_seek() Function
The PHP MySQLi "mysqli_data_seek" function adjusts the result pointer to an arbitrary row in the result and this function returns true on success or false on failure.
Syntax
mysql_data_seek(result,offset) |
Parameter in mysqli_data_seek function
The parameters of the function are:
Parameter |
Description |
result |
It specifies the result set identifier returned by mysqli_query(). |
offset |
It specifies the field offset. |
Example
An example of the function is:
<?php
$con=mysqli_connect("localhost","root","","mysql");
if (mysqli_connect_errno($con))
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$qry="SELECT id,name,salary FROM emp order by name";
if ($result=mysqli_query($con,$qry))
{
mysqli_data_seek($result,0);
$row=mysqli_fetch_row($result);
printf ("ID: %s </br>Name: %s\n", $row[0], $row[1]);
mysqli_free_result($result);
}
mysqli_close($con);
?>
Output