Category: MySQL
-
Email Verification on User Registration In PHP
Hello guys, this post is about email verification system for new user registration. You would have seen 99.9% of websites and web applications want you to verify your email upon registration. Only users with verified email id’s will be able to login. Its really very important to verify email id’s before any user can login…
-
Dynamically Add Input Fields And Submit To Database With jQuery and PHP
Previously I wrote about adding dynamic input fields in a webpage using jQuery, I got a lot of queries on how to submit it to database. This tutorial is all about generating input fields on the fly in a web page and submitting the entered data into database. For this tutorial let’s assume you have…
-
Easily Export Data From MySQL to CSV File
We have already written about “importing a CSV file to MySQL“, I thought about writing a script to export data from MySQL to CSV file. Its really important for websites to generate reports and this script can be used to do the same. Many e-commerce websites, business directory websites, classified websites and other business websites…
-
Easily Import CSV File Data Into Mysql Using PHP
Many times you will need to import data from a CSV (comma separated value) file and insert it into your MySQL database. Consider a case when you have many records in a CSV file and you need to import them into your MySQL database then you can not insert each single record manually as it…
-
Schedule SQL Query Using phpMyAdmin- MySQL Events
I came across one problem when I was creating tutorials. The problem was how to delete records from database tables AUTOMATICALLY? Now you would be thinking why I had to do this? When I created LIVE DEMO of Inserting records into table using jQuery & PHP I felt that after some time my database would…