Write PHP Script for the following Creating connection with

Write PHP Script for the following Creating connection with MySQL Creating database tables Employee(emp_id, emp_name, emp_address, emp_salary, join_date, salary) Select database table Employee(emp_id, emp_name, emp_address, emp_salary, join_date, salary)

Solution

<?php
$servername = \"localhost\";
$username = \"jack\";
$password = \"123\";
$dbname = \"localDb\";

// Create connection
$connection = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($connection->connect_error) {
die(\"Connection failed: \" . $connection->connect_error);
}

// sql to create table
$sql = \"CREATE TABLE Employee (
emp_id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
emp_name VARCHAR(30) NOT NULL,
emp_address VARCHAR(30) NOT NULL,
emp_salary int(11) DEFAULT NULL,
join_date TIMESTAMP,
salary int(11) DEFAULT NULL,
)\";

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

$connection->close();
?>

<?php
$servername = \"localhost\";
$username = \"jack\";
$password = \"123\";
$dbname = \"localDb\";

// Create connection
$connection = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($connection->connect_error) {
die(\"Connection failed: \" . $connection->connect_error);
}

$sql = \"SELECT * FROM Employee\";
$resultSet = $conn->query($sql);

if ($resultSet->num_rows > 0) {
// output data of each row
while($row = $resultSet->fetch_assoc()) {
echo \"Employee Id: \" . $row[\"emp_id\"]. \" - Name: \" . $row[\"emp_name\"].\" - Address: \" . $row[\"emp_address\"].\" - Joining Date: \" . $row[\"join_date\"].\" - Employee salary: \" . $row[\"emp_salary\"].\" - Salary: \" . $row[\"salary\"] \"<br>\";
}
} else {
echo \"No result found\";
}
$conn->close();
?>