PHP - Finding The Interquartile Range (iqr)

I have a simple script that converts an ip range to a readable ip address,

e.g 2147483647 = 127.255.255.255 and it works fine up to this range,
anything after this causes an incorrect ip address.

e.g 2147483648 should be 128.0.0.0 but it outputs 128.0.0.255 and so all ip address after this are incorrect!

code I am using is below;

$rawip_from = '2147483648';

// raw to readable ip
$w1 = (int)($rawip_from / 16777216) % 256;
$x1 = (int)($rawip_from / 65536   ) % 256;
$y1 = (int)($rawip_from / 256     ) % 256;
$z1 = (int)($rawip_from           ) % 256;

$rawip_to = '2147549184';
// raw to readable ip
$w2 = (int)($rawip_to / 16777216) % 256;
$x2 = (int)($rawip_to / 65536   ) % 256;
$y2 = (int)($rawip_to / 256     ) % 256;
$z2 = (int)($rawip_to           ) % 256;

$ip_from = ($w1.'.'.$x1.'.'.$y1.'.'.$z1);
$ip_to = ($w2.'.'.$x2.'.'.$y2.'.'.$z2);

echo "Ip raw range: $rawip_from - $rawip_to<p>Ip range: $ip_from - $ip_to";

/* should output 
Ip raw range: 2147483648 - 2164260863

Ip range: 128.0.0.0 - 128.1.0.0

but it outputs 128.0.0.255 - 128.1.0.255
*/
It always seems to add 255 to the last range instead of the correct value?????
I heard there is a bug in php with integers > 2147483647

if anyone knows of a fix it would be great!!


Thanks...

Hello,

I'm very disapointed because I don't know how do it this.
I'm explain.
I have a database with one input date_arrival and second date_departure.
Two dates are saved in SQL format : 2014-03-02.

After my SQL request to select all dates in database I'd like to add dates between date_arrival and date_departure and for each line.
For example I have
date_arrival date_departure
line 1 : 2014-02-01 2014-02-05
line 2 : 2014-02-10 2014-02-15

In fact at the end, I have to send the result like this (with JSON) :

["2014-02-01","2014-02-02","2014-02-03","2014-02-04","2014-02-05","2014-02-10","2014-02-11","2014-02-12","2014-02-13","2014-02-14","2014-02-15"] 

Can you give me some help to add intermediates values in an array ?
Thx

I can not get the below to work:


if(time() < strtotime("11/21/2011 3:30AM EST") && time() > strtotime("11/21/2011 2:30PM EST"))


It should be evaluating to true between 3:30 AM and 2:30 PM EST for today. Now that it's past 2:30PM it should be evaluating to false, but it's coming up as true.


Edit: Nevermind. Cache/Cookies Issue.

i have the below code which i wrote this monring, for some reason when i assign $date to fetch data from my database i just get the echo of "You had an Error" yet if i manually assign $date as the following it works:

Code: [Select]
$date = strtotime("2011-09-20");
i have it set exactly the same in the database cus if i echo $date

i get:
Code: [Select]
2011-09-20
whats going on? date in php is a cruel function to play around with..

here is my code:
Code: [Select]
<?php
// Query the DB to fetch all data where member_id matches that set in session
$reminder = mysql_query("SELECT * FROM `reminders` WHERE member_id=$_SESSION[SESS_MEMBER_ID]") or die(mysql_error());
//While Loop the results
while($fetch = mysql_fetch_array( $reminder )) { 
// Start date (TODAY!)
$s_date = strtotime("now"); 
// End Date (+7 days from today)
$e_date = strtotime("+1 week"); 
// Fetches Date stamp from "reminderDate" row in DB
$date = $fetch['reminderDate']; 

// Checks if the date is between 2 ranges set above
if($date > $s_date && $date < $e_date) 

//Echo The Results
{
    echo "<div class='notification error png_bg'><a href='#' class='close'><img src='img/cross_grey_small.png' title='Close this notification' alt='close' /></a><div>Custom Error Notification BOX!</div></div>";
}
else
{
    echo "You had an Error";
//echo $date; // TEST that date outputs datestamp "2011-09-02"
}
//END LOOP
}
?>

I've written the code to generate letter and number ranges:


public function generateRange($type = 'numbers', $start = 0, $end = 10)
{
$rangelist = array();

switch($type)
{
case 'upper letters':
{
foreach(range($start, $end) as $letter)
{
$rangelist[] = $letter;
}
}
case 'lower letters':
{
foreach(range($start, $end) as $letter)
{
$rangelist[] = $letter;
}
}
case 'numbers':
{
foreach(range($start, $end) as $number)
{
$rangelist[] = $number;
}
}
default:
{
return false;
}
return $rangelist;
}
}


It current doesn't seem to return the array result correctly currently.

If I change the line "$rangelist[] = $number;" to "echo $number;" it does print the correct data.

Any ideas on why the array return line isn't working correctly?

I have read that i can search for a number within a mysql database using BETWEEN

i.e: SELECT  * FROM `table_name` WHERE `field_name` BETWEEN 99 AND 200

How would i do this with the code below?


<?php
$salary = explode(":", $_GET['salary_to']);
 }
$types[] = (isset($_GET['salary_to']) && strlen(trim($_GET['salary_to'])) > 0) ?
     "`salary_from` LIKE '%". mysql_real_escape_string(trim($salary[0])) ."%' AND `salary_to` LIKE '%". mysql_real_escape_string(trim($salary[1])) ."%'" : ''; 
?>


Thanks for any help

Hi i have the following code

Quote

$sql= "SELECT * FROM income WHERE month(date) between '04' and '12' and year(date) between 2020 and 2020";
 

This obviously selects all the information from April 2020 to December 2020

 

How do i change this to add a date as well for example if i wanted to display all the information from April 6th 2020 to December 5th 2020 ?

 

if i want find included a word in the a range how can i do it?

example : Quote

array("problem is an obstacle, impediment, difficulty or challenge, or any situation that invites resolution; the resolution of which is recognized as a solutionquestion raised for inquiry, consideration, or solution proposition in mathematics or physics stating something to be done");



how can i find only start 20 charecter and my found word after 20 character by end

example :if my word be inquiry

i want find :...soluti

Quote

onquestion raised for inquiryconsideration, or solution proposition...



[/size]

Hi,

I am trying to come up with the best way to create a range voting form.
Each candidate will have a "confidence" value associated with the choice.(using a pulldown menu?)
So for March Madness it would be:
Team .......
Confidence Value.....

each team could only be voted to finish the tournament in a particular place, and a value would be associated with that choice. The total choices possible determines the range of confidence value possible.
So....if there are 16 teams to vote on....the confidence value would range from 1-16. The voter would assign his highest available value to the team he was most confident in landing in that particular position.
Example: 16 teams - 16 conf vals -

if certain Duke will end up at #1 - then vote :
#1 = Duke, conf val 16

next, if almost as certain that NC will end up last - then vote:
#16 = NC, conf val 15

next most certain
"", conf val 14
and so on....

the tricky part is making sure that the form code validates each conf val so that it is used, but used on ly once....

ideally the form could return values that could then be imported into excel and comopared.


has this been done somewhere?
Can you help ?

hope so....

thanks!!

Okay we are using a javascript, but the javascript that the site comes from has bans all irans ips... and it loads slow for those people, how would I place a if statement saying dont load this javascript if in Iran, thanks... I know how to do it, but I can't find a real set number, and I would use just 1 ip but the guy has dynamic... thanks ahead of time

Ok, my subject line may not be exactly what I am looking for and I am not even sure what the subject should be, so let me explain what I am trying to do.

My application is as such that you enter in a zip code and it returns information, however my hard copy has a range of zip codes, in this case, equaling a zone, I.E. 90076-90210 is zone A, now instead of having the following in the database:

Code: [Select]
ID   ZIP        ZONE
1    90076    a
2    90077    a
3    90078    a
...
...
134   90210   a
Could I make it:

Code: [Select]
ID   SZIP        EZIP        ZONE
1    90076      90210     a
and though my PHP/mySQL callout compare the variable to, and find that is ZIP is between SZIP and EZIP to output a?

As there are a couple od thousand zip codes I am trying to minimize my database to be a bit smaller, but am not sure how to code it.  Normally I would make the database have all 99000 entries and pull from the database where ZIP = ZIP, but again I am trying to save my self some time...

Could I make it somehow that if ZIP <= SZIP and >= EZIP output ZONE?

Does this make any sense?  My PHP Coding is unfortunately lacking, I have only been programming it heavily for the last 5 months and it has been basic stuff.  Any help would be appreciated.

So I already have this below...

$state = array (
    1 => 'Sectional',
    2 => 'Regional',
    3 => 'Semi-state',
    4 => 'State'
);

Can those numbers be a range -- 1-16, 17-32, 33-48 and 49-64 -- without just listing them all?

 

 

I am working on a report generation. Here I need to count the number of months involved in the selected date range. I need to apply the monthly charges accordingly.

Example: If the user selects 25-08-2011 to 03-10-2011, it should return 3 as the number of months.

Yes, the number of days are less than 60 but still the date range is spread across 3 months.

Any solution.. Please.

Girish

i'm stuck with searching on age query

i let users register their date of birth (they give in DAY, MONTH, YEAR)  --> column 3

Name    CalcAge    Timestamp    Timestamp calculated for query
Person 1   21   659948401   642754801
Person 2   39   91954801                  83746801
Person 3   15   849337201   848991601
Person 4   33   281257201   281170801
Person 5   23   596876401   600850801
Person 6   87   -1422809999   -1422723599

I came up with the following query to search between a minimum and maximum age (using AJAX):

Code: [Select]
//user enters a minimum and/ or max age - getting the querystring from URL (ajax)
$minAge = $_GET['minAge'];
$maxAge = $_GET['maxAge'];

//age to unix timestamp
function agetostamp($age){
$gebjaar = date(Y) - $age;
$timestamp = mktime (0,0,1,0,0,$gebjaar);
return $timestamp;
}

//making getvariables timestamp in order to compare with database
if (isset ($minAge)){
$minAge = agetostamp($minAge);
}
if (isset ($maxAge)){
$maxAge = agetostamp($maxAge);
}

//building query
query = "SELECT * FROM respondenten WHERE geslacht = '$sex'";

if(is_numeric($minAge) && $minAge > 0)
$query .= " AND geboortedatum <= '$minAge'";
 else if (is_numeric($minAge))
$query .= " AND geboortedatum >= '$minAge'";

if(is_numeric($maxAge) && $maxAge > 0)
$query .= " AND geboortedatum <= '$maxAge'";
 else if (is_numeric($minAge))
$query .= " AND geboortedatum >= '$maxAge'";
I encouter a lot of troubles working like this:

1) if i leave out the part of maxAge (so i only allow to set a minimum age in the search box) it works except for the fact that if i set the minimum age to 23, person 5 will not be included since 596876401 < 600850801 even though she is 23 and should be included.

2) if i add the part of also searching on a max age, i don't get any results

I know that remark 1 probably has to do with the fact that im using date(Y) - $age and that people that are already born this year will have a timestamp higher than the one calculated in the query and visa versa.

conclusion: i don't think i'm going to get out of this so i'm hoping sombody can help me, telling me how to build a query for selecting on age range

I'm trying to wrap my head around how i should go about doing this. I have two dates...2011-05-03 and 2011-05-08. I want to write a function that creates an array of the days that consist of that date range. So say something like

Code: [Select]
<?php
$start = "2011-05-03";
$end = "2011-05-08";

function get_days($start, $end)
{
//code to get the days
}

echo get_days($start, $end);

//hopefully produce something like...
$day['1'] = "2011-05-03";
$day['2'] = "2011-05-04";
$day['3'] = "2011-05-05";
$day['4'] = "2011-05-06";
$day['5'] = "2011-05-07";
$day['6'] = "2011-05-08";

anybody know any idea how to do something like this? Pretty sure i'm going to need the mktime() function to account for ranges going across months and years.