Loading...

How to MySqli Tutorial PHP MySqli Extension

View: 644    Dowload: 0   Comment: 0   Post by: hanhga   Category: Php&mySql   Fields: Other

PHP provides three api to connect mysql Database.

1. MySql
2. MySqli
3. PDO

Out of these three MySql extension is deprecated as of PHP 5.5.0, and will be removed in the future.

MYSQLI is an improved object oriented extension introduced in PHP 5.

Advantages of MySqli over MySql

1. Support Object Oriented interface.

2. Concept of prepared statements is introduced which prevents sql injection.

3. Improved over all performance as compared to mysql extension.

PDO Tutorial

MySqli Tutorial: PHP MySqli Extension

Let’s Connect MySql Database with MySqli extension.

<?php
$server = 'localhost';
$user = 'root';
$password = '';
$dbname = 'example'; 
 
// For demostration purpose i use dbname example.
 
// Connect with mysqli. Creating Object.
$connection = new mysqli($server,$user,$password,$dbname); 
 
/* If connection is successful, <strong>connect_errno method returns 0</strong> otherwise specific errno.*/
 
if($connection->connect_errno){  
 
        die('Connection problem');
 
}
 
?>

Select Data Using MySqli

Let’s Select some data from emp table. MySqli Provides following fetch Modes.

1. fetch_object().
2. fetch_assoc().
3. fetch_array().

Here i am using fetch_object() to fetch records as an object.

<?php
 
   /* I left password field blank, if you have set any password for mysql then enter it.*/
 
   $connection = new mysqli('localhost','root','','example');
 
   if($connection->connect_errno){
 
 die('some error occurred while connection to Database');
 
     }
 
     $result = $connection->query("select * from emp");
 
    /* Fetch record as an object
     */
     while($data = $result->fetch_object()){
 
 echo "Name:".$data->name."Designation:".$data->designation."\n";
 }
 
      // Let's free the memory
 
 $result->free();
 
 // Connection close
 
 $connection->close();

Insert Using MySQLi

 

NOTE: If you are taking any user input and inserting into database it is advisable that you always validate them. Mysqli also provides real_escape_string method which escape special character in a string.

Take an example from user registration system, where user choose his/her username and password.


2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php
//values to be inserted in database table. Taking username and password from users.
 
// real_escape_string escape special characters. 
 
$username = $connection->real_escape_string($_REQUEST['username']);
$password = $connection->real_escape_string($_REQUEST['password']);
 
$insert_row = $connection->query("insert into users (username,password) values ('$username','$password')");
 
if($insert_row){
 
 // Return last insert id
        echo $connection->insert_id."\n";
 
 // Returns how many rows is affected
        echo $connection->affected_rows."\n";
 
}else{
 
 echo "error";
 
}
 
?>

In next MySqli Tutorial, i’ll show how to use prepared statement in MySqli.

How to MySqli Tutorial PHP MySqli Extension

PHP provides three api to connect mysql Database.

Posted on 12-10-2016 

Comment:

To comment you must be logged in members.

Files with category

  • Twitter-like Hashtag Function in PHP

    Twitter-like Hashtag Function in PHP

    View: 0    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    If you ever want a function to hashtag and style words within a string which has '#' next to it like twitter. This piece of code will help

  • PSITS Automated Voting System

    PSITS Automated Voting System

    View: 24    Download: 3   Comment: 0

    Category: Php&mySql     Fields: none

    A free sourcecode for PSITS Automated Voting System develop in PHP programming language. The purposed of the system is to automate the process of voting and maintain the quality of data

  • PHP-University Application System

    PHP-University Application System

    View: 30    Download: 6   Comment: 0

    Category: Php&mySql     Fields: none

    Greeting from Malawi the warm heart of Africa. I developed this university registration system project just to share with the people who can make use of the project like this and at the same time for others like students who can learn from it. This...

  • School Event Management System in PHP/MSQLi

    School Event Management System in PHP/MSQLi

    View: 22    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    This School Event Management System can create school events such as Volleyball games, Basketball, Cultural presentation, Election of school officers etc . During school election Instead of having a compile list of candidates and voters this system...

  • Resort Reservation System with PayPal/Credit Card/Debit Card Payment

    Resort Reservation System with PayPal/Credit Card/Debit Card Payment

    View: 27    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    This reservation system has the ability to help its customers find available rooms, cottages and even function hall for their convenience . And in here, they will also have the idea of the room rates where they can quickly reserve for their family...

  • Activity log

    Activity log

    View: 20    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Simple program to track user's activity log-in time and online/offline status.

  • Electricks - eCommerce

    Electricks - eCommerce

    View: 22    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Electricks is an e-commerce website built using PHP, Bootstrap and some jQuery plugins. It has all the major functionalities of a typical e-shop. This project was used to present in Southern Luzon State University - Lucban. Feel free to use this code...

  • Simple Email App Using PHP

    Simple Email App Using PHP

    View: 18    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    Creating a simple PHP script using mail function for sending out emails.

 
File suggestion for you
Loading...
File top downloads
Loading...
Loading...
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd