If you want to create a table, you can run the CREATE TABLE statement as shown in the following :
CREATE TABLE statement
<?php
$con=mysqli_connect(“example.com”,”user”,”pass”,”my_db”);
// Check connection
if (mysqli_connect_errno()) {
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
$con=mysqli_connect(“example.com”,”user”,”pass”,”my_db”);
// Check connection
if (mysqli_connect_errno()) {
echo “Failed to connect to MySQL: ” . mysqli_connect_error();
}
// Create table
$sql=”CREATE TABLE users(FirstName CHAR(30),LastName CHAR(30),Age INT)”;
// Execute query
if (mysqli_query($con,$sql)) {
echo “Table users created successfully”;
} else {
echo “Error creating table: ” . mysqli_error($con);
}
?>
