rendered paste bodyhere are the three pages source codes : 1. form.php<?phpCustomer 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 databasemysql_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);?>