PHP Tutorials: jQuery: Get Data from MySQL Database without Refreshing

[@benmontoya428]

I've been watching your tutorials along with TheNewBoston's tutorials and I have to say you two are possibly the greatest teachers ever when it comes to programming. You guys are very descriptive and organized, and it's really easy to keep along and understand everything. Thank you.

[@karlpokus]

I love that you start off your tuts with the result. Should really be a best practise. Kudos!

[@SuperVegan1]

Very nice, no excess information and I understood it even though I've never done any php, thank you.

[@codecourse]

That's great to hear! Glad you found it helpful.

[@proxdegracia6788]

***** sir gud am, how to make the display in table form

[@LeviMr77]

Holy mother of god! Just what I needed, I built the interbase version instantly as I was watching your video. Respect +++

[@Patmanduu]

Wow. Thanks for that. I WAS using single quotes in the query. Haven't touched the grave accents button in years (since high school French class).

[@thesickbeat]

Thank you for this. I'm not interested in ajax but this definitely helped me out ALOT with my school assignments.

[@violinov]

Your tutorials are f*****g excellent man. Good job!

Thank you! I had a problem, when i watched half of this tutorial i got the explanation!

[@obsdark]

Excelent work But i have a question.., you see, i'm trying to do this with a PDO syntax, but in PDO you can't select the specific table of a db, so, how can i do it to AJAX search in the right table the information what i need? Thanks in advance

[@VigilianceAurelious]

This is what I've really need on my thesis project! Thanks Alex! :D

[@hieronymus1981]

I always end up with a youtube video of this dude. I wonder.... Again cool stuff mate. !

[@22mawdizzle22]

Alex, how would you fire the same type of AJAX to PHP reaction using Google Maps API V3? There is a listener event on a map marker that I can set to do something when the user clicks. So I want to do the exact same thing you did, but from the map. i.e. the user clicks the marker and my javascript sends my PHP the id of the marker clicked.

[@a55a51n2]

followed your tutorial and it works great. how do i make it so that if i select a value from a select element it echoes the value in a text element of a form.?

[@lestevesl]

Still useful after 11 years.

[@amitasthana]

Hey alex, i want to do the same thing, but i dont want to use the submit type button, i want it should give result as soon as i type in the box, maybe on page or a alert box, i know it can be done...., do you have some tutorial to explain this?

[@santunu23]

Excellent tutorial neat and clean.I need a suggestion can i grab the fetch data into a input tag?

[@cvilee]

Hey alex, nice tut but how would you get back multiple records and store them into table perhaps? Yea i know theres a lot of completed grids waiting just to be implemented, but i just wondering is there any way for us to make from scrach complete CRUD grid with jquery and ajax. Thanks alot for everything you've done so far

[@TheMrChugger]

Chorley... What a beautiful part of the world!

[@gabrieletim4418]

How can this be integrated with a select function? Like

[@Joshua_SZ]

The tracking is very cool when executed, what's that? Firefox?

[@pagework60]

Thanks I love all your tutorials.

[@geeksicle314]

The form would always refresh after using $_POST['submit'] in an if statement with the button. Now I see how to do this, because often times, the form submits multiple times and I get like 12 entires of the same information in my SQL Database! Thank you :)

[@sairajdas6692]

Is there any video preceding it? I can't figure out how the code works.

[@this-self]

Hi. In the previous version of this video, you used fadeIn() on the result div. It was pretty cool. How would you implement fadeIn() in your global.js file? Because this line does not work: $('#result').text(data).fadeIn();

[@bawbawsumhpa]

If I set input type="submit" in html page, data from the method $('div#name-data').text(data) just flash a millisecond and disappear. But this is not the case if I set the input type to "button" instead of "submit". But in your video, even though you set the input type to "submit", it seems to be working. Why is it that?

[@shurui91]

what if there is more than one Alex in the database with different locations? what part of the code needs to be changed?

[@DorrellWilson]

I've been watching a lot of your videos, you're an excellent teacher.

[@iSuperDuper]

hi alex , how can i make auto scrolling data from MySQL ? using jQuery

[@Asimov16]

Very good tutorial and I got it to work. Even upgraded it to MYSQLi too, but I have a different problem now. I want to out the values returned into a table with input forms which I have done with $('#partnumber').val(data); but I want to return more than one set of data eg part number and location. I tried two echos $row = $result->fetch_assoc(); echo $row['PartNumber']; echo $row['Location']; but this returns it together. is there any way to return separate data? Hope I am clear

[@renesteneker9751]

Very nice guide. Any suggestions on how to implement such thing in laravel?

[@cyanideneko8795]

Is there a C# version for this you can recommend? 🥺🥺🥺

[@rezefangz]

Is there a way to do this, except with a file, like a .txt or something?

[@manualvarado2212]

Thank you! This wasn't directly what i was attempting to do, but this helped me to understand .ajax and .get/.post. Really really thank you.

[@schumibr1]

Can you make something like a loading image? I mean after I press the grab button a .gif will be displayed until de actual data is shown from the sql?

[@InnovatorAlvin]

the database connection and retrieval don't appear to apply anymore as i received a kinda obselute message. I got it working by using mysqli_connect, mysqli_query, and mysqli_fetch_assoc. I'm on WAMP server.

[@ThaRSGeek]

How can I make it so it keeps checking if there is a new value posted in the db it automatically updates on the page

[@RQCKQN182]

Awesome video! Thank you! Please help me to alter my output so that it is processed. At the moment my output is just: 31John.Smith How do I get it to output a proper row on a table? Does it relate to global.js line 5 at 9:38?

[@Baiev]

Perfect explanation...

[@SuperMegaStyle]

Nice tutorial! Thank youCodesource

[@jinixvomitorium]

This is very helpful! also I am wondering how to transfer a $_GET from an index page to the jquery page that passes it to the PHP file that processes the query.

[@timbodude2009]

Exactly what I was looking for. Thanks

[@venkman_uk]

me too. doesn't work without. also finding that the name.php alert doesn;t work if you've put the inputs inside a form tag.

[@nicoekkart]

Isn't it better if you use submit instead of click. So you can also just press enter.

[@TranceSerbia]

What if you do not want to echo out data in you php file ? Can you still send it back to jquery post method and use it ?

[@karlpokus]

would return (JSON_encoded obj) work as well as echo?

[@yashrajbasan2689]

But how you can get row which is recently added without refreshing the page?

[@MrGeekYass]

is there a Video on how to do the same thing but in Chat System without refreesh using Jquery ?

[@AdikaAlchemist]

is it work with table within it?

[@sebastianrodriguezcastella9528]

How can I do that with a Dropdown select?

[@DomutaMarcel]

An verry good tutorial for an begginer like me. Thanks :)

[@dannyemmerik1556]

Thanks, I can now grab the output of my query and put this in a jquery dialog box. Only my problem is that the entire content that already exists in that div is now replaced with only the query output. Any help?

[@koelekoetjes]

I myself am still learning, but you should be able to use .= if using php or += when using js/jquery to add on to the current content. Please correct me if i am wrong though.

[@joachimsome7228]

Great tutorial, it worked for me. I am a newbie and want to know how we can apply this to a form tag with different labels?

[@neilharveyjaloog9341]

nice tutorial man !. , btw how to get 2 or more variables from database ? ex. i want to display age and location of the name i inputed in textbox . if i have age in database that is.

[@danishjamil7677]

nice tutorial dude... but mysql to mysqli conversion is lil confusing now but yet nice video. keep on pumping out your tutorial contents, very informative and helpful for our career. ;)

[@fahadshinwari6844]

does it support html becoz i am taking pictures from database and want to show the them on frontend but its not happening

[@websachi]

This is very useful video tutorial, thanks so much

[@CantThinkOfNameOmg]

In my name.php file I want to echo Test surrounded with paragraph tags. However, instead of my webpage display "Test" as a paragraph, it displays "Test" with the actual paragraph tags visible next to it. How can I echo "Test", but keep some paragraph tags on it?

[@Spad223]

Amazing tutorial, thank you!

[@CreativeDirektor1982]

Very Good tutorial, very sample tnx!!!

[@georgeowusu7134]

I need help i want to use number to grab all the data on the row

[@Rezzworks]

Is yours not returning what is in the database? That's the problem I am having too.

[@therc23]

Hi Nice tutorial Can you please help me with this? How to create divs automatically and populate them with records from your database

[@graham8377]

Excellent video good job thank you.

[@prashantbedekar5615]

Really good tutorial. But i am having one query and it is related with jquery. In my application, i am displaying users data in tabular format on a web page. One column contains username and other column contains a checkbox with value equals username fetched from mysql database. I have kept username unique. Below the table, i have taken a dropdown combo and one submit button. All this is embedded in a form. Now, depending upon multiple checkbox selection (i.e. multiple users selection) and single dropdown selection, i want to pass all usernames along with selected 'action' in the dropdown. The dropdown values contain Approve, Unapprove and Delete actions. If ''approve' is selected, then all selected users should receive an approval mail. Similarly for 'unapprove' it should happen. Is this functionality possible using jquery and also displaying approval / unapproval messages without refreshing the page.

[@prettyprinted]

+Prashant Bedekar This is possible. You can send over all the users you selected and approve/unapprove to the server and have code there to either approve or unapprove all of them. Then the server could send a response with the users that were successfully approved or unapproved and you could handle that response in jQuery.

[@lukaspfulb3167]

the javascript file is not working when it is in a seperate file...any ideas?? path is correct and its also not working with $(document).ready(function(){

[@HenriqueVanKlaveren]

Very nice. Thanks!

[@Ones_]

Hi alex, what if the database is being update, how can we update the name.php without being refresh?

[@BassemFouad]

You are great, many thanks

[@KingVentas]

Mine was not working and it's because a was using ' ' instead of `` when selecting db and table.

[@talhakhan4608]

its soo use full thanks allot .

[@joshuadelfin7495]

sir can you upload a video... when the user type a keyword it will display automatically searched data into table format

[@memres217]

Great Tutorial

[@sergeyshishkin82]

Hello It is good exsample for begginer Thanks

[@dashing3201]

very good tutorial. thanks

[@Colstonewall]

The only thing I don't get is why use "===" in the if (isset($_POST['name']) === true && empty($_POST['name']) === false) part of the code? If you're just checking a boolean, why use the "===" tripe equals instead of double? Anyone?

[@مقاطعمترجمة-ش8ث]

Fun fact that I'm moving slowly from PHP and web-developing to C/C++ and desktop developing , looks like I wasn't able to make any progress with it , I craving to my old days and my first language I learn C .

[@aziaja]

good point and very realistic :)

[@chriswillier5075]

Excellent Thanks

[@ilinadiakarim9071]

I want to do like this but without button. I create a form. If I insert id from table product in text box, all information from table product will show up automatically in textbox product name, textbox product price. Then I can add more than one product in that form without submit it more than one time.

[@derk6831]

you can use onkeyup or onkeypress....... if you want to do without clicking a button...

[@CageyLastToKnow]

Many thanks for you help, what i wanted to do works now thanks to you :D

[@derk6831]

Simple and awesome tutorial, I have done this similar tutorial using just php and MySQL, I did not include ajax.. Is it secure that way? but the way I don't have lots experience..

[@GhostInTheShell3000]

BRILLIANT! THANKS!

[@christinedaray3190]

what if the data are stored in a postgre database? and you have to return an image?

[@devjobin475]

To return an image you can simply use the location and then reference the location + file name.

[@mitagavit]

Thank you for the tutorial... was a great help

[@vernielariosa9838]

anything for mysqli version?

[@svenbtb]

I know this is an old comment, but for anyone wondering it's the same, you just use mysqli instead of mysql. Mysqli is a good way to learn, but I would recommend learning PDO syntax when you get more comfortable with mysqli and PHP in general.

[@kazzmi175]

www.dropbox.com/sh/mgtpojb33yshxe9/AABUtyw17WQg0e8Sotr6t9FQa?dl=0 I made the same tutorial with mysqli version and can be downloaded from above link. mysqli is bit different.

[@UmairAbbasi1]

that was awesome, cheers mate...

[@xrandomteenx]

GOD i love this guy! He makes the awesome-est tutorials... i've learned a lot from you ALex! :D

[@KimSalimVFX]

how about without a button?

[@soumyadipsaha2952]

you've helped me a lot! Thank you for the awesome tutorial

[@matte4749]

What could the problem be? Warning mysql_num_rows().supplied argument is not a valid MySQL result resource in C:\AppServ\www\mywebsite\ajax ame.phpon line 11 The code is the same as in the video.

[@bluetastic405]

Kitteh fan I had the same issue.What I used for the SELECT-statement was an apostrophe ( ' ). What he is using in the video is called a grave accent ( ` ). It looks very similar, but the apostrophe messes up the query. I hope that solved your problem! :)

[@Nightzo]

+Mathias Buchwalder Thank you for helping me solve my problem!

[@malolatek9083]

Incredible perceptiveness, thanks!

[@cowietan3096]

Appreciate this vid! Very awesome. Can someone explain what I should do if I were to get an image file name from the MySQL table and display the image? Would it be an alteration in global.js : $('div#name-data').text(data); Or should the change happen in name.php?

[@meineroteBlume]

Very nice tutorial! Simply to understand. At the end of your video you post the mysql_result as an echo. Is it possible to post that over an $_POST to the HTML Page? I want to make a slider that always load the value of the database on the start. Sorry if my English is not quite right :) Greetings from Germany

[@22mawdizzle22]

Just for some perspective, let's say I'm rendering 1000 markers that all have 10 pieces of data associated with them. I only want to bring back three pieces of data initially when I render the markers. But when a user clicks, I want to go get the other 7 pieces of data for just that marker.

[@manilakid3]

Great tutorial. Keep it up.

[@KingVentas]

Is it possible to retrieve more than 1 result, i.e. there's more than 1 Alex and I want to show All Alex Locations.?????

[@studentlife4851]

Hi I am a beginner with this and I understand what is being done here but i want to be able to click on the grab button which will then in return give me the information from my database without having to type anything into a text box to receive information from my database .. I'm not sure if you have a tut for it already but yeah hope iv made enough sense

[@AnhKim-sh5ef]

$.post('ajax/name.php',{name: "alex"})

[@IsaacRosarioDurantecnicomp]

How can i show records in html tables without refresh the page when there are new records in the data base? I have a project that gets data from the database but if i go into the project in another computer and insert something on it, i need to reload the page to see the new records in my browser, i want to know how can i make the mysql query with ajax to load the new records without refresh!

[@data-caresystems153]

I have this same issue. I need my dynamic table to be reload when i click the submit button so that it becomes a real time update of data for those users in my organisation who are already viewing the page. I want the updated data to be loaded on the page without the page being refresh. Example, in this tutorial, say if two users are updating the database then one user can see in real-time the updates the other user in inserting. Alex please help us accomplish this. Thanks.

[@PCKlickNetTV]

Thanks man!

[@LeomarOsorio]

Great tutorial. Thanks. :)

[@mauriciorodrigues8296]

Thank you so much !!!!