从 mysql 迁移到 mysqli 或 pdo?

2021-12-25 00:00:00 php mysql pdo mysqli
<块引用>

重复:mysqli 或 PDO - 有什么优点和缺点?

我希望将网站从 mysql 转移到 mysqli 或 pdo,主要作为学习工具,但如果可能的话,也会提高性能.

我已阅读http://php.net/manual/en/mysqli.overview.php 似乎两者都适合我的需求,但无论哪种方式都不强烈.

该站点目前主要使用非面向对象的代码,但我确实有使用其他语言的 OO 的经验.绝大多数查询都是简单复杂的选择语句,很少有更新/插入.从我自己的教育和这个特定的网站来看,你认为最有用的是什么?

如果您需要任何其他信息,请告诉我.

谢谢.

解决方案

PDO Pro's:

  • 自 5.x 起原生于 PHP
  • 支持命名参数而不是以数字索引?的
  • 同一个抽象库支持多个不同的 RDBM

Mysqli Con 的:

  • 在正确存储和检索大对象数据库.
  • 不支持命名参数.

否则,两个库基本上是同一事物的不同风味.它们都有引用参数的函数,并且都支持参数化查询.

如果以上论点都没有影响您,那么请根据语法、风格等选择您喜欢的库.

Duplicate: mysqli or PDO - what are the pros and cons?

I'm looking to move a website from mysql to either mysqli or pdo as primarily a learning tool, but also for performance increases if possible.

I have read through http://php.net/manual/en/mysqli.overview.php and it seems like both would suit my needs, but it doesn't lean strongly either way.

The site currently uses primarily non object orientated code, but I do have experience with OO in other languages. A huge majority of the queries are simple complex select statements with very little update/inserts. What do you suggest as being the most useful both from my own education and for this specific site?

If you need any additional information please let me know.

Thanks.

解决方案

PDO Pro's:

  • Native to PHP as of 5.x
  • Supports named parameters as opposed to numerically indexed ?'s
  • Same abstraction library supports multiple different RDBM's

Mysqli Con's:

  • Has issues with properly storing and retrieving large objects in the database.
  • No support for named parameters.

Otherwise, both libraries are basically different flavors of the same thing. They both have functions to quote parameters and both support parameterized queries.

If none of the above arguments sway you, then go with whichever library you prefer based on its syntax, style, etc.

相关文章