MySQL Query on timestamp using PHP
In this example I had to create a query only to display orders for the last 90 days.
The orders table is using a standard MySQL timestamp field to store the date of the order. I made timestamp indexed since we will be doing this query against this field.
I figured the easiest way was to only query those 90 days, that way I didn’t have to worry about looking at each row and comparing a date during output. All I had to worry about was creating the right query.
The first line simply is the number of days to go back in the query, in this case the number of days is 90.
The next 2 lines are used to create and format our new date 90 days in the past.
In the query we simply select all records that are newer than our 90 day old date.
$daysback = 90;
$accessdate = strtotime(“-$daysback days”,time());
$mysqldate = date( ‘Y-m-d H:i:s’, $accessdate );$myquery = “select id,ordernumber,timestamp from tblorders where (timestamp > ‘$mysqldate’);”;
CubeCart 5 Beta
When we opened our e-commerce store almost 2 years ago I spent a lot of time researching shopping cart software. Now I knew this would be both an important decision. Shopping cart software is a major influence on the success (or failure) of any e-commerce website.
Tasapspider/0.9
Just found this “bot” going crazy on a site that is on a dedicated server, took the entire server offline. This bot looks to be new and from China, so be on the lookout.
Other reports are saying it is ignoring the robots.txt file, so might not be good enough to deny it there.
It was coming from 218.28.29.236
Here are more details about that IP, and what ranges you might want to block.
http://whois.domaintools.com/218.28.29.236
I placed the following in my .htaccess file
order allow,deny
deny from 218.28.
deny from 218.29.
allow from all
Please post a comment if you this bot has hit your site.
Short Meta Descriptions Can Kill Your Website
If you look at the graph above you will see the nice steady growth of a website. Then suddenly a drop! The site in question dropped from an average of over 100 unique visitors per day down to less than 5 per day. Quite a significant drop! Once I was sure the drop was going to stick, I made a few minor changes and then just left the site alone for a long time. Yes, I was disappointed, but it was not something I had time or ambition to address at the time.
Note: you will see on the chart short regain of traffic, but this seems to be a normal “blip” that can happen as rankings are sorted out across Google data centers.
Fast forward a month or so, and I am looking in through the webmaster tools, and happen to notice the HTML suggestions section under Diagnostics. There I see a line that says: “Short meta descriptions x,xxx”, which is just about every single page of the site. Immediately I fix the problem with the meta descriptions.
The Google Word on Meta Descriptions
Tracking Email Marketing Results
Find out if users are reading and responding to your email newsletters. This simple method will determine a direct correlation between newsletter clicks and sales.
Website backups
How to automate website backups.
Follow this very simple procedure to schedule your website backups. You will be glad you did.
Share your thoughts..