[RESOLVED] Wont connect to MS Access

austenr

I think I may have posted in the wrong area so I closed that thread and started this one.

Why will this not work?

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Administrator / Private Investigator Sign Up</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body >
<p align="left"><img src="file:///C|/Documents%20and%20Settings/aurobins/Desktop/logo_extranet.gif" width="156" height="67"> 
  <font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#0000FF"><br><br><br>

  <strong>Use this form if you are signing up as a new Administrator
  or Private Investigator </strong></p><br><br>
  <form method="POST" action="postit.php">
  Suffix :&nbsp;
  <input name="suffix" type="text" size="5" maxlength="5">
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Prefix :&nbsp;
  <input name="prefix" type="text" size="5" maxlength="5"><br>
  Last Name:&nbsp;<input name="lname" type="text" size="40" maxlength="40"><br>
  First Name:&nbsp;<input name="fname" type="text" size="30" maxlength="30"><br>
  MI:&nbsp;<input name="mi" type="text" size="2" maxlength="2"><br>
  Organization Name:&nbsp;<input name="orgname" type="text" size="40" maxlength="40"><br>
  Position / Title:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="postitle" type="text" size="40" maxlength="40"><br>
  Dept / Program:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="dptpgm" type="text" size="30" maxlength="30"><br>
  Section / Unit:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="secunit" type="text" size="30" maxlength="30"><br>
  BU ID:&nbsp;<input name="buid" type="text" size="15" maxlength="15"><br>
  Address Line 1:&nbsp;<input name="add1" type="text" size="40" maxlength="40"><br>
  Address Line 2:&nbsp;<input name="add2" type="text" size="40" maxlength="40"><br>
  Address Line 3:&nbsp;<input name="add3" type="text" size="40" maxlength="40"><br>
  City:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input name="city" type="text" size="20" maxlength="20"><br>
  County:&nbsp;<input name="county" type="text" size="20" maxlength="20"><br>
  State:&nbsp;&nbsp;&nbsp;<input name="state" type="text" size="4" maxlength="4"><br>
  Country:&nbsp;<input name="country" type="text" size="20" maxlength="20"><br>
  Zip:&nbsp;<input name="zip" type="text" size="9" maxlength="9"><br>
  Phone:&nbsp;<input name="phone" type="number" size="10" maxlength="10"><br>
  Fax:&nbsp;<input name="fax" type="number" size="10" maxlength="100"><br>
  e-mail:&nbsp;<input name="email" type="text" size="30" maxlength="30"><br>
  Group:&nbsp;<input name="grp" type="text" size="15" maxlength="15"><br>
  AP Report:&nbsp;<input name="aprpt" type="text" size="4" maxlength="4"><br>
  Human Subjects Training Certified:&nbsp;<input name="hsub" type="text" size="3" maxlength="3"><br>
  ListServ Only:&nbsp;<input name="lserv" type="text" size="3" maxlength="3"><br>
  Status:&nbsp;<input name="status" type="text" size="11" maxlength="11"><br>
  Comments:<br>&nbsp;
  <textarea name="comments" cols="40" rows="5"></textarea>
  </font></form>
  <input name="Submit" type="submit" value="Submit">&nbsp;<input name="Reset" type="Reset" value="Reset">
  <p>
   </P>



  </body>
</html>

Thanks

Sxooter

I don't know if you've noticed, but this is not a VBScript site, it's a php site.

I don't know enough about vbscript to help you, and likely no one else does either.

You'd do better posting on a board having to do with vbscript.

austenr

Well, I have gotten at least to the point where the PHP is called correctly from the HTML. Now for some reason nothing gets written to the table in Access. I am posting the PHP code below. Thanks

<?php

 if ($_POST[submit] == "Submit")
 {
     // Collect form data abd assign scalar variables

 $Suffix = $_POST[suffix];
 $Prefix = $_POST[prefix];
 $lname = $_POST[lname];
 $fname = $_POST[fname];
 $orgname = $_POST[orgname];
 $postitle = $_POST[postitle];
 $dptpgm = $_POST[dptpgm];
 $secunit = $_POST[secunit];
 $buid = $_POST[buid];
 $add1 = $_POST[add1]; 
 $add2 = $_POST[add2];   
 $add3 = $_POST[add3]; 
 $city = $_POST[city]; 
 $state = $_POST[state]; 
 $county = $_POST[county]; 
 $country = $_POST[country]; 
 $zip = $_POST[zip];
 $phone = $_POST[phone];  
 $fax = $_POST[fax];
 $email = $_POST[email];
 $grp = $_POST[grp];
 $aprpt = $_POST[aprpt];
 $hsub = $_POST[hsub];
 $lserv = $_POST[lserv];
 $status = $_POST[status];
 $comments = $_POST[comments];

 //establish connection to data base

 $conn = odbc_connect('Driver={Microsoft Access Driver (*.mdb)};
 DBQ=C:\Documents and Settings\aurobins\Desktop\test','','');

 // SQL statement

 $sql = "INSERT INTO BMCactive " .
 "(suffix,prefix,lanem,fname,orgname,postitle,dptpgm,secunit,
   buid,add1,add2,add3,city,county,state,country,zip,phone,
   fax,email,grp,aprpt,hsub,lserv,status,comments)

   VALUES ('$suffix', '$prefix', '$lname', '$fname', 
           '$orgname', '$postitle', '$dptpgm', '$secunit',
           '$buid', '$add1', '$add2', '$add3', '$city',
           '$country', '$state', '$country', '$zip', 
           '$phone', '$fax', '$email', '$grp', '$aprpt',
           '$hsub', '$lserv', '$status', '$comments')";

  // Execute SQL statement and store results as a recordset

  $rs = odbc_exec($conn,$sql);

  odbc_close($conn);

 }         

 echo "Your record was successfully added!!";           

?>