Hot File

Here Connect MySql Database using PHP

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

9 point/1 review File has been tested

How to connect MySql database using PHP. PHP provides inbuilt functions to connect to MySql databaseusing their extensions. In this post, I’ll explain how to connect MySql Database using PHP.

Introduction

How to connect MySql database using PHP. PHP provides inbuilt functions to connect to MySql databaseusing their extensions. In this post, I’ll explain how to connect MySql Database using  PHP.

In PHP, you can connect MySql database using following extensions.

1) MySql (Worked only if you are using PHP Version 5.4 or less than that)

2) MySqli (MySql Improved)

3) PDO (PHP Data Objects)

Mysql API extension is deprecated from PHP 5.4 and now this extension is removed from the current version of PHP. So it’s better to learn how to connect MySql database using MySqli and PDO .

1. MySqli and PDO both supports parameterized query which is helpful in preventing an application from SQL injection .

2. Both supports object-oriented interface.

3. Accessing database through MySqli and PDO is faster than previously used MySql API extension.

Difference Between MySqli and PDO

How to Connect MySql Database using PHP

To access MySql database in your code, you need to do following steps –

1. Open a connection.

2. Specify and Connect to the database.

3. Once connection is establish, query(Select/Insert/Update) the database.

4. Close the connection.

Connect MySql Database using PHP MySqli

$server = 'localhost';
$user = 'root',
$password = '';
$dbname = 'test';
 
// Creating connection object.
 
$connection = new mysqli($server, $user, $password, $dbname); 
 
/* If connection is successful, connect_errno method returns 0 otherwise specific errno.*/
 
if($connection->connect_errno){  
 
        die('Could not connect');
 
}
//Connection class
 
class DB {
 
 protected $db_name = 'test';
 protected $db_user = 'root';
 protected $db_pass = '';
 protected $db_host = 'localhost';
 
 // Open a connect to the database
 
 public function connect() {
 
 $connect_db = new mysqli( $this->db_host, $this->db_user, $this->db_pass, $this->db_name );
 
 if ( mysqli_connect_errno() ) {
 printf("Connection failed: %s\
", mysqli_connect_error());
 exit();
 }
 return true;
 
 }
 
}

Connect MySql Database using PHP PDO

$username = 'root';
$password = '';
 
try {
     // Creating PDO object
     $DatabaseConn = new PDO('mysql:host=localhost;dbname=myDatabase', $username, $password);
 
} catch (Exception $e) {
   
    // If exception occurs
    echo $e->getMessage();
}

To prevent an application from SQL injection try to use the prepared statement.

$username = "raj";
$password = "foo";
 
try {
     // Creating PDO object
     $DatabaseConn = new PDO('mysql:host=localhost;dbname=myDatabase', $username, $password);
 
    // Parameterized query
    $query = $DatabaseConn->prepare('SELECT * FROM users WHERE username = :username and password = :password');
    $query->execute(array('username' => $username, 'password' => $password));
 
    while($row = $query->fetch()) {
        print_r($row);
    }
 
} catch (Exception $e) {
   
    // If exception occurs
    echo $e->getMessage();
}

Read detail post on connecting MySQL database using PDO.

Here Connect MySql Database using PHP

Here Connect MySql Database using PHP Posted on 05-10-2016  How to connect MySql database using PHP. PHP provides inbuilt functions to connect to MySql databaseusing their extensions. In this post, I’ll explain how to connect MySql Database using PHP. 9/10 101

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: 1659    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: 129    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: 123    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: 111    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: 139    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: 106    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: 128    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: 127    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