I am going to go crazy!

Anon

I am new to php kinda..

I am going to go crazy if i dont figure this out!

I am wanting to create an web admin interface for adding music album reviews.

I want to have several input fields to control:

-album being reviews
-reviewer
-date
-actual review
-etc

I don't know how to do this. I want one template type file for the reviews and then the content for each review. I also would like to be able to add reviews/delete/modify review in the admin panel

Can someone please help me? I know this is kinda a big task.. but if you can take a moment to help me I am most greatful!! I just need to get started on the right path.

if anyone knows any articles online that would help i would be greatful as well.. i already read the ones on this site.

pleaseeeee...

edwardsbc

So exactly what is it you don't know how to do? Create HTML forms? Design the underlying database? Develop access control? Do any of these thing with PHP?

I'm afraid your request isn't specific enough to generate many responses.

Anon

Seems like you would need one table with the albums that is related to the reviews table.

When you create the query to show the album, make a join and pull the reviews from the reviews table.

When a user wants to add a review, you insert it into the table with a parent id value that relates to the id number of the album being reviewed.

Basically all you need is to have a query create a list of albums. When the user clicks an album to review, pass along the album's id number for use in the review table's insert.

geoffs

this is the kind of project that while not to hard to complete will give you a very good overview of PHP and mysql. I will not include any code here, but I will break it down into steps.

Create the databases. I am not sure how you have this idea layed out but you probably will need two tables. One for the album (albumid, albumname, and other album info) and a review table (reviewid, albumid, reviewer, rating, date, review).
You will need to have some security so that you can control who posts/edits reviews...create some kind of login script. This will also allow you to take care of the fields Reviewer and Date of Review automatically.
After logging in you can give the user some options, lets say add or edit a review.
3.1 Add, A couple text boxes and a submit button...here the user would have to also select whether they are reviewing a new album, or an album already in the albums database. If the album is new then we need to also add album data to albums database.

3.2 Edit, Here we would have a list of currently databased album reviews.From here it would be almost identical code to that of the add option.

Both the add and edit can use the same submital code...

If you like, you can go out and find a news script and modify it to suit your needs...it will offer the same base functionality you would just have to change minor details...hope this helps

Anon

Well..

These have been helpful posts.

Let me explain more detailed. I don't really know how to code it because I am a newbie to php.

So far I was thinking of including a header a footer in the file.

In between that I would also include a file but it would have to be:

include($id".inc"); //i think thats how its done

but i dont understand how.. when i input the info in the forms that it will create the id number.

I was thinking since I had an id variable I could then link to it like..

http://site.com/reviews.php?id=0003

and then it would show me review number 0003. Now the problem is.. I don't know how to make this work exactly. I want ot be able to be able to have multple inputs in the admin form to control the artist, album name, date, reviewer, etc.

I was told that the explode function would do this but I just dont know how to make it work.. If someone could give me a sample code.. That would be great.

thanks for your replys.

Term

Anon

Still need help please.