I have been using php for quite a sometime now and encounter three different interfaces viz. mysql_*, mysqli_* and PDO to connecting with mysql database. What i am not able to understand is why to have so many interfaces for the same.. if one is better then which one?? or is it a matter of choice between select one or other. Does there exists any difference in performance and speed with each of the interfaces?
我应该在php中使用哪个mysql库以及为什么
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
分享- 邀请回答
-
3条回答 默认 最新
- drxyaox153896 2010-08-27 03:48关注
While mysql (procedural) and mysqli (OO) are MySQL client libraries, PDO is a data-access abstraction layer, it allows you to use different database drivers. An advantage of PDO is you could, theorically, change your database driver without rewriting your querying code.
I recommend you to check http://php.net/manual/en/mysqli.overview.php where differences between those 3 libraries are briefly discussed.
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报 分享
- 2014-05-25 17:56回答 1 已采纳 First var_dump($row); and check it is as you expect. Then instead of echo $key.' <input
- 2014-06-26 10:28回答 1 已采纳 Your content probably contains quote characters, which you need to escape. $bcontent = mysql_real
- 2013-09-28 04:38回答 7 已采纳 Assuming that you are using InnoDB engine (which is default in most recent MySQL versions), you sh
- 2020-12-19 07:50php 在线导入 mysql 大数据程序 <?php header("content-type:text/html;charset=utf-8"); error_reporting(E_ALL); set_time_limit(0); $file='./test.sql'; $data=file($file); echo "<pre>"; //print_...
- 2017-03-03 15:51回答 1 已采纳 Try using server side datatables. That way you wont have to fetch all 7.8k rows at once
- 2012-10-21 02:06回答 2 已采纳 First, make sure there's an index on that table. If your queries include both company and division
- 2018-06-18 02:25回答 2 已采纳 建立一个sum(views)的试图，左链接取试图中的sum(views)列值就行了，干嘛要读2次数据库 大概如下，没测试 ``` create view sumviews as s
- 2018-07-08 02:19本文讲的是mysql大数据分库和分表 php解决方案。 mysql分库分表方案、mysql 分库方案、php实现mysql分库分表、mysql高并发解决方案。
- 2015-09-08 13:51回答 2 已采纳 It's not really good practice (it will make PHP chew far more memory than it really should), but I
- 2011-08-17 12:59回答 4 已采纳 mysql shouldn't be used since it's outdated and has been superseded by mysqli. As for the differen
- 2014-05-20 07:32回答 1 已采纳 Looks like your table is missing the indexes and if yes you need to add them first. Before adding
- 2023-10-22 16:57黑夜开发者的博客 本文从主流的数据仓库出发进行讲解，然后重点分析了一下这款产品的特点，及其在数据分析领域的优劣势。然后根据平时在工作用的实际应用实践，给出了常见的一些疑惑问题解答。最后通过一些日常使用的SQL分享，让大家...
- 2014-10-16 13:15回答 2 已采纳 Run this before your script: ini_set('memory_limit', '-1'); You may also need this line to make
- 2020-10-25 19:43介绍：就是想实现简单的ajax上传数据，但是当数据量较大的时候，问题...大小5M,一开始认为这个很简单，就是先上传一下文件，然后读取一下，存到数据库就好了，结果，可能我比较菜，弄了半天做出这个功能。环境是linux.
- 2018-09-13 22:47猿峰的博客 2.搭建完成后使用命令查看 git –version 3. 服务器端创建 git 用户，用来管理 Git 服务，并为 git 用户设置密码 请依次执行一下命令 4.服务器端创建 Git 仓库 设置 /home/data/git/gittest.git 为 G...
- 没有解决我的问题, 去提问
悬赏问题
- ¥15 执行 virtuoso 命令后，界面没有，cadence 启动不起来
- ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
- ¥20 有关区间dp的问题求解
- ¥15 多电路系统共用电源的串扰问题
- ¥15 slam rangenet++配置
- ¥15 有没有研究水声通信方面的帮我改俩matlab代码
- ¥15 ubuntu子系统密码忘记
- ¥15 保护模式-系统加载-段寄存器
- ¥15 电脑桌面设定一个区域禁止鼠标操作
- ¥15 求NPF226060磁芯的详细资料