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.
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. ;)
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 :)
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?
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?
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
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?
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
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();
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.
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.?
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
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.
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..
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
This is a great video; watched it last week! Right now I'm trying to find how to populate a jstree with data from my MySQL database maybe using JSON (or maybe not) but Google has brought me back here! Does anyone know a video that will help me with what I want?
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 .
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?
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.
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.
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.
sir pls help, how to add another display aside location, i have table in my database named position and i want to display it in my page.thank you pls answer
Great job. I wasn't able to get my JQUERY to work unless I started it off with $(document).ready(function(){ $('input#name-submit').on('click', function() {
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.
I love that you start off your tuts with the result. Should really be a best practise. Kudos!
Holy mother of god! Just what I needed, I built the interbase version instantly as I was watching your video. Respect +++
Thank you! I had a problem, when i watched half of this tutorial i got the explanation!
Very nice, no excess information and I understood it even though I've never done any php, thank you.
That's great to hear! Glad you found it helpful.
***** sir gud am, how to make the display in table form
This is what I've really need on my thesis project! Thanks Alex! :D
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.
you've helped me a lot! Thank you for the awesome tutorial
Exactly what I was looking for. Thanks
Your tutorials are f*****g excellent man. Good job!
I've been watching a lot of your videos, you're an excellent teacher.
Thanks I love all your tutorials.
This is really great thank you.
GOD i love this guy! He makes the awesome-est tutorials... i've learned a lot from you ALex! :D
Thank you for this. I'm not interested in ajax but this definitely helped me out ALOT with my school assignments.
Nice tutorial! Thank youCodesource
Thank you for the tutorial... was a great help
thanks for the tutorial, it's work 100%
Amazing tutorial, thank you!
thank you, you helped me sort things out a lot. !! ill sub and like
You are great, many thanks
Many thanks for you help, what i wanted to do works now thanks to you :D
Very nice. Thanks!
BRILLIANT! THANKS!
Excellent video good job thank you.
Amazing titorial, I love it.... Keep it up
that was awesome, cheers mate...
I always end up with a youtube video of this dude. I wonder.... Again cool stuff mate. !
Perfect explanation...
Great tutorial. Thanks. :)
This is very useful video tutorial, thanks so much
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. ;)
Thanks man!
Thank you alex
Very Good tutorial, very sample tnx!!!
its soo use full thanks allot .
good point and very realistic :)
Great tutorial. Keep it up.
Excellent Thanks
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).
Thank you so much !!!!
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 :)
Awesome tutorial.
Alimon Pito Thanks!
Thank You!
An verry good tutorial for an begginer like me. Thanks :)
Thank's very usefull ! best regards !
Great Tutorial
Thanks, it helped me to do something at my work xD
Excellent tutorial neat and clean.I need a suggestion can i grab the fetch data into a input tag?
very good tutorial. thanks
Хороший урок, очень помогли. Спасибо!
Chorley... What a beautiful part of the world!
thank you to much
Still useful after 11 years.
Thank you sir
Thanks.
Its done thanx a lot :D :D :D
nice1 good job
Awesome
Hello
It is good exsample for begginer
Thanks
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?
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?
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?
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
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?
Is there any video preceding it? I can't figure out how the code works.
thx :-)
Very nice guide. Any suggestions on how to implement such thing in laravel?
Cheers I use mysqli instead but still worked sort of
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
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();
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.
Yes you could
The tracking is very cool when executed, what's that? Firefox?
Update with use of PDO. mysql/mysqli are obsolete. Otherwise, great tutorial.
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.?
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
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.
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..
How can this be integrated with a select function? Like
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
i like that
hi this is alex from phpacademy
This is a great video; watched it last week! Right now I'm trying to find how to populate a jstree with data from my MySQL database maybe using JSON (or maybe not) but Google has brought me back here! Does anyone know a video that will help me with what I want?
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 .
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?
what if there is more than one Alex in the database with different locations? what part of the code needs to be changed?
Hi
Nice tutorial
Can you please help me with this? How to create divs automatically and populate them with records from your database
would return (JSON_encoded obj) work as well as echo?
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 ?
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.
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.
you can use onkeyup or onkeypress....... if you want to do without clicking a button...
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.
sir can you upload a video... when the user type a keyword it will display automatically searched data into table format
Is there a C# version for this you can recommend? 🥺🥺🥺
is there a Video on how to do the same thing but in Chat System without refreesh using Jquery ?
sir pls help, how to add another display aside location, i have table in my database named position and i want to display it in my page.thank you pls answer
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?
Great job. I wasn't able to get my JQUERY to work unless I started it off with
$(document).ready(function(){
$('input#name-submit').on('click', function() {
Savior! Thank you. :D
i thought it was weird that he ommitted that. Yeah, ANY JQuery code should be wrapped in $(document).ready(function() { //code here });
Unfortunately AJAX+PHP is NOT working, when we use PHP classes :(
Why not?