PDO / MySQL - Install concerns

[doulos61]

Greetings -

I have been asked by a client to install PDO php function component as part of a shopping cart. My concerns are that I am running MySQL on the server right now.

To put in simplest terms am I able to run the PDO php function, and MySQL on the same server simultaneously? If so, what do I need to take into consideration.

I appreciate any information in consideration of this matter.

Thanks
Shoop

 

[24x7ss]

Yes, you can run both pdo and mysql simultaneously there is no issue with it. First check pdo is installed on the server or not by creating php info file or you can directly check it on server via ssh.

If it is not installed then you can install it by performing easyapache on server. It will not affect your Mysql settings.

 

[doulos61]

Response appreciated,

My intention was to install the PDO via easyApache. I just got to that point on the build selections and had the thought of potential conflict with MySQL that is already on the server. From what I can see from the backend WHM GUI it isn't installed.

Thanks
Shoop

 

[24x7ss]

Hello Shoop,

FYI both PDO and MySQL extension are different when it comes to PHP coding. PHP's MySQL extension provides simple methods that are synonymous to the C API that is available for MySQL. All in all, it's not an advanced system, and most importantly, it is no longer maintained where PDO aims to provide a consistent API that means when a database engine is changed, the code changes to reflect this should be minimal. When using PDO, your code will normally "just work" across many database engines, simply by changing the driver you're using.

 

[LostNerd]

Hi Shoop,

Just to add to the end of what 24x7ss has already said, it's great to note that EasyApache is usually really good at warning you if two extensions/plugins you have added are ikely to conflict and will usually prompt you to disable one or the other.

You can't go too wrong with EasyApache unless you try... I think... I may be wrong... *breaks Apache*

Peter

 

[cPanelMichael]

Hello,

To reiterate, yes, it's acceptable to install the PDO module for PHP when MySQL is installed.

Thank you.