Cloudhostica Tech Blog - Learn Programming, Tech Sories, unboxing

  How to Connect PHP to MySQL Database? In this tutorial we will be learning about how to connect to MySQL Database Management System with PHP. Some Points on MySQL MySQL uses Standard SQL MySQL is free to download MySQL is best suitable for Small and Large Applications Some Points on PHP PHP is a server scripting language PHP scripts are executed in server and pure HTML is returned back to client. PHP files have extension  .php PHP is easy to Learn and implement PHP supports both Structural Programming Paradigm and Object Oriented Programming Paradigm. 1. First, Let's create a Database in MySQL CREATE DATABASE TestDB ; 2. Let's create a Table in TestDB CREATE TABLE testTABLE ( id INT , Fname VARCHAR ( 50 ) , Lname VARCHAR ( 50 ) , EmailID VARCHAR ( 120 ) ) ; 3. Let's Connect to TestDB $mysql_host = "localhost" ; //host address may vary. ex : localhost:3302 $mysql_user = "root" ; //Given by your hosting provider $mysql_pass = ...