{"id":32531,"date":"2023-01-30T15:10:47","date_gmt":"2023-01-30T09:40:47","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/"},"modified":"2023-01-30T15:10:47","modified_gmt":"2023-01-30T09:40:47","slug":"solved-switch-to-mysqli-and-workbench-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/","title":{"rendered":"[Solved] Switch to MYSQLI and workbench [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-33047001\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"33047001\" data-parentid=\"33046737\" data-score=\"3\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<blockquote>\n<p>I&#8217;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. <\/p>\n<\/blockquote>\n<p>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&#8230;<br \/>\n<a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/php.net\/manual\/pt_BR\/book.mysqli.php\">http:\/\/php.net\/manual\/pt_BR\/book.mysqli.php<\/a><\/p>\n<blockquote>\n<p>Also do I need to download the MYSQLI driver and disable the MYSQL one&#8230; <\/p>\n<\/blockquote>\n<p>You do not need to download MYSQLI driver, but, YES, you need to activate MYSQLI driver on your <code>php.ini<\/code><\/p>\n<blockquote>\n<p>I&#8217;m going to learn PDO to connect to my database, I just don&#8217;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.<\/p>\n<\/blockquote>\n<p>PDO is a great lib and it&#8217;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.<\/p>\n<blockquote>\n<p>I don&#8217;t quite understand what&#8217;s this switch to MYSQLI is. Should I use something else?<\/p>\n<\/blockquote>\n<p>It all depends on what kind of application you&#8217;re creating. Also you should learn all possible technologies related once it&#8217;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.<\/p>\n<p>Ex<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/cakephp.org\/\">http:\/\/cakephp.org\/<\/a><\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.codeigniter.com\/\">http:\/\/www.codeigniter.com\/<\/a><\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.yiiframework.com\/\">http:\/\/www.yiiframework.com\/<\/a><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Switch to MYSQLI and workbench [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] I&#8217;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 &#8230; <a title=\"[Solved] Switch to MYSQLI and workbench [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\" aria-label=\"More on [Solved] Switch to MYSQLI and workbench [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[546,340,1117,855,339],"class_list":["post-32531","post","type-post","status-publish","format-standard","hentry","category-solved","tag-database","tag-mysql","tag-mysqli","tag-pdo","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Switch to MYSQLI and workbench [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Switch to MYSQLI and workbench [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I&#8217;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 ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-30T09:40:47+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Switch to MYSQLI and workbench [closed]\",\"datePublished\":\"2023-01-30T09:40:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\"},\"wordCount\":304,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"database\",\"mysql\",\"mysqli\",\"pdo\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\",\"name\":\"[Solved] Switch to MYSQLI and workbench [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-30T09:40:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Switch to MYSQLI and workbench [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Switch to MYSQLI and workbench [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Switch to MYSQLI and workbench [closed] - JassWeb","og_description":"[ad_1] I&#8217;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 ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-30T09:40:47+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Switch to MYSQLI and workbench [closed]","datePublished":"2023-01-30T09:40:47+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/"},"wordCount":304,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["database","mysql","mysqli","pdo","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/","name":"[Solved] Switch to MYSQLI and workbench [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-30T09:40:47+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-switch-to-mysqli-and-workbench-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Switch to MYSQLI and workbench [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/32531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=32531"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/32531\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=32531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=32531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=32531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}