在 MySQL Linux 服务器上安装 PDO 驱动程序

2021-12-23 00:00:00 installation php mysql pdo phpmyadmin

不久前有人建议我更改我的代码以使用 PDO,以便参数化我的查询并安全地将 HTML 保存在数据库中.

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.

嗯,这里是主要问题:

  1. 我看了http://php.net/manual/en/ref.pdo-mysql.php,我真的不知道我应该把那个 $ ./configure --with-pdo-mysql 字符串放在哪里...

  1. 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...

我正在构建的网站实际上只需要一页的 PDO.虽然我可能会考虑重新编写它,但这需要一段时间,而且我需要尽快运行页面,所以我不能完全关闭 MySQL.如果我安装了 PDO,我还能使用 mysql_* 处理程序吗?

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?

有问题的服务器正在运行 PHP 版本 5.4.6-1ubuntu1 和 Apache/2.2.22 (Ubuntu).如果重要的话,我也在运行一个 phpMyAdmin 数据库.

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.

推荐答案

在 Ubuntu 上,您应该能够使用 sudo apt-get install php5-mysql

On Ubuntu you should be able to install the necessary PDO parts from apt using sudo apt-get install php5-mysql

同时使用 PDO 和 mysql_ 没有限制.但是,您需要创建两个到数据库的连接,一个使用 mysql_,一个使用 PDO.

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.

相关文章