PHP - Turning Mktime() Into Month/day/year?

How to acheive it friends? i want my current codes to show results accouding to current  month followed by year, the precious  month goes to the page two.   would really appreciate if someone could help me acheive it  

 $tableName="records";        

    $targetpage = "sales.php";     

    $limit = 1000;

    $cur_month = date("Y-m");


         $query = "SELECT COUNT(*) as num FROM $tableName  WHERE Customer_Status = 'Sale' AND DATE_FORMAT(Date, '%Y-%m') = '$cur_month' ORDER BY id DESC";

    $total_pages = mysql_fetch_array(mysql_query($query));

    $total_pages = $total_pages[num];

    

    $stages = 1;

    $page = mysql_escape_string($_GET['page']);

    if($page){

        $start = ($page - 1) * $limit;

    }else{

        $start = 0;    

        }    

    

    // Get page data

    $query1 = "SELECT id, Date, User, Team, Transfer_Number, Agent_Name, Cell_Phone, Customer_Name, Customer_Status FROM $tableName WHERE Customer_Status = 'Sale' AND DATE_FORMAT(Date, '%Y-%m') = '$cur_month' ORDER BY id DESC LIMIT $start, $limit";

    $result = mysql_query($query1);

    

    // Initial page num setup

    if ($page == 0){$page = 1;}

    $prev = $page - 1;    

    $next = $page + 1;                            

    $lastpage = ceil($total_pages/$limit);        

    $LastPagem1 = $lastpage - 1;    

    

    $paginate = '';

    if($lastpage > 1)

    {    

    $paginate .= "<div class='paginate'>";

        // Previous

        if ($page > 1){

            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";

        }else{

            $paginate.= "<span class='disabled'>previous</span>";    }

                

        // Pages    

        if ($lastpage < 7 + ($stages * 2))    // Not enough pages to breaking it up

        {    

            for ($counter = 1; $counter <= $lastpage; $counter++)

            {

                if ($counter == $page){

                    $paginate.= "<span class='current'>$counter</span>";

                }else{

                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

            }

        }

        elseif($lastpage > 5 + ($stages * 2))    // Enough pages to hide a few?

        {

            // Beginning only hide later pages

            if($page < 1 + ($stages * 2))        

            {

                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

                $paginate.= "...";

                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";

                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        

            }

            // Middle hide some front and some back

            elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))

            {

                $paginate.= "<a href='$targetpage?page=1'>1</a>";

                $paginate.= "<a href='$targetpage?page=2'>2</a>";

                $paginate.= "...";

                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

                $paginate.= "...";

                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";

                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        

            }

            // End only hide early pages

            else

            {

                $paginate.= "<a href='$targetpage?page=1'>1</a>";

                $paginate.= "<a href='$targetpage?page=2'>2</a>";

                $paginate.= "...";

                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

            }

        }

                    

                // Next

        if ($page < $counter - 1){

            $paginate.= "<a href='$targetpage?page=$next'>next</a>";

        }else{

            $paginate.= "<span class='disabled'>next</span>";

            }

            

        $paginate.= "</div>";        

        

}



echo "Total Records:".$total_pages;

echo '<br/><br/>';

 // pagination

 echo $paginate;


 }

Edited by lovephp, 02 December 2014 - 11:50 AM.

Hi,

I've got a date picker on a form which puts data into a database in the YYYY-MM-DD format. Just wondering how I could also put the name of the month (extracted from that) as well as just the year into separate columns. Ie: To use the field race_date from the form to also fill the 'race_month' and 'race_year' columns in the database.

This code obviously only fills the 'race_date' column so far:
Code: [Select]

global $_POST;

$race_date = $_POST["race_date"] ;


....



$query = "INSERT INTO 10k_races (race_date, race_month, race_year)" . "VALUES ( '$race_date', '$race_month',  '$race_year')";

Hi,   I want to display my data in this format  format.JPG   54.52KB   0 downloads   Expense data i am getting like this

 <td><?php
	$in = "SELECT sales_invoice.invoice_id as INID, DATE_FORMAT(sales_invoice.date_invoiced,'%M') AS month, sales_invoice_line_items.invoice_id, SUM(sales_invoice_line_items.sub_total) AS Total, SUM(sales_invoice_line_items.tax_amount) AS total_tax FROM sales_invoice INNER JOIN sales_invoice_line_items ON sales_invoice.invoice_id=sales_invoice_line_items.invoice_id GROUP BY sales_invoice.invoice_id, DATE_FORMAT(sales_invoice.date_invoiced, '%Y-%m')";
	
	$in1 = mysql_query($in) or die (mysql_error());
	$total=0;
	$tax =0;
	while($income = mysql_fetch_array($in1))
	{
		
		$total +=$income['Total']; 
		$tax +=$income['total_tax'];
		echo $total - $tax; }
    ?>
    
    </td>

And Profit i am getting like this

<td><?php
	$in = "SELECT purchase_invoice.invoice_id as INID, DATE_FORMAT(purchase_invoice.date_invoiced,'%M') AS month, purchase_invoice_line_items.invoice_id, SUM(purchase_invoice_line_items.sub_total) AS Total, SUM(purchase_invoice_line_items.tax_amount) AS total_tax FROM purchase_invoice INNER JOIN purchase_invoice_line_items ON purchase_invoice.invoice_id=purchase_invoice_line_items.invoice_id GROUP BY purchase_invoice.invoice_id, DATE_FORMAT(purchase_invoice.date_invoiced, '%Y-%m')";
	
	$in1 = mysql_query($in) or die (mysql_error());
	$total=0;
	$tax =0;
	while($income = mysql_fetch_array($in1))
	{
		
		$total +=$income['Total']; 
		$tax +=$income['total_tax'];
		echo $total - $tax; }
    ?>
    
    </td>

I dont know how to display data like this. Do i need to change the the table structure in my database? Please suggest

Hello. I have a mysql database with an 'entrytime' field which contains the unix timestamp the record was added.

How do I create a mysql query to select all records for a given month/year?

For example, if I wanted to create a query to display all records for October 2010 how do I go about it?

I am at a loss and can't find my answer via google. Thanks in advance for any help!

I have a file upload script that will eventually process a ton of files.  I would like to upload them into sub-directories according to what year, month, and day they are uploaded.     A typical tree should look like this:   attachments/ --/2014 -----/January --------/01 --------/02 --------/03 , etc. -----/February --------/01 --------/04 --------/09 --------/18 --------/20, etc -----/March, etc --/2015, etc.   So a file called image.jpg uploaded on 10/31/2014 would have a URL of attachments/2014/October/31/image.jpg.  I understand that every time a file is uploaded, the script would have to detect through FTP whether or not folders for the year, month, and day exist, and if they don't create them.  My problem is that I have no idea what the logic of this script would be.  What order should I do things in?  Is there a way to use maybe foreach to detect/create the folders?  Any input would be appreciated.    

Hello. I'm new to pHp and I would like to know how to get my $date_posted to read as March 12, 2012, instead of 2012-12-03.
Here is the code:
Code: [Select]
<?php

$sql = " SELECT id, title, date_posted, summary FROM blog_posts ORDER BY date_posted ASC LIMIT 10 ";

$result = mysql_query($sql);

while($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$title = $row['title'];
$date_posted = $row['date_posted'];
$summary = $row['summary'];

echo "<h3>$title</h3>\n";
echo "<p>$date_posted</p>\n";
echo "<p>$summary</p>\n";
echo "<p><a href=\"post.php?id=$id\" title=\"Read More\">Read More...</a></p>\n";
}

?>
I have tried the date() function but it always updates with the current time & date so I'm a little confused on how I get this to work.

Hi,

I'm wanting to find rows whose date is within the next week of the current month of the current year. The format of the date is, for example: 2010-10-28

Any ideas guys?

Thanks lots!

Hello, i have two fields.  a beginning year and an ending year.  How can i make new fields out of the years in between the beginning and ending years.  i hope that makes sense. 

Trying to get the below to generate the month in word form from a numeric entry in a database.
Code: [Select]
elseif($_GET['rma']=="calander"){
$sql101010="SELECT DISTINCT rma_year_issued FROM $tbl_name4 ORDER BY rma_year_issued";
$result101010=mysql_query($sql101010);
while($row101010=mysql_fetch_array($result101010)){
extract($row101010);
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'">'.$rma_year_issued.'</a>
<br />';
}

if(isset($_GET['year'])){
$logout.=' | <a href="./acp_admincp.php?rma=calander">Back to RMA Calander</a>';
$rma_year_issued=$_GET['year'];
$sql111010="SELECT DISTINCT rma_month_issued FROM $tbl_name4 WHERE rma_year_issued='$rma_year_issued' ORDER BY rma_month_issued";
$result111010=mysql_query($sql111010);
while($row111010=mysql_fetch_array($result111010)){
extract($row111010);
$months = array('Janurary', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December');
for($i=0; $i <=11; $i++){
if($rma_month_issued=$i){
$rma_month_issued2=$months[$i];
}
}
$content="";
$content.='<a href="./acp_admincp.php?rma=calander&year='.$rma_year_issued.'&month='.$rma_month_issued.'">'.$rma_month_issued2.'</a>
<br />';

}
}
}

Basically in the data base I may have 2,5,7 under the year 2011.

I want to get the numeric months into words for use in the text of the link.

The above is returning December even though the entry in the database is 5.

Hi..

I need help in getting the 3 Months Name from my table field FromMonth and ToMonth.
Here is the scenario.

First, I select FromMonth and ToMonth.
Ex.
FromMonth = 5
ToMonth = 7
So it means
FromMonth is May
ToMonth is July.

Now I save the MonthNumber to my database:

table- so_month
FromMonth = 5
ToMonth = 7

Now I need to get the between Months Name from FromMonth to ToMonth which are (May, June, July).

How does it possible?
Thank you so much.

So I am creating a list of events.  There will be a drop down menu to change between months.  I only want the months to be listed if an event during that month exists.

So if I have events listed for September and November, list only September and November, skipping October.  Any idea on how to approach this or if there are any functions for such a thing?

My friend a I have to different numbers when we echo mktime(0,0,0,5,12,1990).

How is this possible?

I thought that only, we you leave some parameters blank, the local this is used, else, it's standardized.

thanks in advance

how do I use strtotime() instead of mktime()?

$matchTimea = mktime($mHour, $mMinute, 0, $mMonth, $mDay, $mYear);

if($matchTimea-time() < $cutoffTimea*60)
{

New user of PHP here! I'm using it to display entries from my MYSQL database. Image below.



This is the code snippet that displays information from the 'name', 'author' and 'date' columns of my database. I learned this technique from w3schools.

$result = mysql_query("SELECT * FROM levels ORDER BY date DESC");

while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['author'] . "</td>";
echo "<td align='right'>" . $row['date'] . "</td>";
echo "</tr>";
}

I would like to use the date() function to format the date differently. But the date() function requires that I convert my time into a timestamp. I know you have to use the mktime() function for this, but I don't know how.

Can someone show me how to pass the contents from $row[date] into the mktime() function?