{"id":70095,"date":"2021-08-25T04:10:07","date_gmt":"2021-08-25T08:10:07","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/stored-procedure-php-mysql-16\/"},"modified":"2021-08-25T04:10:07","modified_gmt":"2021-08-25T08:10:07","slug":"stored-procedure-php-mysql-16","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=70095","title":{"rendered":"Stored Procedure: PHP &amp; MySQL #16"},"content":{"rendered":"<p>Stored Procedure: PHP &amp; MySQL. Stored Procedures are new additions to MySQL 5. PHP has supports for Store Procedure as well (with some limitations).   <\/p>\n<ul>\n<li> <a href='http:\/\/www.macronimous.com\/resources\/using_stored_procedure_with_mySQL_and_PHP.asp' target='new' rel=\"noopener\">Using Stored procedure with mySQL and PHP <\/a>      <\/li>\n<li> <a href='http:\/\/www.justintubbs.com\/code-samples\/mysql-stored-procedures.php' target='new' rel=\"noopener\">CODE TUTORIAL: MySql Stored Procedures<\/a><\/li>\n<li> <a href='http:\/\/justetc.net\/knowledge\/index.php?table=Articles&amp;categoryID=16&amp;category=PHP'> PHP Resources at JustETC<\/a><\/li>\n<li> <a href='http:\/\/justetc.net\/knowledge\/index.php?table=Articles&amp;categoryID=5&amp;category=MySQL'> MySQL Resources at JustETC<\/a>  <\/li>\n<\/ul>\n<p>From: http:\/\/sitestree.com\/?p=5263<br \/> Categories:16<br \/>Tags:<br \/> Post Data:2009-10-27 05:05:14<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Stored Procedure: PHP &amp; MySQL. Stored Procedures are new additions to MySQL 5. PHP has supports for Store Procedure as well (with some limitations). Using Stored procedure with mySQL and PHP CODE TUTORIAL: MySql Stored Procedures PHP Resources at JustETC MySQL Resources at JustETC From: http:\/\/sitestree.com\/?p=5263 Categories:16Tags: Post Data:2009-10-27 05:05:14 Shop Online: &lt;a href=&#8217;https:\/\/www.ShopForSoul.com\/&#8217; target=&#8217;new&#8217; &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=70095\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-70095","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69099,"url":"http:\/\/bangla.sitestree.com\/?p=69099","url_meta":{"origin":70095,"position":0},"title":"Stored Procedure in MySql #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Starting from MySQL 5, you get Stored Procedure in Mysql What is a stored procedure: A stored procedure is simply a procedure that is stored on the database server like MySQL. In programming languages, you write procedures to execute a function\/logic. You can write similar procedure in SQL and store\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69107,"url":"http:\/\/bangla.sitestree.com\/?p=69107","url_meta":{"origin":70095,"position":1},"title":"MySQL New Features #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"MySQL New Features Cursor Example:CREATE PROCEDURE p25 (OUT return_val INT)BEGINDECLARE a,b INT;DECLARE cur_1 CURSOR FOR SELECT s1 FROM t;DECLARE CONTINUE HANDLER FOR NOT FOUND < --SET b = 1; <--OPEN cur_1;REPEATFETCH cur_1 INTO a;UNTIL b = 1END REPEAT;CLOSE cur_1;SET return_val = a;END;\/\/ Stored procedure in MySQL http:\/\/www.mysqltutorial.org\/stored-procedures-loop.aspx Loop in stored\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69097,"url":"http:\/\/bangla.sitestree.com\/?p=69097","url_meta":{"origin":70095,"position":2},"title":"MySQL Resources: MySQL Start #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Mysql Resources: First you need the latest\/stable version of MySQL. Right now 6.0 is the latest version. Mysql has two different releases like:community server[free] enterprise server[commercial] Note: MAXDB is the current full package with many features that may not be fully tested. Download MySQL: You can download MySQL fromhttp:\/\/dev.mysql.com\/downloads\/mysql\/5.0.html Check\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69103,"url":"http:\/\/bangla.sitestree.com\/?p=69103","url_meta":{"origin":70095,"position":3},"title":"MySQL: Special Interests #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Optimization MySQL Load Balancher MySQL Replication MySQL Cluster Stored Procedures and Functions MySQL High Availability and Scalability From: http:\/\/sitestree.com\/?p=4904 Categories:5Tags: Post Data:2008-02-06 01:16:07 Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a> <a href='http:\/\/SitesTree.com' target='new'\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":70095,"position":4},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70015,"url":"http:\/\/bangla.sitestree.com\/?p=70015","url_meta":{"origin":70095,"position":5},"title":"Part 2: How to install PHP\/MySQL Development Environment: Eclipse PDT #16","author":"Author-Check- Article-or-Video","date":"August 23, 2021","format":false,"excerpt":"Part 2: How to install PHP\/MySQL Development Environment: Eclipse PDT Video Tutorial on this Topic Tools required: PHP 5, MySQL 5, MySQL GUI, IIS\/Apache, Eclipse PDT Download software and install them. Mostly unzipping or clicking on setup.exe Use Windows - add remove programs to install IIS Configure php.ini for PHP\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70095"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/70095\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70095"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}