jbingman Posted September 22, 2007 Share Posted September 22, 2007 Hey, im trying to do a myspace kind of idea with updating content on a page. where it displays what you have currently and you can edit that content and save it back to the file. Should i be using a mysql database? or is using just a .txt file ok? and how would i go about doing either way? Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted September 22, 2007 Share Posted September 22, 2007 Use mysql, not a flat file. Telling you how to do it is too much for this board. Quote Link to comment Share on other sites More sharing options...
rarebit Posted September 22, 2007 Share Posted September 22, 2007 The sum of many little parts is the whole it is! Quote Link to comment Share on other sites More sharing options...
jbingman Posted September 22, 2007 Author Share Posted September 22, 2007 so is there anywhere you can refer me to learn how to do this? Quote Link to comment Share on other sites More sharing options...
rarebit Posted September 22, 2007 Share Posted September 22, 2007 it depends where you want to start, you'll need a login system with sessions, profile pages, posting pages, upload pages, etc, the list is endless. Yes use mysql to store stuff, designing the db is another issue. What have you already got and what is your next move... Your original question is too broad, if I was to answer honestly i'd say go and get a CMS system such as Drupal or Joomla, but if your like me, you want to design and write your own, then you've got to break it down into small parts and tackle each one progressively... Ask q's, but a bit more specific! Quote Link to comment Share on other sites More sharing options...
jbingman Posted September 22, 2007 Author Share Posted September 22, 2007 Well right now i have a login system and a profile sort of page. This site only has one or 2 login accounts that i set up myself its more of an admin page for the website. So they can edit content thats on the website. www.fresnosar.com. They should be able to edit all the content on this site through the admin area. I guess what i need to start out with then is setting up the database to allow it to hold all that information. Quote Link to comment Share on other sites More sharing options...
rarebit Posted September 22, 2007 Share Posted September 22, 2007 A big topic if your new to it all, you'll find a couple of tutorials here: http://www.phpfreaks.com/forums/index.php/board,41.0.html This is the main mysql manual: http://dev.mysql.com/doc/refman/5.0/en/index.html Here's the php mysql manual pages: http://uk3.php.net/manual/en/ref.mysql.php And here's a google link to some more tutorials... http://www.google.co.uk/search?hl=en&q=php+mysql+tutorial&btnG=Search&meta= Sorry it's a lot and not too specific but all those ref's will come in handy... Basically you'll need to CREATE a table, then you'll want to connect using a username, password and host, and then select an actual database, after that you'll probably use a SELECT query to get info from a table within the database, which you'll print out using php into html... oooh it's sounds fun... after a while it'll be second nature, no probs... any probs, check back! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.