Cursor in stored procedure in phpMyAdmin

Advanced MySQL Concepts in php
Share, Support, Subscribe!!!
TH-cam: / learnwebcoding
Facebook: / learnwebcoding
Blog: dwebcoding.blog...
GitHub: github.com/dur...
Connect with Me:
Linkedin: / durgesh-sahani
Facebook: / durgeshsahani99
Instagram: / durgesh.sahani99
Twitter: / durgeshsahani99

[@foodhomedotcom2716]

Cool. It would help if you put that StorProc into the comments so I can copy paste it.
I'll do that now in absence of your thoughtfulness
BEGIN
DECLARE bname, soldBy TEXT;
DECLARE exit_loop BOOLEAN DEFAULT FALSE;
DECLARE book_cursor CURSOR FOR SELECT name, sold_by FROM books;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET exit_loop = TRUE;
OPEN book_cursor;
book_loop: LOOP
FETCH FROM book_cursor INTO bname, soldBy;
IF exit_loop THEN
LEAVE book_loop;
END IF;
IF soldBy = "snapdeal" THEN
SELECT bname;
END IF;
END LOOP book_loop;
CLOSE book_cursor;
END

[@Voudoo1]

Thankyou! You ended my 3 hours search, finally i can sleep

[@learnWebCoding]

Glad to hear that..!!

[@nicolasmunoz6447]

@@learnWebCoding me too, 8:15 am has been a long night...

[@KajalSharma-kb2pj]

Really its nyc video to know about cursor........

[@SandeepKumar-so2st]

You have explained very well in a 10 minute video.

[@zhasan66]

Excellent video tutorial.

[@jbie4590]

thank you so much. that's really helpful

[@cvharibabu]

Good Tutorial sir! How to call this stored procedure in PHP. Please show and explain the code.

[@michaelbeee3801]

Good Video, but I am not getting it. Why you need a cursor? I can do SELECT bname from table where soldby='amazon'; (pseudo code)

[@Deepakchouhan-gz3em]

sir in php frontend I use mysql_fetch_array but it's fetching only one recode how can I fetch all recode and show them in frontend

[@ZeeshanKhan-kf9by]

Good bit anyone tells me in a simple way. Why do we use the stored procedures in PHPMYADMIN?
Is it for used show result quickly, If yes Than How ?

[@instituteofprofessionaltra3226]

Its really helps to me .

[@veronicamercadoperez6668]

awesome! thanks :)

[@harshpatel105]

Really helpful sir!

[@learnWebCoding]

Glad to hear that.. thank you!