3: Get data from a database without refreshing the browser using AJAX - Learn AJAX programming

Get data from a database without refreshing the browser using AJAX - Learn AJAX programming. In this lessons we will learn how to load more comments in a comment field using AJAX, PHP and a database.

--

mmtuts is a YouTube channel that focuses on teaching beginner and advanced courses in various multimedia related skills.
We plan to make tutorials available on programming, video production, animation, graphic design, and on software such as the Adobe Creative Cloud programs.

AJAX for beginners is a how to series that teaches AJAX to people who are just starting out learning programming. The course teaches how AJAX scripting can be made easy and teaches how to create instant loading on your website withour needing to refresh the browser each time, and much more. Creating dynamic websites with AJAX is easy and should not be seen as otherwise, which is why we want to explain the language in a easy to understand way for beginners.

If you have suggestions on new courses, or specific lessons within existing courses you would like to see, then feel welcome to submit them in the comment section or in a private message. ALL suggestions will be seen, but not all will be replied to since we get quite a few every day.

[willmurphy]

Hi mmtuts, is there a way to replace the existing comments with the new comments instead of loading new comments (or in my case an image) onto the existing ones? This would help me immensely on the website I'm creating. Thanks for the tutorials!

[TheGrandmaster]

This dude is like an entire Udemy by himself. He deserves 9 Million Subs.

[connorbeales]

For anyone looking for the SQL query code:

'insert into comments (author, message) value ('Daniel', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent aliquet non orci sit amet rutrum. Vivamus tristique iaculis justo. Curabitur arcu tortor.');
insert into comments (author, message) value ('John', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent aliquet non orci sit amet rutrum. Vivamus tristique iaculis justo. Curabitur arcu tortor.');
insert into comments (author, message) value ('Daniel', 'Justi curabitur arcu tortor.');
insert into comments (author, message) value ('Jane', 'Vivamus tristique iaculis justo. Curabitur arcu tortor.');
insert into comments (author, message) value ('Connor', 'Consectetur adipiscing elit. Praesent aliquet non orci sit amet rutrum. Vivamus tristique iaculis justo. Curabitur arcu tortor.');
insert into comments (author, message) value ('Joe', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent aliquet non orci sit amet rutrum. Vivamus tristique iaculis justo. Curabitur arcu tortor.');'

[matheussd]

Simply perfect. I've always hated js and now it seems easier to understand.

[DaedalusDM]

Excellent video with a very patient explanation that doesn't make the common programming "teaching" error of assuming that the viewer has so much background knowledge that the lesson has no actual value to them.

[vandamieespadero]

You can shows all data from database by one click of a button instead of pressing it for many times, and replacing show more comment button into less comment button after showing all data. Thanks for this video man, it helps.

[turboromy]

Not sure if I watched this before. Ajax seemed not as important or difficult as php, sql, javascript, etc. But then, I found myself not progressing with Ajax for lack of good materials. Good thing that I found you AGAIN. Thank you Daniel.

[kjragg]

Thank you Dan you're an actual life saver, this is exactly what I needed. Being able to pass variables into the AJAX function is so helpful

[DanyV]

I don't even need to learn this right now and I loved the tutorial! Will for sure come back later when I need it! :D
Keep it up

[alirezakhaksar]

The best YouTube channel

Thank you
In Persian
بهترین پیچ یوتیوب
خیلی ممنون

[janvierz]

There's still a way to replace $result = mysql_query with $result= $con->query($sql); I had trouble retrieving data from phpMyadmin by working with the first part but I knew how to do with the second one already! Thanks @mmtus for this tutorial. Very helpful. I've been looking for this way too long

[dr.umeshdutta]

Amazing work! 18 min 48 sec and you get to know so much! Connecting everything together is tricky and Dani explained it so nicely. Respect!

[mvaldesme]

pure gold man, keep doing these kind of tutorials!

[HARUN-AKSU]

The video was very helpful to me. I understood everything even thought I don't speak or understand english very well. Thank you so much.

[basseyotudor]

I don't usually comment or like youtube videos but mmtuts is in my opinion the best channel to learn from. I used to face difficulties in web dev but after following his tutorials. I learn so so much and I now ace every exam in PHP and JavaScript. Please would you mind teaching Laravel?

[batumanav]

You could’ve used limit and offset to load 2 more comments each time instead of gradually increasing the limit and loading all the comments again and again. Great tutorial for creating a perspective for a ajax beginner tho. Thanks!

[ashikurrahmanshad]

Thanks elder brother. I am highly benifitted from this video. For the first time I successfully use the ajax to load mysql table. Keep it up. Best of luck from my side. Sorry for my poor English condition.

[carztendk]

I really needed to understand this, and found this video vey helpful. Thanks a lot :-),

og jeg er behørigt imponeret at din engelske udtale. Well Done

[nhloniphoxaba]

Thank you so much for all the tutorials you've put out !!

[goldorackconceptionwebmark]

thank alot !!!! its well explained. i like the way you explain every move, been on this for days until iv found youre video ! great work !