PHP - Showing Images For Rating

I'm making a game where you earn points and lose points based on the actions that you take and the actions that your opponents take.  What's the best way to create this system.  Should I use mysql to store all the data and if so, should I set up the actions in a seperate table or should I just join the actions from all of my other tables.  I'm not quite sure what the best method is.

rating_bar($rows['id'],'6','static')." Show a star rating but the stars are to big.
How can I change the size of the rating_bar, like I change the font size?



echo "<TD  style='font-size: 10px;' ALIGN=justify width=50% height=10 scope='row'><p>Please rate</p>". rating_bar($rows['id'],'6','static')."</TD>";

I need a php/mysql star rating which has 3 criteria to rate and at the bottom a link when clicked saves the ratings. Any idea of where to get that?


Something like this

Rate criteria 1

Rate criteria 2

Rate criteria 3


Save ratings

I have two sets of codes that work perfectly.  One is for the table and the other is for the rating system.  I can't seem to figure out how to combine the two codes so that the rating system is displayed INSIDE the table instead of after it.  I'm not sure if it's possible, but I've seen it used on sites like Netflix.  If you can tell me how to fix it or give me a different suggestion I would be eternally thankful.

What I am trying to do ultimately is have a table that has a star rating associated with each entry without linking to a full page.



Code: [Select]
<link rel="stylesheet" type="text/css" href="style.css">
<script type="text/javascript" src="/jquery_star.js"></script>
<script type="text/javascript" src="/script.js"></script>
<?php
$con = mysql_connect("localhost","myhowd5_undrdg","indie500");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("myhowd5_jo151", $con);

$result = mysql_query("SELECT * FROM jos_easytables_table_data_1");

echo "<table border='1'>
<tr>
<th>Artist</th>
<th>Genre</th>
<th>Your Rating</th>
<th>Average Rating</th>
<th>Total Votes</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['column0'] . "</td>";
  echo "<td>" . $row['column1'] . "</td>";
    echo "<td>" . $row['rating'] . "</td>";
      echo "<td>" . $row['total_rating'] . "</td>";
        echo "<td>" . $row['total_ratings'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?> 

<?php
mysql_connect("localhost", "myhowd5_undrdg", "indie500") or die(mysql_error());
mysql_select_db("myhowd5_jo151") or die(mysql_error());

$query = mysql_query("SELECT * FROM jos_easytables_table_data_1");

while($row = mysql_fetch_array($query)) {
    $rating = (int)$row[rating];
    ?>
    <div class="floatleft">
        <div id="rating_<?php echo $row[id]; ?>">
            <span class="star_1"><img src="/star_blank.png" alt="" <?php if($rating > 0) { echo"class='hover'"; } ?> /></span>
            <span class="star_2"><img src="/star_blank.png" alt="" <?php if($rating > 1.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_3"><img src="/star_blank.png" alt="" <?php if($rating > 2.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_4"><img src="/star_blank.png" alt="" <?php if($rating > 3.5) { echo"class='hover'"; } ?> /></span>
            <span class="star_5"><img src="/star_blank.png" alt="" <?php if($rating > 4.5) { echo"class='hover'"; } ?> /></span>
        </div>
    </div>
    <div class="star_rating">
        (Rated <strong><?php echo $rating; ?></strong> Stars)
    </div>

    <div class="clearleft">&nbsp;</div>
    <?php    
}

?>

I've built a database based rating system, and till now everything works as expected except of one minor thing that breaks the while rating system.

When you press thumbs up or down it's only adding the vote to the LAST printed table in the while loop, it does NOT add it to the current table where the button was pressed.

This is the while loop:


<?php 
function knuffix_list ($query, $user_name, $avatar_path, $dbc) {

$data = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc));

//Loop through the array of data

while ($row = mysqli_fetch_array ($data)) {

global $con_id;

$con_id = $row['con_id'];

echo "<table padding='0' margin='0' class='knuffixTable'>";

echo "<tr><td width='65px' height='64px' class='avatar_bg' rowspan='2' colpan='2'><img src='$avatar_path' alt='avatar' /></td>";

echo "<td class='knuffix_username'><strong>" . $user_name . " ___ ";

echo "</strong><br />" . $row['category'] .  " | " . date('M d, Y', strtotime($row['contributed_date'])) . "</td></tr><tr><td>";

echo "<form action='' method='post'>

<button type='submit' name='plusVote' value='like'>Y</button>

<button type='submit' name='minusVote' value='dislike'>N</button>

<input type='hidden' name='hidden_con_id' value='<?= " . $con_id . " ?>' />

</form></td><td class='votes'>Y[ - ] | N[ - ]</td></tr>";

echo "<tr><td class='knuffix_name' colspan='3'><strong>" . htmlentities($row['name']) . "</strong><br /></td></tr>";

echo "<tr><td colspan='2' class='knuffix_contribution'><pre>" . $row['contribution'] . "</pre><br /></td></tr>";

echo "</table>";

}

mysqli_close($dbc);

}

?>


The con_id is the value how I wanted to determine which table it is, when I echo $con_id out (inside the while loop) it's showcasing the numbers correctly, but it doesn't work with the buttons, the buttons simply correspond to the last printed table in the while loop. I think it's because the while loop goes through each row until it's finished and it stops.

This is the rating script:



// RATING SYSTEM

$plus_vote = $_POST['plusVote'];
$minus_vote = $_POST['minusVote'];


if ($plus_vote || $minus_vote) {

$query = "SELECT * FROM con WHERE con_id = '$con_id'";
$query = mysqli_query ($dbc, $query) or die (mysqli_error($dbc)); 
$assoc_vote = mysqli_fetch_assoc ($query);

if ($plus_vote) {

$vote_up = $assoc_vote['likes'] + 1;

$query = "UPDATE con SET likes = '$vote_up' WHERE con_id = '$con_id'";

$query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc)); 

mysqli_close($dbc);

echo "test " . $con_id;

} elseif ($minus_vote) {

$vote_down = $assoc_vote['dislikes'] - 1; 

$query = "UPDATE con SET dislikes = '$vote_down' WHERE con_id = '$con_id'";

$query_run = mysqli_query ($dbc, $query) or die (mysqli_error ($dbc)); 

mysqli_close($dbc);

echo "test " . $con_id;

}
}



If I would be able to make the buttons in the while loop to RECOGNIZE the correct con_id of the table the button was being pressed then the script would work as intended and it would add the vote to the correct row in the table.

How could I solve this problem, because I really have no idea?

I am pretty new to PHP and am trying to create a simple (so I assumed) page to takes data from one html page(works fine) and updates a MYSQL Database.  I am getting no error message, but the connect string down to the end of the body section is showing up as plain text in my browser window.  I do not know how to correct this.  I have tried using two different types of connect strings and have verified my names from the HTML page are the same as listed within the php page.  Suggestions on what I need to look for to correct would be great.  I have looked online, but so far all I am getting is how to connect, or how to create a comment, so I thought I would try here. 
Thank you for any assistance I may get!!  - Amy -
 
Code: [Select]
<body><font color="006600">
 <div style="background-color:#f9f9dd;">
  <fieldset>
<h1>Asset Entry Results</h1>
<?php
  // create short variable names
  $tag=$_POST['tag'];
  $serial=$_POST['serial'];
  $category=$_POST['category'];
  $status=$_POST['status'];
  $branch=$_POST['branch'];
  $comments=$_POST['comments'];

  if (!$tag || !$serial || !$category || !$status || !$branch) {
     echo "You have not entered all the required details.<br />"
          ."Please go back and try again.";
     exit;
  }

  if (!get_magic_quotes_gpc()) {
    $tag = addslashes($tag);
    $serial = addslashes($serial);
    $category = addslashes($category);
    $status = addslashes($status);
    $branch = addslashes($branch);
    $comments = addslashes($comments);
  }

  //@ $db = new mysqli('localhost', 'id', 'pw', 'inventory');
  $db = DBI->connect("dbi:mysql:inventory:localhost","id","pw") or die("couldnt connect to database");

  $query = "insert into assets values
            ('".$serial."', '".$tag."', '".$branch."', '".$status."', '".$category."', '".$comments."')";
  $result = $db->query($query);

  if ($result) {
      echo  $db->affected_rows." asset inserted into Inventory.";
  } else {
     echo "An error has occurred.  The item was not added.";
  }

  $db->close();
?>
  </fieldset>
 </div>
</body>

I have this script from http://lampload.com/...,view.download/ (I am not using a database) I can upload images fine, I can view files, but I want to delete them. When I press the delete button, nothing happens   http://www.jayg.co.u...oad_gallery.php   <form> <?php $dir = dirname(__FILENAME__)."/images/gallery" ; $files1 = scandir($dir); foreach($files1 as $file){ if(strlen($file) >=3){ $foil = strstr($file, 'jpg'); // As of PHP 5.3.0 $foil = $file; $pos = strpos($file, 'css'); if ($foil==true){ echo '<input type="checkbox" name="filenames[]" value="'.$foil.'" />'; echo "<img width='130' height='38' src='images/gallery/$file' /><br/>"; // for live host //echo "<img width='130' height='38' src='/ABOOK/SORTING/gallery-dynamic/images/gallery/ $file' /><br/>"; } } }?> <input type="submit" name="mysubmit2" value="Delete"> </form>   any ideas please?   thanks

I decided to redo the individual roster page I have on my site and came up with this.


<?php
if(isset($_GET['username']) && $_GET['username'] != '')
{
$username = $_GET['username'];
$query = "SELECT bio.username AS username,  bio.charactername AS charactername, bio.id AS id, bio.style_id AS style FROM `efed_bio` AS bio ON bio.id = ebw.bio_id WHERE bio.username = '$username'";
if(!$result = mysql_query($query))
while ($row = mysql_fetch_assoc($result))
{
$fieldarray=array('id','username','charactername','style');
foreach ($fieldarray as $fieldlabel)
{
if (isset($row[$fieldlabel]))
{ 
$$fieldlabel=$row[$fieldlabel];
$$fieldlabel=cleanquerydata($$fieldlabel);
}
}
}
}
?>

        <h1><?php echo $charactername; ?>'s Biography</h1>
<?php echo getBioMenu($style,$username); ?>

<?
//If the GET page variable is biography, display the biography page
if ($page == 'biography')
{
echo getBiopgrahy($style,$id);
}
//Or if the GET page variable is gallery, display the gallery page
elseif ($page == 'gallery')

{
echo getGallery($style,$id);
}
//If the GET page variable is news, display the news page
elseif ($page == 'news')

{
echo getNews($$id);
}
//If the GET page variable is segments, display the segments page
elseif ($page == 'segments')

{
echo getBioSegments($id,S);
}
//If the GET page variable is matches, display the matches page
elseif ($page == 'matches')

{
echo getBioSegments($id,M);
}
elseif ($page == 'chronology')

{
echo getChronology($id);
}
//Otherwise display the bio
else
{
echo getBio($style,$id);
}

?>




The list of characters are listed he

http://kansasoutlawwrestling.com/roster

An example of someone's individual roster page is located he

http://kansasoutlawwrestling.com/bio?username=oriel

hi all
I have a table which i have got results from a database. My question If i want to display the details of a particular row. How do I do that?

Thanks Rgds

Hi People.

Here is a form that is supposed to read from my database.

My primary key is called "index" and I have about 300 records in the database.

I wanted to be able to view the records but when I load this page the "php" part is empty.  I simply get given a blank form.  I know it is connecting to the DB OK because I changed one letter in the password and then got a "can't connect to the database error" just to test it out.

Code: [Select]
<?php
$host = 'localhost';

$usr = "the_db_user";

$password = 'not_shared_on_forum';

$db_name = 'stranded';

function cr($string){
          $clean_string = str_replace("rn","<BR>",$string);
         return $clean_string;
}

//$id = 11;
if (!isset($id)) $id = $_GET['id'];

mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error());
mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error());

$read_query  = "select * from HelperFormData where index = '$id'";
$results = mysql_query($read_query);

$rs = mysql_fetch_array($results);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style></head>

<body>
Surname: <? echo $rs["surname"]; ?>
 
 <table width="500" border="1" bordercolor = "#2c2cf6" textcolor = "#2c2cf6"cellspacing="1" cellpadding="2">
  <tr>
    <td colspan="5">Record number: <? echo $rs["index"]; ?></td>
   </tr>
  <tr>
    <td width="120" bgcolor = #E6F8EB>Surname</td>
    <td width="120" bgcolor = #E6F8EB>First Name</td>
    <td width="120" bgcolor = #E6F8EB>phone1</td>
    <td width="120" bgcolor = #E6F8EB>phone2</td>
    <td width="120" bgcolor = #E6F8EB>Location</td>
   </tr>
  <tr>
    <td bgcolor = #E6F8EB textcolor = #AC1636><strong><? echo $rs["surname"]; ?></strong></td>
    <td bgcolor = #E6F8EB><strong><? echo $rs["firstname"]; ?></strong></td>
    <td bgcolor = #E6F8EB><strong><? echo $rs["phone1"]; ?></strong></td>
    <td bgcolor = #E6F8EB><strong><? echo $rs["phone2"]; ?></strong></td>
    <td bgcolor = #E6F8EB><strong><? echo $rs["location"]; ?></strong></td>
   </tr>
  <tr>
    <td bgcolor = #dbeff8>Qualifications</td>
    <td bgcolor = #dbeff8>Expertise</td>
    <td bgcolor = #dbeff8>Assistance</td>
    <td bgcolor = #dbeff8>Languages</td>
    <td bgcolor = #dbeff8>E-Mail</td>
   </tr>
  <tr>
    <td bgcolor = #dbeff8><strong><? echo $rs["qualifications"]; ?></strong></td>
    <td bgcolor = #dbeff8><strong><? echo $rs["expertise"]; ?></strong></td>
    <td bgcolor = #dbeff8><strong><? echo $rs["assistance"]; ?></strong></td>
    <td bgcolor = #dbeff8><strong><? echo $rs["languages"]; ?></strong></td>
    <td bgcolor = #dbeff8><strong><? echo $rs["e_mail"]; ?></strong></td>
   </tr>
  <tr>
    <td bgcolor = #E6F8EB>Consent</td>
    <td bgcolor = #E6F8EB>Published</td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
   </tr>
  <tr>
    <td bgcolor = #E6F8EB><strong><? echo $rs["consent"]; ?></strong></td>
    <td bgcolor = #E6F8EB><strong><? echo $rs["radio_callsign"]; ?></strong></td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
    <td bgcolor = #E6F8EB>&nbsp;</td>
   </tr>
  <tr>
    <td colspan="5"><p>Comments:<br />
    <strong><? echo $rs["comments"]; ?></strong></td>
   </tr>
 
</table>


</body>
</html>
</html>

I am wanting to echo one of these 4 statements depending on the 'status' value. Currently it is showing the status value on the 2nd line but not the statement below..

Code: [Select]
<li>
<strong>Status: </strong><?php more_fields('status') ?>

<?php if (more_fields('status')=="Red") echo "Your account is currently undergoing judgement";
elseif (more_fields('status')=="Green") echo "Your account is currently Live"; 
elseif (more_fields('status')=="Yellow") echo "Your account is currently undergoing site visits";
elseif (more_fields('status')=="Blue") echo "Your account is currently undergoing insolvency/liquidation";?>

</li>

any help appreciated.

Thanks, Jake

i have the following code:

<?php
session_start();
include "connect.php";

$queryFinished = mysql_query("SELECT * FROM `finished` ORDER BY auctionID DESC LIMIT 10;") or die(mysql_error());
$queryAdmin = mysql_query("SELECT maxClosed FROM `admin`;") or die(mysql_error());

//echo $queryAuctionID." = Auction ID<br />";
$username = mysql_fetch_assoc($queryFinished);

$queryShip = mysql_query("SELECT * FROM ships WHERE typeName='$username[itemName]';") or die(mysql_error());
$getShip = mysql_fetch_assoc($queryShip);
$shipID = $getShip[typeID];

echo "<img src='http://image.eveonline.com/Character/".$username[charid]."_32.jpg'> <span class='eveyellow'>".$username[username]."</span> has won a <img src='/images/types/shiptypes_png/32_32/".$shipID.".png'/> ".$username[itemName]." with ticket number #".$username[ticketNumber]."<br />";

?>

it basically lists the most recent auctions that have won, but even though i set the query to LIMIT by 10 it still only shows the 1?

is something above sticking out to anyone? i know it looks messy but im still learning.

I have a really strange query for you all to figure out why I'm not coming up with the right SELECT statement. I've echoed it and I'll show you what I get for a result from the echo as well. 

Table- Users
Fields- id,creator_id,username,password,firstname,lastname,email,status_id,isadmin,datecreated

$query = "SELECT CONCAT_WS(' ', firstname, lastname) AS name, CONCAT_WS(' ', firstname, lastname) AS handler, DATE_FORMAT(datecreated, '%M %d, %Y') AS datecreated, id, username, email FROM handlers WHERE handlers.id = handlers.creator_id";

produced this result...

SELECT CONCAT_WS(' ', firstname, lastname) AS name, CONCAT_WS(' ', firstname, lastname) AS handler, DATE_FORMAT(datecreated, '%M %d, %Y') AS datecreated, id, username, email FROM handlers WHERE handlers.id = handlers.creator_id

php data table code:

<?php 
$query = "SELECT CONCAT_WS(' ', firstname, lastname) AS name, CONCAT_WS(' ', firstname, lastname) AS handler, DATE_FORMAT(datecreated, '%M %d, %Y') AS datecreated, id, username, email FROM handlers WHERE handlers.id = handlers.creator_id";
    $result = mysqli_query ( $dbc, $query ); // Run The Query
    $rows = mysqli_num_rows($result);
    echo $query;         
<?php if ($rows > 0) { ?>
<table cellspacing="0" class="listTable" id="handlersPageList">
<!-- Thead -->
<thead>
<tr>
<th class="first"><div></div></th>
<th><a href="#" title="Handler Name">Handler Name</a></th>
                <th><a href="#" title="Handler Username">Handler Username</a></th>
                <th><a href="#" title="Handler Emal">Handler Email</a></th>
<th><a href="#" title="Creator">Creator</a></th>
<th class="last"><a href="#" title="Date Created">Date Created</a></th>
</tr>
</thead>
while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) {
              echo '
              <tr>
              <td><input type=checkbox class=checkbox value="' . $row['id'] . '" /></td>
  <td>' . $row['handler'] . '</td>
  <td>' . $row['username'] . '</td>
              <td><a href="mailto:' . $row['email'] . '>' . $row['email'] . '</a></td>
  <td>' . $row['name'] . '</td>
  <td class=last>' . $row['datecreated'] . '</td>
  </tr>';
            }
        ?>


I just decided to take out the parts of the page that would be needed to answer this problem instead of the whole file. This is a little confusing okay lets say the first user is the Administrator with an id of 1 obviously has a first name and last name and username and email and the date he registered is his datecreated and his creator_id is going to be preset because he created it himself so its going to be 1.

The 1st row in the database displays fine however I have 4 other rows that for some reason aren't displaying. And don't know why. For handlers 2-4 they all have their own first and last names and usernames and everything else however when it comes to the creator_id those 3 have a creator_id of 1 representing that the Administrator created it so in the data table instead of it showing the value of 1 for the creator_id I just want it to get the CONCCAT version of the first and last name of the Administrator.

In the past I have not done a very good job of explaining things so I hope this is more than clarified my intention with my code and what it should do and what it is doing wrong right now. If you have any other questions please ask.

The following code should output 1743425391, but it does not show anything
<?php
$xml_feed_url = 'http://api.eve-online.com/eve/CharacterID.xml.aspx?names=TX1';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $xml_feed_url);
curl_setopt($ch, CURLOPT_HEADER, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$xml = curl_exec($ch);
curl_close($ch);


$xmlr = new SimpleXMLElement($xml);

$charid = $xmlr->result->characterID;

echo $charid;
?>

The xml is:
Code: [Select]
<eveapi version="2">
<currentTime>2011-02-01 05:22:38</currentTime>
−
<result>
−
<rowset name="characters" key="characterID" columns="name,characterID">
<row name="TX1" characterID="1743425391"/>
</rowset>
</result>
<cachedUntil>2011-03-01 05:22:38</cachedUntil>
</eveapi>
Any ideas where I went wrong?