PHP - Variable Calculations

Hi guys, I'm working on a project and I can't wrap my head around on a calculation that needs to be done on a multidimensional array. Quick background, it's a hotel benchmarking tool and I need to calculate the market penetration index (MPI). I have an array with 3 main arrays. First 2 are the hotels which are being compared and the last one is the MPI array.

Each array contains an array  for every month the user selects. Inside THAT array is data that needs to be used for calculations.
Here is an example:
Code: [Select]
Array
(
    [Competitive set] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 13
                            [data] => 67.6
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 13
                            [data] => 63.6
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 13
                            [data] => 59.2
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 13
                            [data] => 54.6
                        )

                )

        )

    [Test] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 89
                            [data] => 71.5
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 89
                            [data] => 67.0
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 91
                            [data] => 63.1
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 89
                            [data] => 57.5
                        )

                )

        )

    [MPI] => Array
        (
            [Sep 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-09-01
                            [maxmonth] => 2011-09-01
                            [nrcheck] => 89
                            [data] => 71.5
                        )

                )

            [Oct 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-10-01
                            [maxmonth] => 2011-10-01
                            [nrcheck] => 89
                            [data] => 67.0
                        )

                )

            [Nov 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-11-01
                            [maxmonth] => 2011-11-01
                            [nrcheck] => 91
                            [data] => 63.1
                        )

                )

            [Dec 11] => Array
                (
                    [0] => Array
                        (
                            [minmonth] => 2011-12-01
                            [maxmonth] => 2011-12-01
                            [nrcheck] => 89
                            [data] => 57.5
                        )

                )

        )

)
Currently the  'data' for MPI is wrong. That needs to become the data of the first array divided by the data of the second array and multiplied by 100 (percentage).

How would I go about doing that? The foreach loops are a bit too big for me on this one.

This topic has been moved to PHP Math Help.

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

Hello there,

I stuck in a silly logic ... I will really appreciate if someone helps me...

My Fiscal year starts from 01st April of current year through 31st March of next year, for ex. (01 Apr 2011 to 31st March 2012). I want to put a latefee of 6.25% on total amount, if the payment date is not done on the current fiscal year. Everything depends on the payment date.

For example,

A bill of $8000 was generated on 01st Apr. 2009 then its 6.25% will be $500 and the customer is paying the same on 30th August 2011, then total years passed is 3. So, the late fee will be 500 * 2 = $1000.

i.e. Any bill generated and paid in the current fiscal year (stated above) is free of late fee and after that the above calculation is applicable.

Please help, how to do the calculation. A function is really appreciated.

Hi

I was wondering if somebody could give me some help.

I have a form with the following table for users to input 

			<td width="118" style="text-align: left"><input type="text" name="item1cost"></td>
	        <td width="118" style="text-align: left"><input type="text" name="item1Charge"></td>
			<td width="118" style="text-align: left"><input type="text" name="item1sum""></td>

is there a way to have the 3rd field auto populated by calculations made from the data a user puts in the 1st and 2nd field ?

The calculation i am actually looking for i can explain easier in excel terms

Lets say 

item1cost is in A2

Item1charge is in B2

Item1sum is in C3

A3 would be the cell i want populating with the calculation of 
=SUM(B2-(A2*1.295))

any help would be greatly appreciated

thanks

 

This topic has been moved to PHP Math Help.

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

This topic has been moved to Miscellaneous.

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

I was wondering how to write something like this:

if (table1.column1 + table2.column2 > table3.column3  then .....

I am confused where to put ( ) and '

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here.  It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");
   
   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

Hello all. I am very new to PHP, and I am not sure where to look or what I'm looking for in my current assignment.

My task is to take in two numbers between 0-100. Once I take in that number, it should state beside it "The __ was accepted."
The program should not accept any numbers greater than 100 or any characters.

Once I do this, I must take a second number and do a similar thing.

Finally, I must have a statement show up at the bottom stating which number is greater.

Essentially, I need help in determining what I should use to place parameters, and how I can keep the program from echo ing any statement until input has been taken and tested for parameters.

Any help you can provide will be greatly appreciated!

I have just re-installed Xampp and suddenly my sites are now displaying lots of:

Notice: Use of undefined constant name - assumed 'name' in ...
Notice: Use of undefined constant price - assumed 'price' in ...

this is an example of the line its refering too:

$defineProducts[1001] = array(name=>'This is a product', price=>123);

My login script stores the user's login name as $_SESSION[ 'name'] on login. For some unapparent reason, i'm getting errors stating that $user  and $priv are  undefined variables, though I've attempted to define $user as being equal to $_SESSION['name'], using $user to look up the the user's privilege level (stored as the su column ) in the SQL table, and then where the result of the sql query is $priv which is then evaluated in an if statement. I can't seem to figure out why this might not be working.

The code I'm using:

<?php
session_start();
function verify() {
	//verify that the user is logged in via the login page. Session_start has already been called. 
	if (!isset($_SESSION['loggedin'])) {
	header('Location: /index.html'); 
	exit;
	}
	//if user is logged in, we then lookup necessary privleges. $_SESSION['name'] was written with the login name upon login. Privleges   // are written in db as a single-digit integer of of 0 for users, 1 for administrators, and 2 for special users. 
        $user === $_SESSION['name'];
    //Connect to Databse
	$link = mysqli_connect("127.0.0.1", "database user", "password", "database");
	if (!$link) {
  	  echo "Error: Unable to connect to MySQL." . PHP_EOL;
    	echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    	echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    	exit;
        }
        //SQL Statement to lookup privlege information. 
       if ($result = mysqli_query($link, "SELECT su FROM accounts WHERE username = $user", MYSQLI_STORE_RESULT)) {
         //LOOP TO CYCLE THROUGH SQL RESULTS AND STORE Privlege information as vairable $priv.
            while ($row = $result->fetch_assoc()) {
           $priv === $row["su"];
            }
        }
        // close SQL connection.
        mysqli_close($link);

 // Verify privleges and take action. Only a privlege of "1" is allowed to view this page. A privlege of "2" indicates special 
//accounts used in other scripts that have certain indermediate additional functions, but are not trusted administrators. 

        if ($priv !== 1) {
        echo $_SESSION['name'];
        echo "you have privlege level of $priv";
        echo "<br>";
        echo 'Your account does not have the privleges necessary to view this page';
        exit;
        }
        
}
verify();
?>

 

Hello everyone,

I can get Test 2 to successfully operate the if statement using a variable variable.

But when I try the same method using a session variable (Test 1) the if statement is not executed. Please could you tell me why the if statement in Test 1 is not being executed?

Code: [Select]

<?php
# TEST 1
$_SESSION[test_variable] = "abcd";
$session_variable_name = "_SESSION[test_variable]";
if ($$session_variable_name == "abcd")
{
echo "<br>line 373, abcd<br>";
}

# TEST 2
$test_variable = "efgh";
$test_variable_name = "test_variable";
if ($$test_variable_name == "efgh")
{
echo "<br>line 379, efgh<br>";
}

?>
Many thanks,

Stu

I have a form that creates rows of data input textboxes depending on a user input number of things.  I have a naming convention for all these textboxes that basically just keeps incrementing a number suffix for each row.  All this is working fine.

My problem is I need to get the data inserted into this table of textboxes into an array.

Here's my code where I attempt to to this (it does not work):

Code: [Select]
$temp = $_SESSION['Num_Part'];
$count = 1;
while ($count <= $temp){
  $temp2[$count] = "'Participant_P".$count."'";
  //echo $temp2[$count]."<br/>";
  $temp3[$count]=$_POST[$temp2[$count]];  //here's the problem
  $temp4[$count] = "'Result_P".$count."'";
  $temp5[$count]=$_POST[$temp4[$count]];  //here's the problem
  //echo $temp4[$count]."<br/>";
  $count++;
}

The problem is that the $_POST does not work with the variable in the argument position - even though the argument is formatted with single quotes.

Can a variable be used in a POST argument and if so what is the correct syntax?

If not, is there some other simple solution to harvest the data into an array.  I understand I can harvest by explicitly accessing each key in the post assoc array.  But this could be dozens of rows of input fields.

Thanks in advance for your help here.  I couldn't find anything online re this topic.

I have a script that adds points together based upon the placing. This is the actual script:

Code: [Select]
<? $points = 0;

if($place === '1st') {$points = $points + 50;}
elseif($place === '2nd') {$points = $points + 45;}
elseif($place === '3rd') {$points = $points + 40;}
elseif($place === '4th') {$points = $points + 35;}
elseif($place === '5th') {$points = $points + 30;}
elseif($place === '6th') {$points = $points + 25;}
elseif($place === '7th') {$points = $points + 20;}
elseif($place === '8th') {$points = $points + 10;}
elseif($place === '9th') {$points = $points + 10;}
elseif($place === '10th') {$points = $points + 10;}
elseif($place === 'CH') {$points = $points + 50;}
elseif($place === 'RCH') {$points = $points + 40;}
elseif($place === 'TT') {$points = $points + 30;}
elseif($place === 'T5') {$points = $points + 30;}
elseif($place === 'Champion') {$points = $points + 50;}
elseif($place === 'Reserve Champion') {$points = $points + 40;}

echo "Total HF Points: $points";
?>What it *should* do (my friend's script works the same way and it works) it starts at points = 0, than if there is a first place, it adds 50, and so forth until it reaches the end.

It is included into a file, in this area:

Code: [Select]
<div class="tabbertab">
<h2>Records</h2>
<? $query92 = "SELECT * FROM THISTABLE WHERE VARIABLE='$id' OR VARIABLE = '$name' ORDER BY ABS(VARIABLE), VARIABLE";
$result92 = mysql_query($query92) or die (mysql_error());

echo "<table class='record'>
<tr><th>Show</th> <th>Class</th> <th>Place</th></tr>
";

while($row92 = mysql_fetch_array($result92)) {
$class = $row92['class'];
$place = $row92['place'];
$entries = $row92['entries'];
$race = $row92['show'];
$purse = number_format($row92['purse'],2);

echo "<tr><td>$race</td> <td>$class</td> <td>$place</td></tr>";
}
?>
<tr><td colspan='3'><div align='right'><? include('includes/points.php'); ?></div></td></tr>
</table>
</div>

This is the code that is relevant. When ended here, it echoes the last place that appears in the results (such as a 5th place echoing 30 points). When I move it to be included in the while loop, it shows Total Points: 50 Total Points: 25 Total Points: 10 (depending on the results displayed on that page). What am I doing wrong?

Quote

i need to store a variable from database like if i have "copies" in one of my column in my database then i have to store a particular value for copies store it to $copies
here i want that i can store value of copies into $copies




$update_book="update book set copies=copies-1 where bookid='$bookid'";
        $result=mysql_query($update_book,$linkID1);
            if($result)
            {
            print "<html><body background=\"header.jpg\">
            <p>book successfully subtracted from database</p></body></html>";
            }
            else {
            print "<html><body background=\"header.jpg\">
            <p>problem occured</p></body></html>";
            }

    }