Admin controlled, user testimonials

[Anon2]

I did a quick two searches, one of this forum and another of the whole site and nothing came up with my keywords. So, I hope this is in the correct place.

I'll cut to the chase: I am creating a website, pretty much freelance with little high-end knowledge, for a business, and it is already in the works. I have everything that my client wants accessibility-wise (not so much design, but that is a different story) and one thing has me stumped on how to go about.

The client I am working for wants a page on their business site to be dedicated to user testimonials, or reviews, comments, what have you. My client wants a submission interface that would send the review, comment, etc. to an administrator accessible area (ideally through a login, I imagine) in which my client can select which review, comment, testimonial will be displayed on the base 'Comments' page. Preferably with check boxes for displaying or taking a review off the page. Ideally, there would be a delete check box as well.

Any suggestions? I spent about two hours researching tutorials on how to do such a thing but came up pretty much empty-handed (save zen cart, of which I did not quite understand the concept).

EDIT: typo

[wmorri]

Hi,

Well for writing a testimonial that isn't hard, just set up a feedback form, and the have it go to another page that is only accessible through a login.

Cheers!

[jamiemac2005]

They way i'd go about it is having a "testemonials" table in your db, with a "status" column, with a numeric code to represent whether the testemonial has been approved(0="pending", 1="approved", 2="declined" or something, you could even just delete the declined testemonials). Since you haven't given a language i can't knock out any code...

Then on your testomonials page have a query that selects all the testemonials which have a status of "1", and echos them on the page, then in your admin side, a form which lists the testemonials with a status of "0", and gives a checkbox or similar to approve/disapprove a testemonial...

It's easily done, it just takes a bit of head work and time.

Cheers,
Jamey

[Anon2]

Originally Posted by jamiemac2005

They way i'd go about it is having a "testemonials" table in your db, with a "status" column, with a numeric code to represent whether the testemonial has been approved(0="pending", 1="approved", 2="declined" or something, you could even just delete the declined testemonials).

Thanks, that number system seems like a sound way work it out.

Originally Posted by jamiemac2005

Since you haven't given a language i can't knock out any code...

As probably suspected, I'm simply using HTML and CSS. Haven't gotten in to much other coding.. yet, anyway.

The primary two problems for me are programming the testimonial submission to send (or keep) the testimonial info on an authorization-required page, and then getting the approved testimonials to display on the 'View User Testimonials' page.

I have plenty of time, and for now I am still working on a few of the other pages but (I imagine wisely so,) I figured I'd best figure some of this problem out first. Any help is appreciated and thank you both for your time.

[jamiemac2005]

You'll need a server-side language(I suggest PHP) to complete this, and a database to go with... Once you've dabbled there it's not too hard to accomplish.

Cheers,
Jamey

[Anon2]

Originally Posted by jamiemac2005

You'll need a server-side language(I suggest PHP) to complete this, and a database to go with... Once you've dabbled there it's not too hard to accomplish.

Cheers,
Jamey

I shall experiment with PHP for a bit and see what I can do. Best I can hope for is once I get to know it a tad, I will think of a way to form the basis of that requirement in the site.

Thanks again, I appreciate the fast response.

[jamiemac2005]

That's k, glad to be of help.

Cheers,
Jamey