Installing PDO driver on MySQL Linux server

Question

I was suggested  not long ago  to change my code to use PDO in order to parameterize my queries and safely save HTML in the database   Well  here are the main problems    I looked at http   php net manual en ref pdo-mysql php  and I don t really get where I should put that     configure --with-pdo-mysql string    The site I m building actually only requires PDO for one page  While I may consider re-writing it  it would take a while and I need the pages to be running soon  so I can t turn off MySQL completely  If I do install PDO  will I still be able to use mysql   handlers    The server in question is running PHP Version 5 4 6-1ubuntu1 and Apache 2 2 22  Ubuntu   I m also running a phpMyAdmin database  if it matters

User · Answer

Basically the answer from Jani Hartikainen is right! I upvoted his answer. What was missing on my system (based on Ubuntu 15.04) was to enable PDO Extension in my php.ini

extension=pdo.so
extension=pdo_mysql.so

restart the webserver (e.g. with "sudo service apache2 restart") -> every fine :-)

To find where your current active php.ini file is located you can use phpinfo() or some other hints from here: https://www.ostraining.com/blog/coding/phpini-file/

User · Answer

That s a good question  but I think you just misunderstand what you read   Install PDO  The   config --with-pdo-mysql is something you have to put on only if you compile your own PHP code  If you install it with package managers  you just have to use the command line given by Jany Hartikainen  sudo apt-get install php5-mysql and also sudo apt-get install pdo-mysql  Compatibility with mysql   Apart from the fact mysql  is really discouraged  they are both independent  If you use PDO mysql  is not implicated  and if you use mysql  PDO is not required   If you turn off PDO without changing any line in your code  you won t have a problem  But since you started to connect and write queries with PDO  you have to keep it and give up mysql    Several years ago the MySQL team published a script to migrate to MySQLi  I don t know if it can be customised  but it s official

User · Answer

If you need a CakePHP Docker Container with MySQL  I have created a Docker image for that purpose  No need to worry about setting it up  It just works    GitHub  https   github com marcellodesales php-apache-mysql-4-cakephp-docker DockerHub  https   hub docker com r marcellodesales php-apache-cakephp-mysql    Here s how I installed in Ubuntu-based image   https   github com marcellodesales php-apache-mysql-4-cakephp-docker blob master Dockerfile L8  RUN docker-php-ext-install mysql mysqli pdo pdo mysql   Building and running your application is just a 2 step process  considering you are in the current directory of the app      docker build -t myCakePhpApp     docker run -ti myCakePhpApp

User · Answer

On Ubuntu you should be able to install the necessary PDO parts from apt using sudo apt-get install php5-mysql  There is no limitation between using PDO and mysql  simultaneously  You will however need to create two connections to your DB  one with mysql  and one using PDO

User · Answer

PDO stands for PHP Data Object  PDO MYSQL is the driver that will implement the interface between the dataobject database  and the user input  a layer under the user interface called  code behind   accessing your data object  the MySQL database    The purpose of using this is to implement an additional layer of security between the user interface and the database  By using this layer  data can be normalized before being inserted into your data structure   Capitals are Capitals  no leading or trailing spaces  all dates at properly formed    But there are a few nuances to this which you might not be aware of   First of all  up until now  you ve probably written all your queries in something similar to the URL  and you pass the parameters using the URL itself  Using the PDO  all of this is done under the user interface level   User interface hands off the ball to the PDO which carries it down field and plants it into the database for a 7-point TOUCHDOWN   he gets seven points  because he got it there and did so much more securely than passing information through the URL   You can also harden your site to SQL injection by using a data-layer  By using this intermediary layer that is the ONLY  player  who talks to the database itself  I m sure you can see how this could be much more secure  Interface to datalayer to database  datalayer to database to datalayer to interface   And   By implementing best practices while writing your code you will be much happier with the outcome   Additional sources   Re  MySQL Functions in the url php dot net manual en ref dot pdo-mysql dot php  Re  three-tier architecture - adding security to your applications https   blog 42 nl articles introducing-a-security-layer-in-your-application-architecture   Re  Object Oriented Design using UML If you really want to learn more about this  this is the best book on the market  Grady Booch was the father of UML http   dl acm org citation cfm id 291167 amp CFID 241218549 amp CFTOKEN 82813028  Or check with bitmonkey  There s a group there I m sure you could learn a lot with      If we knew what the terminology really meant we wouldn t need to learn anything

User · Answer

At first install necessary PDO parts by running the command  sudo apt-get install php -mysql    where   is a version name of php like 5 6  7 0  7 1  7 2 After installation you need to mention these two statements extension pdo so extension pdo mysql so  in your  ini file  uncomment if it is already there  and restart server by command sudo service apache2 restart

[php] Installing PDO driver on MySQL Linux server

Examples related to php

Examples related to mysql

Examples related to pdo

Examples related to phpmyadmin

Examples related to installation