PHP - [help] With Range Function

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 ?

 

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

Good Evening,

I've created a function to get the Range of an array (Highest Value - Lowest Value). Now I'm trying to use this to find the Range of the Upper Quartile(Q3) and the Lower Quartile(Q1) but am not sure as to what is the best/most efficient way of doing this? Should I find the middle value of the array, and then create 2 new arrays, the top half and bottom half, then use the Range function on each of them to get Q3 and Q1 or is there a better way to go about doing this?
       
$x = array();
sort($x);

// calculate median (middle number/value)
        $count = count($x);
        $middleval = floor(($count-1)/2);
            if($count % 2) {
                $median = $x[$middleval];
            } else {
            $low = $x[$middleval];
            $high = $x[$middleval+1];
            $median = (($low+$high)/2);
            }

 // calculate range
 $min = min($x);
        $max = max($x);
        return $range = $max - $min;

any help/suggestions are appreciated! Thank you.

Kind Regards,
Ace

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.

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 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 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...

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

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]

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?

 

 

Hi i have two arrays, activity and feed..

contains 100 arrays,
$activity = array(0,1,2....,100);

contains 5 arrays
$feed = array(100,50,25,12,75);

I have 7 ranges, (0 -15),(15-30),(30-45),...(90-105)
now i need to compare feed array with activity array to find in which range it was...

Example,

$feed[0] = 100, then it is in (90-105) range
$feed[3] = 12, then it is in (0-15) range..
...

how to find this range?? please help me..

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. 

I think I've coded myself into a corner.  I have numerous items entered with measurement extremes - highest and lowest. Now I want somebody to be able to search for an item that could match a specific length.

So I could have several items that are entered into a database like this:

Code: [Select]
item_id  |   length  |   high_low_param
-----------+-----------+----------------------
1234      |    12 cm  |  high
-----------+-----------+---------------------
1234      |    6 cm    | low


If somebody searches for an item that is 8 cm long, I want the results to be item 1234 and any other items that span that range. I'm not sure how to do this? array_fill ? I don't know. I don't want to slow down the database too much, and I don't want to have to put an entry for every single length each item could be.

Any suggestions?

Just looking to know if this is the proper way to implement this:

I need the below if to be true when any number between 100 and 1000 is the value of x, including say "105.55"

if($x>= 100 && $x <= 1000){
}


Basically I'm asking will a value of x with a decimal in it not cause the if statement to be true.