Can someone please tell me a way of creating...

February 4, 200421 yr

I need a solution, workaround, anything to get this to work. I need to add mutliple records to a database based on the amount of records in another database. Then I need to edit those records. I have looked into everything there is. Php I thought would work but it says in the FX.php class that you can have only one query string on a page so that would eliminate that. I have tried portals and the .0 without success. Is there any way of doing this?

Justin Grewe

February 4, 200421 yr

"Portals" is a good method.

I have also used PHP (not FX.php) and the "file_get_contents()" function. Examples of this exist on the Forum (however they maybe too long ago).

Good Luck.

Garry

February 4, 200421 yr

Author

How come this will not work Garry?

[FMP-Record]

[FMP-Record]

</form>

Where for every record in one database it creates a new portal row in the other. Otherwise can you be more specific on how to do this with portals?

Thanks,

Justin Grewe

February 4, 200421 yr

"Evalrespond1::RegistrationID.0" creates a new related record (one only). To edit existing Portal Rows you could use this:

This line:

would need to reference the Master DB, not the Related DB.

I would need to look at the whole application to advise accurately on the best solution.

All the best.

Garry

February 6, 200421 yr

Actually, with FX you can make as many DB calls in a single PHP script as you like. Here is a particularly useful example, which allows you to create X number of entries in the database to match X number of provided input from an HTML form:


<body>

<?

if ($_REQUEST['mySubmit']) {

	[color:"green"]// User clicked the mySubmit button[/color]

	

	require("../fx/FX.php");

	foreach ($_REQUEST["userName"] as $userName) {

		[color:"green"]// Create a new record for each userName[] input

		// that is not empty

		//[/color]

		$q = new FX ("127.0.0.1", "591");

		$q -> SetDBData ("userName.fp5", "web");

		$q -> AddDBParam ("name", $userName);

		$q -> FMNew();

		

		print ("Record inserted: ".$userName."<br>n");

	}

}

?>

<form name="myForm" action="<?=$PHP_SELF?>" method="post">

	<input type="text" name="userName[]" value=""><br>

	<input type="text" name="userName[]" value=""><br>

	<input type="text" name="userName[]" value=""><br>

	<input type="text" name="userName[]" value=""><br>

	<input type="submit" name="mySubmit">

</form>

</body>

Perhaps you misunderstood what you read? You can only submit one URL to a PHP script, but that one PHP script can in turn send unlimited URLs to another program (such as FileMaker).

Further, PHP makes it very easy to read in a list of submitted Form Inputs, work with them as an array, and if you want take an action for each Form Input. This is one of the many strengths of PHP. =)

February 6, 200421 yr

Please read my previous post first...

It is also easy to find records in one table and create child records for them in another table. Here is an example that finds all the records in the "parent.fp5" table and create one related child for each parent:

<?

require("../fx/FX.php");

 

[color:"green"]// Find all records in parent table[/color]

$q_parent = new FX("127.0.0.1", "591");

$q_parent -> SetDBData("parent.fp5", "web");

$r_parent -> FMFindAll();

 

[color:"green"]// For each parent, create one related child[/color]

foreach ($_parent['data'] as $parent_row) {

	$q_child = new FX("127.0.0.1", "591");

	$q_child -> SetDBData("child.fp5", "web");

	$q_child -> AddDBParam("key_parentID", $parent_row['key_primary'][0];

	$q_child -> FMNew();

	print ("Child created for parent ".$parent_row['key_primary'][0].".<br>n";

}

?>

February 6, 200421 yr

Sorry, one last thing:

Notice that with PHP, if you append brackets "[ ]" to your HTML input names, then those input are received by the PHP script as an array.

February 6, 200421 yr

Author

Thanks Mariano!

This looks like it will work. I guess I did read the readme file of FX.php wrong and maybe a little of not understanding the whole process of the query string and forms. Thanks again.

Justin Grewe