migrating to the pdo mysql driver
Is that the mysqli vs. mysql thing?
You all gonna be here when I wake up?
Mal ,'Out Of Gas'
Buffistas Building a Better Board ++
Do you have problems, concerns, or recommendations about the technical side of the Phoenix? Air them here. Compliments also welcome.
Jon B. - Dec 07, 2016 10:32:05 am PST #3892 of 4671
A turkey in every toilet -- only in America!
Gudanov - Dec 07, 2016 11:22:58 am PST #3893 of 4671
Coding and Sleeping
Sort of. There are three PHP mysql drivers. The old mysqld which was removed from PHP 7.0. Mysqli and the PDO Mysql. The PDO driver is pretty much the standard one nowadays.
Jon B. - Dec 07, 2016 6:18:12 pm PST #3894 of 4671
A turkey in every toilet -- only in America!
Got it. I thought this article explains well the work involved.
Gudanov - Dec 08, 2016 4:37:51 am PST #3895 of 4671
Coding and Sleeping
Yep. That's what I've started doing. I'm also moving all the database interaction into a set of database access objects so it won't be mixed in with the rest of the code.
amych - Dec 08, 2016 1:22:45 pm PST #3896 of 4671
Now let us crush something soft and watch it fountain blood. That is a girlish thing to want to do, yes?
Yeah, good choice, even if we hadn't needed to update drivers.
Jon B. - Dec 08, 2016 3:37:34 pm PST #3897 of 4671
A turkey in every toilet -- only in America!
I'm also moving all the database interaction into a set of database access objects so it won't be mixed in with the rest of the code.
Good move. I imagine that'll make bootstrapifying the pages a bit easier.
Gudanov - Dec 09, 2016 4:40:33 am PST #3898 of 4671
Coding and Sleeping
There's also some weird stuff going on where tables are being created. I think that can be eliminated with some better indexing.
Calli - Dec 09, 2016 10:11:22 am PST #3899 of 4671
I must obey the inscrutable exhortations of my soul—Calvin and Hobbs
If I can be helpful in beta testing or the like, please let me know.
Gris - Dec 09, 2016 5:24:50 pm PST #3900 of 4671
Hey. New board.
Sometimes I think I know some things about computers, and then I read a page like this.
Gudanov - Dec 14, 2016 7:31:59 am PST #3901 of 4671
Coding and Sleeping
If I can be helpful in beta testing or the like, please let me know.
Will do. That will be very helpful when the time comes.
I've extracted all the SQL statements. Now I need to implement the data access code using prepared statements.