Filter And Display MySQL Information By - This Day, This Week, This Month?
Jun 23, 2011
I am working on a "Top Ranked" feature for my website. I need to display articles that were top ranked, but I want to show results from This Day, This Week, This Month, All Time and I really have no idea on how to do it. I have a field named creation_date which contains information about time when article was posted. And I somehow need to select information from database where creation_date is equal to This Day, This_Month, This_Week etc.I assume that I will select information from database like this:
SELECT * FROM articles WHERE creation_date = //What do I put here for different times? (day, week, Month, Alltime)//
Creating A Dashboard To Display Sales By Day, Week, Month, And Year ?
I'm trying to create a dashboard to tell me how much I've made last year, this year so far, overall in total, month, last month, week, and today. This is the coding i have so far..I cannt get day to work..it prints nothing, I havent even started on week (that looks scarey to code) as well as last year. So far overall sales, this month, and last month works.
Code: $total_sales = $db->select('SELECT SUM(`prod_total`) as `total_sales` FROM `'.$config['dbprefix'].'CubeCart_order_sum` WHERE `status` > 1 ;'); $quick_stats['total_sales'] = $total_sales['total_sales'];[code]....
Select Records From Today - This Week - This Month From Mysql Db
I'm trying to make a few pages - one which will contain results selected from my mysql db's table for today, this week, and this month. The dates are entered when the record is created with date('Y-m-d H:i:s');. Here's what I have so far:
day where date>(date-(60*60*24)) "SELECT * FROM jokes WHERE date>(date-(60*60*24)) ORDER BY score DESC"
week where date>(date-(60*60*24*7)) "SELECT * FROM jokes WHERE date>(date-(60*60*24*7)) ORDER BY score DESC"
month (30 days) where date>(date-(60*60*24*30)) "SELECT * FROM jokes WHERE date>(date-(60*60*24*30)) ORDER BY score DESC"
Sort And Filter Information By Categories From MySql To Web?
On my website I have a form where users can make articles. They Enter Title, Text and choose a category. The problem is that I don't know how to make the
"Select category thing".
Here is what I need to do. I need to have a <select> field with <option>'s, like "Home", "Education", "Cars" etc... So user selects his category and than clicks "Submit" button, which sends all the information to database. How do I make it so it sends selected category? SO I can than filter everything by category? Say I only want to display articles from "Home" category.
I need to determine the week of the month (1-5) so I can rotate menus for a cafeteria. Is the following, which I know prints the week rather than storing it, the simplest or easiest way to determine the week? PHP Code:
Has anybody here ever made or seen a function which when passed year and week number in that year returns month ?
actually what I want is all records from db starting from six months back till now and group them by weeks, and some weeks may have no record so they won't appear in resultset. But I have to display zero against these weeks.
display has to be in form of Number of Records in Week # x of Month y e.g Number of Records in Week 2 x of Month Jan So my solution is to get records from db by this query: .. where abs(Week(Now()) - Week(RecTime)) <= 26
this works ok but I don't have any idea of which month and week of month was 6 months ago. So I decided to get week number and year of 6 months back and then write my function get month form this info.
Possible Duplicate: PHP get number of week for month I want to get week of a month. In PHP I have date library which gives week of a year, but not the week of month. How to implement the same in php. At least give me a algorithm to implement the same.
Display For The Week Of (fridays Date Of The Week).
I have a report that people can access online and it generates data for a given week until friday. In the title and on the report, I want to display For The Week Of (fridays date of the week).
Instead of writing a huge if - then statement array - is it possible for to simply have an expression that figures out what day it is and then tells me Fridays date - has anyone ever done anything like this.
I want to display Week days by given week and year. Based on the week and year it display days and date. The following code display correctly current week and I can go next and prev. But if i change the week to 1 ..i get wrong date 1970!. I noticed it happens if the week is less 10. At week 10 the date start at March!
I'm trying to get the number of the month of the year by the number of a week of the year and the year.So for example week 1 is in january and returns 1, week 6 is in february so I want 2.I tried to go with date_parse_from_format('W/Y') but had no success (it's giving me errors).Is there any way to go with date_parse_from_format() or is there another way?
I'm working on daylight savings time around the world and the database I'm drawing the information from lists the start of daylight savings time with the month, day, week, hour, minute and second it starts.Initially I thought I could throw that information into mktime() and get the timestamp, however once I started doing it I realized the `week` part screws it all up. mktime is setup as mktime (hour, minute, seconds, month, day, year)So you can't add in the week of the month. So if I have the following information, anyone know how I can get a timestamp?
3 types of users. those that want e-mail every week, those that want it every 2 weeks, and those that want it every month. there's only one cronjob set for every week. so the every week e-mail isn't a problem. the way i figure. i need a text file to store the value PHP Code:
However, the documentation for strtotime is a bit weak and i'm not really understanding it. If I pass something like : 2006-12-24 00:00:00 through the query string, how can I find out what day in the month the first day of the week is (which should be December 18th)?.
I have a database of people, and they all have a "Birthday" field. It has the date in format "YYYY-MM-DD." I am needing to do a PHP/MySQL query to find anyone who's birthday month is MM. Is there a way to do this through MySQL, or do I have to fetch the results and sort through them with PHP?
Filter/Sort Through A Value With Three Associated Values (MONTH, DAY, And YEAR)?
I'm trying to filter through some images.Each image has 3 sets of values that I need to sort through collectively, MONTH, DAY, YEAR.I'm trying to figure out how to choose a specific a YEAR, DAY, and/or MONTH and then filter my list of images accordingly.This isn't homework. I don't study CS. I'm writing this in PHP, but your answer probably doesn't need php code for me to know what to do.I don't know that much about sorting algorithms. Perhaps someone could also point me to an interesting introduction to this topic as well?Just to make things more clear:I'd like to be able to go through it backwards or forwards, for example, if someone only selects one of the filters/values, like DAY, then the images displayed will be all those associated with that DAY, regardless of MONTH or YEAR.I have everything already written. It is a website with drop down menus, and when a user selects one item from the YEAR, DAY, or MONTH menus, I will repopulate the others accordingly.
I'm sure php is not the only programming language that supports mysql and thus allowing us to display database information onto a webpage. so...
1) What are some of the other languages available? 2) What advantages does PHP have over them?
I'm asking because I have to justify why I wrote my webpage in PHP and not some other language. To be honest it was just suggested to me that I use PHP and so I did, didn't really look into whether its good or not.