Creating Add. Edit, Delete panel

Jon12345

I need a simple php script to populate a MySQL database. Go to the following link for a demo:

http://always-accepted.co.uk/demo.htm

There will be 6 fields, 5 which require 100 characters space, the 6th field will contain a complete page of text that might be 800 words or so.

So, I see there will be an Add Topic page, Edit Topic page and a Delete function.

The fields are:

Topic
MetaTitle
MetaDesc
ArticleTitle
ArticleBody
ArticleAdvert

Is there a script like this already out there? It seems like a pretty simple job to me but I'm only a rank beginner in php so what do I know! Surely this must be a really common thing?

Thanks,

Jon

thorpe

yeah its a common requirement, just depends if you want to learn to write php, or just have something handed to you.

if you want to learn, go to the manual, and read up on the mysql functions.

otherwise, try somewhere like www.hotscripts.com. though most anything you'd find over there would need customising to suite your needs. might be just as easy to learn the basics.

bradgrafelman

I myself would highly recommend learning PHP. It's so versatile and (relatively) simple, you're just plain better off doing so.

Do you already have your MySQL table structure set up the way you want it? If so, I can help you get started.

Jon12345

That is very kind of you! Yes, structure is set up. It is only 1 table. I've learned how to add a record into the database. That is not a problem. But to delete or edit and to show in a list like in my demo, that is a whole new ballgame!

bradgrafelman

Well, for both the edit and delete pages, you're going to need some kind of a system to list all of the current articles to allow the user to select which one they want to edit/delete.

Do do this, you would probably do something like:

$query = mysql_query("SELECT MetaTitle FROM MyTable");
while($result = mysql_fetch_assoc($query)) {
  echo "$MetaTitle - Edit | Delete";
}

or something similar. Do you know how to set this up to list all of your articles, or have you already done this?