Hi all,
If someone could please help me. I am new at this and I am trying to pass data from an html page to .php to insert data into a msaccess db.
Here is the code for the php page.
<?php
$conn = odbc_connect(Contactmgmt,'','') or die(odbc_error_msg());
$table_Name = "CONTRACTOR_MGMT";
$sql = "
Insert Into CONTRACTOR_MGMT
(LastName,FirstName,MiddleInitial,CurrentAddress,CurrentCity,CurrentState,CurrentZipCode,PreviousAddress,PreviousCity,PreviousState,PreviousZipCode,Homephone,MobilePhone,PreviouWKCBL,PreviousCTRWRK,Birthdate,SocialSecurityNumber,DriverLicense,StateLicense,ExpdateLicense,Contractorcompanyname,region,Title,Status,Reason,backgroundcompanyname,backgroundnum,backgrounddate,drugtestcompanyname,backgroundpassfail,Drugtestnum,drugtestdate,Drugtestpassfail,VehicleMake,VehicleModel,vehicleyear,VINnum,platenum,VehicleColor,VehicleState,CTCSUPLASTNAME,CTCSUPFIRSTNAME,CTCSUPMIDDLEINITIAL)
Values
(\"$LastName\",\"$FirstName\",\"$Middleinital\",\"$CurrentAddress\",\"$CurrentCity\",\"$currentstate\",\"$CurrentZipcode\",\"$previousAddress\",\"$previousCity\",\"$previousstate\",\"$previousZipcode\",\"$Homephone\",\"$mobilephone\",\"$PRVWRKCBL\",\"$previouscontractor\",\"$Birthdate\",\"$socialsecurity\",\"$Driverlicense\",\"$Statelicense\",\"$experationdate\",\"$Contractorcompanyname\",\"$region\",\"$Title\",\"$Status\",\"$Reason\",\"$backgroundcompanyname\",\"$backgroundnum\",\"$backgrounddate\",\"$drugtestcompanyname\",\"$backgroundpassfail\",\"$Drugtestnum\",\"$drugtestdate\",\"$Drugtestpassfail\",\"$vehiclemake\",\"$vehiclemodel\",\"$vehicleyear\",\"$VINnum\",\"$platenum\",\"$Vehiclecolor\",\"$VehicleState\",\"$CTCSUPLASTNAME\",\"$CTCSUPFIRSTNAME\",\"$CTCSUPMIDDLEINITIAL\")
";
$prep = odbc_prepare($conn, $sql);
$result = odbc_exec($conn, $sql);
?>
thank you.
