PHP MySQL Create Table

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

PHP mysql_query() function is used to create table. Since PHP 5.5, mysql_query() function is deprecated. Now it is recommended to use one of the 2 alternatives.

• mysqli_query()
• PDO::__query()

PHP MySQLi Create Table Example

Example

<?php  
$host = 'localhost:3306';  
$user = '';  
$pass = '';  
$dbname = 'test';  
  
$conn = mysqli_connect($host, $user, $pass,$dbname);  
if(!$conn){  
  die('Could not connect: '.mysqli_connect_error());  
}  
echo 'Connected successfully<br/>';  
  
$sql = "create table emp5(id INT AUTO_INCREMENT,name VARCHAR(20) NOT NULL,  
emp_salary INT NOT NULL,primary key (id))";  
if(mysqli_query($conn, $sql)){  
 echo "Table emp5 created successfully";  
}else{  
echo "Could not create table: ". mysqli_error($conn);  
}  
  
mysqli_close($conn);  
?>  

Output:

Connected successfully
Table emp5 created successfully

< prev

next >