Is it possible to update data in database automatically

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
crazyboy23052005
Forum Newbie
Posts: 1
Joined: Sat May 09, 2009 11:47 am

Is it possible to update data in database automatically

Post by crazyboy23052005 »

Hi,

I am working on a project of website development which uses a mysql database as back end and php as a front end language. I have to maintain and update the database entries all the time when i add some content. and after that the updated content is displayed on my website. each time i have to do this manual work.

so, i want to know that if it is possible to update the entries in the database automatically when i need to add any content. for example there is a folder which contains data whose entries are in the database, when i need to add some data in the database, i just add the content in that folder and the details are automatically updated in the database. and from there these details are displayed on the site without any manual entries of individual data in the database.

so please let me know if there is any code possible for this purpose. And if it is can you provide me the example of the code.

Thank you,
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: Is it possible to update data in database automatically

Post by Mark Baker »

crazyboy23052005 wrote:so, i want to know that if it is possible to update the entries in the database automatically when i need to add any content. for example there is a folder which contains data whose entries are in the database, when i need to add some data in the database, i just add the content in that folder and the details are automatically updated in the database. and from there these details are displayed on the site without any manual entries of individual data in the database.
Basically the answer is no. Databases aren't simple text files that can be edited directly. It is possible with some databases, but you're more likely to corrupt your data by editing the files directly.
That's the whole point of the SQL Insert, Update and Delete statements, to maintain the data in the database. Front-end tools like phpMyAdmin for MySQL or TOAD for Oracle provide a useful and simple front-end that allows you to maintain data directly by generating and executing the Insert/Update/Delete statements for you.
Most applications provide dedicated tools allowing you to modify the data in their database.
Post Reply