Get last inserted id (record id) with FM-and-PHP

[dexxx]

Hi there,

For people who works a lot with php and mysql (just like me) and think in mysql-methods, i have found a solution to get the last_insert_id (recordid) after a INSERT in de Filemaker database. Maybe it's usefull in your future scripts.

This methode only works in combination with FM-and-PHP. More info you can find on www.fm-and-php.info

Check this !

 

<?php

include("./fmandphp.php");

$FM = new FM_and_PHP();

$FM->setFileMakerHost("localhost","80","7");

$FM->setDatabaseName("bsp7");

$FM->setDatabaseUserPassword("Admin","Admin");

$FM->setDatabaseLayout("www");

$FM->setCommand("new");



$FM->addParameter("Field1", $_REQUEST['field1']);

$FM->addParameter("Field2", $_REQUEST['input_field_2']);

$FM->addParameter("Field3", $_REQUEST['field3']);

$FM->addParameter("Field4", $_REQUEST['field_number_4']);

$FM->addParameter("Field5", $_REQUEST['field5']);



$FM->doQuery();



if ( $FM->getErrorNumber() != 0 ) {

    echo "An error occurred:";

    echo $FM->getErrorDescription();

    die();

} else {

   $newrecordResult=$FM->getNextRecord();

   echo "Record created - id=".$newrecordResult[recordid]."<br>";

}

?>

 

Cheers,

Gee

[dexxx]

Hi there,

For people who works a lot with php and mysql (just like me) and think in mysql-methods, i have found a solution to get the last_insert_id (recordid) after a INSERT in de Filemaker database. Maybe it's usefull in your future scripts.

This methode only works in combination with FM-and-PHP. More info you can find on www.fm-and-php.info

Check this !

 

<?php

include("./fmandphp.php");

$FM = new FM_and_PHP();

$FM->setFileMakerHost("localhost","80","7");

$FM->setDatabaseName("bsp7");

$FM->setDatabaseUserPassword("Admin","Admin");

$FM->setDatabaseLayout("www");

$FM->setCommand("new");



$FM->addParameter("Field1", $_REQUEST['field1']);

$FM->addParameter("Field2", $_REQUEST['input_field_2']);

$FM->addParameter("Field3", $_REQUEST['field3']);

$FM->addParameter("Field4", $_REQUEST['field_number_4']);

$FM->addParameter("Field5", $_REQUEST['field5']);



$FM->doQuery();



if ( $FM->getErrorNumber() != 0 ) {

    echo "An error occurred:";

    echo $FM->getErrorDescription();

    die();

} else {

   $newrecordResult=$FM->getNextRecord();

   echo "Record created - id=".$newrecordResult[recordid]."<br>";

}

?>

 

Cheers,

Gee

[dexxx]

Hi there,

For people who works a lot with php and mysql (just like me) and think in mysql-methods, i have found a solution to get the last_insert_id (recordid) after a INSERT in de Filemaker database. Maybe it's usefull in your future scripts.

This methode only works in combination with FM-and-PHP. More info you can find on www.fm-and-php.info

Check this !

 

<?php

include("./fmandphp.php");

$FM = new FM_and_PHP();

$FM->setFileMakerHost("localhost","80","7");

$FM->setDatabaseName("bsp7");

$FM->setDatabaseUserPassword("Admin","Admin");

$FM->setDatabaseLayout("www");

$FM->setCommand("new");



$FM->addParameter("Field1", $_REQUEST['field1']);

$FM->addParameter("Field2", $_REQUEST['input_field_2']);

$FM->addParameter("Field3", $_REQUEST['field3']);

$FM->addParameter("Field4", $_REQUEST['field_number_4']);

$FM->addParameter("Field5", $_REQUEST['field5']);



$FM->doQuery();



if ( $FM->getErrorNumber() != 0 ) {

    echo "An error occurred:";

    echo $FM->getErrorDescription();

    die();

} else {

   $newrecordResult=$FM->getNextRecord();

   echo "Record created - id=".$newrecordResult[recordid]."<br>";

}

?>

 

Cheers,

Gee