php与mysql那个好用_使用PHP时MySQL与MySQLi的比较

慕的地10843

有一个手册页面，用于帮助在mysql、mysqli和pdo之间进行选择。http：/php.net/手册/en/mysqlinfo.api.selecing.php和http：/www.php.net/手动/en/mysqlinfo.Library ary.Choosing.phpPHP团队推荐mysqli或PDO_MySQL用于新开发：建议使用mysqli或PDO_MySQL扩展。不建议在新开发中使用旧的MySQL扩展。下面提供了详细的特征比较矩阵。所有三个扩展的总体性能被认为大致相同。尽管扩展的性能只贡献了PHP Web请求的总运行时间的一小部分。影响往往低至0.1%。该页面还具有比较扩展API的功能矩阵。mysqli和mysql API的主要区别如下：                               mysqli     mysqlDevelopment Status             Active    

                                Maintenance onlyLifecycle                      Active   

                                  Long Term Deprecation Announced*Recommended                  

                                    Yes        NoOOP API                      

                                      Yes        NoAsynchronous Queries          

                                       Yes        NoServer-Side Prep. Statements   Yes     

                                          NoStored Procedures              Yes      

                                            NoMultiple Statements            Yes        

                                            NoTransactions                   Yes       

                                             NoMySQL 5.1+ functionality       Yes     

                                                No* http://news.php.net/php.internals/53799有一个额外的特性矩阵比较库(新的mysqlnd和libmysql)http：/www.php.net/手动/en/mysqlinfo.Library ary.Choosing.php和一篇非常详尽的博客文章http：/blog.ulf-wendel.de/2012/php-mysql-为什么要升级-extmysql/