Hi Board, I need to customisations
1) is to run a stored procedure from one of my pages, it will have 3 inputs, (need to be drop downs) once all 3 selected then the stored proc runs.
2) is after someone updates a table any other record with a matching oppid field is updated with the same info that was entered
if anyone can help point me in the right direction I would be grateful
Bryan
Customisation required
-
- Posts: 6
- Joined: 2016-10-17 01:28
- Contact:
Re: Customisation required
The function after_update in the corresponding hooks file could help.
Re: Customisation required
Can AppGini use Stored Procedures? That would make part of what I am wanting to do much easier.
Mostly to be able to execute a stored procedure, don't really need it for adding/updating/deleting data in the table.
Alan
Mostly to be able to execute a stored procedure, don't really need it for adding/updating/deleting data in the table.
Alan
AppGini, MySQL/MariaDB and Stored Procedures
The term "Stored Procedures" usually is related to databases and not to code-generators like AppGini is.Can AppGini use Stored Procedures
- Many databases support stored procedures but not every database does.
You need to have a look at your MySQL/MariaDB database-version and your hosting environment. Maybe you can just try using any SQL workbench (like Adminer, phpMyAdmin or any other). Have a look here: http://www.mysqltutorial.org/introducti ... dures.aspx.
Caution: If your SPs do run on your local machine, it does not automatically mean that your SPs do run in your hosted environment. - AppGini supports programming in PHP and/or JavaScript. On executing SQL statements like INSERT or UPDATE, stored procedures may be triggered on your database.
You can use PHP in your AppGini-hooks to trigger stored procedures if your database supports them.
Hope this helps!
Regards,
Jan
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools