calling MySQL stored procedure in PHP script on form submission

[cheesegrits]

Kinda depends how you want to load it, and what you are loading. If it's multiple rows, loadObjectList(), loadRowList or loadAssocList(). If it's a single row, LoadObject(), loadRow(), etc.

The methods from the Joomla database class you might look at are in database.php starting around line 398.

-- hugh

 

[Wisdom Hunter]

Thanks. Got it working using database.loadAssocList. Getting the hang of simple PHP coding I think.

 

[cheesegrits]

If you are going to be doing much coding, I'd strongly recommend using a PHP development IDE, like Eclipse. Even better, set up a local test server and install xdebug, so you can do realtime debugging.

Apart from anything else, just being able to step through the code as the page loads is an invaluable tool in learning how all this stuff (J! and Fabrik) hang together and do what they do.

-- hugh