PHP MySQL Connect

PHP Tutorial

• PHP Tutorial
• Install PHP
• PHP Code
• PHP Echo and print
• PHP Variable
• PHP Variable Scope
• PHP $ and $$
• PHP Constants
• PHP Data Types
• PHP Operators
• PHP Comments

Control Statement

• PHP If else
• PHP Switch
• PHP For Loop
• PHP foreach loop
• PHP While Loop
• PHP Do While Loop
• PHP Break
• PHP Continue

PHP Functions

• PHP Functions
• Parameterized Function
• PHP Call By Value and reference
• PHP Default Arguments
• PHP Variable Arguments
• PHP Recursive Function

PHP Arrays

• PHP Array
• PHP Indexed Array
• PHP Associative Array
• Multidimensional Array
• PHP Array Functions

PHP Strings

• PHP String
• PHP String Functions

PHP Math

• PHP Math Functions

PHP Form

• PHP Form: Get Post

PHP Include

• PHP include & require

State Management

• PHP Cookie
• PHP Session

PHP File

• PHP File Handling
• PHP Open File
• PHP Read File
• PHP Write File
• PHP Append File
• PHP Delete File

Upload Download

• PHP File Upload
• PHP Download File

PHP OOPs Concepts

• OOPs Concepts
• OOPs Abstract Class
• OOPs Abstraction
• OOPs Access Specifiers
• OOPs Const Keyword
• OOPs Constructor and destructor
• Encapsulation
• Final Keyword
• OOPs Functions
• OOPs Inheritance
• OOPs Interface
• OOPs Overloading
• OOPs Type Hinting

PHP MySQLi

• MySQLi CONNECT
• MySQLi CREATE DB
• MySQLi CREATE Table
• MySQLi INSERT
• MySQLi UPDATE
• MySQLi DELETE
• MySQLi SELECT
• MySQLi Order by

PHP Topics

• Compound Types
• is_null() Function
• Special Types
• Inheritance Task
• Special Types
• MVC Architecture
• PHP vs. JavaScript
• PHP vs. HTML
• PHP vs. Node.js
• PHP vs Python
• PHP PDO
• Top 10 PHP frameworks
• phpMyAdmin
• Count All Array Elements
• Create Newline
• Get Current Page URL

PHP Mail

• PHP Mail

Since PHP 5.5, mysql_connect() extension is deprecated. Now it is recommended to use one of the 2 alternatives.

• mysqli_connect()
• PDO::__construct()

---

PHP mysqli_connect()

PHP mysqli_connect() function is used to connect with MySQL database. It returns resource if connection is established or null.Syntax

1. resource mysqli_connect (server, username, password)  

PHP mysqli_close()

PHP mysqli_close() function is used to disconnect with MySQL database. It returns true if connection is closed or false.

Syntax

1. bool mysqli_close(resource $resource_link)  

PHP MySQL Connect Example

Example

<?php  
$host = 'localhost:3306';  
$user = '';  
$pass = '';  
$conn = mysqli_connect($host, $user, $pass);  
if(! $conn )  
{  
  die('Could not connect: ' . mysqli_error());  
}  
echo 'Connected successfully';  
mysqli_close($conn);  
?>  

Output:

Connected successfully

< prev

next >