adding to database

itworks

imagine i have a list of regists that result from a query.

this regists are printed into a table with 4 columns.

in the first column i have a checkbox for each regist. the other columns are: TITLE, YEAR and VOTES.

what i need help with is the first column, when the user selects one regist by clicking on it's checkbox and then he clicks the vote button at the end of the page a vote must be added to the votes column in the database.

i know it's simple but not for a newbie like me.

thanks in advance. 🙂

cgraz

What does your form look like?

itworks

i'm glad you were the one who replied to me, since you were the one who advice me in how to do the top list.

i followed your advice and till now things are going ok, but i still can't vote, i think for now i'll forget the only 10 can be selected part, i just want to vote.

the script at the time is like this

<html>
<head>
<title>PHP - Mysql </title> </head>
<body>
<?php
$ligação=mysql_connect("localhost","","");
if (!$ligação) {
print ("problems connecting to Mysql server");
}
$sql="select * from movies order by votes desc";
$result = mysql_db_query ("omdb", $sql);
if ($result) {
print ("<table width=\"95%\" align=center border=2>");
print ("<tr><td width=\"10%\" bgcolor=\"CCCCCC\">SELECT</td><td width=\"50%\" bgcolor=\"CCCCCC\">TITLE</td><td width=\"10%\" bgcolor=\"CCCCCC\">VOTES</td></tr>");
while ($regist=mysql_fetch_array($result)) {
$tit=$regist["title"];
$vot=$regist["votes"];
$id=$regist["id"];
print ("<tr><td><input type='checkbox' name='assign_name[]' value='" . $regist["id"] . "'></td><td>$tit</td><td>$vot</td></tr>");
}
echo ("</table>");
}else{
print ("there are no entries");
}
mysql_free_result ($result);
?>
</body>
</html>

the database is called OMDB.
the table with the movies is called MOVIES.
and the columns in MOVIES are: TITLE, YEAR, PAGE, VOTES and ID.

ahundiak

You left out the form code.
if ($result)
{
print('<form method="post" action = "vote.php">');
print('<table ...'

and then at the end
echo "</table>";
echo '<input type="submit" value="Press me" />';
echo '</form>';

Now, when the user presses the button, you should be able to
$assign_name = $_POST['assign_name'];
and process the array.

itworks

well i didn0t exaclty left anything out (form) like i said that's what i have 'till now, i'm new in php and just taking my first steps.

thanks for your reply, i'm gonna try and see if i can get it to work 😕

anyway i just didn't quite followed the last part, can you explain better if it isn't much trouble?

thanks

itworks

i've made the first part and so far so good. now i have the form part but then and going back to my first question, i need to process the votes which in your example is done by the vote.php script which i really don't know where to begin.

(i suppose that last part you mentioned is a part of that script) can anyone give me a hint about that vote code, how to make it?

ahundiak

vote.php would be something like this

<?php

/* Open your mysql database */

/* This gives an array of all the check boxes
 * that were actually selected
 * The value of each entry will be the record id
 */
$assign_name = $_POST['assign_name'];

/* Cycle through */
foreach($assign_name as $id)
{
  /* First need the current vote count */
  $set = mysql_query("Select votes from movies where id=$id");
  $rec = mysql_fetch_array($set);

  /* Increment the vote count */
  $votes = $rec['votes'] + 1;

  /* And update */
  mysql_query("Update movies set votes=$votes where id=$id");
}
?>

I just typed this in so there may be a syntax error or two.

itworks

i know that it's just not easy to reply like you did just giving me the whole code or a big part of it, but it's not like i asking people to do all the work for me i just need someone to push me as i take my first steps into php. it's not easy for me, i'm a designer not a programmer, at least not for now!

again i thank you😃

itworks

thanks to the help of you all i got it to work.

the voting system is complete in all ways but i've just remember that i have no protection against people who wanna vote several times, and i never worked with cookies before, so how does it work?!

thanks.