Buy Now
Sign in

Question about Mysql

daffy , March 09 2009, 09:58
D
daffy 124
March 09 2009, 09:58 #25828
I have been using 'interbase=firebird" now for about 10 years and have a hire system NOT web-based that operates well.
Not many hosts are familiar with firebird so we finish up with a host in Arizona, which is a long way from Sussex ! (and this is a permanently on-line system).

The boss says we must get web-based and Muggins has to think about it.
So let's try Joomla and MySql.
Now I use transactions a lot. If a customer comes along and we sort out details of what he wants but the money does not get cleared we simply do a 'rollback' if it is fine we do 'commit'.

What do MySql people do ??

Go back over it all and delete the records one by one ? A typical deal involves about 55 records.
Is there a method based upon session ids to do an overall delete?
My mind is boggling.

I know MySql now has transactions but Joomla does not seem to know about them.
--
Dave
GreyHead 64
March 09 2009, 10:40 #25832
Hi Dave,

Your outside anything I understand well enough to answer . . . found a couple of threads here and here that might help.

One thread has some code hack that will let you add MySQL transactional capability; the other one voices some concerns and suggests a possible implementation route that will avoid some problems with other Joomla transactions.

I've done some simple overloading of the Joomla db drivers and it seems to work OK so this approach might work for you (from one of the above threads)
At my present project we needed prepared statements, and just copied the mysqli.php driver as mysqlie.php and then added our methods that were needed. Would be just as easy to do the same for transaction support, and then all the code you write could reference that driver's API.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
D
daffy 124
March 09 2009, 18:50 #25872
Thanks Bob,
The first link may be very useful.

Where are you in Brittany ? I have a cottage near La Roche Bernard where I shall be for a few weeks in a week or so. Still working ! J'avais soixante-quinze ans. Peut-etre quand j'ai quatre-vingts ans je m'arrĂȘterai
--
dave
GreyHead 64
March 09 2009, 20:56 #25879
Hi Dave,

We're diametrically at the other end of Brittany on the NW tip of Finistere - about 250k away.

Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much