Dependent Drop Down list In PHP and MySQL using jQuery Ajax

แชร์
ฝัง
  • เผยแพร่เมื่อ 8 พ.ย. 2024

ความคิดเห็น • 82

  • @pedrosoares7273
    @pedrosoares7273 4 ปีที่แล้ว +6

    I've been trying to do this for over 15 hours (spread between 2 days).
    No joke.
    And thanks to your video I could do it. Thank you very much

    • @learnWebCoding
      @learnWebCoding  4 ปีที่แล้ว

      I am glad to hear that. you're most welcome!!

  • @sithusoe8797
    @sithusoe8797 2 ปีที่แล้ว

    Thanks a lot. God Bless U bro. Fully explain in only one short video. I understand well. Code also working very well. I'll never forget u. Thanks ....

  • @cj3413
    @cj3413 6 ปีที่แล้ว +1

    This worked for me very well, except json parse who don’t accept the use of accents in words like : é or è.
    Thank you so much Sir

  • @zacmussatt9267
    @zacmussatt9267 4 ปีที่แล้ว +2

    I found this adaptable for my project. Thank you for taking the time to make this demo.

  • @zealcrew9217
    @zealcrew9217 2 ปีที่แล้ว

    it was a big help bro, abhi maja aiga na bhidu, god bless you mere bhai.

  • @darshitsolanki4922
    @darshitsolanki4922 5 ปีที่แล้ว +2

    after an hour got the right video ... thank you so much

  • @pythusiast4701
    @pythusiast4701 3 ปีที่แล้ว

    awesome man. You saved my day. Very helpful. GOD bless u.

  • @PhanDuyAnhB
    @PhanDuyAnhB ปีที่แล้ว

    thank u so much, love u 3000 🥰😁😁😁

  • @parideshpande7315
    @parideshpande7315 4 ปีที่แล้ว +2

    Thank you so much for this video! I was struggling to do this since a veryy long time. Thank you so much!!

    • @learnWebCoding
      @learnWebCoding  4 ปีที่แล้ว +1

      Glad to hear that.. your welcome!!

    • @fabianhernandez3569
      @fabianhernandez3569 4 ปีที่แล้ว

      @@learnWebCoding hi good work, just have a question how can i add the value in --'' + --model.name-- + ''-- thank you

  • @vijayshah8393
    @vijayshah8393 4 ปีที่แล้ว

    Nice One... Really like this tutorial

  • @jennygrigoryan3809
    @jennygrigoryan3809 2 ปีที่แล้ว

    Thanks a lot! It works!!!!!!!!!

  • @akshaygupta8331
    @akshaygupta8331 5 ปีที่แล้ว

    thanks a lot sir for the video. my all queries get solved. thanks once again

  • @DailyTutorial
    @DailyTutorial 3 ปีที่แล้ว

    nice bro

  • @kazimrahman7499
    @kazimrahman7499 3 ปีที่แล้ว

    Awesome...!!

  • @bachuarg
    @bachuarg 5 ปีที่แล้ว

    Thanks for the video.
    Was really useful and got it working.
    Now Im stuck in the following step.
    I need to submit the author and book to get the book detail in another page, adding the awards and the year the books were published.
    Would be great if you can help me!

  • @khal-elbangcola8167
    @khal-elbangcola8167 4 ปีที่แล้ว +1

    Thank you very much Sir

  • @ianfineza6870
    @ianfineza6870 6 ปีที่แล้ว +1

    Hi sir! I am your fan from Philippines :)

  • @LaughterCentra
    @LaughterCentra 4 ปีที่แล้ว +1

    Hi thanks for your effort on this tutorial . can you make another tutorial using postgresql?

  • @omniversal4739
    @omniversal4739 4 ปีที่แล้ว

    Thanks, bro! Very informative tutorial.

  • @isuruaravinda9651
    @isuruaravinda9651 5 ปีที่แล้ว

    Really helpful video, thank you very much

  • @farithadnan
    @farithadnan 4 ปีที่แล้ว +1

    omg! thank you so much for this tutorial! i really needed this

  • @ahmetcengiz6247
    @ahmetcengiz6247 5 ปีที่แล้ว +1

    This video made my day! Thanks my friend :)

    • @learnWebCoding
      @learnWebCoding  5 ปีที่แล้ว

      Glad to hear that.. your welcome!

  • @sachinbhagat1483
    @sachinbhagat1483 5 ปีที่แล้ว

    Instead of selecting from drop-down from first text box I want to select from autocomplete suggestions from first text box and fetch associated books in second text box..
    Please make this video of dynamic drop-down based on autocomplete suggestions selection.
    I have searched over Google but didn't find any decent tutorial on this.

  • @serveque
    @serveque 4 ปีที่แล้ว

    thank you so much . it is excellent

  • @naidum.krishnakumar7665
    @naidum.krishnakumar7665 6 ปีที่แล้ว

    Great video

  • @ginamagdadaro7748
    @ginamagdadaro7748 2 ปีที่แล้ว

    How to edit or update dependent dropdown? Can you make a tutorial please i badly need it for my project. Thanks in advance

  • @DwikiIkhwan
    @DwikiIkhwan 4 ปีที่แล้ว +1

    Embrace your ears, plug your headphones in 11:45
    You're welcome

    • @PureRiseTv
      @PureRiseTv 2 ปีที่แล้ว

      😂😂😂😂

  • @farhanazam8981
    @farhanazam8981 6 ปีที่แล้ว

    it is working, so how about showing back the dropdown based on the data from database?

  • @mohammedbashiru9551
    @mohammedbashiru9551 6 ปีที่แล้ว

    Thank you sir. You are very good

  • @emmanuelokonkwo6578
    @emmanuelokonkwo6578 5 ปีที่แล้ว

    Thanks for this. However I need to insert the selected option into the database not the id. Thanks

  • @ccnaexperts19
    @ccnaexperts19 4 ปีที่แล้ว

    Thanks!

  • @akbarjonkarimdjanov6554
    @akbarjonkarimdjanov6554 4 ปีที่แล้ว

    Thank you for the nice tutorial. How about binding more than two dropdowns and to show the price in frontend as a result? Ex.: (Make) Samsung -> (Model) Galaxy S9 ->(Country) India->(Carrier) Airtel->(Service) AAA = $10

  • @mohdnawazishalam3255
    @mohdnawazishalam3255 5 ปีที่แล้ว

    Very helpful tuturial bro can you make it on laravel

  • @akshaygupta8331
    @akshaygupta8331 5 ปีที่แล้ว

    is it necessary to write the lines "
    " in the program

  • @emmanuelaku6892
    @emmanuelaku6892 5 ปีที่แล้ว

    Nice work. Thanks for sharing. Please, how can I get the codes?

  • @nijandhanjaganathan5281
    @nijandhanjaganathan5281 5 ปีที่แล้ว

    Thank you Bro.

  • @dhanabalp9175
    @dhanabalp9175 4 ปีที่แล้ว

    i want a four dropdown and last dropdown select means get price can u help for us?

  • @arkchannel7830
    @arkchannel7830 3 ปีที่แล้ว

    Please tell me how to connect four dropdown list connections

  • @manjannan3976
    @manjannan3976 4 ปีที่แล้ว

    Can I use this to Google form..?

  • @webprogramming7055
    @webprogramming7055 6 ปีที่แล้ว

    thank you..

  • @swathir8828
    @swathir8828 2 ปีที่แล้ว

    Is it possible without using php only by using jQuery?

  • @mr.sopeou9319
    @mr.sopeou9319 3 ปีที่แล้ว

    How to insert variables placeholder in mysql

  • @sachitparmar129
    @sachitparmar129 4 ปีที่แล้ว

    But how u insert author id into book table please explain

  • @sumit390
    @sumit390 5 ปีที่แล้ว

    How to displays the information of the authors and book selected on the same page

  • @akshaygupta8331
    @akshaygupta8331 5 ปีที่แล้ว

    sir , in line no. 19 "books.forEach(function(book)" where the book comes from?

    • @hasnathrumman8712
      @hasnathrumman8712 4 ปีที่แล้ว +2

      book is just a param... it's the first array of this {books}... btw you can use any keyword instead of book and it'll work...
      And make sure use the same keyword when you append with books table...
      exm:
      books.forEach( function(bookie) {
      $('#books').append('' + bookie.book_name + '')
      })

  • @aliihsansuna
    @aliihsansuna 6 ปีที่แล้ว

    good jop

  • @twiggitina21
    @twiggitina21 5 ปีที่แล้ว +1

    Can we please have access to the source code? I have copied you ajax verbatim and the $_post var is not getting to my php script

  • @bikramjitsinghvirdi5365
    @bikramjitsinghvirdi5365 3 ปีที่แล้ว

    Thanx sir can you give me css and jquery for the same i m unable to run this

  • @binduvasini8614
    @binduvasini8614 4 ปีที่แล้ว

    Sir I have included the jQuery file. But still, the second drop-down is not working.

  • @shreyabhat2701
    @shreyabhat2701 4 ปีที่แล้ว

    sir,
    I tried to implement your logic with my database but its showing the below error
    Uncaught SyntaxError: Unexpected end of JSON input
    at JSON.parse ()
    at Object. (create_quotation.php:20)
    at fire (jquery-1.8.2.js:974)
    at Object.fireWith [as resolveWith] (jquery-1.8.2.js:1082)
    at done (jquery-1.8.2.js:7788)
    at XMLHttpRequest.callback (jquery-1.8.2.js:8500)
    can u please help me with it.
    even in console nothing is getting displayed

  • @vcleanandcaresolution8228
    @vcleanandcaresolution8228 3 ปีที่แล้ว

    Your name (required)
    [text* your-name]
    [select* Main Category "Home deep cleaning"][select* Sub Category "sofa cleaning"
    "kitchen cleaning"
    "bathroom cleaning"][select* Main Category "Painting"][select* Sub Category "interior painting"
    "exterior painting"
    "texture painting"]
    [select* Main Category "Painting"][select* Sub Category "interior painting"
    "exterior painting"
    "texture painting"]
    Your email
    [email* your-email]
    Subject
    [text* your-subject]
    Your message (optional)
    [textarea your-message]
    [submit "Submit"]

  • @ripplesharma7166
    @ripplesharma7166 5 ปีที่แล้ว

    don't show the second dropdown what to do now plz help me...

  • @boukhatemiabdelkader65
    @boukhatemiabdelkader65 6 ปีที่แล้ว +3

    thank you for this nice tuto, please i have write the same code for another database but i have this message:
    Uncaught SyntaxError: Unexpected end of JSON input
    at JSON.parse ()
    at Object. ((index):16)
    in this line:
    books = JSON.parse(books);
    books.ForEach (function(book){
    $('#books').append(''+ book.code_sec +'')
    })
    in my BD i have 2 tables :
    1: specialite (id_spe, nom_spe, code_spe)
    2: section (id_sec, code_sec, #id_spe)
    Thks for help me

    • @YassineIBNELHASSANMA
      @YassineIBNELHASSANMA 6 ปีที่แล้ว +1

      I'm having the same issue. Have you managed to find a solution for it?

  • @hafizullah5123
    @hafizullah5123 4 ปีที่แล้ว

    Anyone to help, I need to insert district id into database, one i click province, dependent dropdown should should show all its districts and then id of that district should be inserted into my database.Thanks in advance

  • @laboratoryforeducationalte9457
    @laboratoryforeducationalte9457 3 ปีที่แล้ว

    where is the jquery and css file and the second selection is not working.plz reply

  • @wisdomguy9837
    @wisdomguy9837 3 ปีที่แล้ว

    The code from github is incomplete

  • @mohammedbashiru9551
    @mohammedbashiru9551 6 ปีที่แล้ว

    Imaging I wanted to show my results to be like Books, Author for the Books Dropdown list how would I do that Sir?

  • @yunvi10z
    @yunvi10z 6 ปีที่แล้ว +1

    ths dont work for me dont show the second select

    • @technicalgyan1628
      @technicalgyan1628 6 ปีที่แล้ว

      true it is not work

    • @blankshell3401
      @blankshell3401 5 ปีที่แล้ว

      to get the 2nd select you need to have the jquery-3.2.1.min.js and place it in your folder

  • @ms-arif
    @ms-arif 5 ปีที่แล้ว

    This script is just owo, but i need to insert country name,state name & city name ,.pls help me

  • @robinjoseph8925
    @robinjoseph8925 ปีที่แล้ว

    There is an error in your SQL file source code bro

  • @mitbusinessorganization6738
    @mitbusinessorganization6738 2 ปีที่แล้ว

    SOURCE CODE NOT WORKING

  • @MehediHasan-iq6tz
    @MehediHasan-iq6tz 5 ปีที่แล้ว

    source code plz..!

  • @gyan_ki_baate_2023
    @gyan_ki_baate_2023 7 หลายเดือนก่อน

    No works

  • @ratnakarsingh82
    @ratnakarsingh82 5 ปีที่แล้ว

    code de ta