How to MySqli Tutorial PHP MySqli Extension

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

0 point/0 review File has been tested

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

How to MySqli Tutorial PHP MySqli Extension Posted on 12-10-2016  PHP provides three api to connect mysql Database. 5/10 476

Comment:

To comment you must be logged in members.

Files with category

  • SimpleXML is a PHP extension that allows us to easily manipulate and get XML data

    SimpleXML is a PHP extension that allows us to easily manipulate and get XML data

    View: 66    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    SimpleXML provides an easy way of getting an element's name, attributes and textual content if you know the XML document's structure or layout. SimpleXML turns an XML document into a data structure you can iterate through like a collection of arrays...

  • How to use the PHP download file script? Class Download PHP

    How to use the PHP download file script? Class Download PHP

    View: 66    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    This is my favorite PHP download script. I’ve used a different more simple method until a client wanted to be able to allow their site visitors to download a large file from a password protected directory. The PHP script works on Apache web servers...

  • Installing OCI8 & PHP 7.2 on RHEL or CentOS 6

    Installing OCI8 & PHP 7.2 on RHEL or CentOS 6

    View: 204    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    You’ll need to stop Apache (web server) using the following command. In any Linux commands I show in this article, it presumes you aren’t logged in as the root user, so you will need to use sudo to issue privileged commands.

  • PHP source code: get content of google search

    PHP source code: get content of google search

    View: 171    Download: 2   Comment: 0

    Category: Php&mySql     Fields: Other

    How to get the results of google search and display on your website. This PHP code can do that. Refer to the following code.

  • PHP as a Scripting Language for C#

    PHP as a Scripting Language for C#

    View: 103    Download: 0   Comment: 0

    Category: Php&mySql     Fields: none

    When creating .NET applications (including desktop and web applications), it may be useful to allow extending the application using some scripting language. The users of the application can write simple scripts to configure the application, modify...

  • How to Picking the Brains of Your Customers with Microsoft’s Text Analytics

    How to Picking the Brains of Your Customers with Microsoft’s Text Analytics

    View: 4183    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    With the explosion of machine learning services in recent years, it has become easier than ever for developers to create “smart apps”. In this article, I’ll introduce you to Microsoft’s offering for providing machine-learning capabilities to apps.

  • How to MySqli Tutorial PHP MySqli Extension

    How to MySqli Tutorial PHP MySqli Extension

    View: 476    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    PHP provides three api to connect mysql Database.

  • Make Laravel Artisan Commands

    Make Laravel Artisan Commands

    View: 454    Download: 0   Comment: 0

    Category: Php&mySql     Fields: Other

    Artisan is the command line tool used in Laravel framework. It offers a bunch of useful command that can help you develop application quickly. Apart from Artisan available commands, you can create your own custom commands to improve your workflow.

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