alert('Service Type Added successfully'); window.location.href='view-servicetype.php';"; } if(isset($_POST['updateservicetypename'])) { $updateservicetypename = $_POST['updateservicetypename']; $servicetypeupdateid=$_POST['servicetypeupdateid']; $insert="UPDATE `servicetype` SET `servicetype`='$updateservicetypename' WHERE id='$servicetypeupdateid'"; $runinsert=mysqli_query($conn,$insert); echo ""; } if(isset($_POST['servicetyperemovegetid'])) { $servicetyperemovegetid=$_POST['servicetyperemovegetid']; $delete="DELETE FROM `servicetype` WHERE id='$servicetyperemovegetid'"; $run=mysqli_query($conn,$delete); if($run) { echo ""; } } if(isset($_POST['addcardno'])) { $addcustomernameid = $_POST['addcustomernameid']; $addcustomer_vehickenumbernum = $_POST['addcustomer_vehickenumbernum']; $addcardno = $_POST['addcardno']; $addjobcarddate = $_POST['addjobcarddate']; $addjobcardtime = $_POST['addjobcardtime']; $addentrytime = $_POST['addentrytime']; $addgreetingtime = $_POST['addgreetingtime']; $addaftertime = $_POST['addaftertime']; $addjobcardphonenumber = $_POST['addjobcardphonenumber']; $addjobcardemail = $_POST['addjobcardemail']; $addjobcardbirthday = $_POST['addjobcardbirthday']; $addjobcardrepair = $_POST['addjobcardrepair']; $addjobcardmodal = $_POST['addjobcardmodal']; $addjobcardregno = $_POST['addjobcardregno']; $addjobcardchassisno = $_POST['addjobcardchassisno']; $addjobcardengineno = $_POST['addjobcardengineno']; $addjobcardmilage = $_POST['addjobcardmilage']; $addservicetypenumid = $_POST['addservicetypenumid']; $addjobcardserviceadvisorcommend = $_POST['addjobcardserviceadvisorcommend']; $addjobcardcommends = $_POST['addjobcardcommends']; $addjobcardadditionalcommends = $_POST['addjobcardadditionalcommends']; $addjobcardtechnician = $_POST['addjobcardtechnician']; $addjobcardserviceadivisor = $_POST['addjobcardserviceadivisor']; $addvehiclepickup = $_POST['addvehiclepickup']; $addvehicledrop = $_POST['addvehicledrop']; $insert="INSERT INTO `jobcardstore`(`cusid`,`vehicleno`, `cardnum`, `date`, `time`, `entrytime`, `greetingtime`, `aftertime`, `phonenumber`, `email`, `birthday`, `repair`, `modal`, `regno`, `chassisno`, `engineno`, `milage`, `servicetype`, `serviceadvisorcommend`, `commends`, `additionalcommends`, `technician`, `serviceadivisor`, `vehiclepickup`, `vehicledrop`) VALUES ('$addcustomernameid','$addcustomer_vehickenumbernum','$addcardno','$addjobcarddate','$addjobcardtime','$addentrytime','$addgreetingtime','$addaftertime','$addjobcardphonenumber','$addjobcardemail','$addjobcardbirthday','$addjobcardrepair','$addjobcardmodal','$addjobcardregno','$addjobcardchassisno','$addjobcardengineno','$addjobcardmilage','$addservicetypenumid','$addjobcardserviceadvisorcommend','$addjobcardcommends','$addjobcardadditionalcommends','$addjobcardtechnician','$addjobcardserviceadivisor','$addvehiclepickup','$addvehicledrop')"; $runinsert=mysqli_query($conn,$insert); echo ""; } if(isset($_POST['jobcardremovegetid'])) { $jobcardremovegetid=$_POST['jobcardremovegetid']; $delete="DELETE FROM `jobcardstore` WHERE id='$jobcardremovegetid'"; $run=mysqli_query($conn,$delete); if($run) { echo ""; } } if(isset($_POST['updatejobcardupdateid'])) { $updatejobcardupdateid=$_POST['updatejobcardupdateid']; $updatecustomer_vehickenumbernum = $_POST['updatecustomer_vehickenumbernum']; $addcustomernameid = $_POST['updatecustomernameid']; $addcardno = $_POST['updatecardno']; $addjobcarddate = $_POST['updatejobcarddate']; $addjobcardtime = $_POST['updatejobcardtime']; $addentrytime = $_POST['updateentrytime']; $addgreetingtime = $_POST['updategreetingtime']; $addaftertime = $_POST['updateaftertime']; $addjobcardphonenumber = $_POST['updatejobcardphonenumber']; $addjobcardemail = $_POST['updatejobcardemail']; $addjobcardbirthday = $_POST['updatejobcardbirthday']; $addjobcardrepair = $_POST['updatejobcardrepair']; $addjobcardmodal = $_POST['updatejobcardmodal']; $addjobcardregno = $_POST['updatejobcardregno']; $addjobcardchassisno = $_POST['updatejobcardchassisno']; $addjobcardengineno = $_POST['updatejobcardengineno']; $addjobcardmilage = $_POST['updatejobcardmilage']; $updateservicetypenumid = $_POST['updateservicetypenumid']; $addjobcardserviceadvisorcommend = $_POST['updatejobcardserviceadvisorcommend']; $addjobcardcommends = $_POST['updatejobcardcommends']; $addjobcardadditionalcommends = $_POST['updatejobcardadditionalcommends']; $addjobcardtechnician = $_POST['updatejobcardtechnician']; $addjobcardserviceadivisor = $_POST['updatejobcardserviceadivisor']; $updatevehiclepickup = $_POST['updatevehiclepickup']; $updatevehicledrop = $_POST['updatevehicledrop']; $update="UPDATE `jobcardstore` SET `cusid`='$addcustomernameid',`vehicleno`='$updatecustomer_vehickenumbernum',`cardnum`='$addcardno',`date`='$addjobcarddate',`time`='$addjobcardtime',`entrytime`='$addgreetingtime',`greetingtime`='$addgreetingtime',`aftertime`='$addaftertime',`phonenumber`='$addjobcardphonenumber',`email`='$addjobcardemail',`birthday`='$addjobcardbirthday',`repair`='$addjobcardrepair',`modal`='$addjobcardmodal',`regno`='$addjobcardregno',`chassisno`='$addjobcardchassisno',`engineno`='$addjobcardengineno',`milage`='$addjobcardmilage',`servicetype`='$updateservicetypenumid',`serviceadvisorcommend`='$addjobcardserviceadvisorcommend',`commends`='$addjobcardcommends',`additionalcommends`='$addjobcardadditionalcommends',`technician`='$addjobcardtechnician',`serviceadivisor`='$addjobcardserviceadivisor',`vehiclepickup`='$updatevehiclepickup',`vehicledrop`='$updatevehicledrop' WHERE id='$updatejobcardupdateid'"; $runinsert=mysqli_query($conn,$update); echo ""; } if(isset($_POST['addcustomer_name'])) { $addcustomer_name=$_POST['addcustomer_name']; $selectgoo="SELECT * FROM `customer` WHERE name='$addcustomer_name'"; $run_goo=mysqli_query($conn,$selectgoo); while($row_goo=mysqli_fetch_array($run_goo)) { $customer_vehicleno=$row_goo['vehicleno']; $str_customer_vehicleno =explode("@@@@",$customer_vehicleno); $itemcount=count($str_customer_vehicleno); for($i=0;$i<$itemcount;$i++) { ?> $('#addcustomer_name').val('$name');"; echo ""; echo ""; } ?>