求解一个php难题 是一个时间比较有关问题
求解一个php难题 是一个时间比较问题
总是出的数据是0，是不是需要转换一下数据格式啊 数据库时间是年：月：日 小时分秒 ，我是不是需要转成年月日啊，关键是如何转换啊 小弟亏求
for ($i = 0; $i $tomorrow = mktime(0,0,0,date("m"),date("d")-$i,date("Y"));
$sql="select count(*) from customers_info where customers_info_date_account_created='".date("Y-m-d", $tomorrow)."'";
$result=mysql_query($sql,$conn) or
die("Error:".mysql_error);
$row=mysql_fetch_row($result);
echo $row[0]."
";
}
?>
------解决方案--------------------
$sql="select count(*) from amp_test where date between '".date("Y-m-d", ($tomorrow-3600*24))."' and '".date("Y-m-d", $tomorrow)."'";
输出：
1257292800select count(*) from amp_test where date between '2009-11-03' and '2009-11-04'2
1257206400select count(*) from amp_test where date between '2009-11-02' and '2009-11-03'1
1257120000select count(*) from amp_test where date between '2009-11-01' and '2009-11-02'0
我测试用的数据库里的格式是timestamp , 2009-11-04 11:13:25这种
------解决方案--------------------
可以使用DATE_FORMAT(your_field, '%Y-%m-%d') = ...来转换
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1359
52
How to create and name a file/folder based on current timestamp
Apr 27, 2023 pm 11:07 PM
If you're looking for a way to automatically create and name files and folders based on system timestamps, you've come to the right place. There is a super simple way to accomplish this task. The created folders or files can then be used for various purposes such as storing file backups, sorting files based on date, etc. In this article, we will explain in some very simple steps how to automatically create files and folders in Windows 11/10 and name them according to the system’s timestamp. The method used is a batch script, which is very simple. Hope you enjoyed reading this article. Section 1: How to automatically create and name a folder based on the current timestamp of the system Step 1: First, navigate to the parent folder where you want to create the folder,
PHP Warning: date() expects parameter 2 to be long, string given solution
Jun 22, 2023 pm 08:03 PM
When developing using PHP programs, you often encounter some warning or error messages. Among them, one error message that may appear is: PHPWarning:date()expectsparameter2tobelong,stringgiven. The error message means: the second parameter of the function date() is expected to be a long integer (long), but what is actually passed to it is a string (string). So, we
How to hide the select element in jquery
Aug 15, 2023 pm 01:56 PM
How to hide the select element in jquery: 1. hide() method, introduce the jQuery library into the HTML page, you can use different selectors to hide the select element, the ID selector replaces the selectId with the ID of the select element you actually use; 2. css() method, use the ID selector to select the select element that needs to be hidden, use the css() method to set the display attribute to none, and replace selectId with the ID of the select element.
Asynchronous processing method of Select Channels Go concurrent programming using golang
Sep 28, 2023 pm 05:27 PM
Asynchronous processing method of SelectChannelsGo concurrent programming using golang Introduction: Concurrent programming is an important area in modern software development, which can effectively improve the performance and responsiveness of applications. In the Go language, concurrent programming can be implemented simply and efficiently using Channels and Select statements. This article will introduce how to use golang for asynchronous processing methods of SelectChannelsGo concurrent programming, and provide specific
Introduction to methods and usage of using Date and SimpleDateFormat classes to process time in Java
Apr 21, 2023 pm 03:01 PM
1. Introduction The Date class in the java.util package represents a specific time, accurate to milliseconds. If we want to use our Date class, then we must introduce our Date class. Writing the year directly into the Date class will not produce the correct result. Because Date in Java is calculated from 1900, so as long as you fill in the first parameter with the number of years since 1900, you will get the year you want. The month needs to be subtracted by 1, and the day can be inserted directly. This method is rarely used, and the second method is commonly used. This method is to convert a string that conforms to a specific format, such as yyyy-MM-dd, into Date type data. First, define an object of Date type Date
How to implement change event binding of select elements in jQuery
Feb 23, 2024 pm 01:12 PM
jQuery is a popular JavaScript library that can be used to simplify DOM manipulation, event handling, animation effects, etc. In web development, we often encounter situations where we need to change event binding on select elements. This article will introduce how to use jQuery to bind select element change events, and provide specific code examples. First, we need to create a dropdown menu with options using labels:
How to get the millisecond representation of a date using the getTime() method of the Date class
Jul 24, 2023 am 11:42 AM
How to get millisecond representation of date using getTime() method of Date class In Java, Date class is a class used to represent date and time. It provides many useful methods to manipulate and obtain information about date objects. Among them, the getTime() method is an important method in the Date class, which can return the millisecond representation of the date object. Next, we will detail how to use this method to obtain the millisecond representation of a date, and provide corresponding code examples. Using the Date class
What are the options for calendar and date libraries in Python?
Oct 21, 2023 am 09:22 AM
There are many excellent calendar libraries and date libraries in Python for us to use. These libraries can help us handle date and calendar related operations. Next, I will introduce you to several common choices and provide corresponding code examples. Datetime library: Datetime is Python's built-in date and time processing module. It provides many date and time related classes and methods, which can be used to process dates, times, time differences and other operations. Sample code: importdatetime#Get the current date
