PHP - Converting Month Number To Word Month

Hello everyone

I am coding a membership system for my usersystem on my website and I needed a little help. I have searched around quite a bit and can't find a working code.

In my database I have the date the VIP was purchased and I was wondering if anyone had a code which would check if they've had VIP for over a month and if so, delete it from the database.

I'm new-ish to MySQL and PHP and can't seem to code a working one. 

I'm trying to get a total number from the db where the month is the same and the ip is different.
This is a stats script that someone else wrote, and I'm just trying to get a month-to-month total.

Right now, it pulls the information out and displays the month with how many different ips came that month, the problem is, it lists like this:

June - 41 - 41

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 1 - 1

June - 9 - 9

June - 2 - 2

June - 2 - 2

June - 2 - 2

June - 1 - 1

June - 3 - 3

June - 2 - 2

June - 4 - 4

June - 1 - 1

June - 13 - 13

June - 154 - 154

what I need to do is grab all those numbers and give a total for that month, in this case, June.

This is my query
Code: [Select]
$query = "SELECT date, COUNT(referrer)'referrer' FROM app_analytics WHERE appid = $userid AND date BETWEEN '" .$y_month . "' AND '" . $t_month . "' GROUP BY referrer ORDER BY date";

Can anybody help out?

Thanks in advance

Hello. I want to generate the initial of the day of all the days of a chosen month. Meaning, if I choose this month it will give me:

TFSSMTWTFSSMTWTFSSMTWTFSSMTWTF

Is that clear? Can anybody help me? thanks!

OK, since today is the 31st, I guess I figured out that strtotime("-1 Month') really only goes back 30 days, so where I think it should be September, its registering October 1st. Is there a fix for this?
Code: [Select]
$month = date('F Y', strtotime("-1 month"));
$month1 = date('F Y', strtotime("-2 month"));
$month2 = date('F Y', strtotime("-3 month"));
$month3 = date('F Y', strtotime("-4 month"));
$month4 = date('F Y', strtotime("-5 month"));
$month5 = date('F Y', strtotime("-6 month"));

Hi, I m trying to extract data by month from my date table.
my date format 2011-03-28

my query

$sql = "select * from table WHERE MONTH(date) = 03 " 


Now problem is i have many records in 3rd month but it only display the first row with above $sql. How can i see all month records.
Thanks

delete

Hi, this one has me stumped!

For some reason February refuses to show up in my calender, that is, month 2 reads as march as well as month 3 (being correct).

Here is my code which is fine except for this silly bug:


$month = $_GET['month'] ;

$year = $_GET['year'] ;

if(!$month) $month = date('n') ;

if(!$year) $year = date('Y') ;

$days = cal_days_in_month(CAL_GREGORIAN, $month, $year) ;

echo "<div style='width:100%;text-align:center;font-size:1.3em;font-weight:bold;'>" ;

if($month == 1) echo "<a href=\"?month=12&year=" . ($year-1) ;

else echo " <a href=\"?month=" . ($month-1) . "&year=" . $year ; 

echo "\"><img style='border:none;' width='16' src='prev-month.png' /></a>" ;

echo " Classes for " . date("F, Y", strtotime("$year-$month")) . "\n" ;

if($month == 12) echo "<a href=\"?month=1&year=" . ($year+1) ;

else echo " <a href=\"?month=" . ($month+1) . "&year=" . $year ;

echo "\"><img style='border:none;' width='16' src='next-month.png' /></a>\n" ;

echo "</div>\n" ;

for($i=1;$i < 8;$i++) { // Create day headers...

echo "<div style='float:left;width:110px;margin:20px 5px 0px 5px;text-align:center;background:#1552ff;color:white;border:1px solid #155BFF;'>" . date("l", strtotime("$year-$month-$i")) . "</div>\n" ;

}

for($i=1; $i < $days+1;$i++) { // Create days...

$result = mysql_query("SELECT *

   FROM classes

   WHERE DAY(classDate) = '$i'

   AND MONTH(classDate) = '$month'

   AND YEAR(classDate) = '$year'")or die(mysql_error()) ;

$classCount = mysql_num_rows($result) ;

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

$classes .= $row['title'] . "<br />" ;

}

echo "<div style='float:left;width:104px;height:104px;margin:0px 5px 0px 5px; border:1px solid #155BFF;border-top:none;cursor:pointer;padding:3px;' onmouseover=\"this.style.background='#ffbdec';\" onmouseout=\"this.style.background='none';\" title=\"" . str_replace('<br />', "\n\n", $classes) . "\" alt=\"" . str_replace('<br />', "\n\n", $classes) . "\">\n" ;

echo "<div style='float:left;height:84px;width:104px;'>\n" ;

echo "<span style='font-weight:bold;'>$i</span><br />\n" ;

echo "<span style='font-size:0.7em;'>" ;

echo $classes ;

echo "</span></div>\n" ;

echo "<div style='float:left;height:20px;width:104px;text-align:center;'>\n" ;

echo "<a href='#' style='font-size:0.7em;'>click to book a class</a>\n" ;

echo "</div>\n" ;

echo "</div>\n" ;

$classes = '' ;

}


working example he www.caketopper.co.uk/2011/class-schedule.php

Hi,

I am having set of records,
id       
name
dob

1  philip         1278226800
2  winsent     1278216800
3  Benn          1272226800


now i want to fetch the records based on the month and listing out, can anyone help me to write for the above concept.

Thanks,

Hello this code is supposed to sort by year and month, but it doesn't.  It sort by year and months are random.  Any suggestions?  Many thanks,

$sortdata =[];
        $namecolumn = array_column($data, '0');
        foreach($data as $datecolumn){
            $dateexplode = explode('/', $datecolumn[3]);
            $sortdata[] = (isset($dateexplode[1])) ? $dateexplode[1] : ((isset($dateexplode[0])) ? $dateexplode[0] : '');
    
        }
        array_multisort($namecolumn, (($sorttype=='DESC') ? SORT_DESC : SORT_ASC), $sortdata, (($sorttype=='DESC') ? SORT_DESC : SORT_ASC), $data);

            

Edited May 13 by Barand
code tags added

I'm trying to get a bar graph from total number of hit on a month to month basis.

Everything works out find, except the bar graph is only showing 1 month, not everything that's being pulled out of the db.

Can anybody look and see what I'm doing wrong?

Code: [Select]
$userid = '44';
$t_month = date("Y-m-d h:i:s");
$y_month = date("Y-m-d h:i:s", strtotime("-1 Year"));

//Grabs Unique Visitors to App Page
$query = "SELECT CONCAT_WS(' ', YEAR(date), MONTHNAME(date)) AS RptDate, COUNT(DISTINCT referrer) 'referrer'
FROM app_analytics
WHERE appid = $userid
AND date BETWEEN '" .$y_month."'  AND  '" .$t_month."'
GROUP BY CONCAT_WS(' ', YEAR(date), MONTHNAME(date))
ORDER BY YEAR(date), MONTH(date)";

    $result = mysql_query($query) or die(mysql_error());       
        //$totals = array();
        while($row = mysql_fetch_array( $result )){
           
            $months = date("M", strtotime($row['RptDate']));
            $ip = $row['referrer']; 
             
           $values = array("$months" => $ip);
     
    $img_width=450;
$img_height=300;
$margins=20;

 
# ---- Find the size of graph by substracting the size of borders
$graph_width=$img_width - $margins * 2;
$graph_height=$img_height - $margins * 2;
$img=imagecreate($img_width,$img_height);

 
$bar_width=20;
$total_bars=count($values);
$gap= ($graph_width- $total_bars * $bar_width ) / ($total_bars +1);

 
# -------  Define Colors ----------------
$bar_color=imagecolorallocate($img,0,64,128);
$background_color=imagecolorallocate($img,240,240,255);
$border_color=imagecolorallocate($img,200,200,200);
$line_color=imagecolorallocate($img,220,220,220);
 
# ------ Create the border around the graph ------

imagefilledrectangle($img,1,1,$img_width-2,$img_height-2,$border_color);
imagefilledrectangle($img,$margins,$margins,$img_width-1-$margins,$img_height-1-$margins,$background_color);

 
# ------- Max value is required to adjust the scale -------
$max_value=max($values);
$ratio= $graph_height/$max_value;

 
# -------- Create scale and draw horizontal lines  --------
$horizontal_lines=20;
$horizontal_gap=$graph_height/$horizontal_lines;

for($i=1;$i<=$horizontal_lines;$i++){
$y=$img_height - $margins - $horizontal_gap * $i ;
imageline($img,$margins,$y,$img_width-$margins,$y,$line_color);
$v=intval($horizontal_gap * $i /$ratio);
imagestring($img,0,5,$y-5,$v,$bar_color);

}
 
 
# ----------- Draw the bars here ------
for($i=0;$i< $total_bars; $i++){
# ------ Extract key and value pair from the current pointer position
list($key,$value)=each($values);
$x1= $margins + $gap + $i * ($gap+$bar_width) ;
$x2= $x1 + $bar_width;
$y1=$margins +$graph_height- intval($value * $ratio) ;
$y2=$img_height-$margins;
imagestring($img,0,$x1+3,$y1-10,$value,$bar_color);
imagestring($img,0,$x1+3,$img_height-15,$key,$bar_color);
imagefilledrectangle($img,$x1,$y1,$x2,$y2,$bar_color);
}
 
header("Content-type:image/png");
imagepng($img);
 } 

Thanks in advance

Hi guys, i was having an issue with dates and although it leans a bit more into MYSQL I was hoping i could get some help ive searched all over the net for this so I dont know if im not thinking on how to ask this correctly or can't find it, but ill be as detailed as possible and hope that helps.   Ok I have a table that shows when payment was received on past invoices dating back to say 1995;  The company processes 'ALL' invoices every month on the 9th, so if anything comes in from the first to the ninth it will be processed that month on the ninth.  If it comes in from the tenth to the thirtieth or thirty-first it will be processed the following month.   The table already has a "Received" date filed and now I want to create a column on the table called "Processed Date" (adding the column is no problem don't need help with that part) that shows me the date we processed the invoice.   I know i have to use the "Received" field (because it shows what day the invoice was put into the system) but im not sure how to format the "Processed Date" field, so say the "Received" field shows an invoice came in on  '1995-05-11', I want the "Processed Date" field to display it was payed on '1995-06-09' (notice that is the following month).   I thought i would put in a visual of what I was trying to do below:   So if I pull the two columns in MYSQL from that table I would see something like this:   Received                Processed Date 1996-02-03            1996-02-09 1996-03-03            1996-03-09 1996-04-11            1996-05-09 1996-05-20            1996-06-09 1996-07-13            1996-08-09   If i could get some guidance/help on this i would really appreciate it.   thanks in advance!!   JL

Ok, so I have made 12 columns in mysql for each month.........I will have an event manager page that you can select each month that the event will take place in 0 is false 1 is true.........so I need to know how I can edit this code so that if the current month equals whatever month is checked, it will display..........is there a way to do this????????or would I need to use a date format instead of varchar and use a format such as yyyy-mm-dd and value = 0000/mm/00 so that only the month will display and then it could equal current month? Code: [Select]
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{

   $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $startdate, $enddate) = $row;
  
      $as .= "<p><a href=\"viewevent.php?eventid=$eventid\">$startdate - $enddate --- $event</a></p>\r\n";
   }


   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);
   $startdate = $row['startdate'];
      $enddate = $row['enddate'];
     $location = $row['location'];
   $description = $row['description'];
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];
$title1 = $row['title1'];
$title2 = $row['title2'];
$title3 = $row['title3'];
$title4 = $row['title4'];
$title5 = $row['title5'];
$title6 = $row['title6'];
$title7 = $row['title7'];
$title8 = $row['title8'];
$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
$date1 = $row['date1'];
$date2 = $row['date2'];
$date3 = $row['date3'];
$date4 = $row['date4'];
$date5 = $row['date5'];
$date6 = $row['date6'];
$date7 = $row['date7'];
$date8 = $row['date8'];
}
?> Code: [Select]
<table width="410" border="1" cellspacing="0" cellpadding="0">
    <tr>
      <td width="339" bgcolor="#999999" scope="col">EVENTS</td>
    </tr>
    <tr>
      <td class="afasd"><?php echo date("F",strtotime("-0 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="adfaf"><?php echo date("F",strtotime("+1 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
    <tr>
      <td class="jasdfjs"><?php echo date("F",strtotime("+2 month")); ?></td>
    </tr>
    <tr>
      <td><?php echo $as; ?></td>
    </tr>
  </table>
does this make sense?

Okay so I have a time in the format yyyy-mm-dd that is pulled from a MySQL array row and I need to add one month to it then echo that out. I assume it has something to do with the strtotime() and date() functions but I have tried every combination and cannot figure it out. Can I get some assistance please and thank you? Very very very new to php.

Here is what I have lol;
Code: [Select]
$row=mysql_fetch_array($result);
$ddaterow=$row['donation_date'];
Like I said the date will always be in the format yyyy-mm-dd

Thanks to aleX_hill and RussellReal for the help so far. I'm trying to utilise the code before to find the next month. However, it needs to be used with the current year. So I altered the below


<?php
$nextMonth = date("m") + 1;
$daysInNextMonth = date("t",mktime(0,0,0,$nextMonth));
echo $daysInNextMonth;?>


to

#NEXT MONTH
$nextMonth = date("m") + 1;
echo $nextMonth; 
$daysInNextMonth = date("t",mktime(0,0,0,$nextMonth));
echo $daysInNextMonth ;
$year = date("o"); 
echo $year;


I can then pass it into my url query like so:

<a href="<?php echo $url_path; ?>after=<?php echo $year; ?>-<?php echo $nextMonth;  ?>-01&before=<?php echo $year; ?>-<?php echo $nextMonth;  ?>-<?php echo $daysInNextMonth; ?>">Next Month</a>


Brilliant I thought, until it comes to December 2010, the next month needs to be January 2011. Now I'm bamboozled. How do I get around this one?

Many thanks, your help is always appreciated!

Hi,   I'm new to php,   I'm trying to get the month value from a date stamp (ie I have a variable with the following sort of value: 2014-08-20 07:32:20 )   how do I create a new variable with just the month values (ie 08) of the date stamp??   any help would be appreciated.   Thanks !