{"id":10205,"date":"2020-02-13T12:40:30","date_gmt":"2020-02-13T12:40:30","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=10205"},"modified":"2022-05-08T12:07:20","modified_gmt":"2022-05-08T12:07:20","slug":"insert-and-retrieve-data-from-database-in-php-using-mysqli","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/insert-and-retrieve-data-from-database-in-php-using-mysqli\/","title":{"rendered":"Insert and Retrieve data from database in PHP using MySQLI"},"content":{"rendered":"\n<p><strong>What is Mysqli:-<\/strong><br>The <strong>Mysqli<\/strong> extension, or as it is used before this name the <strong>MYSQL<\/strong> and update extension, was developed to take advantage of new features found in <strong>Mysqli <\/strong>systems versions 4.1.3 and now. The <strong>Mysqli<\/strong> extension is included with PHP versions 5 and now. <strong>Mysqli<\/strong> Supports only <strong>Mysql<\/strong> Database.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Mysqyli advantage:-<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Object-oriented interface<\/li><li>Support for Transactions<\/li><li>Support for Multiple Satatements<\/li><li>Support for Prepared Statements<\/li><\/ul>\n\n\n\n<p><strong>Step- 1<\/strong><br> First, install XAMPP and run in local server.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/xampp-1.png\" alt=\"\" class=\"wp-image-10485\" width=\"458\" height=\"295\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/xampp-1.png 667w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/xampp-1-300x194.png 300w\" sizes=\"auto, (max-width: 458px) 100vw, 458px\" \/><\/figure>\n\n\n\n<p><strong>Step &#8211; 2<br><\/strong> First Go to in<strong> localhost\/PHPMyAdmin<\/strong> local server and click <strong>New<\/strong> and create <strong>Database<\/strong> and after create a <strong>table<\/strong>. In the database to easily handled by the user and user easily <strong>create<\/strong>, <strong>update<\/strong>, and <strong>delete<\/strong> any data from the database. <\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/database-1-1024x433.png\" alt=\"\" class=\"wp-image-10489\" width=\"701\" height=\"296\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/database-1-1024x433.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/database-1-300x127.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/database-1-768x324.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/database-1.png 1366w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/figure>\n\n\n\n<p><strong>Step &#8211; 3<\/strong><br>Go to (C drive of Pc) and open xampp folder and go to htdocx and create a new folder as you wish. And open it create a new file and his name will be .php file extension.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/php-file-1.png\" alt=\"\" class=\"wp-image-10492\" width=\"425\" height=\"163\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/php-file-1.png 792w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/php-file-1-300x116.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/php-file-1-768x296.png 768w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/figure>\n\n\n\n<p><strong>Step- 4<\/strong><br>After step 3 creating a sample form as index.php and edit in HTML form as below:-<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ajcotocus\/682586c3df862ffea41f26343b0f07d5.js\"><\/script>\n\n\n\n<p><strong>Step &#8211; 5<\/strong><br> After step 4 then create a new PHP file as you wish and fill as below for add to the database and connect to the table-:<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"170\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/syntax.png\" alt=\"\" class=\"wp-image-10235\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/syntax.png 820w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/syntax-300x62.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/02\/syntax-768x159.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/figure>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ajcotocus\/8b01d8aa45020c8a07e269138e7d7e3b.js\"><\/script>\n\n\n\n<p>Here,<br> &#8216;name&#8217;          = from index form <br> &#8217;email&#8217;          = from index form<br> &#8216;mobile&#8217;        = from index form<br> &#8216;localhost&#8217;    = server name<br> &#8216;root&#8217;             = user name<br> &#8216; &#8216;                    = password defalut<br> &#8216;school-db&#8217;   = database name<br> mysqli_connect    = database connection<br> mysqli_query    = return query<\/p>\n\n\n\n<p><strong>$qyery<\/strong> = You can select from<strong> database<\/strong> before go <strong>database table<\/strong> and click <strong>SQL<\/strong> and after click<strong> insert<\/strong> button then copy query in screen and select. This is right way.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ajcotocus\/c012ddcee350fc0367fa1a788dd00462.js\"><\/script>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_23370\"><iframe loading=\"lazy\"  id=\"_ytid_13310\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_23370\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>What is Mysqli:-The Mysqli extension, or as it is used before this name the MYSQL and update extension, was developed to take advantage of new features found in Mysqli systems&#8230; <\/p>\n","protected":false},"author":1,"featured_media":10247,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5150],"tags":[5355,5448,5593,177,5833],"class_list":["post-10205","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-database","tag-insert","tag-mysqli","tag-php","tag-retrieve"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/10205","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=10205"}],"version-history":[{"count":16,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/10205\/revisions"}],"predecessor-version":[{"id":24963,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/10205\/revisions\/24963"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/10247"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=10205"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=10205"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=10205"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}