1. Write a PHP script to create an employee table using attributes employee number, employee name, address joining date and salary. If a table is created then display the appropriate message otherwise end the PHP script.

Assignment: Set A Q.1 Solution

Write a PHP script to create an employee table using attributes employee number, employee name, address joining date and salary. If a table is created then display the appropriate message otherwise end the PHP script.

index.php:

          <?php
  $conn=mysql_connect("localhost","root","");
    if(!$conn)
    {
      echo"Could not connect database";
    }
    
  $sd=mysql_select_db("seta");
  if(!$sd)
  {
    echo"Could not select database";
  }

  $ct=mysql_query(" create table employee
                  (
                      eno int not null primary key,
                      ename varchar(40),
                      esal int,
                      joindate date,
                      eadd varchar(40)
                  );
                    
                  ");
  if(!$ct)
  {
    echo"Table not created or already exist";
  }
  else
  {
    echo"Table Created sucessfully with attributes:<br>";
    echo"eno <br>";
    echo"ename <br>";
    echo"esal<br>";
    echo"joindate<br>";
    echo"eadd<br>";
  }
  
?>