PHP - Working Out Months.

Just to make things a lot simpler, I decided to start a new topic.

My question is, how can I count how many months it is back to the past November?

Example: May 2011 back to November would return 6.

Example: Dec 2011 back to November would return 1.

Example: October 2011 back to November would return 11.

Jake

I got 3 problems I am not able to do with the following PHP code

1) The sort function is not sorting the months in order like how I want it? Why?
2) How would I use a for loop to display the array of months?
3) How would I use a while loop and switch statements to display the array of months with # of days in each?

Code: [Select]
<?php
$calendar = array("Janurary", "Feburary", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December");
print_r ($calendar);

echo "<h1>FOR loop</h1>";
echo "(put for loop code here)";
echo "<br>";
sort($calender);
echo "<br>";
print_r ($calendar);

echo "<h1>WHILE loop, SWITCH statement</h1>";
echo "(put while loop code here)";
echo "<br>";
?>

hi, im making a simple blgo system, and i'd like to show a list of the last ten months, so the user can click the month name, and it will open the blog page with all the posts from that month, just like we usually see in blogs.
any ideas?
thanks in advance

Hello All,

I have a News database in which articles are entered in. Right now all the stories are being display in one big page with every story on it. What I would like to do is to create an "archive" in which it automatically organizes the stories by their date.

For example.

2011
February
January

2010
December
November
October
September
etc...
etc...

I have a datetime field for the database, and I know how to do this all manually, but I can't figure out how to make it automatically add a month each month. It would be too much maintanence to have to update this every month.

I also don't know what this would be called, so I don't even know what to search for. I've tried blog and news, but doesn't seem to be what I want.

Any help would be appreciated!

Hi,

Something strange has happend today.

I am from the UK the date is March 31st so I am using timezone:
date_default_timezone_set('UTC');
I capture the date:
$date = date("Y-m-d");
Add a month to the date:
date("Y-m-d", strtotime("+1 Month", strtotime($date)))

And its comming out as May.

If I capture the date through the URL which I do when navigating back:
$date = $_GET['date'];
Its works and says April

Can anyone please advise me on why this is happening.

Thanks

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

Hello,
I am trying to display rainfall totals for the year so far in a table with months going across and days going down. Like so:

-- Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1
2
3
4
5
6
7
8
etc

And then have the rainfall totals for each day in the table, I am quite experienced with PHP however I cant work out how I would do this 

The data is stored in a mysql table called "wx_daily", and the rainfall column is called" RainTotal". The dates are stored in the "Date" column in mysql Date format.

Im using the following mysql query:

SELECT * FROM wx_daily WHERE YEAR(Date) = '2011' ORDER BY Date Asc


Thanks,
Mark

As far as I can see, this code:
Code: [Select]
$this->_licence_expires = date('Y/m/d', mktime(0, 0, 0, date("m"), date("d")-1, date("Y")));
results in accounts expiring 1 year from today, right?

How can I change it so that it will result in expiry 9 months from today?

TIA

I am using the following code to get the third sunday of every month for +6 Months from todays date.  I have put together the following code which works perfectly when the date is echoed however when it comes to inserting those dates into mysql db it throws a unable to convert to string error.  Im new to this and my head is in a spin as to why those dates can't be inserted if they can echoed ok.  I have spent 2 days at it now and searched many forum however they seem to get side tracked from my issue (or do they)??????? I figure I can't go mixing DateTime and date() the way I have?  Please help???

Code: [Select]
[php]
$month=date('F');
$now=date('Y-m-d');
$year=date('Y');

$num='3'; //example only this will be a $_POST value 0-3
$day='Sunday'; //example only this will be a $_POST value Monday-Sunday

$start= date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.''));

if($start>$now) {
$begin=strtotime('+'.$num.' week '.$day.' '.$month.' '.$year.'');
} else {
$d = new DateTime( $start );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$year = $d->format( 'Y' );
$begin=strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.'');
}

$date=date('Y-m-d', $begin);
# insert into db first occurance
//mysql_select_db($database);
//$query_rsFirst = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsFirst = mysql_query($query_rsFirst) or die(mysql_error());
echo $date.'<br/>';
for($i = 0; $i <= 4; $i++)  {
$d = new DateTime( $date );
$d->modify( 'first day of next month' );
$nextmonth = $d->format( 'F' );
$date=date('Y-m-d', strtotime('+'.$num.' week '.$day.' '.$nextmonth.' '.$year.''));

# insert into db
//mysql_select_db($database);
//$query_rsDate = "INSERT INTO event_date VALUES (NULL, '$event', '$d', '$date', '$date')";
//$rsDate = mysql_query($query_rsDate) or die(mysql_error());
echo $date.'<br/>';
if($nextmonth=="December") {
$d = new DateTime( $date );
$d->modify( 'first day of next year' );
$year = $d->format( 'Y' );
}
}
[/php]

I'm getting this error "Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/westiehi/public_html/groupBOS.php on line 36"

for this code: Code: [Select]
$query_rs_specialty = "SELECT * FROM specialty WHERE Group_Place <> '' and Date>= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) ORDER BY Date DESC";

I've tried everything to get this to take records where the one field is blank and the date is greater than a date 6 months ago but nothing seems to work.  Help would sure be appreciated!!

So this is a simple code that finds out the difference between two dates and displays it in number of days.

$date1=date_create("2013-03-15");
$date2=date_create("2013-12-12");
$diff=date_diff($date1,$date2);
echo $diff->format("%R%a days");

// RESULT
+272 days

 

My first question. Is it possible to remove the + sign in the result above?

Second question. Is it possible to show "months" if it's greater than 30 days? And years if the days are greater than 365?

How would I do this?

http://paste.ee/p/OhiWv   The above is a link to a readable version of my code.  The XMLHTTPREQUEST worked, and the array was pulled down.  Was able to print out the undecoded/unparsed array.  However, immediately afterwards, all code stops working.

		<script>  
			var xhr;
			 if (window.XMLHttpRequest) { // Mozilla, Safari, ...
				xhr = new XMLHttpRequest();
			} else if (window.ActiveXObject) { // IE 8 and older
				xhr = new ActiveXObject("Microsoft.XMLHTTP");
			} 
				xhr.open("POST", "PHPLibrary/selectMemberResults.php", true); 
				xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");                  
				xhr.send();
				xhr.onreadystatechange = display_data;
				var $phparray
				function display_data() {
				 if (xhr.readyState == 4) {
				  if (xhr.status == 200) {
				    //alert(xhr.responseText);	   
					$phparray = xhr.responseText;
					document.getElementById("suggestion").innerHTML = $phparray;
					//
					//
					//......................................................?
					// The above line of code is the last thing to print or 
					// to do anything that returns to the browser....
					//.......................................................?
					// All lines below do nothing............................?

					//
				  } else {
					//alert('There was a problem with the request.');
				  }
				 }
				}   
				document.write("Length of phparray Array :" + $phparray.length + "<");  
				var output = JSON.parse($phparray, function (key,val) {
					if ( typeof val === 'string' ) {
						// regular expression to remove extra white space
						if ( val.indexOf('\n') !== -1 ) {
							var re = /\s\s+/g;
							return val.replace(re, ' ');
						} else {
							return val;
						}
					}
					return val;
				} ); 
				document.write("Length of Array :" + $output.length + "<");
				for (var i=0; i < $output.length; i++)
					{
						document.getElementById("suggestion").innerHTML = $output[i].MEMBER_NAME;
					}  
		</script> 

i dont understand what is wrong plz help me. here is code

$name = "img/".rand(1,9999999).".png";
$myFile = $name;
$fh = fopen($myFile, 'w') or die("can't open file");
$stringData = $html;
fwrite($fh, $stringData);
fclose($fh);
$file=$name;
$fst=file_get_contents($file);
$im=imagecreatefromstring($fst);
imagefilter($im, IMG_FILTER_GRAYSCALE);
imagefilter($im, IMG_FILTER_NEGATE);
//Convert to Grey Scale
for($i=0;$i<123;$i++){
for($j=0;$j<50;$j++){
$px=imagecolorat($im,$i,$j);
if($px<0x303030){
imagesetpixel($im,$i,$j,0);
}else{
imagesetpixel($im,$i,$j,0xffffff);
}
}
}
$database = unserialize(@file_get_contents("db.txt"));
if($database === false) $database = array();
// modify the database if needed
if($_SERVER['REQUEST_METHOD'] == 'POST'){
	if($_POST['submit'] == 'Add')
		$database[$_POST['ident']] = substr($_POST['letter'], 0, 1);
	if($_POST['submit'] == 'Del')
		unset($database[$_POST['ident']]);
	if($fh = @fopen('db111.txt', 'w+')){
		fwrite($fh, serialize($database));
		fclose($fh);
}
}else{
$newimage = true;
}
$width   = 130;
$height  = 40;
$captcha_gridstart   =1;
$captcha_gridspace   =2;
$letters = findletters($im, $width, $height, $captcha_gridstart, $captcha_gridspace);
$count   = count($letters);
$cellw   = ($count > 0) ? intval(100 / $count) : 0;
//dispeckle the image and GET co-ordinates of the characters of captcha image and return them. 
function findletters($image, $width, $height, $gridstart, $gridspace){
	$offsets  = array(); $o = 0;
	$atstartx = true;
	for($x = 0; $x < $width; $x++){
		$blankx = true;
		for($y = 0; $y < $height; $y++){
			if(imagecolorat($image, $x, $y) == 0){
				$blankx = false;
				break;
			}
		}
		if(!$blankx && $atstartx){
			$offsets[$o]['startx'] = $x;
			$atstartx = !$atstartx;
		}else if($blankx && !$atstartx){
			$offsets[$o]['endx']   = $x;
			$atstartx = !$atstartx;
			$o++;
		}
	}
	$count = $o;
	for($o = 0; $o < $count; $o++){
		for($y = 0; $y < $height; $y++){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['starty'] = $y;
				break;
			}
		}
		for($y = $height-1; $y > $offsets[$o]['starty']; $y--){
			$blanky = true;
			for($x = $offsets[$o]['startx']; $x < $offsets[$o]['endx']; $x++){
				if(imagecolorat($image, $x, $y) == 0){
					$blanky = false;
					break;
				}
			}
			if(!$blanky){
				$offsets[$o]['endy'] = $y;
				break;
			}
		}
	}
	for($o = 0; $o < $count; $o++){
		$offsets[$o]['ident'] = "";
		for($x = $offsets[$o]['startx'] + $gridstart; $x < $offsets[$o]['endx']; $x += $gridspace){
			for($y = $offsets[$o]['starty'] + $gridstart; $y < $offsets[$o]['endy']; $y += $gridspace){
				$offsets[$o]['ident'] .= ((imagecolorat($image, $x, $y) == 0) ? "0" : "1");
				#echo $offsets[$o]['ident'].'<br>';
			}
		}
	}
	return $offsets;
}
$a="";
foreach($letters as $letter){
$asciiletter = $database[$letter['ident']];
if(!empty($asciiletter)) {
$a.=$asciiletter;
}
}

I need bit of help, so I am looking into a plugin created for newsletter where default is it shows ad but it has option to remove ads by checking the check box. Default is to send ads in newsletter but if you don't want to send ads through newsletter then check the box. The problem is, it seems like checkbox selected is not being picked up. Some help would be appreciated.

The custom field in wp:

 

'label' => 'Hide newsletter ads',
           'name' => 'hide_ads', 
          'type'  => 'checkbox',
                'instructions'      => 'Checking the checkbox will remove ads',
                'required'          => 0,
                'conditional_logic' => 0,
                'wrapper'           => array(
                    'width' => '',
                    'class' => '',
                    'id'    => '',
                ),
                'choices' => array(
                    'Hide newsletter ads' => 'Hide newsletter ads',
                ),
                'allow_custom' => 0,
                'default_value' => array(
                ),
                'layout' => 'block',
                'toggle' => 0,
                'return_format' => 'value',
                'save_custom' => 0,
               ),

 

This is the php code for it:

  <!doctype html>
    <html lang="en-GB">
 <head>
<meta name="viewport" content="width=device-width" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="x-apple-disable-message-reformatting">
<title><?php the_title(); ?></title>
<style>
    <?php require ABSPATH . 'path/newsletter.css'; ?>
</style>
<!--[if mso]>
<style type="text/css">
.outlook-fallback-font {
    font-family: 'Lucida Bright', 'Cambria', -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, Oxygen-Sans, Ubuntu, Cantarell, "Helvetica Neue", sans-serif;
}
</style>
 <![endif]-->
 </head>

 <?php
$hide_newsletter_ads = get_field('hide_ads');
echo $hide_newsletter_ads;
?>

 <body itemscope itemtype="http://schema.org/EmailMessage">

 <div class="wrap">

    <?php
    if (!$hide_newsletter_ads) {
        include ABSPATH . 'path/ad-banner.php';
        }
    ?>
    <div class="header">
        <a href="<?php bloginfo( 'url' ); ?>">
            <img src="<?php echo get_home_url().'logo.png' ?>" alt="News" 
       />
        </a>
    </div>

    <?php
    if ( have_posts() ) :
        while ( have_posts() ) :
            the_post();
            ?>

            <?php if ( get_field( 'newsletter_summary' ) ) { ?>
                <div class="newsletter-summary"><?php the_field( 'newsletter_summary' ); ?></div>
            <?php } ?>

            <?php if ( have_rows( 'newsletter_content' ) ) : ?>

                <?php
                // Loop through the ACF blocks
                $count = 0;
                while ( have_rows( 'newsletter_content' ) ) :
                    the_row();

                    if ( get_row_layout() === 'story' ) :
                        ?>

                        <?php if ( 0 === $count ) { ?>
                            <span class="date outlook-fallback-font"><?php the_time( 'd M Y' ); ?></span>
                        <?php } ?>

                        <?php if ( get_sub_field( 'story_heading' ) ) : ?>
                            <h1><?php the_sub_field( 'story_heading' ); ?></h1>
                        <?php endif; ?>

                        <div class="content">
                            <?php the_sub_field( 'story_content' ); ?>
                        </div>

                        <?php
                    endif;

                    if ( 'post_list' === get_row_layout() ) :
                        ?>

                        <?php
                        $posts = get_sub_field( 'post_list' );
                        if ( $posts ) :
                            ?>

                        </div>
                        <div class="story-list">
                            <h2><span class="wrap"><?php the_sub_field( 'post_list_heading' ); ?></span></h2>
                            <div class="wrap-table">
                                <table width="100%" cellpadding="0" cellspacing="0" border="0">

                                    <?php
                                    // Output story cards
                                    foreach ( $posts as $i => $post ) {
                                        if ( 0 === $i % 2 ) {
                                            echo '<tr>';
                                        }

                                        $class = ( 0 === $i % 2 ) ? 'odd' : 'even';

                                        $image_src    = wp_get_attachment_image_src( get_post_thumbnail_id( $post->ID ), array( 640, 345 ) );
                                        $image_srcset = wp_get_attachment_image_srcset( get_post_thumbnail_id( $post->ID ) );
                                        echo sprintf(
                                            '<td class="story-cell %4$s" valign="top">
                                            <a href="%1$s" class="story-card outlook-fallback-font">
                                            <img src="%3$s" alt="" height="120" style="height: 150px; object-fit: cover;" />
                                            <span>%2$s</span>
                                            </a>
                                            </td>',
                                            esc_url( get_permalink( $post->ID ) . '?utm_source=newsletter&utm_medium=email&utm_campaign=newsletter' ), // permalink
                                            esc_html( get_the_title( $post->ID ) ), // title
                                            // esc_attr( $image_src[0] ), // image  - src
                                            esc_attr( $image_src[0] ), // image  - src
                                            esc_attr( $class ) // class
                                        );

                                        if ( 0 !== $i % 2 || count( $posts ) === ( $i + 1 ) ) {
                                            echo '</tr>';
                                        }
                                    }
                                    ?>

                                </table>
                            </div>
                        </div>
                        <div class="wrap">
                            <?php
                        endif;
                    endif;

                    if (!$hide_newsletter_ads) {

                     (0 === $count) {
                        include ABSPATH . 'path/mpu-1.php';
                    }

                    if (1 === $count) {
                        include ABSPATH . 'path/mpu-2.php';
                    }
                }

                    $count++;

                endwhile;

            endif;
            ?>

            <div class="footer">
                <table width="100%" cellpadding="0" cellspacing="0" border="0">
                    <tr>
                        <td align="left">
                            &copy;  <?php echo esc_html( date( 'Y' ) ); ?>
                        </td>
                        <td class="footer-link">
                            <a href="<?php echo get_permalink( get_page_by_path( 'privacy-policy' ) ); ?>">Privacy Policy</a> &middot;
                            <a href="%unsubscribe_url%">Unsubscribe</a>
                        </td>
                    </tr>
                </table>
            </div>

        </div>

        <?php
    endwhile;
endif;
?>

 

I'm trying to turn this while loop into a for loop and am unable to get my result set to display properly in the for loop.  The while works fine I just want to be able to have more control over which information is shown in my table as I loop and was wanting to use a for loop that way I can take advantage of the counter variable while i"m displaying my information.  Any help would be appreciated. 

while ($row = mysql_fetch_assoc($data_result_set)) {
            echo "<td>".$row["product_id"]."</td>";
            echo "<td>".$row["city"]."</td>";
            echo "<td>".$row["quantity"]."</td>";
            }


*** I'm wanting it to look like something like this but can't figure out how to properly work in which row to display with the $i variable.

$count=mysql_num_rows($data_result_set);

for($i = 0; $i <= $count; $i++){
echo "<td>".mysql_fetch_assoc[$i]["product_id"]."</td>";
            echo "<td>".mysql_fetch_assoc[$i]["city"]."</td>";
            echo "<td>".mysql_fetch_assoc[$i]["quantity"]."</td>";

}

I know the syntax for the for loop is totally off with the method mysql_fetch_assoc just dropped in there like a jerk but I'm just kinda pseudoing it out.

Any help would be appreciated.
Thanks in advance.