PHP - Please Check N Suggest My Update Code

im developing a voting system where you can vote for multiple choices using checkboxes..
upon submitting the vote form, votecounts must automatically be updated.. values for votecount will come from the checkbox value 1.


ive been having a hard time trying to figure out hot to update multiple rows with checkbox values..any help would be appreciated..thanks in advance!

here's the code:

Code: [Select]
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form_vote"))
$i=1;{
while ($i<= $totalRows_rs_candi) {
  $updateSQL = "UPDATE tbl_candidates SET votecount={$_POST['votecount']} WHERE user_id={$_POST['candi']}";

  mysql_select_db($database_organizazone_db, $organizazone_db);
  $Result1 = mysql_query($updateSQL, $organizazone_db) or die(mysql_error());
 
  $i++;
}

  if (isset($_SERVER['QUERY_STRING'])) {
  $updateGoTo = "vote_success.php";
  }
  header(sprintf("Location: %s", $updateGoTo));
}

Code: [Select]
<form id="form_vote" name="form_vote" method="POST" action="<?php echo $editFormAction; ?>">
  <table border="1">
    <tr>
      <td>&nbsp;</td>
      <td>user_id</td>
      <td>l_name</td>
      <td>course_id</td>
      <td>yearlevel</td>
      <td>about</td>
    </tr>
    <?php $i=1; do { ?>
      <tr>
        <td><span id="sprycheckbox1">
        <input name="votecount[<?php echo $i ?>]" type="checkbox" id="votecount" value="1" />
        <span class="checkboxMinSelectionsMsg">Minimum number of selections not met.</span></span>         
        <label for="votecount[]"></label></td>
        <td><label for="candi"></label>
        <input name="candi" type="text" disabled="disabled" id="candi" value="<?php echo $row_rs_candi['user_id']; ?>" readonly="readonly" /></td>
        <td><?php echo $row_rs_candi['l_name'].' ,'.$row_rs_candi['f_name'].' '.$row_rs_candi['m_name']; ?></td>
        <td><?php echo $row_rs_candi['course_id']; ?></td>
        <td><?php echo $row_rs_candi['yearlevel']; ?></td>
        <td><?php echo $row_rs_candi['about_me']; ?></td>
      </tr>
      <?php $i++; ?>
      <?php } while ($row_rs_candi = mysql_fetch_assoc($rs_candi)); ?>
  </table>

I'm trying to get some code to work that will update a field to show a checkbox either checked or not checked.   The field either uses a Y or N.  Y is checked, N not checked.  A code that I have tried displays the correct result for the box either checked or not checked. 

input type="checkbox" name="obcDisplay" value="Y" <?=($r['obcDisplay'] == 'Y') ? 'checked="checked"' : ''; ?>/>

But I want the ability to change when the form is submitted.  so if I bring up a page and the checkbox is checked (Y) and I submint, I want the database to update to N and the other way around.

Hi, I joined new here, and I am really having hard time figuring out what's wrong with the code below which isn't working.

    if (isset($_POST['privacy_submit'])) {
if (($_SERVER['REQUEST_METHOD'] == "POST"))
{
    $privacy_upd = mysql_query("UPDATE clf_privacy_terms SET
            'p_bannerads' = '".$_POST['p_bannerads']."',
            'p_shareinfo' = '".$_POST['p_shareinfo']."',
         'p_crossmarketing' = '".$_POST['p_crossmarketing']."',
            'p_tacking' = '".$_POST['p_tacking']."',
            'p_sendcommunication' = '".$_POST['p_sendcommunication']."',
         'p_under13' = '".$_POST['p_under13']."',
            'p_internationally' = '".$_POST['p_internationally']."',
            'p_discloselegal' = '".$_POST['p_discloselegal']."',
         'p_server_country' = '".$_POST['p_server_country']."',
            'p_forums' = '".$_POST['p_forums']."',
            'p_newslettermodule' = '".$_POST['p_newslettermodule']."',
            'p_membershipmodule' = '".$_POST['p_membershipmodule']."'
            ") or die(mysql_error());

        $msg="Successfully Updated!";
}
    }
else    {
        $msg="<font color=\"red\">Incorrect method of submission.</font> Please try again.";
} 

?>

<h2>Privacy Policy</h2>

<?php if ($privacy_upd) { echo ($msg); } ?>

<form class="box" name="privacy_upd" action="gen.php" method="post">
.........................................................................................
........................

MySQL Error returns the following:

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''p_bannerads' = 'do not', 'p_shareinfo' = 'do not', 'p_cross' at line 2
Let me know if any of your guys can solve it for me, I would appreciate since I am not able to solve it for last two days already.

Thank you...

Right I want to make a request to my db to check the no. of rows it has.
If it has changed, refresh the chat page.
else wait.
I have tried to check for last db update, that never worked as well.
Well here is my code.

Code: [Select]
//this is my refresh script below
$result = mysql_query("SELECT * FROM chatmessages");
$num_rows = mysql_num_rows($result);
echo "$num_rows Rows\n";

while(0){
$num_rows_temp = mysql_num_rows($result);
if ($num_rows  != $num_rows_temp){
$$num_rows=$num_rows_temp;
echo "<script>";
echo "window.location.replace('chatlog.php')";
echo "</script>";
}else{
sleep(2);
}
}
I assume $num_rows  != $num_rows_temp is wrong as  it does not seem to do anything. Any help would be welcome. thanks.

Hi, I need to insert some code into my current form code which will check to see if a username exist and if so will display an echo message. If it does not exist will post the form (assuming everything else is filled in correctly). I have tried some code in a few places but it doesn't work correctly as I get the username message exist no matter what. I think I am inserting the code into the wrong area, so need assistance as to how to incorporate the username check code.

$sql="select * from Profile where username = '$username';
$result = mysql_query( $sql, $conn )
      or die( "ERR: SQL 1" );
if(mysql_num_rows($result)!=0)
{
process form
}
else
{
echo "That username already exist!";
}


the current code of the form


<?PHP
//session_start();
require_once "formvalidator.php";
$show_form=true;

if (!isset($_POST['Submit'])) {



$human_number1 = rand(1, 12);



$human_number2 = rand(1, 38);



$human_answer = $human_number1 + $human_number2;



$_SESSION['check_answer'] = $human_answer;
}

if(isset($_POST['Submit']))
{





if (!isset($_SESSION['check_answer'])) {
echo "<p>Error: Answer session not set</p>";
}


if($_POST['math'] != $_SESSION['check_answer']) {
echo "<p>You did not pass the human check.</p>";
exit();
}


   $validator = new FormValidator();
    $validator->addValidation("FirstName","req","Please fill in FirstName");







$validator->addValidation("LastName","req","Please fill in LastName");
$validator->addValidation("UserName","req","Please fill in UserName");
$validator->addValidation("Password","req","Please fill in a Password");
$validator->addValidation("Password2","req","Please re-enter your password");
$validator->addValidation("Password2","eqelmnt=Password","Your passwords do not match!");
$validator->addValidation("email","email","The input for Email should be a valid email value");
$validator->addValidation("email","req","Please fill in Email");
$validator->addValidation("Zip","req","Please fill in your Zip Code");
$validator->addValidation("Security","req","Please fill in your Security Question");
$validator->addValidation("Security2","req","Please fill in your Security Answer");
    if($validator->ValidateForm())
    {
        $con = mysql_connect("localhost","uname","pw") or die('Could not connect: ' . mysql_error());
        mysql_select_db("beatthis_beatthis") or die(mysql_error());
$FirstName=mysql_real_escape_string($_POST['FirstName']); //This value has to be the same as in the HTML form file
$LastName=mysql_real_escape_string($_POST['LastName']); //This value has to be the same as in the HTML form file
$UserName=mysql_real_escape_string($_POST['UserName']); //This value has to be the same as in the HTML form file
$Password= md5($_POST['Password']); //This value has to be the same as in the HTML form file
$Password2= md5($_POST['Password2']); //This value has to be the same as in the HTML form file
$email=mysql_real_escape_string($_POST['email']); //This value has to be the same as in the HTML form file
$Zip=mysql_real_escape_string($_POST['Zip']); //This value has to be the same as in the HTML form file
$Birthday=mysql_real_escape_string($_POST['Birthday']); //This value has to be the same as in the HTML form file
$Security=mysql_real_escape_string($_POST['Security']); //This value has to be the same as in the HTML form file
$Security2=mysql_real_escape_string($_POST['Security2']); //This value has to be the same as in the HTML form file



$sql="INSERT INTO Profile (`FirstName`,`LastName`,`Username`,`Password`,`Password2`,`email`,`Zip`,`Birthday`,`Security`,`Security2`) VALUES ('$FirstName','$LastName','$UserName','$Password','$Password2','$email','$Zip','$Birthday','$Security','$Security2')"; 
//echo $sql;
if (!mysql_query($sql,$con)) {

 die('Error: ' . mysql_error());

} else{



mail('email@gmail.com','A profile has been submitted!',$FirstName.' has submitted their profile',$body);

echo "<h3>Your profile information has been submitted successfully.</h3>";
}

mysql_close($con);
        $show_form=false;
    }
    else
    {
        echo "<h3 class='ErrorTitle'>Validation Errors:</h3>";

        $error_hash = $validator->GetErrors();
        foreach($error_hash as $inpname => $inp_err)
        {
            echo "<p class='errors'>$inpname : $inp_err</p>\n";
        }        
    }
}

if(true == $show_form)
{
?>