Hi,
I hope anyone can help me with my problem.
My problem is that need a function based on Mysql and PHP that can do the following,
First I need a (web based) admin interface there I can do a input for a subject, a picture and a short text (about 2 lines) into the database.
Then I need a page that shows all subjects from the DB in a list, there every subject is linked to a new page that shows the whole thing (the subject, picture & the short text)
Is there anyone that has done this or know where I can find anything like this, i would be really happy to share that. I am a totally newbie at mysql and php, so I really need help the whole way.
Thanks
List of objects that can be administrated by a "webmodu
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
This type of thing is done all the time - if you don't want to write it yourself hotscripts.com might have something like it. If you want to do it yourself it shouldn't be too difficult though.
I'd start with some MySQL and PHP tutorials: Once you're able to INSERT into a database and SELECT out of it then you can worry about the file uploading bit.
A few notes:
I'd start with some MySQL and PHP tutorials: Once you're able to INSERT into a database and SELECT out of it then you can worry about the file uploading bit.
A few notes:
- It's probably best not to save the picture in the database, instead save the path that you will use to link to it.
- Make sure that there is a column in your database which contains something like a unique auto-incrementing integer, that way when you want to construct the links from your subject page you can use this to identify each entry in the database.
- Do a bit at a time of your project, don't try and do the whole lot in one go break it down and you'll find it a lot less frustrating than if it's too complicated too soon.