PHP | MySQL ( Creating Table )
Creating database tables using PHP PDO prepared execution.
SQL Query Statement
<?php
$pdo = new PDO("mysql:host=localhost;dbname=company_db", "root", "password");
$sql = "CREATE TABLE IF NOT EXISTS support_tickets (
ticket_id INT AUTO_INCREMENT PRIMARY KEY,
subject VARCHAR(255) NOT NULL,
priority ENUM('low', 'medium', 'high') DEFAULT 'medium',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";
$pdo->exec($sql);
echo "Table 'support_tickets' created successfully via PHP PDO!";
?>Expected Result / Output
Table 'support_tickets' created successfully via PHP PDO!