Это видео недоступно.
Сожалеем об этом.
Insert Data Into MySQL Database using jQuery + AJAX + PHP
HTML-код
- Опубликовано: 12 авг 2024
- technotip.com/2208/insert-data...
Insert Data Into Database Without Refreshing Webpage..
Video tutorial illustrates insertion of data into MySQL database using jQuery and PHP, using AJAX method i.e., $.post() method
jQuery Video Tutorial List:
technotip.com/2514/jquery-tuto...
![Megan Thee Stallion - Mamushi (feat. Yuki Chiba) [Official Video]](http://i.ytimg.com/vi/OdxSbc0ap-s/mqdefault.jpg)
The last time I watched this video is when I was still doing my thesis 4th year college of BSIT here in the Philippines. That was 2014, I graduated in March 2015. Wow, I'm feeling all the struggles I got back then while watching this video again. Thank you, Satish :)
Feeling so happy for your progress bro. Praying for more successful years to you ..
Excellent video. I'm self-taught in PHP, Javascript, HTML5, Coldfusion and CSS. Now I'm tackling AJAX. Until this video, I did not fully understand the simplicity. Straight to the point and thank you for not spending wasted time on theory. Perfect. One thing that would make it better for me is to provide a place to download the code for copy and paste reasons.
You break this down so well! Thank you! I will be checking more of your videos!
Even though this is quite an old video, it is still valid and is crystal clear and easy to follow. Thank you
Thanks a lot for your good words Sir ..means a lot to me.
This video is very good :) , a strong hug from Brazil...
strong hug back from India :)
Thank you for this very good presentation. Followed your steps and it all went smooth. Big thumbs up !
Glad to know that it helped 👍
Superb. It's answered some questions I had regarding the backend website I want to build.
Awesome video Satish. Clear and to the point.
It's a JavaScript library you can download from jQuery.com website.
Please follow the tutorials in its order and you'll not be confused.
For the list of tutorial order, please visit the link present in the description section of above video or visit our site and browse through jQuery category.
Hope that helps ..
There maybe many ways of doing this ..but what I've done with the video above perfectly works and there is no redundant code in it. And the logic is optimized to work in minimum time.
Nice tutorial ...post method of Ajax is really great
Thank u for this video ..........your way is very easy to understand ............
But the same time .......I want this with validation like email , phone number and name types(only character, only numbers n all) validation .........needed ........
your way is very easy to understand ............
nice video. It took a little while to get going, but really nice demonstration. Thanks for sharing. Matt, California.
You make the world easier to live,...
thanks man, this helped a lot.
hint for today (january 2018): output complains about: mysql_query is deprecated.
I made some changes and it worked for me.
the connection to db:
$conn = new mysqli('localhost', 'root', 'your_pw', 'your_database');
and the insert query:
$conn->query("INSERT INTO table_name VALUES('whatever', 'values', 'you', 'got')");
never mind, I don't know what happened, but it's working correctly now. thanks
Thank you very much Satish. Excelent Tutorial
Thank you so much! This helped me a lot to understand .get/.post and .ajax.
I like your video. keep on the good work
Very helpful, thanks Satish.
And I am also applied it in my modal! You are my life saver! hahaha cheers man! :D
This was very helpful! Thanks a lot!
he does this really quickly, but you can see there isn’t much html - he’s just utilizing an html webpage that references a couple of PHP files and a js file. he writes to the db through what looks like he’s preventing sql injection methods but it’s all so compact. i think i’m gonna try to set something up like this. I’m be very curious to understand if there are security protocols that are missing from this. i mean it’s missing the SSL which would be necessary for our application, but i’m still not clear on how all of that ties together.
sir Above video is very simple to understand.m in new php and will you please upload the video for simple carrier form including captcha and basic detail of the user.
Thnx
Sandhya Vishwakarma I've this video tutorial published on my blog Technotip.com I've done it using Node.js and MongoDB. If you're still in the initial stages of learning php, then I would recommend you to shift to Node.js MongoDB
thks you bro for this video is simple , undestandeble and I invite you to come in morroco
Very helpful video, thanks man... 🙏
Glad it was helpful!
Panie Hindus, jesteś piękny i dziękuje ślicznie.
It's all amazing tutorial I like very much thankss alot.
Thank you Satish
Make sure, that jQuery is installed correctly. Else, read the code again and tell yourself, what every function does. If there's something wrong, you'll get that with this method (that often helps me)
man you'r my legend :)
this is excellent video
I am working on a small example where I use reservation system..Basically user picks a date and time and submits the form..The picked slot turns red onclick but the page refreshes after I submit the form and the slot goes back to green..I figured out that I need to use ajax calls to prevent a page refresh..Every time I log into the page the booked slots should be red.I am using jquery, php, mysql db..I am new to ajax and hoping to get some help from you.A video tutorial would be great. thanks :)
Brilliant, just what I needed!
Your teaching skills are very good can you make videos on java platform.
thanks your brother from Algeria.......
Thanks for the tut, can you please show us how to multiple rows insert into database table? E.g. Row1 (id, name, age, job title, wage, date_joined) Row2 or Row3 with different data and ID is auto increment? With one submit button?
Everything works great, however if I include an id with Auto Increment as a third column say, which is extremely important, it does not work. How to you include id without inserting an actual id in the database
do you know how to insert data inside input forms in html on "website" not in code, and when inserted it remains there... : / i can't find it anywhere
Thank you for useful knowledge
nice vedio, i will like to know how to validate the fields before inserting data, thanks
Thank you so much brother!
tictac Guys yes man. Perfectly working.
tictac Guys all i can say is to try again. Since it actually woked for me the exact same way. It's difficult to find errors so just try again with a new file
What a nice video, man.
Instead of name and age I want to send html table td elements using ajax call...I hope you get my point..Thanks for reply
You rock Satish !
Thank you sir ... . . . .
hi thanks ofr good video
i need your help
i have two dropdown and i want to change data of the second dropdown based on the values selected in first dropdown .
(NOTE:- Values are retrived form the database and i want to use ajax and jquery )
any suggestion ?
Out of curiosity is there a way to get the data from the text fields onto a database but instead of manually inputting the text, the text is automatically entered there via a dropdown option?
Like lets say I'm doing an escaperoom business and the customer can use a dropdown to choose what room they like to book, when they choose a room then text boxes will fill up displaying the info for that room.
I've used an ajax to do the functionality of filling the text boxes with that specific information and for calculating total price and what not yet for some reason, my code will not accept the input and won't insert the data onto a table, it literally considers the text boxes as empty despite otherwise. How would I go about it so that the program checks if there is anything inside the text boxes and gather the info from there to output as data in the dbtable?
Hi! Satish you video is good. I just got some questions.could i use serialize() instead of serializeArray?
superb tutorial satis. keep it up. please upload it with hindi langauge also, because i don't well know english. Thanks again.
many thanks sir gggggg
Thank you very mach
I am not getting the values of the text boxes inserted into the user table. I am getting the names of the variables. For example: instead of John, 30 inserted into the DB, I am getting $name, 0 inserted into the DB user table. How do I get the values, not the variables? My code in the userInfo.php is exactly like yours and I am getting the "successfully inserted" message. Thanks!
very nice prasentation .
Good tutorial! I hope this will work to my project! :)
Thank you for this video, now how to uplad text and an or more ?? Using this code
valeu ajudou bastante!!! obrigado
i am working on sending form data as a single JSON string in database and get it back that data in my html form.. so any idea...
omg. thank you..
You're welcome 👍
Hey got it all figured out and is working great. One more thing though- Is there a way to have the result message from php as an .alert? Rather than a div. Thanks man- You rock! Going to watch some more of your videos :)
hey can you make a link on your lectures to show how to retrieve the data that is saved? I cant find your other link or find it in order
This was a great video. You explained everything great. Only problem is my jquery dosent seem to call the .js page. PHP and form inputs work though. It just keeps loading the php file from form action. Been dealing with this all week. Its completely frustrating! Thanks for the tut though. It does help me out alot-
hi dude you seems to be with lot of patience and helpful iam a school teacher there is software called Dredge school administrations system you can find it in sourceforg
please help how to make it work i tried intslling wamp and all but didnt get it.
iam a novice lol
Awesome tut, thanks a lot :)
halo nice tutor but why I can not getting index of my value after I put return false line, and when I delete those line i will get my value but my page direct to my php file
great tut.
thank you so much
Is there a way in jquery to put a condition to 'do nothing' if there is nothing entered in the feilds? or would we have to make that a php condition?
Good, I understood when mute speakers,
It works❤
I liked your channel
Sir where you are from?
i followed your guide except that you used external javascript file but i wrote the javascript code as internal javascript file between head tags... now i seem to get undefined index error on clicking the button
[update the issue seems to be resolved .. just had to remove input from formname:input in js]
also i am trying now to extract data from table in the same manner... the table gets extracted but is being shown on a new page. any suggestions ?
If the PHP returns json encoded data how we can get data ...? can u give me a example ..?
simple and understandable. TQ :)
thanks a lot for the feedback ..
Hi it was awesome! just would you tell me how to add preloader to your code .
great tut i would like to know how to use php vars like a logged in username session instead of a user input and also a php var for if a user is vieing a friends profile page so i would like to know how to send 2 vars to a parser without refresh it is for a poke application i am making can you do a tut on this please?
I am using html table elements for picking slots..td elements..
I don't know how to pass a table element in ajax request call
i'm adding a new data into my database and it will show in my website but before my data show in my website i need to refresh it..what is the problem?? plz help..
fantastic stuff - keep it coming!
really great tutorial thanx,but i didn't find the next tutorial display inserted data ,pleas post to me it links.. :)
uhmm.. i just want to ask something
what are post folder and script folder for? im all new to this....
Thanks for this tutorial, When we complete entering data can you tell me how can make Page Query for Data ? I mean how can make page search .
Thanks
My php file is opening wihtin the same window as the html file but it does nto return to the HTML code
Hi Satish Sir,
I have created a dynamic table by using JQuery and HTML now I want to fetch the data from each row of dynamic table but the dynamic table is created all row with the same name so How to fetch the value in php file?
great tutorial man!
Put button to ,
type=submit 👌
Another has default submit
.
Nice tutorial!
Thank you so much this video helped me so much thank you I subbed and liked xD
thanks for the tutorial. but i have a problem when using the method. i can't echo out the values typed in the text field. can you help me?
Muchas gracias!
I don't unstand how to *.php file is started, doesn't your form require a action when pressing submit? How does your *.php script know when to start?
Can i use this to make a chat system? I'm trying to make a chat without using interval to refresh a specific part of the page..
Could you please remake this tutorial using mysqli or PDO? You are easy to follow along with and do a good job, but mysql is deprecated.
When I press submit button, the form insert the values into my datebase, but my page goes to the php file and it doesn't stay in the index file without refreshing the full page, what's going wrong?
can I use this with my bootstrap modal?
coz I use bootstrap modal with my registration form
pls reply thanks great tut very informative tutorial though!
in sourceforge education section on page number five you can get it please help me
Wow coming from MVC 5. Learning PHP is a slep.
But great tutorial none the less.
Very helpful Satish, thank you very much !
Quick question which program would you recommend
Codelobster or Dreamweaver