Php -- 2,

Php -- 2,

Do not change the. php file to Chinese in case of a problem, which may cause No input file specified errors.

 

Create a data table

<? Php
$ Servername = "localhost ";
$ Username = "root ";
$ Password = "123456 ";
$ Dbname = "myDB ";

// Create a connection
$ Conn = new mysqli ($ servername, $ username, $ password, $ dbname );
// Detect connections
If ($ conn-> connect_error ){
Die ("Connection Failed:". $ conn-> connect_error );
}

// Use SQL to create a data table
$ SQL = "CREATE TABLE MyGuests (
Id INT (6) UNSIGNED AUTO_INCREMENT primary key,
Firstname VARCHAR (30) not null,
Lastname VARCHAR (30) not null,
Email VARCHAR (50 ),
Reg_date TIMESTAMP
)";

If ($ conn-> query ($ SQL) === TRUE ){
Echo "Table MyGuests created successfully ";
} Else {
Echo "data table creation error:". $ conn-> error;
}

$ Conn-> close ();
?>