PHP - Php And Mysql Looking Up Zip Code In A Range

I am currently working on a date range script and wondering if anybody think of an easier way to do this, doing up to next 8 weeks?  This one starts on a Sunday. I also need to do one starting on a Monday (will figure that one later)

$thisweek = date("Y-m-d");
$week = date('w', strtotime($thisweek));
$date = new DateTime($thisweek);
$firstWeek = $date->modify("-".$week." day")->format("M d");
$endWeek = $date->modify("+6 day")->format("M d");
echo $firstWeek." - ";
echo $endWeek;

$nextweek = date(("Y-m-d"), strtotime("+7 Days"));
$week1 = date('w', strtotime($nextweek));
$date1 = new DateTime($nextweek);
$firstWeek1 = $date1->modify("-".$week1." day")->format("M d");
$endWeek1 = $date1->modify("+6 day")->format("M d");
echo $firstWeek1." - ";
echo $endWeek1;

 

At this time i am building an email generation report program.  I have everything working for the first and second report.  But when i try to update and get the 3 run of emails it doesnt update the previous one.  below you will find the code that i have been working on and i have everything working except for the update to run every single time.

Code: [Select]
$con = mysql_connect("test","test","test");

// $con = mysql_connect("localhost","root","");

if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("test", $con);
// mysql_select_db("test", $con);

$id = $_POST['id'];
$demo = $_POST['demo'];

$limit = $row["unique_recp"];

}

$res = mysql_query("SELECT emails FROM email_list WHERE custid = '$id' and demo = 'N' LIMIT ".$limit." ");

while ($row = mysql_fetch_array($res))
{
echo "<div id=\"left\">".$row['emails']."</div><div id=\"clr\"></div>";
}
mysql_query($res);

$res2 = "update email_list set demo = 'Y' WHERE custid = '$id' LIMIT ".$limit."";

mysql_query($res2);

mysql_close($con);

I have put in test for the actual data.

Let me know if you can figure out what is going on?  If you need to see the enter code i can send it.

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?

 

 

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

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 ?

 

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

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?

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

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

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

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
}
?>

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

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