PHP - Distance Calculating Function Problem

I have a page that gets the closest stores to a latitude and longitude. I want to have a MySQL table like this:

location_id:::::items

showing how many items are at each store and then show 'spit' them in the following format with the lowest number of items first:

location_id, distance to location_id, items.

here is the code I am using to show location_id by distance


Code: [Select]
<?php

include "connectionfile.php";

$lat = $_GET["lat"];
$lng = $_GET["lng"];


$sql = mysql_query("SELECT id, ( 6371 * acos( cos( radians($lat) ) * cos( radians( lat ) )
  * cos( radians( lng ) - radians($lng) ) + sin( radians($lat) ) 
  * sin( radians( lat ) ) ) ) AS distance
FROM locations
HAVING distance < 250
ORDER BY distance LIMIT 0 , 60;
");

WHILE($lstlocations = mysql_fetch_array($sql)) {
$location_id[$count]=$lstlocations['id'];
$distance=$lstlocations['distance'];

echo "id = " . $location_id[$count] . "  Distance = " . $distance. "<br>";
$count = $count + 1;
}

?>

What would be the best way to achieve this?

Table Of Contents
- General Description
- Database Image
- Code
- Code
- Issue

I have the following code (from outside sources), which, is apparently incompatible with my co-ordinate types.

Here is a database excerpt (first thirty rows) of about 9200 airports from around the world.

<?php
function distance($lat1, $lon1, $lat2, $lon2, $unit) { 

  $theta = $lon1 - $lon2; 
  $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) +  cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta)); 
  $dist = acos($dist); 
  $dist = rad2deg($dist); 
  $miles = $dist * 60 * 1.1515;
  $unit = strtoupper($unit);

  if ($unit == "K") {
    return ($miles * 1.609344); 
  } else if ($unit == "N") {
      return ($miles * 0.8684);
    } else {
        return $miles;
      }
}
$dep = $_GET['dep'];
$arr = $_GET['arr'];

$sql   = 'SELECT * FROM `airports` WHERE `iata` = \'' . $dep . '\'';
$query = mysql_query($sql);
$dep   = mysql_fetch_array($query);

$sql   = 'SELECT * FROM `airports` WHERE `iata` = \'' . $arr . '\'';
$query = mysql_query($sql);
$arr   = mysql_fetch_array($query);

echo distance($dep['latt'], $dep['long'], $arr['latt'], $arr['latt'], "k") . " km<br>";
?>

Here is my output [dep=yyz, arr=yul] with [yyz = 43.68,   -79.63; yul = 45.47,   -73.74] : 8719.64724823 km

Obviously, with YYZ being Toronto, Canada and YUL being Montreal, Canada, it is definitely not 9000 km away (actually, ~500 km).

Can you help me convert the units, or re-write the algorithms in order to make it function correctly.

Thank you in advance.

This topic has been moved to Miscellaneous.

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

Getting the difference in seconds between two timestamps is easy.  Taking the seconds and doing a breakdown of time frames is also easy.
Code: [Select]
<?php

echo '<p>There are a total of ' . round($seconds) . ' seconds between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round($seconds / 60) . ' minutes between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round(($seconds / 60) / 1440) . ' days between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((($seconds / 60) / 1440) / 7) . ' weeks between Timestamp 1 and Timestamp 2.</p>';
echo '<p>There are a total of ' . round((((($seconds / 60) / 1440) / 7) / 30)) . ' months between Timestamp 1 and Timestamp 2.</p>';
echo '<p>The total breakdown of time from Timestamp 1 to Timestamp 2 is .</p>';
?>
What I am trying to figure out, is get a collective amount as well....
X years X months X weeks X days X minutes and X seconds.
Does anyone have any good algorithm for handling that, or have any feedback on where to start to handle this type of math.

Hi

i am looping through some history data i have collected via soap. i have the data in an array containing lat, lon and timestamp.

Code: [Select]
foreach($history['data'] as $record) {
echo 'add(jQuery(this), number += 1, "' . date("d-m-Y @ h:i:s",$record['timestamp']) . '", "map_post.php?n=' . $name . 'u=' . $history['user'] . '", "' . $history['user'] . '", "' . $record['latitude'] . '", "' . $record['longitude'] . '");';
}

i wondered it it would be possible to check if each position is within say 300 metres of the last position and if so dont display it?

I have a timestamp field in my mySQL table and need to check if it's 14 day or older.  What's the best way to do this?

Any help will be appreciated

I have a form that I will post the code for. In my form I have a few things that need to be filled out.... Age, Gender, Coverage Amount, and Health Conditions.

The Health Conditions are 5 check boxes the user can select.

Now what I'm trying to do is make it so that when the user hits submit the Age and number of Health Conditions checked off will do this...

if # of Health Conditions <=2 and Age is <= 30 then = $0.90

if # of Health Conditions =>2 but <=5 and Age is <= 30 then = $1.20

Then after those are calculated I need these to apply to the code...


- Men are charged a 5% gender risk
- Students receive an 8% discount


Here is a example of what I'm trying to get this to do...

If you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm doing a life insurance form and these are some of the calculations that need to go into it. I'm not sure how I would code these. If someone could help me get started that would be great.



Here is my form code and the display page.


Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>



Display Page




Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

   

    <head>

        <title>Lab4</title>

       

    </head>

    <body>

    <div id="page">

        <div id="main">






        <div id="content">

           

            <h2>Life Insurance</h2>

            <table>

                <tr>

                    <th>Coverage Amount</th>

                    <th>Name</th>

                    <th>Gender</th>

<th>Age</th>

<th>Health Conditions</th>

<th>Employment Status</th>

<th>Comments</th>



                </tr>

<?php

$coverage_amount = $_POST['coverage_amount'];
$age = $_POST['age'];
$health = $_POST['health'];


if $age = 



?>










                                <tr>



                    <td><?php echo $_POST['coverage_amount'];?></td>

                    <td><?php echo $_POST['first_name'];?></td>

                    <td><?php echo $_POST['gender'];?></td>

<td><?php echo $age?></td>

<td class="right"><?php echo $_POST['health'];?></td>

<td class="right"><?php echo $_POST['employment'];?></td>

<td><?php echo $_POST['comments'];?></td>



                </tr>

                 

                            </table>

        </div>

        </div>

        <div id="footer"></div>

    </div>

    </body>

</html>

Not asking someone to do this for me. Just looking for someone to help me get going, and show me how to do this.


Need helping calculating text boxes on a form. I want my form to display the premium of $10,000 health insurance. What I mean by this is that I have a form that involves filling out life insurance information.

This is the table I'm basing this off of...

                                                      Age <=30
#health conditions <=2                   $0.90
2 <= #health conditions <=5           $1.20



The number of health conditions is equivalent to the number of check boxes that were checked. Additionally,
the following conditions apply:

- Men are charged a 5% gender risk
- Students receive an 8% discount

For example, if you are a 23 year old male student who smokes but has no other risk factors your
premium amount per $10,000 would be $0.90 * 1.05 * 0.92 = $0.8694. If you wanted to take out a
$150,000 life insurance, your monthly premium would be $13.04 (15 * $0.8694).



I'm new to php and haven't really calculated forms before...


here is my form codes....



Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">


<head>
    <title>Lab 4</title>
   
</head>


<body>
    <?php


?>



<form method="POST" action="lab4form.php">

<label for="first_name">First Name:</label>
<input type="text" id="first_name" name="first_name" /><br />
<label for="last_name">Last Name:</label>
<input type="text" id="last_name" name="last_name" /><br />
<label for="coverage_amount">Coverage Amount:</label>
<input type="text" id="coverage_amount" name="coverage_amount" /><br />
<label for="gender">Gender:</label>
<br>
<input id="male" type="radio" value="Male" name="gender" />
<label for="male">Male</label>

<input id="female" type="radio" value="Female" name="gender" />
<label for="female">Female</label> <br />
<br>
<label for="Age">Age:</label>
<input type="text" id="age" name="age" /><br />
<br>
<label for="health">Health Conditions</label> <br />

<input type="checkbox" name="health" value="Heart Disease" />
<label for="health">Heart Disease</label><br />

<input type="checkbox" name="health" value="Diabetes" />
<label for="health">Diabetes</label><br />

<input type="checkbox" name="health" value="High Blood Pressure" />
<label for="health">High Blood Pressure</label><br />

<input type="checkbox" name="health" value="Smoker" />
<label for="health">Smoker</label><br />

<input type="checkbox" name="health" value="Lung Disease" />
<label for="health">Lung disease</label><br />

<FORM METHOD=POST ACTION="lab4form.php">
<P>Employment Status<BR>
<SELECT NAME="employment">
<OPTION VALUE="Unemployed">Unemployed
<OPTION VALUE="Full-Time">Full-Time
<OPTION VALUE="Part-Time">Part-Time
<OPTION VALUE="Student">Student
</SELECT><br />
<br>
<label for="comments">Comments</label>
<input type="text" id="comments" name="comments"/><br />






<br>
<input type="submit" value="Add User" name="btn_add" />
</form>
</body>
</html>

Hi everyone,
I'm trying to add up the current time with a specified amount of seconds and insert it in a database afterwards.
When I add say: 500 seconds to the current time it adds a whole lot more and I get a number few thousands higher than I want. Can anyone help me???.
Gr Ryflex

Hello

Please take a look at attatchment:

Lets say for example I wanted to check the streak of clan1 (column) = 9 (rows)
The streak would be 5 because each row has score1 greater than score2.

So I want to calculate the streak of the value in clan1 column that has score1 greater than score2 in rows, if score2 is greater than score1 in a row then the streak breaks if that makes sense? let me know if I need to re-phrase.

Secondly, if there are two streaks, I want it to calculate the highest one.

Thanks for any help !!

Hi, im trying to calculate and display a time elapsed from known date in db. however im having trouble displaying it. other values display no problem, just cant calculate and display date on the fly. does anyone see a problem with my query? thank you.

Code: [Select]
<?php
include('config.php');
$uname=$_SESSION['username'];
if($_SESSION['username']){
$sql="SELECT country, nationality, passportDate FROM country WHERE uname='$uname'";
$result = mysql_query($sql) or die(mysql_error());
$passportDate _ts = strtotime($row['passportDate ']);
$passportDate _str = date("M-d-Y", $passportDate _ts);
$TotalTime = floor((time() - $passportDate _ts)/(60*60*24)) . ' days'; 

while($row=mysql_fetch_array($result))  {

 echo "<table border='0'>
  <tr>
  <th>Nationality</font></th>
  <th>Country</font></th>
  <th>Passport Seent Date</font></th>
  <th>Time Elapsed</font></th>
  </tr>";

  echo "<tr>";
  echo "<td>" . $row['nationality']."</td>";
  echo "<td>" . $row['country'] . "</td>";
  echo "<td>" . $row['passportDate '] . "</td>";
  echo "<td>" . ('$TotalTime') . "</td>"; 
  echo "</tr>";
  }
  echo "</table>"; 
  }
?>

I tried using a for loop but I'm trying to think of a way to calculate interest for a number of years but after I have the amount of interest for one year I'm unsure of how to add the interest to the principle then calculate it again for the next year, to hold that number like $Principle + $Interest = $NewPrinciple then $NewPrinciple + $Interest for multiple years.  

<?php
if (isset($_POST['submit'])) {
	$InvestmentFrequency = $_POST['InvestmentFrequency'];
	$CompoundFrequency = $_POST['CompoundFrequency'];
	$InitialInvestment = preg_replace("/[^0-9]/", '', $_POST['InitialInvestment']);
	$Contributions = preg_replace("/[^0-9]/", '', $_POST['Contributions']);
	$InvestmentLength = preg_replace("/[^0-9]/", '', $_POST['InvestmentLength']);
	$InterestRate =  $_POST['InterestRate'];
	
	if ($InvestmentFrequency == "Weekly") {
	$InvestmentFrequency = "52";
	} elseif ($InvestmentFrequency == "Monthly") {
	$InvestmentFrequency = "12";
	} else {
	$InvestmentFrequency = "1";
	}
	
	if ($CompoundFrequency == "Annually") {
	$CompoundFrequency = "1";
	} elseif ($CompoundFrequency == "Semiannually") {
	$CompoundFrequency = "2";
	} elseif ($CompoundFrequency == "Monthly") {
	$CompoundFrequency = "12";
	} elseif ($CompoundFrequency == "Weekly") {
	$CompoundFrequency = "52";
	} else {
	$CompoundFrequency = "365";
	}
	
	if ($CompoundFrequency == "1") {
	$AdditionalInvestments = $Contributions * $InvestmentFrequency;
	$Principle = $InitialInvestment + $AdditionalInvestments;
	$Interest = $Principle * $InterestRate;
	$NewPrinciple = $Principle + $Interest;
	
		for ($x = 0; $x <= $InvestmentLength; $x++){
			echo "$x - $NewPrinciple</br>";
		}
	}
	
}

This is the output I get the principle and interest added together for the number of years I entered.

Edited July 26, 2020 by dataxspy

Hi,

This query will show match stats of a user, the query is the output in the attatchment.
I want to calculate the streak if score1 is greater than score2. So basically, in the attatchment I have selected 3 rows, these 3 rows should be a 3 streak because the user won 3 matches in a row (according to date)

Code: [Select]
SELECT * FROM webs_cup_matches WHERE ladID='17' AND (clan1 != '0' AND clan2 != '0') AND (clan1='2630' || clan2='2630') AND (clan1 != '2147483647' AND clan2 != '2147483647') ORDER BY date DESC
any help appreciated.

I have this block of code that was written by someone years ago :-

 

<?php

	class BoDelivery {
		
		public function EstimatedDays($off, $standard_days, $saturday, $delay) {
            
            $today = date("N"); // Weekday - number 1-7
            $now = strtotime("now"); // Unix
            
            $off_array = explode(":", str_replace(".", ":", $off));
            
            $off_unix = mktime($off_array[0], $off_array[1], "00", date("n"), date("j"), date("Y"));

            $sending_days_from_now = 0;
            if ($now > $off_unix) {
                $sending_days_from_now++;
            }
            $sending_day = $today + $sending_days_from_now;
            switch ($sending_day) {
                case 6:
                    $sending_days_from_now++;
                    $sending_days_from_now++;
                    break;
                case 7:
                    $sending_days_from_now++;
                    break;
            }
            $sending_day = $today + $sending_days_from_now;

            // Estimated delivery time
            $delivery_days = $standard_days;
            $over_weekends = 0;

            // Add Delay
            if ($delay) {
                $delivery_days = $delivery_days + $delay;
            }
			            
            if ($sending_day == 5 && !$saturday) {
                $delivery_days++;
                $delivery_days++;
                $over_weekends++;
            }
            
            $delivery_day = $sending_day + $delivery_days;

            switch ($delivery_day) {
                case 6:
                    if (!$saturday) {
                        $delivery_days++;
                        $delivery_days++;
                        $over_weekends++;
                    }
                    break;
                case 7:
                    $delivery_days++;
                    $over_weekends++;
                    break;
            }
            
            if ($over_weekends == 0 && $delivery_days > 5) {
                $delivery_days++;
                $delivery_days++;
            }
            
            $delivery_day = $sending_day + $delivery_days;
            
            switch ($delivery_day) {
                case 13:
                    $delivery_days++;
                    $delivery_days++;
                    $over_weekends++;
                    break;
                case 14:
                    $delivery_days++;
                    $over_weekends++;
                    break;
            }
            
            $delivery_day = $sending_day + $delivery_days;
            
            $delivery_days = $delivery_day - $today;
            			
			return $delivery_days;
			
		}
		
	}
	
?>

 

Which is supposed to calculate the number of days for delivery, taking into account weekends & with a delay variable that we can set.

It isn't working as expected, may never have worked(??) or maybe down to PHP upgrades.

For example, if today (18th)I set the delay to 2 days the delivery estimate is the 21st (which is correct), if I change the delay to 3 OR 4 it becomes the 24th, 5 then becomes the 26th!

I can't get my head around the code at all, I wonder if someone could assist in what may be going on or add comments to the code snippets so I can maybe work it out?

 

Thanks for any help.

hey guys just a quick onei having a blank moment

i have an array at themoment pulling from a database.

i basically want to split this array based on a min and max value. divide it equally and then give it a value on each smaller array and where each array starts... to make it clearer

- say i have an array with 600 values in
i want it split up into 8 smaller arrays link so

Array
(
    => Array
        (
            [start] => 0
            [split] => 75
        )

    [1] => Array
        (
            [start] => 75
            [split] => 75
        )

    [2] => Array
        (
            [start] => 150
            [split] => 75
        )

  carrying on till the end
)

how would i do this.