I have created a MYSQL stored procedure p_test_proc. It is tested and working fine. Now how can I call this procedure from the forms Submit button so that every time the users press the submit button, this procedure is called.
This should be simple but i have v little knowledge of php. can anyone help me with the code?
-Ashish
Hi ashishb01,
The best way to do this is probably to add the necessary code to one of the OnSubmit code boxes. If you search here on 'getDBO' you will find many examples of Joomla database queries.
Bob
by "but nothing is happening" i mean that the effects of the procedure is not taking place... the form is functioning smoothly
Thanks GreyHead,
I am becoming a fan of chronoengine!
Hi Bob,
after fiddling for a few days now with this issue i stumbled upon this topic,
this seem to give me a result, yet not the most desired, i've got the following setup:
Win 2008 R2, IIS 7, with Php 5.3, then MySql 5.6 also installed on the same server, problem is that the supplied script above is causing IIS to return a Error page 500.0 Error Code 0x8007000d
according to IIS this is something to do with the modules, any help would very much be appreciated.
ChronoForms 4.0 RC3.5.2.4 on Joomla! 3.0.3 Stable [ Ember ] 04-February-2013 14:00 GMT .
System Information
Setting Value
PHP Built On Windows NT TRAAPP 6.1 build 7600 (Windows Server 2008 R2 Standard Edition) i586
Database Version 5.6.10
Database Collation utf8_general_ci
PHP Version 5.3.10
Web Server Microsoft-IIS/7.5
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.0.3 Stable [ Ember ] 04-February-2013 14:00 GMT
Joomla! Platform Version Joomla Platform 12.2.0 Stable [ Neil Armstrong ] 21-September-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:9.0.1) Gecko/20100101 Firefox/9.0.1
Hi Fritz,
Please first try updating to the latest ChronoForms release for Joomla! 3 v4 RC 3.5.2.5 as there were some bug fixes.
Are there any clues in the 500 Error message - sometimes there is a more detailed error message included?
Bob
PS I suggest you don't use you email address as a username here as it is publicly visible, email or PM me if you'd like to change it.