  |
Results from the most recent live auction are here.
20 members in the live chat room. Join Chat!
| | 
04-16-2006, 12:16 PM
|
· #1 | | Steven Name: Steven Gibbons Location: United Kindom Join Date: Aug 2005
Posts: 1,506
NP$: 40.00 ( Donate)
| Rate My. . .
Hi,
I was wondering how i can make myself a script that put all the image in a database, then on the homepage it displays a random one, and people can rate it and it shows its rating.
What would it consist of and what would be some coding?
Cheers,
Steven
| 
|  | |
04-17-2006, 08:29 AM
|
· #2 | | NamePros Member | Easiest way to do it would be assigning to every picture an unique ID. Perhaps a growing number. Then all you have to do th get a random picture is get a random number from 1 to $number_of_pictures_you_have and pull 1 row from database with that specific images data (url, desc, previous ratings, size, etc) | |
| | |
04-17-2006, 12:04 PM
|
· #3 | | Senior Member Name: Thomas White Location: England Join Date: Sep 2005
Posts: 1,033
NP$: 31.15 ( Donate)
| Perhaps this will help: Code:
<?php
require_once ('connect.php');
$query = "SELECT ImageID FROM Images";
$result = @mysql_query ($query);
$num = mysql_num_rows ($result);
$id = rand(1,$num);
// So basically you see how many records there are in the database, then generate a random number between 1 and that many records
$query2 = "SELECT ImageID, Whatever, SomethingElse FROM Images WHERE ImageID='".$id."' ";
$result2 = @mysql_query ($query2);
?>
Hope that was useful to you.  | |
| | |
04-17-2006, 12:18 PM
|
· #4 | | NamePros Staff Name: Peter Location: Scotland Join Date: Nov 2003
Posts: 4,337
NP$: 2039.40 ( Donate)
| it is best not to upload images to the database, although databases can handle this type of data is not the best way to do it.
You could upload them into a folder and upload the filename of the image to the database then when selecting the image use the mysql RAND() function to select the image and put the url for the image into the img src tag when outputting. | |
| | |
04-17-2006, 12:23 PM
|
· #5 | | Steven Name: Steven Gibbons Location: United Kindom Join Date: Aug 2005
Posts: 1,506
NP$: 40.00 ( Donate)
| how then would the rating system work for each image? | |
| | |
04-17-2006, 01:08 PM
|
· #6 | | Senior Member Name: Thomas White Location: England Join Date: Sep 2005
Posts: 1,033
NP$: 31.15 ( Donate)
| Add 2 more fields: RatingTotal and RatingCount.
Use a <SELECT> box and make the selections 1-5 star, or whatever. Add this number to the RatingTotal, then add 1 to the RatingCount. The average would then obviously be RatingTotal / RatingCount. | |
| | |
04-17-2006, 01:42 PM
|
· #7 | | NamePros Staff Name: Peter Location: Scotland Join Date: Nov 2003
Posts: 4,337
NP$: 2039.40 ( Donate)
| or have another table that holds what people have rated the image along with the image id. Then to find the rating simply extract the sum of all the fields that are for that image and divide by the total amount of people who rated it.
Doing it this way would enable you to keep track of who has rated the images already (have another field with their username (if they have 1) or some other distinguishing mark such as an ip address (not fool proof but good enough for what you need). This would get around the majority of people who will try and up the rating of the image by continuously giving it a maximum rating. | |
| | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off | | | |
