PHP - Star Rating Multiple Criteria

How should I go about keeping track of photos that a user has rated, since I only want the user to rate the photo once? Can I store arrays in a mysql database?

thanks,
George

This is posting to any row in mssql that has a matching 'start_date'.  I would like it to post rows where start_date = '$start_date' and it also matches the 'meter_id' .  It should perform this check of both parameters before posting to mssql. 

<?php
$session_id = $_SESSION['id'];
$comm_id = $_GET['meter_id'];
$start_date = $_GET['start_date'];
$payment_date = $_POST['payment_date'];
$amount_paid = $_POST['amount_paid'];
$check_number = $_POST['check_number'];

$sql = "UPDATE [radiogates].[dbo].[ops_invoice_history] SET payment_date = '$payment_date', amount_paid = '$amount_paid', check_number = '$check_number' where start_date = '$start_date'";

$query = sqlsrv_query($conn, $sql);

Thank you for any help.

I have a string for rating, containing numbers from 0-5. How I can assign an image to each range:

0-0.5 displaying 05.jpg
0.5-1.0 displaying 10.jpg
.
.
.
4.5-5.0 displaying 50.jpg
 

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>";

Hi,   I can I include a date range criteria to query with in the following code? The date field in the table (t_persons) is IncidentDate.

$criteria = array('FamilyName', 'FirstName', 'OtherNames', 'NRCNo', 'PassportNo', 'Gender', 'IncidenceCountryID', 'Status', 'OffenceKeyword', 'AgencyID', 'CountryID', 'IncidenceCountryID' );
    $likes = "";
    $url_criteria = '';
    foreach ( $criteria AS $criterion ) {
            if ( ! empty($_POST[$criterion]) ) {
                    $value = ($_POST[$criterion]);
                    $likes .= " AND `$criterion` LIKE '%$value%'";
                    $url_criteria .= '&'.$criterion.'='.htmlentities($_POST[$criterion]);
            } elseif ( ! empty($_GET[$criterion]) ) {
                    $value = mysql_real_escape_string($_GET[$criterion]);
                    $likes .= " AND `$criterion` LIKE '%$value%'";
                    $url_criteria .= '&'.$criterion.'='.htmlentities($_GET[$criterion]);
            } //var_dump($likes);
    }
    $sql = "SELECT * FROM t_persons WHERE PersonID>0" . $likes . " ORDER BY PersonID DESC";

Kind regards.  

I am working on a project that involves providing details for county government, and if applicable, cities independent of county oversight.  Virginia is a state with a lot of independent cities, so I wanted to echo them in a separate list underneath the county governments.   This code works fine when displaying Virginia information.  However, I would like to hide the Independent Cities heading in every other state.  For some reason, this code still echoes the Independent Cities heading in states without independant cities in the database.   Any thoughts or wisdom?   (sorry for pasting the whole bulky code)

$query = "SELECT * FROM state WHERE st_id=$statecode";
            $result = mysql_query($query) or die("Query $query failed : " . mysql_error());
            $row = mysql_fetch_assoc($result);
            $state_name=$row["st_name"];
            $state_note=$row["state_notes"];

            echo "<h2>Counties of " . $state_name; "</h2>\n";
            
            $query = "SELECT * FROM counties WHERE st_id=$statecode AND visible=1 ORDER BY county_name ASC";
            $result = mysql_query($query) or die("Query $query failed : " . mysql_error());
        
            echo "<table width=100%><tr><td valign=top width=33%>\n";

            $count = 1;
            $col = 0;
            $rowcount = (int)(mysql_num_rows($result) / 3) + 1;
            $remainder = mysql_num_rows($result) - ($rowcount - 1) * 3;
            /* ********************************************************* */
            while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                echo "<a href=\"services.php?county=".$row["county_id"]."\">".$row["county_name"] . "</style></a><br />\n";
                $count = $count + 1;
                if ((($remainder > 0) && ($count == ($rowcount + 1))) || (($remainder <= 0) && ($count == $rowcount))) {
                    $col = $col + 1;
                    if ($col!=3) {
                        echo "</td><td valign=top width=33%>\n";
                        $count = 1;
                        if ($remainder > 0)
                            $remainder = $remainder - 1;
                    }
                }
            }
            /* ********************************************************* */
            echo "</td></tr></table><br>\n";
            mysql_free_result($result);
            /* ********************************************************* */
            
            $query2 = "SELECT * FROM cities WHERE st_id=$statecode AND visible=1 ORDER BY city_name ASC";
            $result2= mysql_query($query2) or die("Query $query failed : " . mysql_error());
            $city_id = $row['city_id'];
            $city_name = $row['city_name'];
            
            if ($city_id!="") {
                echo "<h3>Independent cities of " . $state_name; "</h3>\n";
                echo "<table width=100%><tr><td valign=top width=33%>\n";
                $count2 = 1;
                $col2 = 0;
                $rowcount2 = (int)(mysql_num_rows($result2) / 3) + 1;
                $remainder2 = mysql_num_rows($result2) - ($rowcount2 - 1) * 3;
                /* ********************************************************* */
                while ($row = mysql_fetch_array($result2, MYSQL_ASSOC)) {
                    echo "<a href=\"services.php?county=".$row["city_id"]."\">".$row["city_name"] . "</style></a><br />\n";
                    $count2 = $count2 + 1;
                    if ((($remainder2 > 0) && ($count2 == ($rowcount2 + 1))) || (($remainder2 <= 0) && ($count2 == $rowcount2))) {
                        $col2 = $col2 + 1;
                            if ($col2!=3) {
                            echo "</td><td valign=top width=33%>\n";
                            $count2 = 1;
                            if ($remainder2 > 0)
                                $remainder2 = $remainder2 - 1;
                    }
                }
            
                
            }
            /* ********************************************************* */
            echo "</td></tr></table><br>\n";
            mysql_free_result($result2);
            /* ********************************************************* */
            
            
            
            }
            
        ?>

Edited by myotch, 06 September 2014 - 09:19 PM.

So let's assume i'm making a script for searching cars by different criteria. Name of the car, color, and mileage. I used to do this by using LIKE and just adding AND for as many times as needed. But i've read that that is obsolete and is giving servers a hard time, so i went ahead and started making a new script that will use fulltext search. I've hit a dead end.

Code: [Select]
   function search($table,$what,$string,$limit,$start,$country) {
   global $totrows;
   global $pages;
   $string = explode("*",$string);
   $what = explode("*",$what);
   $cname = trim($string[0]);
   $t = 0;
   $parameters = "";
   while (isset($what[$t])){
   if ($t>0) { $paramm .= ", "; }
   $paramm .= trim($what[$t]);
   if ($t>0) { $parama .= " "; }
   $parama .= trim($string[$t]);
   $t++;
   }
   $parameters .= " AND locationc = '".$country."'";
   $sql = "SELECT *, MATCH(".$paramm.") AGAINST('".$parama."') AS score FROM main WHERE MATCH(".$paramm.") AGAINST('".$parama."') ORDER BY score DESC";
   $result = mysql_query($sql) or die(mysql_error());
   while ($row = mysql_fetch_array($result)) {
var_dump($row);   
   
    }
   }
How does this work:

The user selects and enters his parameters>
The script then joins them all into a single variable which is then sent to the function(the reason i do this i because the user might input only the name, so that way i can add more criteria and not need to change the script)>
The script explodes those into arrays and then it processes them into a form for use with sql>
I run the sql query and then return the results.

What's the problem? There's two of them actually>

The first one is that mysql returns an error "Can't find FULLTEXT index matching the column list" even though i did setup fulltext indexes.

(phpmyadmin c/p)
Code: [Select]
name FULLTEXT No No name 0 YES
color FULLTEXT No No color 0 YES
mileage FULLTEXT No No mileage 0 YES

The second problem is that the script is not selective and will not work as intended. For example, a car's name is 300, the users input's 300, and the script will return those rows that had mileage 300 or 300000 or whatever.

How do i fix this, and is FULLTEXT the right way to go with multi criteria search?

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    
}

?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308916.0

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?

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=351561.0

First, Happy X-Mas to all!


I want to do a form for entering dog-show results. On first site of form the user is able to enter how many dogs for each class (there are youth and open class for example) he want to insert. So on second site there will be formfields for every dog in every class, created with php. User should be able to take dogname from jquery autocomplete - this works for multiple fields. But i need the according id to the dogname - and actual only one id is given - the first one is changing by choosing from autocomplete in next fields...

Data came from a json array like

0: {dogidindatabase: "9892", value: "Excalibur Khali des Gardiens de la Cour ",…}
dogidindatabase: "9892"
label: "<img src='../main/img/female.png' height='20'>Excalibur Khali des Gardiens de la Cour   "
value: "Excalibur Khali des Gardiens de la Cour   "
1: {dogidindatabase: "15942", value: "Excalibur from Bandit's World Kalli",…}
dogidindatabase: "15942"
label: "<img src='../main/img/male.png' height='20'>Excalibur from Bandit's World   Kalli"
value: "Excalibur from Bandit's World   Kalli"

all i need is inside ...


the script in form is

<script type='text/javascript'>
		//<![CDATA[
		$(function() {
		
				$(".dog").autocomplete({
				source: "xxx.php",
				minLength: 3,
				select: function(event, ui) {
					$('#dogidindatabase').val(ui.item.dogidindatabase);
					}
			});
			
			$["ui"]["autocomplete"].prototype["_renderItem"] = function( ul, item) {
				return $( "<li></li>" ) 
  				.data( "item.autocomplete", item )
  				.append( $( "<a></a>" ).html( item.label ) )
  				.appendTo( ul );
			};
	
		});
		//]]>
</script>

and the form looked like

<input type='text' name='dog' class='dog' value='".strip_tags(${'dogname' .($countbabymale+1)})."' size='35' data-required='true' /><br>
	
<input class='readonly' readonly='readonly' type='text' id='dogidindatabase' name='dogidindatabase' size='5'  />

I changed in script and form id='dogidindatabase' to class, but it doesn´t work.   Testsite is under http://www.wolfdog-d...how.php?lang=de (only german at first) - Insert a number (higher than 1) under baby 3-6 (first box, the others are not working for testing); submit to get to page 2; you see all post-variables (for testing). Try to insert a dogname in first input-field (choose "exc") and insert first one - the id is under dogname. In second dogname inputfield you can choose second dog - the id for the first one changes to id of seond one ....   How can i get both for every dog?

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Ok so i want to grab an id from the checkbox then grab the option drop down associated with that check box and update a mysql row here is my code so far

any help is awesome help taaaanks guys

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

print "<input name='delete[]' value='{$row['id']}' type='checkbox'>";
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
print "<form name='namestoupdate' method='post' action='update.php'>\n";
print '<select>';
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'" name="prov['.$i++.']">'.$row2['user'].'</option>';}
}
print '</select>';
print "<input type='submit' value='submit' />";
print "</form>";
}
?>


Visual aid

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo