PHP - Calculations No Longer Working.

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

 

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.

This topic has been moved to PHP Math Help.

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

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.

//
I am trying to calculate the number of days between dates and have a major problem.  When I try the example below, it gives me exactly 201 days, yet the dates have different times, meaning that a full day is impossible.  If it matters, I am testing via xampp 1.7.3 with php version 5.3.1 with Windows XP.  Can anyone explain what I am doing wrong.  Can daylight savings play a role?

        $frmritedate7116    =    strtotime('2010-12-13 23:00');
        $frmritedate7156    =    strtotime('2010-05-27 00:00');
//
        $frmritedate7251    =    $frmritedate7156 - $frmritedate7116;
//
//
1274943600-1292310000=-17366400 // 86400 seconds in a day ( 201.00 )
//
//
//

I'm sure there is a very simple fix to this problem.

I have an image uploader in the backend of my site. Since moving hosts this no longer works.

The PHP is



if((!empty($_FILES["indeximage"]))) {

$indeximagename = basename($_FILES['indeximage']['name']);
$indeximagenew = $_SERVER['DOCUMENT_ROOT'] . '/images/uploaded/index/' . $indeximagename;

if (!file_exists($indeximagenew)) {
if ((move_uploaded_file($_FILES['indeximage']['tmp_name'], $indeximagenew)) === true) {
echo $indeximagename;
echo ' was successfully uploaded.';
}else {
echo 'Unable to move';
echo $indeximagename;
echo ' into the right folder.';
}
}else {
echo 'You did not upload an index image.';
}
}



I'm guessing the problem is with the document root part. $indeximagenew echos /var/www/vhosts/webaddress.co.uk/httpdocs/images/uploaded/index/imagename.jpg

The actual actual address of the image, when on the site, is http://www.webaddress.co.uk/images/uploaded/index/imagename.jpg

Any help would be great!

Hello,
While I am working on my code I faced this problem, which is
 Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp\www\factory1.php on line 100
Call Stack
#   Time   Memory   Function   Location
1   0.0062   379160   {main}( )   ..\factory1.php:0
Any help to come over this problem. My database is quite large (600 MB).
Thanks in advance.

We're moving to a new web server and we recently migrated to a new MS SQL server, as well. All PHP functions on the old web server were switched to point to the new SQL server and all was well.

But..... Now I''m trying to move my PHP functions to the new web server and it won't connect to the database. PHP works fine because I can echo "Testing" or whatever. I've downloaded the SQL Server PHP drivers from Microsoft, changed the connection string from MSSQL to SQLSRV, updated the PHP.ini file, and taken several other steps. It still can't see the database.

Ideas?

Oh, yeah. And both the new web server and MS SQL server are Server 2008 R2.

I apologize if this isn't the exact right location for this question, but it's the best place I could find.  I work for a small business and the server hosting our website recently disabled FormMail.  We no longer have a webdesigner per se and I've been the one taking care of the website.  Unfortunately the few programming classes I've taken have mostly left me by now and I'm banging my head against the wall trying to find a way to get back our multiple feedback forms.  I'm sure the best thing would be to hire someone, but business hasn't been great and the boss is counting on me, so I'm hoping someone here may have some suggestions.  I've been corresponding with our server trying to get some suggestions on what to do and this is the best they've been able to tell me;

"The reason being that Shared Servers must have
the ability for php/cgi to send mail disabled as a protection against
darkmailer, so any form or scripts that would send mail must be able to
authenticate itself to the server as a valid user."

"If you can find a method to send the
mail without php/cgi, or one that does go through the steps to authenticate as
a valid user (specifically, as you), then we can probably get you all set up."

"The only option at this point would
be to correct your script to authenticate as a valid email user."

"...you would need to change your scripts to
login with a mail user to authenticate and send mail."

Now I'm not completely programming illiterate; I mean, I passed my classes in college, but I can't figure out how to do this.  They say they don't allow any FormMail or FormMail Clones, so I'm fairly lost.  If anyone has any helpful hints or suggestions I would appreciate it greatly.

Thanks,
Zach

This topic has been moved to PHP Math Help.

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

I had to move hosters recently and I have a couple of scripts run using CRON to backup my MySql database and manage the number of backups that I keep.  I can ask the hosters to deprecate the version of PHO backwards but I don't want to lose the opportunity of features that may be available in the new version.  The main script essentially performs a MySqlDump to a specified directory and then emails me to tell me that it completed successfully.  The second script just deletes any files in the backup folder more than x days old.

I know mysqldump is a valid call so I should need to use anything other than that but I'm lost when it comes to seeing what is wrong with my scripts.

backup.php

<?
$datestamp = date("Y-m-d");      // Current date to append to filename of backup file in format of YYYY-MM-DD
                                 // run the command php -q /home/mysite/public_html/scripts/ffbackup.php

/* CONFIGURE THE FOLLOWING SEVEN VARIABLES TO MATCH YOUR SETUP */
//    require($_SERVER["DOCUMENT_ROOT"]."/config/db_config.php");
    require("/home/mysite/config/db_config.php");
    $connection = mysql_connect($db_host, $db_user, $db_password);
    mysql_select_db($db_name, $connection);

//$dbuser = $db_user, $conection ;            // Database username
//$dbpwd = ($db_password, $conection);            // Database password
//$dbname = ($db_name, connection);            // Database name. Use --all-databases if you have more than one
$backdir ="/home/mysite/forumbackup/";
$filename= "backup-$datestamp.sql.gz";   // The name (and optionally path) of the dump file
$to = "my-email@address.com";      // Email address to send dump file to
$from = "admin@mysite.com";      // Email address message will show as coming from.
$subject = "Mysite MySQL backup file-$datestamp";      // Subject of email

$command = "mysqldump -u $db_user --password=$db_password $db_name | gzip > $filename";
$result = passthru($command);
$newfile = $filename;

copy ($filename, $backdir.$newfile);

$message = "Compressed database backup file $filename copied to backup directory.";
$headers = "From: $from\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

mail($to, $subject, $message, $headers);

unlink($filename);   //delete the backup file from the server
?>

 

and delold.php

<?php
$path = "/home/mysite/forumbackup/";

//echo "script is running";
//echo "the path is $path ";

      if (is_dir("$path") )
        {
           $handle=opendir($path);
           while (false!==($file = readdir($handle))) {
               if ($file != "." && $file != "..") { 
                   $Diff = (time() - filectime("$path/$file"))/60/60/24;
                   if ($Diff > 10) unlink("$path/$file");

               }
           }
           closedir($handle);
   }
?>

 

This topic has been moved to Miscellaneous.

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

I have a 'subscribe' form on a website that uses Ajax to validate the input fields, the form is then processed via php. The actual html code resides on a Wordpress page.   I had actually just got the form to work again. The website was static, and I transferred everything over to Wordpress, and the form didnt work. I was able to get it working by specifying the url: in ajax, as an absolute path to my php form. Overnight, something, I'm not sure what, stopped the form from processing. No data is posted to myql, and no email is sent or received. The status message just hangs at "Please wait while we process your information..." This message is in part of my Ajax code, so I am thinking something is wrong with my php script. I have a 'contact' page that uses nearly identical code that the 'subscribe' pages uses to validate the input fields, and it works.   I was able to recover both the ajax and php script from an earlier time when they did work, I uploaded back to my server and nothing, the form still does not process. I also made sure my database credentials were correct with my host, and even tested my connection to mysql which I was able to connect. Next, I made sure I was able to send mail with my host.   I don't know what is causing the form to hang, and I would love to get this solved; any help would be appreciated!

  $start = 0;

Hi there,

I am working on a PHP web form and I have a very simple situation I guess, I have a variable named: $MyVal

When I do

print_r($MyVal);
To see whats inside, I get:

SimpleXMLElement Object ( [0] => 8.23 )
Now I am assigning this variable into a session variable so that I can do calculations with it.

So I assign:

$_SESSION['MySesVal'] = $MyVal;
But after assigning to session variable, when I do my calculations:

$finalValue = $_SESSION['MySesVal'] * 4;

I get 0. So is it because the actual $MyVal variable has some XML stuff as:

SimpleXMLElement Object ( [0] => 8.23 )

So what is the right way to properly assign $MyVal variable to a session variable to do calculations.

Please reply.

All comments and feedbacks are always welcome.

Thank you!