I would like to hear about triggers in the DB.
eg. Add a record to a table1 --> a total in table2 is then evaluated and
updated based on a condition (eg if the total goes below 0 then the
transaction is rolled back).
ie. Eftpos withdrawal, AccountTotal table is evaluated to assess if
there is enough funds and updated accordingly.
Also, a call to an external shell command, eg. write to a text log file.
STORED PROCS
I would like to see how you execute stored procs from PHP and how you
create them in mySQL and postgres.
Cheers Don
Zane Gilmore wrote:
I am giving a talk about SQL and possibly PHP at the next CLUG meeting.
In an attempt to provide what people want, could you give me some
indication of what you want to hear about?
I can sound convincing on these topics:
- SQL (MySQL and postgres)
- PHP
- The joining of the two.
- database design
- and now I've done a bit I could probably muddle through with Python
What I was thinking was just a description of a few simple PHP scripts
hooked up to a very simple database to describe the basic principles of
how a PHP site with a database works.
Does that sound interesting or really boring?
Regards,
Zane
--
Don Gould
2/59 Peverel Street, Riccarton, Christchurch, New Zealand
Phone: +64 3 348 7235
www.bowenvale.pointclark.net/funny
www.bowenvale.pointclark.net/benjamin/
www.thinkdesignprint.co.nz - www.tcn.bowenvale.co.nz -
www.bowenvale.co.nz - www.hearingbooks.co.nz - www.crra.org.nz -
www.justhelicopters.co.nz - www.buxtonsquare.co.nz -
skype:ThinkDesignPrint?add - Good ideas: www.solarking.co.nz
