0

I am planning to start a site in which the content is generated by the users. What is the best method to save the data submitted by user?

Is the method of saving the data in phpmyadmin database a good idea considering that the data submitted by users is large similar to a blog post. Btw I'm good in working with php and mysql but I'm not sure whether it is a good method.

Rocky
  • 1
  • 1
    Welcome to SO. This is impossible to answer with the level of detail you're giving. What format will the content be in? What kind of data are you expecting? – Pekka Apr 22 '10 at 18:57
  • Are you asking how to save something in a MySQL database? I don't understand what phpMyAdmin has to do with this. – Brendan Long Apr 22 '10 at 18:57
  • Probably related: http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay – Pekka Apr 22 '10 at 18:57

2 Answers2

1

By 'phpmyadmin' database I assume you just mean a MySQL database.

Since your user data is basically a 'blog post' - basic text and HTML, and you'll most likely be storing username, posting dates, titles, and the like as well -- a MySQL database is a fine place to store it.

If you're using standard shared hosting, your options are pretty much a relational database (MySQL) or a flat file. Between those two choices, a relational database is the better option.

Tim Lytle
  • 17,549
  • 10
  • 60
  • 91
0

Not sure just what you're asking here - If you're thinking of actually trying to save a .jpg file and text as blobs physically stored in the database, don't. Not if you intend to have a lot of users all uploading stuff. Look into saving it on your server in a folder for the user or better yet to the cloud - it'll be cheaper in the long run and save you tons of anguish with a corrupt database.

Edd Twilbeck
  • 101
  • 5