PHP Tutorial
Control Statement
PHP Programs
- 20-php-programs
PHP Functions
PHP Arrays
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
Upload Download
- php-file-upload
- php-download-file
PHP Misc
PHP Mail
- php-mail
PHP MySQLi
PHP JSON
- php-json-example
PHP OOPs Concepts
PHP Topics
Related Tutorials
Interview Questions

PHP MySQL Create Table

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

Next TopicPHP MySQL Insert Record

← prev next →

Hot Tutorials

HTML/CSS

JavaScript

Backend language

Development Framework

Database

Mobile development

Development tools

Big Data

XML Tutorial

Contact US

Email:jjw.quan@gmail.com

PHP Tutorial

Control Statement

PHP Programs

PHP Functions

PHP Arrays

PHP Strings

PHP Math

PHP Form

PHP Include

State Management

PHP File

Upload Download

PHP Misc

PHP Mail

PHP MySQLi

PHP JSON

PHP OOPs Concepts

PHP Topics

Related Tutorials

Interview Questions

PHP MySQL Create Table

PHP MySQLi Create Table Example

Hot Tutorials

Python tutorial

Vue.js Tutorial

HTML Tutorial

Java Tutorial

PHP Tutorial

Spring Tutorial

JavaScript Tutorial

CSS Tutorial

jQuery Tutorial

SQL Tutorial

C Tutorial

HTML/CSS

HTML Tutorial

HTML5 Tutorial

CSS Tutorial

Bootstrap Tutorial

JavaScript

JavaScript Tutorial

Vue.js Tutorial

ReactJS Tutorial

jQuery Tutorial

Node.js Tutorial

TypeScript Tutorial

AngularJS Tutorial

JSON Tutorial

Ajax Tutorial

ES6 Tutorial

Angular 7 Tutorial

jQuery UI Tutorial

Backend language

Python tutorial

Java Tutorial

Node.js Tutorial

PHP Tutorial

Go Tutorial

C Tutorial

C++ Tutorial

C# Tutorial

Ruby Tutorial

JSP Tutorial

JSTL Tutorial

ASP.NET Tutorial

Perl Tutorial

Scala Tutorial

VBA Tutorial

Development Framework

Spring Tutorial

Spring Boot Tutorial

Django Tutorial

Servlet Tutorial

Struts 2 Tutorial

Hibernate Tutorial

Solr Tutorial

Database

SQL Tutorial

MySQL Tutorial

Oracle Tutorial