Review Script

lancey10

Can someone give me a tutorial or help me code a review script? It pretty basic. A admin submit page:

Title:
Category: (Games, Movies, Anime)
Rating: (1-5)
Story: (entire story here)
And a submit button!

and then i would like the top 10 NEW reviews of each category listed.
And finally each category will have its own archive of reviews organized A-Z on seperate pages!

I know, its a noob question, but im a noob on php, please anyone help me!

bpat1434

First: I like the idea, but you need to read stuff first.

You've got your layout done. You know what you want. Next step is selecting the way to get it. mySQL or Postgre or flat-file database structures. It's up to you.

Then, once you've selected it, start looking at how to query a database (hint hint: php manual over at php.net). Look at how to manipulate the data using SQL (hint hint: mySQL manual (group by, order by, limit) ). Then it's up to you to get some code going....

You could possibly find a rating script at hotscripts.com too. If you do, I'd say you look at that for a reference (and only a reference, unless you wanna use it). I started using PHPSupportTickets as my "gateway" into PHP (heh... I just related PHP to drugs.... 🙂 ).

Think you can handle that?

lancey10

ok, what you just wrote was jiberish to my eyes..... ive tried a research it through multiple utorials but im geting no luck!

madwormer2

Do you know basic PHP?
Have you ever used a database before?
How much do you know?

Knowing the extent of your knowledge can help us help. (oh man, I'm confused by that sentence, but I'm sure it makes sense)

lancey10

yea it makes since, lol, well lets see....... i basically know as much as a girl knows how to edit myspace (if that makes since) so basically i know VERY LITTLE in php. I know basic php, BUT NOTHING WITH DATABASE and storing/retreiving info from a database

vaaaska

Well, start reading then. Ask questions and post some code when you need more help.

lancey10

ok so i started! and i dont know what i did wrong... here is what i got so far:

db.php:

<?php
// Database variables
$host = 'BLOCKED';
$user = 'dbo154983898';
$pass = 'BLOCKED';
$dbname = 'db1549838989';

// Connect to Mysql Database
$mysql = mysql_connect($host,$user,$pass);
$db = mysql_select_db($dbname,$mysql);

//grab rveiews vars
function reviews($reviews) {

$get_reviews = mysql_fetch_array(mysql_query("select * from reviews"));
$reviews = $get_reviews[$reviews];
return $reviews;
}
?>

index.php:

<?php 
include("db.php");

access();

echo ('<h4>Submit a Review</h4>');


if($_POST['options']){


$title  = $_POST['title'];
$posted = $_POST['posted'];
$story = $_POST['story'];
$picturepath = $_POST['picturepath'];
$quality = $_POST['quality'];
$effect = $_POST['effect'];
$overall = $_POST['overall'];


$options = "UPDATE reviews SET title='$title',posted='$posted',story='$story',picturepath='$picturepath',quality='$quality',effect='$effect',overall='$overall'";
$update_options = mysql_query($options);

	echo("Reviews Submited.<br /><br />");

}



$config = mysql_fetch_array(mysql_query("select * from reviews"));
	$title  = $config['title'];
	$posted = $config['posted'];
	$story = $config['story'];
	$picturepath = $config['picturepath'];
	$quality = $config['quality'];
	$effect = $config['effect'];
	$overall = $config['overall'];;


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

<table cellspacing="1" cellpadding="4" border="0" bgcolor="#f2f2f2">

<tr>
  <td width="95">Title: </td><td width="352" style="border-right: 10px solid <? echo $bg1; ?>;"><input type="text" name="bg1" value="<? echo $title; ?>" size="20" /></td></tr>
<tr>
  <td>Posted By : </td><td style="border-right: 10px solid <? echo $bg2; ?>;"><input type="text" name="bg2" value="<? echo $posted; ?>" size="20" /></td></tr>
<tr>
  <td valign="top">Story: </td><td style="border-right: 10px solid <? echo $text; ?>;"><textarea name="text" cols="50" rows="8"><? echo $story; ?></textarea></td></tr>
<tr>
  <td>Picture Url: </td><td><input type="text" name="size" value="<? echo $picturepath; ?>" size="20" /></td></tr>
<tr>
  <td>&nbsp;</td>
  <td><b>Ratings:</b></td>
</tr>
<tr>
  <td>Picture Quality: </td>
  <td><label>
    <select name="select">
      <option value="<? echo $quality; ?>">1</option>
      <option value="<? echo $quality; ?>">2</option>
      <option value="<? echo $quality; ?>">3</option>
      <option value="<? echo $quality; ?>">4</option>
      <option value="<? echo $quality; ?>">5</option>
    </select>
  </label></td>
</tr>
<tr>
  <td>Effects:</td>
  <td><select name="select2">
    <option value="<? echo $effect; ?>">1</option>
    <option value="<? echo $effect; ?>">2</option>
    <option value="<? echo $effect; ?>">3</option>
    <option value="<? echo $effect; ?>">4</option>
    <option value="<? echo $effect; ?>">5</option>
    </select></td>
</tr>
<tr>
  <td>Overall:</td>
  <td><select name="select3">
    <option value="<? echo $overall; ?>">1</option>
    <option value="<? echo $overall; ?>">2</option>
    <option value="<? echo $overall; ?>">3</option>
    <option value="<? echo $overall; ?>">4</option>
    <option value="<? echo $overall; ?>">5</option>
    </select></td>
</tr>
</table>
<br /><br />







<input type="submit" name="options" value="Submit" />
</form>

i made it myself i got help from other scripts! PLEASE SOMOENE HELP, because its not submiting to the database at all!

bpat1434

If you mean to loop through each row returned from the database, you need to use a while() loop....

And your update query needs a WHERE clause so it knows just what to update!! 😉

lancey10

just a reminder, "ur speaking to a noob, so i really dont understand!

thorpe

just a reminder, "ur speaking to a noob, so i really dont understand!

Then you need to read a tutorial then.