adambedford Posted March 4, 2009 Share Posted March 4, 2009 I am developing a website and I would like to be able to update the majority of the content from an admin section. I know I will be using PHP and MySql but I'm quite sure how. the website is www.etseuro.com. I would like to be able to edit the home page, the destinations page and the news page. Any help on how to organise the table structure would be greatly appreciated. I also need to know how to get it so that each 'block' of text displays on the right page and in the right module. I am using dreamweaver. Is it also possible to keep the formatting when storing the info in MySql, maybe with Fckeditor or something? Thanks Adam Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/ Share on other sites More sharing options...
adambedford Posted March 4, 2009 Author Share Posted March 4, 2009 Please. Any help would be greatly appreciated Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776279 Share on other sites More sharing options...
Boo-urns Posted March 4, 2009 Share Posted March 4, 2009 Are all the pages just static at the moment? I would create a table describing what you're editing. So from first glance here is how I would set it up. (with just field names for now) id | page | section | sectionTitle | description | viewable page = what page you're on 'homepage' sectionTitle = 'who we are' etc... description = your text viewable = you can flag on or off the section if you want that functionality. It is possible to keep the formatting the same either if you know how to already put it together, something like fckeditor, or what is very easy to setup is textile. I hope that helps you out. Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776369 Share on other sites More sharing options...
adambedford Posted March 4, 2009 Author Share Posted March 4, 2009 hi thank you very much!! the pages are all static at the moment yes. i have a similar table structure in place (but without the viewable option) so good to know I am on the right track! with the information in the table, how would i assign a row to a page? and then a row to a module? could I also get it to work with the images? and if there isnt an image assigned to that module, have it show up looking good anyway? I know I'm asking really basic questions, but thanks for the help! Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776401 Share on other sites More sharing options...
Boo-urns Posted March 4, 2009 Share Posted March 4, 2009 how would i assign a row to a page? I wouldn't necessarily sign a specific row to a page as you might change it delete it etc in the future. That is where the 'page' field comes in hand so you would sort via that page. ("WHERE page='home'") You can setup the page field as the same name as the end of your URL with $_SERVER['PHP_SELF'] or you can do it manually on the page. (ie. 'home') and then a row to a module? Are you already using a templating system or a cms already setup? could I also get it to work with the images? and if there isnt an image assigned to that module, have it show up looking good anyway? Yup, of course you can get it setup with the images as well. There are a few ways to do that as well. If you don't have more than say 2 images I would put it in the same table. (image1 | image2) Then if you don't have a picture but there is always a space for it i would create a div for the image section and a div for the text section. Or you can just put the image on the page and float it with some padding so your text will wrap. Hope that helps some more! Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776431 Share on other sites More sharing options...
cooldude832 Posted March 4, 2009 Share Posted March 4, 2009 Would you like a copy of my very basic framework in php/mysql to look at? Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776579 Share on other sites More sharing options...
adambedford Posted March 4, 2009 Author Share Posted March 4, 2009 Yes please! That would be very helpful Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776580 Share on other sites More sharing options...
cooldude832 Posted March 4, 2009 Share Posted March 4, 2009 Send me a PM its on my desktop at home Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776581 Share on other sites More sharing options...
adambedford Posted March 4, 2009 Author Share Posted March 4, 2009 PM'd. Thanks. Link to comment https://forums.phpfreaks.com/topic/147901-cms-type-website-php-mysql/#findComment-776594 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.