{"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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"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":70015,"url":"http:\/\/bangla.sitestree.com\/?p=70015","url_meta":{"origin":70095,"position":4},"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":[]},{"id":67783,"url":"http:\/\/bangla.sitestree.com\/?p=67783","url_meta":{"origin":70095,"position":5},"title":"Apache PHP MySQL Platform configuration #By Sayed Ahmed #MS SQL Server","author":"Author-Check- Article-or-Video","date":"July 28, 2021","format":false,"excerpt":"From: http:\/\/sitestree.com\/?p=2774 Categories:By Sayed Ahmed, MS SQL ServerTags:PHP MySQL Post Data:2015-11-02 18:33:46 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","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}]}}