Tag: MySQL
-
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…
-
Delete Records From Database Using jQuery
Hello guys, if you have seen my older posts then you already know how to insert record in database using jQuery. I also explained the process to fetch record from database using jQuery. The left part is how to delete the records in a database using jQuery. I am dedicating this post to tell you…
-
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…
-
Fetch Record From Database using jQuery and PHP
You have seen how we can Insert record into database using jQuery. It really reduces the amount of data transferred to server and saves page loading time. Today I will show you how you can fetch data from database using jQuery and PHP and display the data in your page. Check LIVE DEMO here. Note:…
-
Insert Record In Database Using jQuery And PHP
I have already posted about inserting any record in database using PHP in my “Registration Page Using PHP” Tutorial. It’s good to insert data using PHP but its better if you add little jQuery in your Code, it makes the whole process faster and the load on your webpage decreases. Check LIVE DEMO Today I…