Php code to create database and table
A database consists of one or more tables. Show
You will need special CREATE privileges to create or to delete a MySQL database. Create a MySQL Database Using MySQLi and PDOThe CREATE DATABASE statement is used to create a database in MySQL. The following examples create a database named "myDB": Example (MySQLi Object-oriented)$servername = "localhost"; // Create connection // Create database $conn->close(); Note: When you create a new database, you must only specify the first three arguments to the mysqli object (servername, username and password). Tip: If you have to use a specific port, add an empty string for the database-name argument, like this: new mysqli("localhost", "username", "password", "", port) Example (MySQLi Procedural)$servername = "localhost"; // Create connection // Create database mysqli_close($conn); Note: The following PDO example create a database named "myDBPDO": Example (PDO)$servername = "localhost"; try { $conn = null; Tip: A great benefit of PDO is that it has exception class to handle any problems that may occur in our database queries. If an exception is thrown within the try{ } block, the script stops executing and flows directly to the first catch(){ } block. In the catch block above we echo the SQL statement and the generated error message. A database table has its own unique name and consists of columns and rows. Create a MySQL Table Using MySQLi and PDOThe CREATE TABLE statement is used to create a table in MySQL. We will create a table named "MyGuests", with five columns: "id", "firstname", "lastname", "email" and "reg_date": CREATE TABLE MyGuests ( Notes on the table above: The data type specifies what type of data the column can hold. For a complete reference of all the available data types, go to our Data Types reference. After the data type, you can specify other optional attributes for each column:
Each table should have a primary key column (in this case: the "id" column). Its value must be unique for each record in the table. The following examples shows how to create the table in PHP: Example (MySQLi Object-oriented)$servername = "localhost"; // Create connection // sql to create table if ($conn->query($sql) === TRUE)
{ $conn->close(); Example (MySQLi Procedural)$servername = "localhost"; // Create connection // sql to create table if (mysqli_query($conn, $sql)) { mysqli_close($conn); Example (PDO)$servername = "localhost"; try { // sql to create table // use exec() because no results are returned $conn = null; How can we create a database using PHP?The basic steps to create MySQL database using PHP are: Establish a connection to MySQL server from your PHP script as described in this article. If the connection is successful, write a SQL query to create a database and store it in a string variable. Execute the query.
Can PHP be used for database?With PHP, you can connect to and manipulate databases. MySQL is the most popular database system used with PHP.
How do you create a database and table in MySQL?Create a Table in MySQL Shell. Step 1: Log into the MySQL Shell. Step 2: Create a Database. Step 3: Create a Table.. Create a Table Using a File Script.. Query MySQL Data. Display Column Data. Create a View. Alter a View.. How use PHP with MySQL database with example?PHP Create a MySQL Database. Example (MySQLi Object-oriented) Example (MySQLi Procedural)
Example (PDO)
|