{"id":210,"date":"2016-12-01T15:55:12","date_gmt":"2016-12-01T15:55:12","guid":{"rendered":"http:\/\/www.softwaretraininginchennai.com\/blog\/?p=210"},"modified":"2026-01-05T07:23:06","modified_gmt":"2026-01-05T07:23:06","slug":"crud-operation-in-php-with-mysql","status":"publish","type":"post","link":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/","title":{"rendered":"CRUD operation in PHP with MySQL"},"content":{"rendered":"<div style=\"color: #000;\">\n<p>Download and install XAMPP from the below url<br \/>\n<a href=\"https:\/\/www.apachefriends.org\/download.html\">https:\/\/www.apachefriends.org\/download.html<\/a><\/p>\n<p>Run the Xampp Exe File as below,<br \/>\n<strong>xampp-win32-7.0.13-0-VC14-installer.exe<\/strong><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\" alt=\"\" \/><br \/>\nInstall XAMPP in the Customised location as below in E:\\ drive.<br \/>\nRun Xampp_control.exe from XAMPP folder,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati2.png\" alt=\"\" \/><br \/>\nStart Apache and Mysql in XAMPP Control Panel<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati3.png\" alt=\"\" \/><br \/>\nClick on Admin to redirect to MySQL Page,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati4.png\" alt=\"\" \/><br \/>\nCreate <strong>employeedetails<\/strong> Database by clicking on New.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati5.png\" alt=\"\" \/><br \/>\nClick on Create to create database.<br \/>\nClick on New to create a new table.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati6.png\" alt=\"\" \/><br \/>\nClick on Save to create a new table.<br \/>\nPut the PHP files in <strong>htdocs<\/strong> folder as below,<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati7.png\" alt=\"\" \/><br \/>\nCreate CRUD folder in htdocs.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati8.png\" alt=\"\" \/><br \/>\nCreate db.php,AddEmployee.php,index.php as shown below in CRUD folder.<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati9.png\" alt=\"\" \/><br \/>\nAdd below code in db.php,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 439px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b>&lt;?php<br \/>\n$servername = &#8220;localhost&#8221;;<br \/>\n$username = &#8220;root&#8221;;<br \/>\n$password = &#8220;&#8221;;<br \/>\n$dbname = &#8220;employeedetails&#8221;;<br \/>\n\/\/ Create connection<br \/>\n$conn = new mysqli($servername, $username, $password, $dbname);<br \/>\n?&gt;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Code in index.php,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 652px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b><b><b>&lt;style type=&#8221;text\/css&#8221;&gt;<br \/>\n&lt;\/style&gt;<br \/>\n&lt;?php<br \/>\ninclude(&#8216;db.php&#8217;);<br \/>\n?&gt;<br \/>\n&lt;a href=&#8221;AddEmployee.php&#8221; value=&#8221;Create Employee&#8221; &gt;Create&lt;\/a&gt;<br \/>\n&lt;table cellspacing=&#8221;5&#8243; cellpadding=&#8221;5&#8243;&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;th&gt;<br \/>\nEmployee Id<br \/>\n&lt;\/th&gt;<br \/>\n&lt;th&gt;<br \/>\nEmployee Name<br \/>\n&lt;\/th&gt;<br \/>\n&lt;th&gt;<br \/>\nAge<br \/>\n&lt;\/th&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;?php<br \/>\n$sql =&#8221;select * from employeedata&#8221;;<br \/>\n$result1 = $conn-&gt;query($sql);<br \/>\nif ($result1-&gt;num_rows &gt; 0) {<br \/>\n\/\/ output data of each row<br \/>\nwhile($row = $result1-&gt;fetch_assoc())<br \/>\n{<br \/>\n?&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;?php echo $row[&#8220;EmpId&#8221;]?&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;?php echo $row[&#8220;EmpName&#8221;]?&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;?php echo $row[&#8220;EmpAge&#8221;]?&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;a href=&#8221;AddEmployee.php?edited=1&amp;id=&lt;?php echo $row[&#8220;EmpId&#8221;]; ?&gt;&#8221;&gt;Edit&lt;\/a&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;td&gt;<br \/>\n&lt;a href=&#8221;&#8221;&gt;Delete&lt;\/a&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;?php<br \/>\n}<br \/>\n}else {<br \/>\necho 0;<br \/>\n}<br \/>\n?&gt;<br \/>\n&lt;\/table&gt;<\/b><\/b><\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>Code in AddEmployee.php as below,<\/p>\n<div>\n<table style=\"border-collapse: collapse;\" border=\"0\">\n<colgroup>\n<col style=\"width: 655px;\" \/><\/colgroup>\n<tbody valign=\"top\">\n<tr>\n<td style=\"border: solid #a3a3a3 1.0pt; padding: 2px; color: #000;\"><b>&lt;?php<br \/>\ninclude(&#8216;db.php&#8217;);<br \/>\n$EmployeeID=&#8221;;<br \/>\n$EmployeeName=&#8221;;<br \/>\n$Age=&#8221;;<br \/>\n$Operation=&#8217;Create&#8217;;<br \/>\nif(isset($_POST[&#8216;btnSave&#8217;]))<br \/>\n{<br \/>\nif($_POST[&#8216;txtoperation&#8217;] ==&#8221;Create&#8221;)<br \/>\n{<br \/>\n$EmpId=$_POST[&#8216;txtEmployeeID&#8217;];<br \/>\n$EmpName=$_POST[&#8216;txtEmployeeName&#8217;];<br \/>\n$Age=$_POST[&#8216;txtAge&#8217;];<br \/>\n$sql=&#8221;INSERT INTO Employeedata(EmpId, EmpName, EmpAge) VALUES (&#8216;$EmpId&#8217;,&#8217;$EmpName&#8217;,&#8217;$Age&#8217;)&#8221;;<br \/>\nif ($conn-&gt;query($sql) === TRUE) {<br \/>\necho &#8220;New record created successfully&#8221;;<br \/>\nheader(&#8216;Refresh:0; index.php&#8217;);<br \/>\n} else {<br \/>\necho &#8220;Error: &#8221; . $sql . &#8220;&lt;br&gt;&#8221; . $conn-&gt;error;<br \/>\n}<br \/>\n}<br \/>\nelse<br \/>\n{<br \/>\n$EmpId=$_POST[&#8216;txtEmployeeID&#8217;];<br \/>\n$EmpName=$_POST[&#8216;txtEmployeeName&#8217;];<br \/>\n$Age=$_POST[&#8216;txtAge&#8217;];<br \/>\n$sql=&#8221;UPDATE Employeedata SET EmpName=&#8217;$EmpName&#8217;,EmpAge=&#8217;$Age&#8217; WHERE EmpId='{$_GET[&#8216;id&#8217;]}'&#8221;;<br \/>\nif ($conn-&gt;query($sql) === TRUE) {<br \/>\necho &#8220;New record updated successfully&#8221;;<br \/>\nheader(&#8216;Refresh:0; index.php&#8217;);<br \/>\n} else {<br \/>\necho &#8220;Error: &#8221; . $sql . &#8220;&lt;br&gt;&#8221; . $conn-&gt;error;<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\nif(isset($_GET[&#8216;edited&#8217;]))<br \/>\n{<br \/>\n$sql =&#8221;select * from employeedata where EmpId='{$_GET[&#8216;id&#8217;]}'&#8221;;<br \/>\n$result1 = $conn-&gt;query($sql);<br \/>\nif ($result1-&gt;num_rows &gt; 0) {<br \/>\n\/\/ output data of each row<br \/>\nif($row = $result1-&gt;fetch_assoc())<br \/>\n{<br \/>\n$EmployeeID=$row[&#8220;EmpId&#8221;];<br \/>\n$EmployeeName=$row[&#8220;EmpName&#8221;];<br \/>\n$Age=$row[&#8220;EmpAge&#8221;];<br \/>\n$Operation=&#8221;Edit&#8221;;<br \/>\n}<br \/>\n}<br \/>\n}<br \/>\n?&gt;<br \/>\n&lt;form action=&#8221;&#8221; method=&#8221;post&#8221;&gt;<br \/>\n&lt;table&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;Employee Id&lt;\/td&gt;<br \/>\n&lt;td&gt;&lt;input type=&#8221;text&#8221; name=&#8221;txtEmployeeID&#8221; value=&#8221;&lt;?php echo $EmployeeID; ?&gt;&#8221; \/&gt;<br \/>\n&lt;input type=&#8221;hidden&#8221; name=&#8221;txtoperation&#8221; value=&#8221;&lt;?php echo $Operation; ?&gt;&#8221; \/&gt;<br \/>\n&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;Student Name&lt;\/td&gt;<br \/>\n&lt;td&gt;&lt;input type=&#8221;text&#8221; name=&#8221;txtEmployeeName&#8221; value=&#8221;&lt;?php echo $EmployeeName; ?&gt;&#8221; \/&gt;&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;Age&lt;\/td&gt;<br \/>\n&lt;td&gt;&lt;input type=&#8221;text&#8221; name=&#8221;txtAge&#8221; value=&#8221;&lt;?php echo $Age; ?&gt;&#8221; \/&gt;&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;tr&gt;<br \/>\n&lt;td&gt;&lt;\/td&gt;<br \/>\n&lt;td&gt;&lt;input type=&#8221;submit&#8221; value=&#8221;save&#8221; name=&#8221;btnSave&#8221; \/&gt;&lt;\/td&gt;<br \/>\n&lt;\/tr&gt;<br \/>\n&lt;\/table&gt;<br \/>\n&lt;\/form&gt;<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><span style=\"color: green;\"><b>The Output is as below,<\/b><\/span><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati10.png\" alt=\"\" \/><br \/>\nhttp:\/\/localhost\/CRUD\/index.php<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati11.png\" alt=\"\" \/><br \/>\nhttp:\/\/localhost\/CRUD\/AddEmployee.php<br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati12.png\" alt=\"\" \/><br \/>\n<img decoding=\"async\" src=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati13.png\" alt=\"\" \/><br \/>\nhttp:\/\/localhost\/CRUD\/AddEmployee.php?edited=1&#038;id=2<br \/>\nClick below to download the solution,<br \/>\n<a href=\"https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6w5Te07v0wqAspR4g\">https:\/\/1drv.ms\/u\/s!ArddhCoxftkQg6w5Te07v0wqAspR4g<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Download and install XAMPP from the below url https:\/\/www.apachefriends.org\/download.html Run the Xampp Exe File as below, xampp-win32-7.0.13-0-VC14-installer.exe Install XAMPP in the Customised location as below in E:\\ drive. Run Xampp_control.exe from XAMPP folder, Start Apache and Mysql in XAMPP Control Panel Click on Admin to redirect to MySQL Page, Create employeedetails Database by clicking on [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1],"tags":[36,75,113,114,115,116,117,161,162,163],"class_list":["post-210","post","type-post","status-publish","format-standard","hentry","category-php-training-in-chennai","category-uncategorized","tag-crud-operation-in-php","tag-freelancer-in-chennai","tag-php-sample-download","tag-php-training-maria-academy","tag-php-training-in-chennai","tag-php-training-in-tnagar","tag-php-with-mysql-sample-download","tag-web-development-consultants-in-chennai","tag-web-development-freelancers","tag-web-development-training-in-chennai"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>CRUD operation in PHP with MySQL | Maria Academy<\/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:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CRUD operation in PHP with MySQL | Maria Academy\" \/>\n<meta property=\"og:description\" content=\"Download and install XAMPP from the below url https:\/\/www.apachefriends.org\/download.html Run the Xampp Exe File as below, xampp-win32-7.0.13-0-VC14-installer.exe Install XAMPP in the Customised location as below in E: drive. Run Xampp_control.exe from XAMPP folder, Start Apache and Mysql in XAMPP Control Panel Click on Admin to redirect to MySQL Page, Create employeedetails Database by clicking on [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Maria Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DotnetTrainingChennai\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-01T15:55:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-05T07:23:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:site\" content=\"@dotnettraining2\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"headline\":\"CRUD operation in PHP with MySQL\",\"datePublished\":\"2016-12-01T15:55:12+00:00\",\"dateModified\":\"2026-01-05T07:23:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\"},\"wordCount\":694,\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\",\"keywords\":[\"CRUD operation in PHP\",\"Freelancer in chennai\",\"PHP sample download\",\"PHP training - maria academy\",\"PHP training in chennai\",\"PHP training in tnagar\",\"PHP with Mysql sample download\",\"web development consultants in chennai\",\"web development freelancers\",\"web development training in chennai\"],\"articleSection\":[\"PHP Training in Chennai\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\",\"name\":\"CRUD operation in PHP with MySQL | Maria Academy\",\"isPartOf\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\",\"datePublished\":\"2016-12-01T15:55:12+00:00\",\"dateModified\":\"2026-01-05T07:23:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage\",\"url\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\",\"contentUrl\":\"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CRUD operation in PHP with MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#website\",\"url\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/\",\"name\":\"Maria Academy\",\"description\":\"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CRUD operation in PHP with MySQL | Maria Academy","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:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/","og_locale":"en_US","og_type":"article","og_title":"CRUD operation in PHP with MySQL | Maria Academy","og_description":"Download and install XAMPP from the below url https:\/\/www.apachefriends.org\/download.html Run the Xampp Exe File as below, xampp-win32-7.0.13-0-VC14-installer.exe Install XAMPP in the Customised location as below in E: drive. Run Xampp_control.exe from XAMPP folder, Start Apache and Mysql in XAMPP Control Panel Click on Admin to redirect to MySQL Page, Create employeedetails Database by clicking on [&hellip;]","og_url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/","og_site_name":"Maria Academy","article_publisher":"https:\/\/www.facebook.com\/DotnetTrainingChennai","article_published_time":"2016-12-01T15:55:12+00:00","article_modified_time":"2026-01-05T07:23:06+00:00","og_image":[{"url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@dotnettraining2","twitter_site":"@dotnettraining2","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#article","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/"},"author":{"name":"admin","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"headline":"CRUD operation in PHP with MySQL","datePublished":"2016-12-01T15:55:12+00:00","dateModified":"2026-01-05T07:23:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/"},"wordCount":694,"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png","keywords":["CRUD operation in PHP","Freelancer in chennai","PHP sample download","PHP training - maria academy","PHP training in chennai","PHP training in tnagar","PHP with Mysql sample download","web development consultants in chennai","web development freelancers","web development training in chennai"],"articleSection":["PHP Training in Chennai"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/","name":"CRUD operation in PHP with MySQL | Maria Academy","isPartOf":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png","datePublished":"2016-12-01T15:55:12+00:00","dateModified":"2026-01-05T07:23:06+00:00","author":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e"},"breadcrumb":{"@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#primaryimage","url":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png","contentUrl":"http:\/\/www.softwaretraininginchennai.com\/blog\/wp-content\/uploads\/2016\/12\/120116_1554_CRUDoperati1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/crud-operation-in-php-with-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softwaretraininginchennai.com\/blog\/"},{"@type":"ListItem","position":2,"name":"CRUD operation in PHP with MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#website","url":"https:\/\/www.softwaretraininginchennai.com\/blog\/","name":"Maria Academy","description":"Dot Net Training in Chennai, Best Dot Net Training Institute in Chennai, .Net Training in Chennai","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softwaretraininginchennai.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.softwaretraininginchennai.com\/blog\/#\/schema\/person\/e7dbda3490333ae356b6ad09076c8a6e","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f68fba18793457e0192658e2fe53431c0fb4a1d551aef61c57c1847324110d80?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/210","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/comments?post=210"}],"version-history":[{"count":4,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/210\/revisions"}],"predecessor-version":[{"id":1724,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/posts\/210\/revisions\/1724"}],"wp:attachment":[{"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/media?parent=210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/categories?post=210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwaretraininginchennai.com\/blog\/wp-json\/wp\/v2\/tags?post=210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}