PHP - Adding Values Of Each Instance In A While Loop

I'm telling it to add 1 each time through the while loop but its not and not sure why.

Code: [Select]
<fieldset class="answerLeg">
        <legend>Edit Poll Answers</legend>
        <?php
        $j = 0;
        while($row2 = mysqli_fetch_array ( $pollAnswersResult, MYSQL_ASSOC )) { 
        ?>
            <div class="field required answers">
                <label for="answer<?php echo ($j + 1)?>">Answer #<?php echo ($j + 1)?></label><input type="text" class="text" name="answer<?php echo ($j + 1)?>" id="answer<?php echo ($j + 1)?>" title="Answer <?php echo ($j + 1)?>" value="<?php echo $row2['answer']; ?>"/>
                <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>     
            </div>
        <?php } ?>
    </fieldset>

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

Code: [Select]
$product_id=$_GET['product'];
$sql500="SELECT * FROM $tbl_name3 WHERE product_id='$product_id'";
$result500=mysql_query($sql500);
$num_rows500=mysql_num_rows($result500);
while($row500=mysql_fetch_array($result500)){
extract($row500);
$review_product_rating_total=$review_product_rating; //What do I do here?
}
$average_rating=$review_product_rating_total/$num_rows500;

I need a way to take a column of product ratings (0-5 in 1/2 increments), add them together, and divide by the number of rows taken from the database. I know how to get the number of rows with mysql_num_rows. But how would I add together the data from database?

hello, how would i add the values off all results in the $pamount array?

Code: [Select]
$result2 = mysql_query("SELECT * FROM pobook WHERE jobnumber = '$jobid'");
while($row2 = mysql_fetch_array($result2))
{
$pamount=$row2['amount'];
 
  echo "<tr>";
  echo "<td>" . $pamount . "</td>";
  echo "</tr>";


  echo "<tr>";
  echo "<td>VALUE OF ALL RETURNED $pamount HERE</td>";
  echo "</tr>";

Hi,

I currently have a string with some values in it:

$a_random_string="some random text, goes here - $123<br>some more random text goes here - $53 (text 123 )<br>ANother line of text - $126";

Now I want to add all the values that have a '$' before the value eg; $123.

So in this case I would end up with: 302

How would I do this?

Thanks,

mme

Hey guys:

If I some multi-dimensional arrays, like so:

Code: [Select]


array {

array {
  [0]=>
     "Path1"
  [1]=>
   "10"
}

}

array {

array {
  [0]=>
     "Path2"
  [1]=>
   "16"
}

array {
  [0]=>
     "Path3"
  [1]=>
   "110"
}

}

How can I add all of the values of key 1? I know its a foreach loop,  but I can't figure it out... would it be this?

I have a store number that i want to add and echo. This resembles an invoice so i my table has unit_price and total_value which is defined by by multiplying unit_price and pieces. Now that i want to print invoice i want to know how to add all items that are from that invoice_id

Code: [Select]
//get the total value for order
$sql_value = "SELECT total_value FROM `".TABLE_ORDERDETAILS."`WHERE order_id = $record_order[order_id]";
$rows_value = $db->fetch_all_array($sql_value);
foreach($rows_value as $record_value){
$value = $record_value[total_value];

}

I have the following multidimensional array where each sub-array represents quantity[0] and item #[1]:
  Array
(
    => Array
        (
            => 1 [1] => 12113
        )

    [1] => Array
        (
            => 2 [1] => 21200
        )

    [2] => Array
        (
            => 4 [1] => 10200
        )

    [3] => Array
        (
            => 1 [1] => yyyy
        )

    [4] => Array
        (
            => 20 [1] => xxxxx
        )

    [5] => Array
        (
            => 5 [1] => 21200
        )

I'm trying to consolidate like items.  For example I need to create a new array that reflects any duplicate part numbers with a combined quantity.
(ie.
...
=> 7 [1] => 21200
...

Hey guys,

I am trying to input data into a mysql database from data thats been added by a jquery form with cloned fields. It is working however it adds the first row correctly then a blank row and then the rest of the rows correctly

The code is this

$x=0;

do {
$fga=$_POST['ID'.$x.'fga'];
$fgm=$_POST['ID'.$x.'fgm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$tpa=$_POST['ID'.$x.'tpa'];
$tpm=$_POST['ID'.$x.'tpm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$stl=$_POST['ID'.$x.'stl'];
$trb=$_POST['ID'.$x.'trb'];
$ast=$_POST['ID'.$x.'ast'];
$blka=$_POST['ID'.$x.'blka'];
$blkf=$_POST['ID'.$x.'blkf'];
$tovr=$_POST['ID'.$x.'tovr'];

mysql_query("INSERT INTO stats (gameId, fga, fgm, tpa, tpm, fta, ftm, ast, stl, trb, blka, blkf, tovr) VALUES ('$gameId', '$fga', '$fgm', '$tpa', '$tpm', '$fta', '$ftm', '$ast', '$stl', '$trb', '$blka', '$blkf', '$tovr')")or die("<div class='errmsg'>Insert Error: ".mysql_error()."</div><br /> \n");

$x++;

Can anyone see what ive done wrong?

Thanks

Hello,

I have a database that contains a column with a int value for number of slots reserved, and what I want to do is fetch the value of each column and add them together to create one whole number. For example, in my database under preserved I have two separate values of 2 and 4.. I would like to take those two values and add them up into 6 through php... here is what I have so far:


$slots = mysql_query("SELECT * FROM treservations WHERE reservation_date='$reservation_date' AND reservation_hour='$reservation_hour'") or die(mysql_error());
while ($row = mysql_fetch_assoc($slots)) {
     $row["preserved"];
}

mysql_free_result($slots);

Any help would be GREATLY appreciated.. if I need to add additional code please let me know. Thank you!

hi i have got the following issues i am using the following code.

Code: [Select]
<?php

//DB CONNECTION

$ROWS = "id,firstname,lastname";

// explode at the comma and insert into an array
$test = explode("," , $ROWS);

//adds array test to the var sam
$sam = array($test);

// querys the database
$new = mysql_query("SELECT * FROM {$DB_TABLE}");

// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {

foreach ($sam[0] as $v) {

echo $row[$v] . $DELIMITER . "<br />";

}

}
?>
i get the following results.

834(|)
Steph(|)
Thompson(|)
835(|)
Lucy(|)
kim(|)
836(|)
Iwan(|)
Will(|)
837(|)
Sarah (|)
Good(|)

The problem i have is the br tag where do i put it because i need it to output like this. like it shows in the $ROWS variable above "$ROWS = "id,firstname,lastname";";


834(|)Step(|)Thompson(|)
835(|)Lucy(|)kim(|)
836(|)Iwan(|)Will(|)
837(|)Sarah (|)Good(|)

Where do i add the br tag???

Any Help PLease

Hello,
I am trying to add all rows in the same column together.
So here is the basic scheme:
id  l    column1
1   l         1
2   l         2
3   l         3


Second table

id   l      variable1

1   l               3
2   l               5
3   l               6

I basically want to add 5+3+6 and set it to a variable named '$total'. Would this be done using while loops? Here is the code I have been messing with.

$sql="SELECT column1 from table1 where id='$userid'";   // userid would be set near the top of the page
   $sql2=mysql_query($sql,$conn);
          while($rows=mysql_fetch_array($sql2)){
              $getid = $rows['column1'];
                          $sql3="SELECT variable1 FROM table2 where id='$getid'";
                          $sql4=mysql_query($sql3,$conn);
           while($items=mysql_fetch_array($sql4)){
              // Then I'm getting lost...
           } 
           }


Can you at least see what I am trying to do? I'm not even sure if this is the right approach, any help would be appreciated!

Hi, I would like to know if there's a way to quickly collect and sort form data, then use that data in an if statement. I've tried for a while now and i just can't seem to figure it out.



I would like to do this with radio buttons. Hopefully this will make it clear:
Code:
Code: [Select]
<?php

if (isset($_POST['submit'])) 
{
// I don't know how to do this but maybe something like

// if $_POST values == "Yes"
// put them into an array
// then count how many are in the array, e.g. 2 if 2 "Yes" radio buttons are selected

$count = count($array) . " Yes values selected";
echo $count;

//else if do the same for "No" values

// hopefully this is understandable
}

?>

<!-- i want to take these values and group them, so all the "Yes" values selected together and the "no" values together -->
<form method="post" action="">

<input type="radio" name="first" value="Yes" />
<input type="radio" name="first" value="No" />

<input type="radio" name="second" value="Yes" />
<input type="radio" name="second" value="No" />

<input type="submit" name="submit">
</form>

Good day guyz... I dont know why this code does not work...

the connection is fine, the database is also fine it works with the localhost, when i upload it on free hosting site like 000webhost and infinityfree this is not working.. the database on free hosting site are also working also the connection is code, just only this code i cant figure it out..

else{

$sql = "INSERT INTO .$name (TrxID, ProductName, Price, ProductImage, PurchasedDate, PurchasedStatus) VALUES (?, ?, ?, ?, ?, ?)";

$stmt = mysqli_stmt_init($conn2);

if(!mysqli_stmt_prepare($stmt, $sql)){

echo 'connection error';

}

mysqli_stmt_bind_param($stmt, "isssss", $val, $PName, $Price, $PImage, $PDate, $PStatus);

mysqli_stmt_execute($stmt);

mysqli_stmt_close($stmt);

header("location: ../customer/cart.html");

exit();

}

}

 

CREATE TABLE `members` (
`id` int(4) NOT NULL auto_increment,
`username` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;


Hi, i would like to add values automattically from a form that my users fill out that corresponds to their login details. The form templete is above.

Thanks!