Like Us Like Us Facebook Subscribe Subscribe us YouTube Whatsapp Share us Whatsapp Query Send your queries

My way learn MySQLI and PHP by examples

My way learn MySQLI and PHP by examples

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.

MySQLI and PHP by examples

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

5 1 vote
Article Rating
Subscribe
Notify of
guest

This site uses Akismet to reduce spam. Learn how your comment data is processed.

3 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
CSS3Mania

There are some quality design site which are sample show in this site. You can submit fresh siteĀ free download themes

Ali Atif

Informative Thanks for sharing dear.
Marvelloustechnologies.com

Fully Help

Nice blog…Very useful information is providing by ur blog. find Great beginning php tutorials Very clear and helpful for beginners.