// Create a new database connection $conn = new mysqli($servername, $username, $password, $dbname); // Create the user table $sql = "CREATE TABLE users ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(30) NOT NULL, password VARCHAR(30) NOT NULL, email VARCHAR(50) )"; // Execute the SQL query if ($conn->query($sql) === TRUE) { echo "User table created successfully!"; } else { echo "Error creating table: " . $conn->error; } // Close the database connection $conn->close();
// Create a new database connection $conn = new mysqli($servername, $username, $password, $dbname); // Create the product table $sql = "CREATE TABLE products ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30) NOT NULL, description TEXT, price DECIMAL(10, 2) NOT NULL, quantity INT(11) NOT NULL )"; // Execute the SQL query if ($conn->query($sql) === TRUE) { echo "Product table created successfully!"; } else { echo "Error creating table: " . $conn->error; } // Close the database connection $conn->close();Both examples use the MySQL package library which allows PHP developers to interact with MySQL databases. MySQL is one of the most popular relational database management systems used in web development.