{"id":4575,"date":"2021-05-28T14:44:19","date_gmt":"2021-05-28T14:44:19","guid":{"rendered":"http:\/\/mauricemuteti.info\/?p=4575"},"modified":"2023-01-26T21:17:41","modified_gmt":"2023-01-26T21:17:41","slug":"insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin","status":"publish","type":"post","link":"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/","title":{"rendered":"Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin)"},"content":{"rendered":"\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_49 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"ez-toc-toggle-icon-1\"><label for=\"item-676e223fae148\" aria-label=\"Table of Content\"><span style=\"display: flex;align-items: center;width: 35px;height: 30px;justify-content: center;direction:ltr;\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/label><input  type=\"checkbox\" id=\"item-676e223fae148\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#Insert_Delete_Read_Data_From_Mysql_Table_Using_PHP_MySQL_HTML_Xampp_LocalhostphpMyAdmin\" title=\"Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin)\">Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#DEMO_VIDEO\" title=\"DEMO VIDEO\">DEMO VIDEO<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#SOURCE_CODE\" title=\"SOURCE CODE\">SOURCE CODE<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#indexphp\" title=\"index.php\">index.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#insertMoviephp\" title=\"insertMovie.php\">insertMovie.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#insertActorphp\" title=\"insertActor.php\">insertActor.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#insertActorToAMoviephp\" title=\"insertActorToAMovie.php\">insertActorToAMovie.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#viewMovieActorsphp\" title=\"viewMovieActors.php\">viewMovieActors.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#actionPagephp\" title=\"actionPage.php\">actionPage.php<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#mystylecss\" title=\"mystyle.css\">mystyle.css<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#phpMyAdmin_SQL_Dump\" title=\"phpMyAdmin SQL Dump\">phpMyAdmin SQL Dump<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#SCREENSHOTS\" title=\"SCREENSHOTS\">SCREENSHOTS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#DATABASE_DESIGN\" title=\"DATABASE DESIGN\">DATABASE DESIGN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/mauricemuteti.info\/insert-delete-read-data-from-mysql-table-using-php-mysql-html-xampp-localhostphpmyadmin\/#DATABASE_STRUCTURE_AND_TABLES\" title=\"DATABASE STRUCTURE AND TABLES\">DATABASE STRUCTURE AND TABLES<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Insert_Delete_Read_Data_From_Mysql_Table_Using_PHP_MySQL_HTML_Xampp_LocalhostphpMyAdmin\"><\/span>Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DEMO_VIDEO\"><\/span>DEMO VIDEO<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin)\" width=\"769\" height=\"433\" src=\"https:\/\/www.youtube.com\/embed\/nmKoS_7a0ZA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"SOURCE_CODE\"><\/span>SOURCE CODE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"indexphp\"><\/span>index.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">\n&amp;lt;!DOCTYPE html&amp;gt;\n&amp;lt;html&amp;gt;\n\t&amp;lt;head&amp;gt;\n\t\t&amp;lt;!-- Page Title --&amp;gt;\n\t\t&amp;lt;title&amp;gt;MOVIES AND ACTORS&amp;lt;\/title&amp;gt;\n\t\t&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;mystyle.css&quot;&amp;gt;\n\t&amp;lt;\/head&amp;gt;\n\t&amp;lt;body&amp;gt;\n\t\t&amp;lt;!-- Page Header --&amp;gt;\n\t\t&amp;lt;h1&amp;gt;MOVIES AND ACTORS HTML PHP MYSQL DATABASE&amp;lt;\/h1&amp;gt;\n\t\t&amp;lt;!-- Add Movie to database page link --&amp;gt;\n\t\t&amp;lt;a href=&quot;insertMovie.php&quot;&amp;gt;Add Movie&amp;lt;\/a&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n\t\t&amp;lt;!-- Add Actor to database page link --&amp;gt;\n\t\t&amp;lt;a href=&quot;insertActor.php&quot;&amp;gt;Add Actor&amp;lt;\/a&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n\t\t&amp;lt;!-- Add Actor to database page link --&amp;gt;\n\t\t&amp;lt;a href=&quot;insertActorToAMovie.php&quot;&amp;gt;Add Actor To A Movie&amp;lt;\/a&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n\t\t&amp;lt;!-- View Movie Actors --&amp;gt;\n\t\t&amp;lt;a href=&quot;viewMovieActors.php&quot;&amp;gt;View Movie Actors&amp;lt;\/a&amp;gt;\n\t&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\n<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"312\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1-700x312.png\" alt=\"\" class=\"wp-image-4586\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1-700x312.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1-300x134.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1-768x342.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1-769x343.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-1.png 864w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"insertMoviephp\"><\/span>insertMovie.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">\n&amp;lt;!DOCTYPE html&amp;gt;\n&amp;lt;html&amp;gt;\n\t&amp;lt;head&amp;gt;\n\t\t&amp;lt;title&amp;gt;Movie&amp;lt;\/title&amp;gt;\n\t\t&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;mystyle.css&quot;&amp;gt;\n\t&amp;lt;\/head&amp;gt;\n\t&amp;lt;body&amp;gt;\n\t\t&amp;lt;!-- HTML Form --&amp;gt;\n\t\t&amp;lt;form action=&quot;\/MoviesActorsPHPMySQLDatabase\/actionPage.php&quot;&amp;gt; \n\t\t\t&amp;lt;fieldset&amp;gt; \n\t\t\t\t&amp;lt;legend&amp;gt;\n\t\t\t\t\tMovie information:  \n\t\t\t\t&amp;lt;\/legend&amp;gt;\n\t\t\t\tMovie Name:\n\t\t\t\t&amp;lt;!-- Name Input Field  --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;text&quot; name=&quot;name&quot; value=&quot;&quot; required&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n\t\t\t\t&amp;lt;!-- Submit button field --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;submit&quot; name=&quot;submitMovie&quot; class=&quot;button&quot; value=&quot;submit&quot;&amp;gt; \n\t\t\t&amp;lt;\/fieldset&amp;gt; \n\t\t\t\n\t\t&amp;lt;\/form&amp;gt;\n\t&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\n<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"293\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Movie-700x293.png\" alt=\"\" class=\"wp-image-4587\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Movie-700x293.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Movie-300x125.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Movie.png 746w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"insertActorphp\"><\/span>insertActor.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: xml; title: ; notranslate\" title=\"\">\n&amp;lt;!DOCTYPE html&amp;gt;\n&amp;lt;html&amp;gt;\n\t&amp;lt;head&amp;gt;\n\t\t&amp;lt;title&amp;gt;Actor&amp;lt;\/title&amp;gt;\n\t\t&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;mystyle.css&quot;&amp;gt;\n\t&amp;lt;\/head&amp;gt;\n\t&amp;lt;body&amp;gt;\n\t\t&amp;lt;!-- HTML Form --&amp;gt;\n\t\t&amp;lt;form action=&quot;\/MoviesActorsPHPMySQLDatabase\/actionPage.php&quot;&amp;gt; \n\t\t\t&amp;lt;fieldset&amp;gt; \n\t\t\t\t&amp;lt;legend&amp;gt;\n\t\t\t\t\tActor information:  \n\t\t\t\t&amp;lt;\/legend&amp;gt;\n\t\t\t\tActor Name:\n\t\t\t\t&amp;lt;!-- Name Input Field  --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;text&quot; name=&quot;name&quot; value=&quot;&quot; required&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;\n\t\t\t\t&amp;lt;!-- Submit button field --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;submit&quot; name=&quot;submitActor&quot; class=&quot;button&quot; value=&quot;submit&quot;&amp;gt; \n\t\t\t&amp;lt;\/fieldset&amp;gt; \n\t\t\t\n\t\t&amp;lt;\/form&amp;gt;\n\t&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\n<\/pre>\n\n\n\n<h2><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"316\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-1-700x316.png\" alt=\"\" class=\"wp-image-4594\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-1-700x316.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-1-300x135.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-1.png 744w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"insertActorToAMoviephp\"><\/span>insertActorToAMovie.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\t\/\/ Mysql Database connection\n\t\/\/ Server name , username, password, Database name\n\t$databaseConnection = mysqli_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;,&quot;moviesactors&quot;);\n\t\n\t\/\/ Check database connection status\n\tif (mysqli_connect_errno()){\n\t\techo &quot;Failed to connect to MySQL: &quot; . mysqli_connect_error();\n\t}\n?&amp;gt;\n&amp;lt;!DOCTYPE html&amp;gt;\n&amp;lt;html&amp;gt;\n\t&amp;lt;head&amp;gt;\n\t\t&amp;lt;title&amp;gt;Actor&amp;lt;\/title&amp;gt;\n\t\t&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;mystyle.css&quot;&amp;gt;\n\t&amp;lt;\/head&amp;gt;\n\t&amp;lt;body&amp;gt;\n\t\t&amp;lt;!-- HTML Form --&amp;gt;\n\t\t&amp;lt;form action=&quot;\/MoviesActorsPHPMySQLDatabase\/actionPage.php&quot;&amp;gt;\n\t\t\t&amp;lt;fieldset&amp;gt;\n\t\t\t\t&amp;lt;legend&amp;gt;\n\t\t\t\t\tActor\/Movie information:\n\t\t\t\t&amp;lt;\/legend&amp;gt;\n\t\t\t\tActor Name:\n\t\t\t\t&amp;lt;!-- Name select Input Field --&amp;gt;\n\t\t\t\t&amp;lt;?php\n\t\t\t\t\t$query = &quot;SELECT * FROM `actors` WHERE 1&quot;;\n\t\t\t\t\t$res = mysqli_query($databaseConnection, $query);\n\t\t\t\t\techo &quot;&amp;lt;select name = 'nameA'&amp;gt;&quot;;\n\t\t\t\t\twhile (($row = mysqli_fetch_array($res)) != null)\n\t\t\t\t\t{\n\t\t\t\t\t\techo &quot;&amp;lt;option value = '{$row['id']}'&quot;;\n\t\t\t\t\t\techo &quot;&amp;gt;{$row['name']}&amp;lt;\/option&amp;gt;&quot;;\n\t\t\t\t\t}\n\t\t\t\t\techo &quot;&amp;lt;\/select&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&quot;;\n\t\t\t\t?&amp;gt;\n\t\t\t\tMovie Name:\n\t\t\t\t&amp;lt;!-- Actors select Input Field --&amp;gt;\n\t\t\t\t\n\t\t\t\t&amp;lt;?php\n\t\t\t\t\t$query = &quot;SELECT * FROM `movies` WHERE 1&quot;;\n\t\t\t\t\t$res = mysqli_query($databaseConnection, $query);\n\t\t\t\t\techo &quot;&amp;lt;select name = 'nameM'&amp;gt;&quot;;\n\t\t\t\t\twhile (($row = mysqli_fetch_array($res)) != null)\n\t\t\t\t\t{\n\t\t\t\t\t\t\n\t\t\t\t\t\techo &quot;&amp;lt;option value = '{$row['id']}'&quot;;\n\t\t\t\t\t\techo &quot;&amp;gt;{$row['name']}&amp;lt;\/option&amp;gt;&quot;;\n\t\t\t\t\t}\n\t\t\t\t\techo &quot;&amp;lt;\/select&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&quot;;\n\t\t\t\t?&amp;gt;\n\t\t\t\t\n\t\t\t\t&amp;lt;!-- Submit button field --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;submit&quot; name=&quot;submitActorMovie&quot; class=&quot;button&quot; value=&quot;submit&quot;&amp;gt;\n\t\t\t&amp;lt;\/fieldset&amp;gt;\n\t\t\t\n\t\t&amp;lt;\/form&amp;gt;\n\t&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\t\t\n<\/pre>\n\n\n\n<h2><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"396\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-To-Movie-700x396.png\" alt=\"\" class=\"wp-image-4597\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-To-Movie-700x396.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-To-Movie-300x170.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Add-Actor-To-Movie.png 742w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"145\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actor-Already-Assigned-700x145.png\" alt=\"\" class=\"wp-image-4624\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actor-Already-Assigned-700x145.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actor-Already-Assigned-300x62.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actor-Already-Assigned.png 741w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"viewMovieActorsphp\"><\/span>viewMovieActors.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\t\/\/ Mysql Database connection\n\t\/\/ Server name , username, password, Database name\n\t$databaseConnection = mysqli_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;,&quot;moviesactors&quot;);\n\t\n\t\/\/ Check database connection status\n\tif (mysqli_connect_errno()){\n\t\techo &quot;Failed to connect to MySQL: &quot; . mysqli_connect_error();\n\t}\n?&amp;gt;\n&amp;lt;!DOCTYPE html&amp;gt;\n&amp;lt;html&amp;gt;\n\t&amp;lt;head&amp;gt;\n\t\t&amp;lt;title&amp;gt;Movie Actors&amp;lt;\/title&amp;gt;\n\t\t&amp;lt;link rel=&quot;stylesheet&quot; href=&quot;mystyle.css&quot;&amp;gt;\n\t&amp;lt;\/head&amp;gt;\n\t&amp;lt;body&amp;gt;\n\t\t&amp;lt;!-- HTML Form --&amp;gt;\n\t\t&amp;lt;form action=&quot;&quot;&amp;gt;\n\t\t\t&amp;lt;fieldset&amp;gt;\n\t\t\t\t&amp;lt;legend&amp;gt;\n\t\t\t\t\tMovie Actors information:\n\t\t\t\t&amp;lt;\/legend&amp;gt;\n\t\t\t\tMovie Name:\n\t\t\t\t&amp;lt;!-- Actors select Input Field --&amp;gt;\n\t\t\t\t\n\t\t\t\t&amp;lt;?php\n\t\t\t\t\t$query = &quot;SELECT * FROM `movies` WHERE 1&quot;;\n\t\t\t\t\t$res = mysqli_query($databaseConnection, $query);\n\t\t\t\t\techo &quot;&amp;lt;select name = 'nameM'&amp;gt;&quot;;\n\t\t\t\t\twhile (($row = mysqli_fetch_array($res)) != null)\n\t\t\t\t\t{\n\t\t\t\t\t\techo &quot;&amp;lt;option value = '{$row['name']}'&quot;;\n\t\t\t\t\t\techo &quot;&amp;gt;{$row['name']}&amp;lt;\/option&amp;gt;&quot;;\n\t\t\t\t\t}\n\t\t\t\t\techo &quot;&amp;lt;\/select&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;&quot;;\n\t\t\t\t?&amp;gt;\n\t\t\t\t\n\t\t\t\t&amp;lt;!-- Submit button field --&amp;gt;\n\t\t\t\t&amp;lt;input type=&quot;submit&quot; name=&quot;submitShowMovieActors&quot; class=&quot;button&quot; value=&quot;Show Movie Actors&quot;&amp;gt;\n\t\t\t&amp;lt;\/fieldset&amp;gt;\n\t\t\t\n\t\t\t\n\t\t&amp;lt;\/form&amp;gt;\n\t\t&amp;lt;?php\n\t\t\tif (isset($_GET['submitShowMovieActors'])) {\n\t\t\t\t\n\t\t\t\t\/\/ Store data into the variables\n\t\t\t\t$m_name = $_GET['nameM'];\n\t\t\t\t\n\t\t\t\t\/\/ Storing data into the variables and Escaping special characters.\n\t\t\t\t$nameM = mysqli_real_escape_string($databaseConnection, $m_name);\n\t\t\t\t\n\t\t\t\t\/\/ query\n\t\t\t\t$selectMovieActorsQuery = &quot;SELECT\n\t\t\t\tactors.name As Actors\n\t\t\t\tFROM movies\n\t\t\t\tJOIN moviesactors\n\t\t\t\tON movies.id = moviesactors.movies_id\n\t\t\t\tJOIN actors\n\t\t\t\tON actors.id = moviesactors.actors_id\n\t\t\t\tWHERE movies.name = '$nameM' &quot;;\n\t\t\t\t\/\/ results\n\t\t\t\t$res = mysqli_query($databaseConnection, $selectMovieActorsQuery);\n\t\t\t\tif ($res) {\n\t\t\t\t\t# code...\n\t\t\t\t\t$rowcount=mysqli_num_rows($res);\t\t\t\n\t\t\t\t\t\n\t\t\t\t\t\n\t\t\t\t}\n\t\t\t\tif ($rowcount &amp;gt; 0) {\n\t\t\t\t\t# code...\n\t\t\t\t\techo &quot;&amp;lt;ul&amp;gt;&quot;;\n\t\t\t\t\twhile( ($row = mysqli_fetch_array($res))  != null )\n\t\t\t\t\t{\n\t\t\t\t\t\techo &quot;&amp;lt;li class=''&amp;gt;&amp;lt;a href='#'&amp;gt;&quot;;\n\t\t\t\t\t\techo $row['Actors'];\n\t\t\t\t\t\techo &quot;&amp;lt;\/a&amp;gt;&amp;lt;\/li&amp;gt;&quot;;\n\t\t\t\t\t}\n\t\t\t\t\techo &quot;&amp;lt;\/ul&amp;gt;&quot;;\n\t\t\t\t\t\n\t\t\t\t\t} else {\n\t\t\t\t\techo &quot;No Actors Found For The Selected Movie!&quot;;\n\t\t\t\t\texit();\n\t\t\t\t}\n\t\t\t}\n\t\t?&amp;gt;\n\t&amp;lt;\/body&amp;gt;\n&amp;lt;\/html&amp;gt;\t\t\t\t\t\t\n<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"515\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-700x515.png\" alt=\"\" class=\"wp-image-4600\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-700x515.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-300x221.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors.png 736w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"324\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-No-Movie-Actors-Found-700x324.png\" alt=\"\" class=\"wp-image-4605\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-No-Movie-Actors-Found-700x324.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-No-Movie-Actors-Found-300x139.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-No-Movie-Actors-Found.png 741w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"352\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-3-700x352.png\" alt=\"\" class=\"wp-image-4621\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-3-700x352.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-3-300x151.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-View-Movie-Actors-3.png 742w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"actionPagephp\"><\/span>actionPage.php<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\n&amp;lt;?php\n\t\n\t\/\/ Mysql Database connection\n\t\/\/ Server name , username, password, Database name\n\t$databaseConnection = mysqli_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;,&quot;moviesactors&quot;);\n\t\n\t\/\/ Check database connection status\n\tif (mysqli_connect_errno()){\n\t\techo &quot;Failed to connect to MySQL: &quot; . mysqli_connect_error();\n\t}\n\t\n\t\/\/If submit button is clicked\n\tif (isset($_GET['submitMovie'])) {\n\t\t\n\t\t\/\/ Store data into the variables\n\t\t$m_name = $_GET['name'];\n\t\t\n\t\t\/\/ Storing data into the variables and Escaping special characters.\n\t\t$name = mysqli_real_escape_string($databaseConnection, $m_name);\n\t\t\n\t\t\n\t\t\/\/ Insert query\n\t\t$sql = &quot;INSERT INTO `movies` (name) VALUES ('$name')&quot;;\n\t\t\n\t\t\/\/ Inserting data into users table\n\t\t$insert_data = mysqli_query($databaseConnection, $sql);\n\t\t\n\t\t\/\/ Check if data inserted\n\t\tif($insert_data){\n\t\t\techo &quot;Data inserted successfully.&quot;;\n\t\t}\n\t\t\/\/ else data not inserted\n\t\telse{\n\t\t\techo &quot;Something error occurred&quot;;\n\t\t}\n\t} else \/\/If submit\/submitActor button is clicked\n\tif (isset($_GET['submitActor'])) {\n\t\t\n\t\t\/\/ Store data into the variables\n\t\t$m_name = $_GET['name'];\n\t\t\n\t\t\/\/ Storing data into the variables and Escaping special characters.\n\t\t$name = mysqli_real_escape_string($databaseConnection, $m_name);\n\t\t\n\t\t\n\t\t\/\/ Insert query\n\t\t$sql = &quot;INSERT INTO `actors` (name) VALUES ('$name')&quot;;\n\t\t\n\t\t\/\/ Inserting data into users table\n\t\t$insert_data = mysqli_query($databaseConnection, $sql);\n\t\t\n\t\t\/\/ Check if data inserted\n\t\tif($insert_data){\n\t\t\techo &quot;Data inserted successfully.&quot;;\n\t\t}\n\t\t\/\/ else data not inserted\n\t\telse{\n\t\t\techo &quot;Something error occurred&quot;;\n\t\t}\n\t} else \/\/If submit\/submitActorMovie button is clicked\n\tif (isset($_GET['submitActorMovie'])) {\n\t\t\n\t\t\/\/ Store data into the variables\n\t\t$a_name = $_GET['nameA'];\n\t\t$m_name = $_GET['nameM'];\n\t\t\n\t\t\/\/ Storing data into the variables and Escaping special characters.\n\t\t$nameA = mysqli_real_escape_string($databaseConnection, $a_name);\n\t\t$nameM = mysqli_real_escape_string($databaseConnection, $m_name);\n\t\t\n\t\t\/\/ Check If Exists query\n\t\t$sqlCheckIfExists = &quot;SELECT `id`, `movies_id`, `actors_id` FROM `moviesactors` WHERE `movies_id` = '$nameM' AND `actors_id` = '$nameA' &quot;;\n\t\t\/\/ data Exists users table\n\t\t$data_Exists = mysqli_query($databaseConnection, $sqlCheckIfExists);\n\t\tif ($data_Exists) {\n\t\t\t# code...\n\t\t\t$rowcount=mysqli_num_rows($data_Exists);\n\t\t\t\n\t\t}\n\t\tif ($rowcount &amp;gt; 0) {\n\t\t\t# code...\n\t\t\techo &quot;That Actor Is Already Assigned To The Selected Movie!&quot;;\n\t\t\texit();\n\t\t\t\n\t\t\t} else {\n\t\t\t# code...\n\t\t\t\n\t\t\t\/\/ Insert query\n\t\t\t$sql = &quot;INSERT INTO `moviesactors` (`movies_id`, `actors_id`) VALUES ('$m_name', '$a_name')&quot;;\n\t\t\t\n\t\t\t\/\/ Inserting data into users table\n\t\t\t$insert_data = mysqli_query($databaseConnection, $sql);\n\t\t\t\n\t\t\t\/\/ Check if data inserted\n\t\t\tif($insert_data){\n\t\t\t\techo &quot;Data inserted successfully.&quot;;\n\t\t\t}\n\t\t\t\/\/ else data not inserted\n\t\t\telse{\n\t\t\t\techo &quot;Something error occurred&quot;;\n\t\t\t}\n\t\t}\n\t}\n\t\n\t\n\t\n\t\n?&amp;gt;\t\t\t\t\n<\/pre>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"mystylecss\"><\/span>mystyle.css<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: css; title: ; notranslate\" title=\"\">\na:link, a:visited {\n  background-color: white;\n  color: black;\n  border: 2px solid green;\n  padding: 10px 20px;\n  text-align: center;\n  text-decoration: none;\n  display: inline-block;\n}\n\na:hover, a:active {\n  background-color: green;\n  color: white;\n}\n.button {\n  background-color: #4CAF50;\n  border: none;\n  color: white;\n  padding: 15px 32px;\n  text-align: center;\n  text-decoration: none;\n  display: inline-block;\n  font-size: 16px;\n  margin: 4px 2px;\n  cursor: pointer;\n}\nfieldset {\n  background-color: #eeeeee;\n}\n\nlegend {\n  background-color: gray;\n  color: white;\n  padding: 5px 10px;\n}\n\ninput {\n  margin: 5px;\n}\n\ninput[type=text], select {\n  width: 100%;\n  padding: 12px 20px;\n  margin: 8px 0;\n  display: inline-block;\n  border: 1px solid #ccc;\n  border-radius: 4px;\n  box-sizing: border-box;\n}\n\n\nul {\n  counter-reset: li; \n  list-style: none; \n  padding: 0;\n  text-shadow: 0 1px 0 rgba(255,255,255,.5);\n}\n\nul a {\n  position: relative;\n  display: block;\n  padding: .4em .4em .4em 2em;\n  margin: .5em 0;\n  background: #DAD2CA;\n  color: #444;\n  text-decoration: none;\n  border-radius: .3em;\n  transition: .3s ease-out;\n}\n\nul a:hover { background: #E9E4E0; }\nul a:hover:before { transform: rotate(360deg); }\nul a:before {\n  content: counter(li);\n  counter-increment: li;\n  position: absolute;\n  left: -1.3em;\n  top: 50%;\n  margin-top: -1.3em;\n  background: #f9dd94;\n  height: 2em;\n  width: 2em;\n  line-height: 2em;\n  border: .3em solid #fff;\n  text-align: center;\n  font-weight: bold;\n  border-radius: 2em;\n  transition: all .3s ease-out;\n}\n<\/pre>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"phpMyAdmin_SQL_Dump\"><\/span>phpMyAdmin SQL Dump<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n-- phpMyAdmin SQL Dump\n-- version 5.1.0\n-- https:\/\/www.phpmyadmin.net\/\n--\n-- Host: 127.0.0.1\n-- Generation Time: May 28, 2021 at 03:44 PM\n-- Server version: 10.4.19-MariaDB\n-- PHP Version: 8.0.6\n\nSET SQL_MODE = &quot;NO_AUTO_VALUE_ON_ZERO&quot;;\nSTART TRANSACTION;\nSET time_zone = &quot;+00:00&quot;;\n\n\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\n\/*!40101 SET NAMES utf8mb4 *\/;\n\n--\n-- Database: `moviesactors`\n--\nCREATE DATABASE IF NOT EXISTS `moviesactors` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;\nUSE `moviesactors`;\n\n-- --------------------------------------------------------\n\n--\n-- Table structure for table `actors`\n--\n\nCREATE TABLE `actors` (\n  `id` int(11) NOT NULL,\n  `name` varchar(30) NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n\n--\n-- Dumping data for table `actors`\n--\n\nINSERT INTO `actors` (`id`, `name`) VALUES(1, 'Jason Statham');\nINSERT INTO `actors` (`id`, `name`) VALUES(2, 'Josh Hartnett');\nINSERT INTO `actors` (`id`, `name`) VALUES(3, 'Holt McCallany');\nINSERT INTO `actors` (`id`, `name`) VALUES(6, 'Bruce Willis');\n\n-- --------------------------------------------------------\n\n--\n-- Table structure for table `movies`\n--\n\nCREATE TABLE `movies` (\n  `id` int(11) NOT NULL,\n  `name` varchar(30) NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n\n--\n-- Dumping data for table `movies`\n--\n\nINSERT INTO `movies` (`id`, `name`) VALUES(1, 'Wratt Of Man');\nINSERT INTO `movies` (`id`, `name`) VALUES(2, 'Green Honnet');\nINSERT INTO `movies` (`id`, `name`) VALUES(3, 'Clash Of Titans');\n\n-- --------------------------------------------------------\n\n--\n-- Table structure for table `moviesactors`\n--\n\nCREATE TABLE `moviesactors` (\n  `id` int(11) NOT NULL,\n  `movies_id` int(11) NOT NULL,\n  `actors_id` int(11) NOT NULL\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n\n--\n-- Dumping data for table `moviesactors`\n--\n\nINSERT INTO `moviesactors` (`id`, `movies_id`, `actors_id`) VALUES(1, 1, 1);\nINSERT INTO `moviesactors` (`id`, `movies_id`, `actors_id`) VALUES(2, 1, 3);\nINSERT INTO `moviesactors` (`id`, `movies_id`, `actors_id`) VALUES(3, 1, 2);\nINSERT INTO `moviesactors` (`id`, `movies_id`, `actors_id`) VALUES(11, 1, 6);\nINSERT INTO `moviesactors` (`id`, `movies_id`, `actors_id`) VALUES(12, 2, 6);\n\n--\n-- Indexes for dumped tables\n--\n\n--\n-- Indexes for table `actors`\n--\nALTER TABLE `actors`\n  ADD PRIMARY KEY (`id`);\n\n--\n-- Indexes for table `movies`\n--\nALTER TABLE `movies`\n  ADD PRIMARY KEY (`id`);\n\n--\n-- Indexes for table `moviesactors`\n--\nALTER TABLE `moviesactors`\n  ADD PRIMARY KEY (`id`),\n  ADD KEY `Constraint_FK_Movies_ID` (`movies_id`),\n  ADD KEY `Constraint_FK_actors_ID` (`actors_id`);\n\n--\n-- AUTO_INCREMENT for dumped tables\n--\n\n--\n-- AUTO_INCREMENT for table `actors`\n--\nALTER TABLE `actors`\n  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;\n\n--\n-- AUTO_INCREMENT for table `movies`\n--\nALTER TABLE `movies`\n  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;\n\n--\n-- AUTO_INCREMENT for table `moviesactors`\n--\nALTER TABLE `moviesactors`\n  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;\n\n--\n-- Constraints for dumped tables\n--\n\n--\n-- Constraints for table `moviesactors`\n--\nALTER TABLE `moviesactors`\n  ADD CONSTRAINT `Constraint_FK_Movies_ID` FOREIGN KEY (`movies_id`) REFERENCES `movies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,\n  ADD CONSTRAINT `Constraint_FK_actors_ID` FOREIGN KEY (`actors_id`) REFERENCES `actors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;\nCOMMIT;\n\n\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;\n\n<\/pre>\n\n\n\n<h2><\/h2>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"SCREENSHOTS\"><\/span>SCREENSHOTS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DATABASE_DESIGN\"><\/span>DATABASE DESIGN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"405\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Design-700x405.png\" alt=\"\" class=\"wp-image-4607\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Design-700x405.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Design-300x174.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Design.png 746w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<h2><span class=\"ez-toc-section\" id=\"DATABASE_STRUCTURE_AND_TABLES\"><\/span>DATABASE STRUCTURE AND TABLES<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"355\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables-700x355.png\" alt=\"\" class=\"wp-image-4610\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables-700x355.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables-300x152.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables-768x390.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables-769x390.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-Tables.png 946w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"417\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table-700x417.png\" alt=\"\" class=\"wp-image-4614\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table-700x417.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table-300x179.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table-768x458.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table-769x458.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Actors-Database-Table.png 946w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"459\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table-700x459.png\" alt=\"\" class=\"wp-image-4618\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table-700x459.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table-300x197.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table-768x504.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table-769x505.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movies-Database-Table.png 942w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"700\" height=\"490\" src=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables-700x490.png\" alt=\"\" class=\"wp-image-4615\" srcset=\"https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables-700x490.png 700w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables-300x210.png 300w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables-768x537.png 768w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables-769x538.png 769w, https:\/\/mauricemuteti.info\/wp-content\/uploads\/2021\/05\/Insert-Delete-Read-Data-From-Mysql-Php-Html-Css-SQL-Movie-Actors-Database-moviesactors-Tables.png 946w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Insert Delete Read Data From Mysql Table Using PHP MySQL HTML Xampp Localhost(phpMyAdmin) DEMO VIDEO SOURCE CODE index.php insertMovie.php insertActor.php insertActorToAMovie.php viewMovieActors.php actionPage.php mystyle.css phpMyAdmin&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3283],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/4575"}],"collection":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/comments?post=4575"}],"version-history":[{"count":0,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/posts\/4575\/revisions"}],"wp:attachment":[{"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/media?parent=4575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/categories?post=4575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mauricemuteti.info\/wp-json\/wp\/v2\/tags?post=4575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}