HTML Forum

**Pinkasaurus** · 07-08-2005, 09:50 AM

I wanted to know how I could create something like the bellow so that my users could rate pictures and add comments? I searched around for a bit but couldnt find anything of any help. I knew that someone here could help me.

Thanks

**Minaki** · 07-08-2005, 10:26 AM

You will need some sort of server side language(Preferably ASP.NET, but could also use others such as ASP, PERL, ISAPI or PHP), and somewhere to store to store the ratings (like a database or a text file).

Talk to your web host and see what server side language is available, if any - you should be able to find rating scripts available everywhere.. (try google, hotscripts). Failing that, you could write one without too much trouble.

- Mina

**Enigmatic** · 07-08-2005, 11:07 AM

As an example:

PHP Code:


			
##----[ TABLE STRUCTURE ]----##



CREATE TABLE `ratings`

 (

  userid int() auto_increment NOT NULL default '',

  imageid int() NOT NULL default '',

  userRating int() NOT NULL default '',

  comments varchar(255) default ''

 );





##----[ SQL ]----##



<?PHP



/*the code below assumes you already have a user db set up and sessions are registered*/

$sql = mysql_query("INSERT INTO ratings (userRating, comments) VALUES ('$userRating', '$comments') WHERE userid =  '$userid' AND imageid = '$imageid'");



?>





##----[ EXAMPLE FORM ]----##



<html>

<head>

<title>Example Form</title>

<style type="text/css">

.text

  {

   font-family:Verdana, Arial, Helvetica, sans-serif;

   font-size:10;

   font-weight:normal;

   color:#000000;

  }

.inputField

  {

font-family:Verdana, Arial, Helvetica, sans-serif;

color:#000000;

font-size:10px;

font-wieght:normal;

border-color:#666666;

border-width:1px;

border-style:solid;

width:150px;

height:17px;

  }

.inputField

  {

font-family:Verdana, Arial, Helvetica, sans-serif;

color:#000000;

font-size:10px;

font-wieght:normal;

border-color:#666666;

border-width:1px;

border-style:solid;

width:150px;

height:17px;

  }

.textArea

  {

font-family:Verdana, Arial, Helvetica, sans-serif;

color:#000000;

font-size:10px;

font-wieght:normal;

border-color:#666666;

border-width:1px;

border-style:solid;

width:150px;

height:50px;

  }

.button 

  {

   font-family:Verdana, Arial, Helvetica, sans-serif;

   font-size:10;

   color:#000000;

   height:17px;

   width:50px;

   border-color:#666666;

   border-width:1px;

   background-color:#CCCCCC;

  }

</style>

</head>

<body>

<table class="text">

<tr>

<td><u>Example Form</u></td>

</tr>

</table>

<form name="signup_form" action="<?PHP echo $_SERVER['PHP_SELF'] ?>"> method="post">

<table class="text">

<tr>

<td align="right">Rating:</td>

<td><input type="text" name="userRating" class="inputField" max="1"></td>

</tr>

<tr>

<td align="right" valign="top">Comments:</td>

<td><textarea name="comments" class="textArea"></textarea></td>

</tr>

<tr>

<td>&nbsp;</td>

<td align="right"><input type="reset" class="button" value="Reset"> &nbsp; <input type="submit" class="button" 



value="submit"></td>

</tr>

</table>

</form>

</body>

</html>

HTML Forum

Find a Professional HTML Freelancer!

FREE Outsourcing eBook!