Write a PHP program to connect to a database and create a database with employee table.

Certainly! Here’s a PHP program that connects to a MySQL database and creates a database along with an employee table.

PHP Program

<?php
// Step 1: Database configuration
$servername = "localhost"; // Server name
$username = "your_username"; // Database username
$password = "your_password"; // Database password

// Step 2: Create a connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";

// Step 3: Create a database
$sql = "CREATE DATABASE EmployeeDB";
if ($conn->query($sql) === TRUE) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $conn->error;
}

// Step 4: Select the created database
$conn->select_db("EmployeeDB");

// Step 5: Create a table
$sql = "CREATE TABLE Employee (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    first_name VARCHAR(30) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    hire_date DATE,
    salary DECIMAL(10, 2)
)";

if ($conn->query($sql) === TRUE) {
    echo "Table Employee created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

// Step 6: Close the connection
$conn->close();
?>

Instructions:

1. Replace your_username and your_password with your actual database username and password.
2. Run this script on a server with PHP and MySQL installed (like XAMPP, MAMP, or a live server).
3. Upon successful execution, it will create a database named EmployeeDB and a table named Employee with predefined columns.

Final Note:

Make sure to handle potential errors and confirmations in a production environment. Always sanitize and prepare your database queries to prevent SQL injections.