Jump to content

This topic is 7380 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I am trying to create a new record in a database with FMNew(), but it doesn't seem to be working. I know that the variables have the correct data in them, and the same code used for FMEdit() (plus the -recid parameter) works fine. I've copied the code below:

<?

include_once("../FX/FX.php");

include_once("server_data.php");

$firstname = $_REQUEST['FIRST_NAME'];

$lastname = $_REQUEST['LAST_NAME'];

$middleinitial = $_REQUEST['Middle_Initial'];

$numids = $_REQUEST['ID_Number'];

$birthday = $_REQUEST['Birthday'];

$gender = $_REQUEST['Gender'];

$ethnicity = $_REQUEST['ETHNICITY'];

$localstreet = $_REQUEST['Street_Add'];

$localzip = $_REQUEST['Local_City_State_Zip'];

$homestreet = $_REQUEST['ADDRESS'];

$homecity = $_REQUEST['CITY'];

$homestate = $_REQUEST['STATE'];

$homezip = $_REQUEST['ZIP'];

$localphone = $_REQUEST['Campus_Phone'];

$homephone = $_REQUEST['Phone'];

$cellphone = $_REQUEST['Cell'];

$numIDs = $_REQUEST['NumIDs'];

$college = $_REQUEST['COLLEGE'];

$gradyear = $_REQUEST['Grad_Year'];

$pay = $_REQUEST['Paid_or_Volunteer'];

$area = $_REQUEST['Assigned_Area'];

$projectcood = $_REQUEST['Project_Coordinator'];

$board = $_REQUEST['Board_Member'];

$BookQuery2 = new FX($serverIP, $webCompanionPort);

$BookQuery2->SetDBData('Student Database.fp5', 'webform');

$BookQuery2->SetDBPassword('4me2know');

$BookQuery2->AddDBParam('FIRST NAME', $firstname);

$BookQuery2->AddDBParam('LAST NAME', $lastname);

$BookQuery2->AddDBParam('Middle Initial', $middleinitial);

$BookQuery2->AddDBParam('ID Number', $numids);

$BookQuery2->AddDBParam('Birthday', $birthday);

$BookQuery2->AddDBParam('Gender', $gender);

$BookQuery2->AddDBParam('ETHNICITY', $ethnicity);

$BookQuery2->AddDBParam('Street Add.', $localstreet);

$BookQuery2->AddDBParam('Local City State Zip', $localzip);

$BookQuery2->AddDBParam('ADDRESS', $homestreet);

$BookQuery2->AddDBParam('CITY', $homecity);

$BookQuery2->AddDBParam('STATE', $homestate);

$BookQuery2->AddDBParam('ZIP', $homezip);

$BookQuery2->AddDBParam('Campus Phone', $localphone);

$BookQuery2->AddDBParam('Phone #', $homephone);

$BookQuery2->AddDBParam('Cell Phone', $cellphone);

$BookQuery2->AddDBParam('Num of IDs', $numIDs);

$BookQuery2->AddDBParam('COLLEGE', $college);

$BookQuery2->AddDBParam('Grad Year', $gradyear);

$BookQuery2->AddDBParam('Paid or Volunteer', $pay);

$BookQuery2->AddDBParam('Assigned Area', $area);

$BookQuery2->AddDBParam('Project Coordinator', $projectcood);

$BookQuery2->AddDBParam('Board Member', $board);

$BookData2 = $BookQuery2->FMNew();

$currentKey2 = key($BookData2['data']);

?>

This topic is 7380 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.