Dependent Drop Down list In PHP and MySQL using jQuery Ajax

Поділитися
Вставка
  • Опубліковано 19 вер 2024
  • Dependent Drop Down list In PHP and MySQL using jQuery Ajax
    Get the code from my GitHub Channel: github.com/dur...
    Share, Support, Subscribe!!!
    UA-cam: / learnwebcoding
    Facebook: / learnwebcoding
    Blog: dwebcoding.blog...
    GitHub: github.com/dur...
    Connect with Me:
    Linkedin: / durgesh-sahani
    Facebook: / durgeshsahani99
    Instagram: / durgesh.sahani99
    Twitter: / durgeshsahani99

КОМЕНТАРІ • 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!!

  • @zacmussatt9267
    @zacmussatt9267 4 роки тому +2

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

  • @darshitsolanki4922
    @darshitsolanki4922 5 років тому +2

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

  • @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

  • @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 ....

  • @zealcrew9217
    @zealcrew9217 Рік тому

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

  • @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

  • @pythusiast4701
    @pythusiast4701 3 роки тому

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

  • @vijayshah8393
    @vijayshah8393 4 роки тому

    Nice One... Really like this tutorial

  • @akshaygupta8331
    @akshaygupta8331 5 років тому

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

  • @DailyTutorial
    @DailyTutorial 3 роки тому

    nice bro

  • @PhanDuyAnhB
    @PhanDuyAnhB Рік тому

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

  • @ianfineza6870
    @ianfineza6870 6 років тому +1

    Hi sir! I am your fan from Philippines :)

  • @omniversal4739
    @omniversal4739 4 роки тому

    Thanks, bro! Very informative tutorial.

  • @kazimrahman7499
    @kazimrahman7499 3 роки тому

    Awesome...!!

  • @ahmetcengiz6247
    @ahmetcengiz6247 4 роки тому +1

    This video made my day! Thanks my friend :)

  • @isuruaravinda9651
    @isuruaravinda9651 5 років тому

    Really helpful video, thank you very much

  • @LaughterCentra
    @LaughterCentra 4 роки тому +1

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

  • @khal-elbangcola8167
    @khal-elbangcola8167 4 роки тому +1

    Thank you very much Sir

  • @naidum.krishnakumar7665
    @naidum.krishnakumar7665 6 років тому

    Great video

  • @mohammedbashiru9551
    @mohammedbashiru9551 6 років тому

    Thank you sir. You are very good

  • @farithadnan
    @farithadnan 4 роки тому +1

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

  • @jennygrigoryan3809
    @jennygrigoryan3809 2 роки тому

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

  • @serveque
    @serveque 4 роки тому

    thank you so much . it is excellent

  • @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!

  • @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

  • @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.

  • @webprogramming7055
    @webprogramming7055 6 років тому

    thank you..

  • @mohdnawazishalam3255
    @mohdnawazishalam3255 5 років тому

    Very helpful tuturial bro can you make it on laravel

  • @ccnaexperts19
    @ccnaexperts19 4 роки тому

    Thanks!

  • @nijandhanjaganathan5281
    @nijandhanjaganathan5281 5 років тому

    Thank you Bro.

  • @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

  • @emmanuelokonkwo6578
    @emmanuelokonkwo6578 5 років тому

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

  • @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?

  • @aliihsansuna
    @aliihsansuna 6 років тому

    good jop

  • @DwikiIkhwan
    @DwikiIkhwan 4 роки тому +1

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

  • @farhanazam8981
    @farhanazam8981 5 років тому

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

  • @arkchannel7830
    @arkchannel7830 3 роки тому

    Please tell me how to connect four dropdown list connections

  • @hafizullah5123
    @hafizullah5123 3 роки тому

    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

  • @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

  • @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

  • @dhanabalp9175
    @dhanabalp9175 4 роки тому

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

  • @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 5 років тому +1

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

  • @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

  • @swathir8828
    @swathir8828 Рік тому

    Is it possible without using php only by using jQuery?

  • @bikramjitsinghvirdi5365
    @bikramjitsinghvirdi5365 3 роки тому

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

  • @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 + '')
      })

  • @binduvasini8614
    @binduvasini8614 4 роки тому

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

  • @laboratoryforeducationalte9457
    @laboratoryforeducationalte9457 2 роки тому

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

  • @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"]

  • @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

  • @sumit390
    @sumit390 5 років тому

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

  • @ripplesharma7166
    @ripplesharma7166 5 років тому

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

  • @wisdomguy9837
    @wisdomguy9837 3 роки тому

    The code from github is incomplete

  • @manjannan3976
    @manjannan3976 4 роки тому

    Can I use this to Google form..?

  • @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?

  • @robinjoseph8925
    @robinjoseph8925 Рік тому

    There is an error in your SQL file source code bro

  • @mitbusinessorganization6738
    @mitbusinessorganization6738 2 роки тому

    SOURCE CODE NOT WORKING

  • @ms-arif
    @ms-arif 5 років тому

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

  • @gyan_ki_baate_2023
    @gyan_ki_baate_2023 6 місяців тому

    No works

  • @MehediHasan-iq6tz
    @MehediHasan-iq6tz 5 років тому

    source code plz..!

  • @ratnakarsingh82
    @ratnakarsingh82 5 років тому

    code de ta