migrating to the pdo mysql driver
Is that the mysqli vs. mysql thing?
You got all kinds of learnin' and you made me look the fool without tryin', and yet here I am with a gun to your head. That's 'cause I got people with me. People who trust each other, who do for each other, and ain't always lookin' for the advantage.
Mal ,'Our Mrs. Reynolds'
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 4673
A turkey in every toilet -- only in America!
Gudanov - Dec 07, 2016 11:22:58 am PST #3893 of 4673
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 4673
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 4673
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 4673
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 4673
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 4673
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 4673
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 4673
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 4673
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.