dourukeng5302 2015-10-09 20:36
浏览 49
已采纳

切换到MYSQLI和工作台[关闭]

I'm using MYSQL Workbench right now to build my database, do I need to build my database differently now to use MYSQLI or is MYSQLI just the syntax for connecting to the database. Also do I need to download the MYSQLI driver and disable the MYSQL one... I'm honestly just very confused. I'm going to learn PDO to connect to my database, I just don't want something bad to happen to my website after, from what I understand, the MYSQL driver wont work in the future and everything must use the MYSQLI driver, or library, or whatever it is. I don't quite understand what this switch to MYSQLI is. Should I use something else?

Sorry if what I post is confusing, I'm just a beginner.

Thanks a lot,

Mike

  • 写回答

1条回答 默认 最新

  • dongyue3795 2015-10-09 20:53
    关注

    I'm using MYSQL Workbench right now to build my database, do I need to build my database differently now to use MYSQLI or is MYSQLI just the syntax for connecting to the database.

    No. You do not need to build your database again. MYSQLI is a set of functions to establish a relation with any mysql database. You can query, delete, create, etc... http://php.net/manual/pt_BR/book.mysqli.php

    Also do I need to download the MYSQLI driver and disable the MYSQL one...

    You do not need to download MYSQLI driver, but, YES, you need to activate MYSQLI driver on your php.ini

    I'm going to learn PDO to connect to my database, I just don't want something bad to happen to my website after, from what I understand, the MYSQL driver wont work in the future and everything must use the MYSQLI driver, or library, or whatever it is.

    PDO is a great lib and it's good for you to learn how to use it. But MYSQLI and PDO do the same thing in different ways (instead of connecting to other databases like SQL SERVER) so you need to choose if you want to use PDO or MYSLI on your core application.

    I don't quite understand what's this switch to MYSQLI is. Should I use something else?

    It all depends on what kind of application you're creating. Also you should learn all possible technologies related once it's good for your career. But in any case there are several frameworks that will do the thing for you and connect to the db and also create the queries.

    Ex

    http://cakephp.org/

    http://www.codeigniter.com/

    http://www.yiiframework.com/

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

  • 切换到MYSQLI和工作台[关闭] database mysql php
    2015-10-09 20:36
    回答 1 已采纳 I'm using MYSQL Workbench right now to build my database, do I need to build my database differ
  • 从MySQL切换到MYSQLi - 循环不起作用 mysql php
    2013-11-19 10:58
    回答 1 已采纳 If you have a $mysqli object (I'm assuming that you created one in conn.php), you're not passing i
  • 怎么做mysql到mysqli php
    2016-10-01 10:07
    回答 3 已采纳 Use regular expressions. I have not checked that my expression works as advertised, and regular ex
  • 阿里云服务器购买和使用图文详解
    2023-08-11 21:35
    李果果7的博客 随着科技的迅猛发展和互联网的普及，云计算成为当今社会中不可或缺的一部分。阿里云作为领先的云计算服务提供商，在满足各种需求的同时，也成为了许多组织和个人不可或缺的选择。现在这个时代，用到阿里云服务器的...
  • Mysql到Mysqli数据库连接 mysql php
    2017-05-13 12:28
    回答 3 已采纳 Agreed with RiggsFolly, but notice variable $type is not defined anywhere and can also be removed
  • MySQLi条件不正常工作 mysql php
    2018-04-12 14:23
    回答 2 已采纳 You both need to specify a column to select as well as include quotes round the device_id... $tri
  • 使用mysqli和php创建表 mysql php
    2017-09-25 08:51
    回答 1 已采纳 your query should be like this. $mySql = CREATE TABLE Users( ID VARCHAR(255) NOT NULL,
  • 最新PHP 面试、笔试题汇总(code happy)
    2019-06-28 19:27
    想出家的霸天虎的博客 2、图片服务器分离 把图片单独存储，尽量减少图片等大流量的开销，可以放在一些相关的平台上，如七牛云 3、数据库集群和库表散列及缓存 数据库的并发连接为100，一台数据库远远不够，可以从读写分离、主从复制，...
  • 使用html表单和php [关闭]在mysqli中插入数据 html php
    2018-09-08 19:34
    回答 3 已采纳 Hope this fix works for you. The syntax for mysqli_query is - mysqli_query($connectionObject, $
  • php mysqli无法正常工作 php
    2016-02-16 08:01
    回答 4 已采纳 Try this query : $row2 = mysqli_fetch_assoc(mysqli_query($conn,"SELECT * FROM login WHERE userna
  • PHP mysqli高于和低于一个数[关闭] php
    2018-10-18 15:26
    回答 1 已采纳 you have to explicitly put the second condition foreach($data as $nav) { if ($nav['main_nav'
  • linux的使用并下载mysql库
    2021-12-03 23:32
    - 痴的博客 最近要使用dock和其他的一些软件的缘故，重新学习了一遍linux操作，在这里简单的总结一下，并拿mysql做案例演示，之后可能会有dock以及部署项目等的演示，项目下载的话可以在官网找到并使用，在此就不再讲解了 ...
  • mysqli和multi_query无法正常工作 php
    2011-12-21 14:52
    回答 4 已采纳 You need a semicolon at the end of the first query. $query="SELECT query_title FROM administrator
  • MySQL
    2021-12-22 18:04
    追逐春日的博客 2，因为现在是一个大数据时代，而数据库的作用是整个软件行业不可缺少的部分，在大数据时代，我们需要一个存取数据的地方，就算没有数据库也会有一个变量来存储数据，或者是另一个与数据库类似的会被创建出来，所以...
  • LINUX运维知识点总结(容器；云计算)
    2023-04-24 15:34
    赵唯一的博客 目录 一、Linux基础篇 1、描述Linux系统的启动过程 2、描述Linux下软硬链接的区别 3、如何查看和修改Linux进程优先级 查看进程优先级 修改进程优先级 4、如何将Centos.ISO文件挂载 到/mnt/cdrom 5、查找/opt/tomcat/...
  • mysql
    2022-09-06 22:12
    weixin_41973331的博客 SQL是用于访问数据库的标准化语言语法SQL语句可以单行或多行书写，以分号结尾关键字、函数名、列名和索引名不区分大小写数据库的名字、表名、别名区分大小写注释单行注释– 注释内容约束是作用于表中字段上的规则，...
  • 最全Ansible学习总结
    2022-03-23 20:38
    九离⠂的博客 Ansible学习 一、ansible的概述 1.1 ansible简介 Ansible Ansible Ansible ansible ansible ansible ...ansible用Python写成，类似于saltstack和Puppet，ansible有一个不同和优点是我们不需要在节点中安装任何客户端。
  • PHP进阶面试题
    2021-06-11 08:42
    颜夕啊的博客 比较一下php和go的区别？ Go是一种静态类型语言。PHP是一种动态类型语言。 PHP 每个请求进来时都会创建 fpm-worker 进程，从而导致系统并发高时 CPU 会产生频繁创建进程的开销，而 Go 不会。 golang 是先编译，后...
  • computer security 复习
    2022-01-14 01:06
    爱格白的博客 知识产权类型，与网络和计算机安全相关的知识产权，英国版权设计和专利法，数字千年版权法案，数字版权管理 隐私：隐私法律法规，GDPR 和数据保护法，组织反应，电脑使用隐私，隐私、数据监控、大数据和社交媒体 16...
  • 没有解决我的问题, 去提问

悬赏问题

  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 信号傅里叶变换在matlab上遇到的小问题请求帮助
  • ¥15 保护模式-系统加载-段寄存器
  • ¥15 电脑桌面设定一个区域禁止鼠标操作
  • ¥15 求NPF226060磁芯的详细资料