MySQL is world most used database and when its works PHP then they have no match. Learning MySQL is very is one can found thousand of tutorial on net but these are now old as MySQLI(or MySQL Advanced) next version are now on demand as implementation is easy, secure and little bit faster. In this tutorial I am going to share Uses of MySQli in your next project.
For Connecting to database, create a PHP file name dbsettings.php with following code :
[php]
$sanjay=new mysqli(‘localhost’,’root’,”,’mysqlifirst’);
if($sanjay->connect_errno){
echo $sanjay->connect_error;
}
[/php]
I think above line is quite easy to understand, mysqlifirst is the name of your database.
Data query :
Suppose you have a table name billings which has coloumn trans_id, amount and so on.
Create a another file name dataquery.php with following code:
[php]
require(‘dbsettings.php’);
$query=”select * from billings where trans_id=’2013′ “;
$sendq=$sanjay->query($query);
$rows=$sendq->fetch_assoc();
echo “Transaction ID. 2013 amount is Rs.”.$rows[‘amount’];
[/php]
This is I think a very simple example of using MySqli. If you have any doubt then comment below , I will try to explain it later.
+Sanjay Prasad
There are some quality design site which are sample show in this site. You can submit fresh site free download themes
Informative Thanks for sharing dear.
Marvelloustechnologies.com
Nice blog…Very useful information is providing by ur blog. find Great beginning php tutorials Very clear and helpful for beginners.