PHP - Prefix Decrementing Operator Vs. Postfix Decrementing Operator

Hi guys, I have written this code, it might look messy but I am learning so I don't really mind that but my main concern is that it is not working, could anyone help me out?

I am using an array to "unsubscribe" from multiple events at once, now I also need to decrement the amount of participants in that event, the code is working I am able to unsubscribe from events but the currentparticipants field is not updating.. any idea why?

This is the code that runs when you click unsubscribe :

Code: [Select]
if(isset($_POST['eventsID']) && count($_POST['eventsID']))
{
$eventsID = $_POST['eventsID'];

    //Ensure values are ints
    $deleteIDs = implode(', ', array_map('intval', $_POST['eventsID']));
    $query = "DELETE FROM Eventparticipants WHERE eventsID IN ({$deleteIDs})";
    //Debug line
echo '';
    mysql_query($query) or die(mysql_error());
    $result5=mysql_query("SELECT maxparticipants, currentparticipants FROM Events WHERE eventsID='$eventsID'");
$row5=mysql_fetch_assoc($result5);

$currentparticipants = $row5['currentparticipants'];
$maxparticipants = $row5['maxparticipants'];

$newcurrentparticipants = $currentparticipants--;



$sql="UPDATE Events SET currentparticipants='$newcurrentparticipants'
WHERE eventsID='$eventsID'";

if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }

}

And here is the code where you actually click unsubscribe

Code: [Select]
     $result2 = mysql_query("SELECT * FROM Eventparticipants WHERE participant = '$username'")
or die(mysql_error());

echo '</br><b>You are currently taking place in these events: </b></br>';
echo "<form action='' method='POST' onsubmit='return executeOnSubmit();'>";
echo '<table border="0">';
while($row2 = mysql_fetch_array($result2))
{


echo '<tr>';
echo '<td><a href="showevent.php?eventsID=';
echo $row2['eventsID'];
echo '">';
echo $row2['eventdescriptionheader'];
echo '</a></td>';


echo "<td><input type='checkbox' name='eventsID[]' value='{$row2['eventsID']}' /></td>";
echo '</tr>';


}
echo '</table>';
      echo "</br><input type='submit' value='Unsubscribe to event(s)' name='delete' />";
        echo '</form>';


And here is the full script in one
Code: [Select]
<?php
include 'connect.php';
include_once "markdown.php";
session_start();

if(!isset($_SESSION['username']))
{
      echo 'You have to be a registered member to be able to view your space.<br><br> <a href="register.html">Click here to register</a>';
              echo '<br><br><br><br>Or if you are already a member, please login to use this area.<br>';
        echo '
        <form method="POST" action="loginverification.php">
        <table border="0">
        <tr><td>
  Username: </td><td><input type="text" name="username" size="15" /></td></tr>
  <tr><td>Password:</td><td> <input type="password" name="password" size="15" /></td></tr>
  </table>
  <div align="center">
    <p><input type="submit" value="Login" /></p>
  </div>
</form>';
}
else{

if(isset($_POST['eventsID']) && count($_POST['eventsID']))
{
$eventsID = $_POST['eventsID'];

    //Ensure values are ints
    $deleteIDs = implode(', ', array_map('intval', $_POST['eventsID']));
    $query = "DELETE FROM Eventparticipants WHERE eventsID IN ({$deleteIDs})";
    //Debug line
echo '';
    mysql_query($query) or die(mysql_error());
    $result5=mysql_query("SELECT maxparticipants, currentparticipants FROM Events WHERE eventsID='$eventsID'");
$row5=mysql_fetch_assoc($result5);

$currentparticipants = $row5['currentparticipants'];
$maxparticipants = $row5['maxparticipants'];

$newcurrentparticipants = $currentparticipants--;



$sql="UPDATE Events SET currentparticipants='$newcurrentparticipants'
WHERE eventsID='$eventsID'";

if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }

}



       $username = $_SESSION['username'];


       $result = mysql_query("SELECT * FROM Members WHERE username = '$username'")
               or die(mysql_error());
               while($row = mysql_fetch_array($result))
               {
                       echo '<b>' . $username . '</b></br></br>';


     echo '<img src="data:image/jpg/png/jpeg;base64,' . base64_encode( $row['image'] ) . '" height="150" />';
     echo '</br>';


$selfdescription = Markdown($row['selfdescription']);
                       echo $selfdescription;
                       echo '</br></br>';
echo '<table border="0">';

echo '<tr>';
echo '<td>';
echo 'Email: ';
echo '</td>';
echo '<td><b>';
echo $row['email'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Date joined: ';
echo '</td>';
echo '<td><b>';
print date('d M Y', strtotime($row['datejoined']));
echo "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Last visit: ';
echo '</td>';
echo '<td><b>';
print date('d M Y', strtotime($row['lastvisit']));
echo "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'First name: ';
echo '</td>';
echo '<td><b>';
echo $row['firstname'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Family name: ';
echo '</td>';
echo '<td><b>';
echo $row['familyname'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Date of birth: ';
echo '</td>';
echo '<td><b>';
print date('d M Y', strtotime($row['dob']));
echo "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Gender: ';
echo '</td>';
echo '<td><b>';
echo $row['gender'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'County: ';
echo '</td>';
echo '<td><b>';
echo $row['county'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo 'Postcode: ';
echo '</td>';
echo '<td><b>';
echo $row['postcode'] . "</b>";
echo '</td>';
echo '</tr>';

echo '<tr>';
echo '<td>';
echo '</br>';
echo '<form action="editprofile.php">';
echo '<input type="submit" name="" value="Edit Profile">';
echo '</form>';
echo '</td>';
echo '</tr>';

echo '</table>';

               }

            $result2 = mysql_query("SELECT * FROM Eventparticipants WHERE participant = '$username'")
or die(mysql_error());

echo '</br><b>You are currently taking place in these events: </b></br>';
echo "<form action='' method='POST' onsubmit='return executeOnSubmit();'>";
echo '<table border="0">';
while($row2 = mysql_fetch_array($result2))
{


echo '<tr>';
echo '<td><a href="showevent.php?eventsID=';
echo $row2['eventsID'];
echo '">';
echo $row2['eventdescriptionheader'];
echo '</a></td>';


echo "<td><input type='checkbox' name='eventsID[]' value='{$row2['eventsID']}' /></td>";
echo '</tr>';


}
echo '</table>';
      echo "</br><input type='submit' value='Unsubscribe to event(s)' name='delete' />";
        echo '</form>';

                            $result4 = mysql_query("SELECT * FROM Events WHERE hoster = '$username'")
or die(mysql_error());

echo '</br><b>You are currently hosting these events: </b></br>';
echo "<form action='' method='POST'>";
echo '<table border="0">';
while($row4 = mysql_fetch_array($result4))
{


echo '<tr>';
echo '<td><a href="showevent.php?eventsID=';
echo $row4['eventsID'];
echo '">';
echo $row4['eventdescriptionheader'];
echo '</a></td>';



echo '</tr>';


}
echo '</table>';

        echo '</form>';

}


?>

Much appreciated!

Hi,

This ones stumped me a little as i've done this previously and it seemed to work fine:

I have a form to add with two password boxes, the IDs are different as they should be but the type is the same:

Code: [Select]
<form action="<?php echo $PHP_SELF;?>" method="post">
<p>New Password: <input type="password" id="newpassword" name="newpassword" /></p><br />
<p>Confirm Password: <input type="password" id="confirmpassword" name="confirmpassword" /></p><br />
<p><input type="submit" name="submit" value="submit"></p>
</form>

I have this code to check if they are both equal then md5 them and add them to the database:

Code: [Select]
// Check if button name "submit" is active, do this
if(isset($_POST['submit'])) {

//variable to identify user
$email = ($_SESSION['email']);

//post variable from form
$newpassword = $_POST['newpassword'];
$password = $_POST['confirmpassword'];

//if passwords are not equal
if($password != $confirmpassword)  { 
echo "The passwords do not match<br />"; 

//debugging - to see if they are equal or not - remove afterwards
echo $password . "<br />";
echo $newpassword . "<br />";
} 

//if passwords are equal
if($newpassword == $password)  {

//use md5 so they match when logging in
$password = md5($password); 
$newpassword = md5($newpassword);

$sql= "UPDATE users SET password='$newpassword' WHERE username='$email'"; 
$result = mysql_query($sql);
if($result) 
    { 
    echo "Congratulations You have successfully changed your password"; 
    }   
}
}

I've tried to explain my thinking as best i can in the code, the debugging part at the top shows that both values  seem to be identical yet i'm being thrown into the not equal loop and they aren't adding to the database.

Can anyone explain what i'm doing wrong here? I imagine its only minor but its thrown me.

Cheers

Hi

Ok, so I pick a random value 23 for example and I want this value to be in between two other values.
E.g. if 23 is in between 20 and 30, then continue otherwise die.

How can I do this?

I've been looking through the Joomla docs trying to understand how everything works and I've seen something that I don't understand and cannot find an answer to anywhere on the net.

The basic question is what is the ampersand used for in this conditional he

if (!($mask & 1) && is_string($var)) {

The two in the middle are obviously the AND part of the conditional.  I know it can be used for creating references to variables but I don't think this is what is happening here.  I've seen people using it to test for odd and even numbers too but with no explanation of how it works/what it does.  The full code is below:


function _cleanVar($var, $mask = 0, $type=null)
    {
        // Static input filters for specific settings
        static $noHtmlFilter    = null;
        static $safeHtmlFilter    = null;
 
        // If the no trim flag is not set, trim the variable
                if (!($mask & 1) && is_string($var)) {
            $var = trim($var);
        }
 
        // Now we handle input filtering
                if ($mask & 2)
        {
            // If the allow raw flag is set, do not modify the variable
                        $var = $var;
        }
        elseif ($mask & 4)
        {
            // If the allow html flag is set, apply a safe html filter to the variable
                        if (is_null($safeHtmlFilter)) {
                $safeHtmlFilter = & JFilterInput::getInstance(null, null, 1, 1);
            }
            $var = $safeHtmlFilter->clean($var, $type);
        }
        else
        {
            // Since no allow flags were set, we will apply the most strict filter to the variable
                        if (is_null($noHtmlFilter)) {
                $noHtmlFilter = & JFilterInput::getInstance(/* $tags, $attr, $tag_method, $attr_method, $xss_auto */);
            }
            $var = $noHtmlFilter->clean($var, $type);
        }
        return $var;
    }

This might is a newbie/stupid question.  But, what does this operator below means?

->