Hot File

How to MySqli Tutorial PHP MySqli Extension

View: 246    Dowload: 0   Comment: 0   Post by: hanhga  
Author: none   Category: Php&mySql   Fields: Other

0 point/0 review File has been tested

PHP provides three api to connect mysql Database.

Introduction

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 246

Comment:

To comment you must be logged in members.

Files with category

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

    View: 2948    Download: 0   Comment: 0   Author: none  

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

    Category: Php&mySql
    Fields: Other

    5/1 review
    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

    View: 246    Download: 0   Comment: 0   Author: none  

    How to MySqli Tutorial PHP MySqli Extension

    Category: Php&mySql
    Fields: Other

    0/0 review
    PHP provides three api to connect mysql Database.

  • Make Laravel Artisan Commands

    View: 222    Download: 0   Comment: 0   Author: none  

    Make Laravel Artisan Commands

    Category: Php&mySql
    Fields: Other

    0/0 review
    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.

  • Check if a Number is a Power of 2

    View: 202    Download: 0   Comment: 0   Author: none  

    Check if a Number is a Power of 2

    Category: Php&mySql
    Fields: Other

    2.25/2 review
    How to check if a number is a power of 2. To understand this question, let’s take some example.

  • Concatenate columns in MySql

    View: 261    Download: 0   Comment: 0   Author: none  

    Concatenate columns in MySql

    Category: Php&mySql
    Fields: Other

    0/1 review
    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

  • How to Query NULL Value in MySql

    View: 193    Download: 0   Comment: 0   Author: none  

    How to Query NULL Value in MySql

    Category: Php&mySql
    Fields: Other

    5/1 review
    Misunderstanding NULL is common mistake beginners do while writing MySql query. While quering in MySql they compare column name with NULL. In MySql NULL is nothing or in simple word it isUnknown Value so if you use comparison operator for NULL values...

  • How to Abstract Class in PHP

    View: 226    Download: 0   Comment: 0   Author: none  

    How to Abstract Class in PHP

    Category: Php&mySql
    Fields: Other

    0/0 review
    What is an abstract class in PHP and when to use an abstract class in your application. In this tutorial, we’ll learn about abstract class and their implementation.

  • Use Enums in Rails for Mapped Values

    View: 221    Download: 0   Comment: 0   Author: none  

    Use Enums in Rails for Mapped Values

    Category: Php&mySql
    Fields: Other

    5/1 review
    When I worked in a call center, we used to mark cases with different statuses. This allowed upper management to get a handle on where cases stood, what the bottlenecks were and flow of calls. Thankfully it has been a long time since I worked in a...

 
Newsletter Email

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd