here are the three pages source codes : 

1. form.php

<?php

Customer data form (Add a customer):
<form action="CreateDataBaseAndInsert.php" method="post" >
CustomerID: <input type="text" name="customerid" />
Name: <input type="text" name="name" />
Address: <input type="text" name="address" />
Contact: <input type="text" name="contact" />
Email: <input type="text" name="email" />
<input type="submit" />
</form>


Staff Data form (Add an employee):
<form action="CreateDataBaseAndInsert.php" method="post">
EmployeeID: <input type="text" name="employeeid" />
Name: <input type="text" name="name" />
Nationality: <input type="text" name="nationality" />
Field: <input type="text" name="field" />
Address: <input type="text" name="address" />
Contact: <input type="text" name="contact" />
Email: <input type="text" name="email" />
<input type="submit" />
</form>


Work order form (Post a work order):
<form action="CreateDataBaseAndInsert.php" method="post">
CustomerID: <input type="text" name="customerid" />
Problem: <input type="text" name="problem" />
EmployeeID: <input type="text" name="employeeid" />
OrderNumber: <input type="text" name="ordernumber" />
Description: <input type="text" name="description" />
Status: <input type="text" name="status" />
Comments: <input type="text" name="comments" />
<input type="submit" />
</form>

?>

2. CreateDataBaseAndInsert.php


<?php
$con=mysql_connect('127.0.0.1:3306'); 
mysql_select_db("my_db", $con);
 


$sql = sprintf('INSERT INTO 
                 Customers 
              (customerid, name, address, contact, email) 
                 VALUES
              ("%s", "%s", "%s", "%s", "%s")',
              mysql_real_escape_string($_POST['customerid']),
              mysql_real_escape_string($_POST['name']),
              mysql_real_escape_string($_POST['address']),
              mysql_real_escape_string($_POST['contact']),
              mysql_real_escape_string($_POST['email']));
            
$result = mysql_query($sql); 



$con=mysql_connect('127.0.0.1:3306');
$sql="CREATE DATABASE my_db";
if(mysql_query($sql,$con))
{
echo "database my_db created";
}
else
{
echo "error creating database: " . mysql_error();
}


if(!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db('my_db');

$query="INSERT INTO Customers
(customerid,name,address,contact,email)
VALUES
('$customerid','$name','$address','$contact','$email')";
$result=mysql_query($query,$con);
printf("update records: %d\n",my_sql_affected_rows());

echo($result)?"Insert was succesfull.\r\n" : "insert was unsuccessfull.\r\n";


?>

</body>
</html>


3. the tables creating page  , my_dbTables.php


// create table in the my_db database
mysql_select_db("my_db",$con);
$sql = "CREATE TABLE Customers
(
CustomerID varchar(30) NOT NULL,
PRIMARY KEY(CustomerID),
Name varchar(50),
Address varchar(100),
Contact varchar(30),
Email varchar(30)
)";

if($sql)
{
echo "TABLE Customers created ";
}

else
{
echo "Error creating table " . mysql_error();
} 
mysql_query($sql,$con);

mysql_select_db("my_db",$con);
$sql = "CREATE TABLE Staff
(
EmployeeID varchar(30) NOT NULL,
PRIMARY KEY(EmployeeID),
Name varchar(50),
Nationality varchar(50),
Field varchar(30),
Address varchar(100),
Contact varchar(30),
Email varchar(30)
)";

if($sql)
{
echo "TABLE Staff created ";
}

else
{
echo "Error creating table " . mysql_error();
}
mysql_query($sql,$con); 

mysql_select_db("my_db",$con);
$sql = "CREATE TABLE WorkOrder
(
CustomerID varchar(30) NOT NULL,
PRIMARY KEY(CustomerID),
Problem varchar(50),
EmployeeID varchar(30),
OrderNumber varchar(30),
Description varchar(300),
Status varchar(200),
Comments varchar(300)
)";


if($sql)
{
echo "TABLE WorkOrder created ";
}

else
{
echo "Error creating table " . mysql_error();
} 
mysql_query($sql,$con);
mysql_close($con);

?>