In Excel: 40847 corresponds to 2011-10-31, which is a numeric representation of dates.
In PHP, echo date (' y-m-d h:i:s ', 40847);/Results 1970-01-01 11:52:30
Reason:
PHP's time function is calculated from the 1970-1-1 day, in seconds. But Excel
This article is mainly summarized for beginners who don't know anything about PHP features, so the demo code takes up more space. Let's see what you need to add. Welcome to the Mail or in Phpchina's "Phper" magazine section to correct the error. A
Converts the first letter of each word to uppercase: Ucwords ()Capitalize the first letter of a word: Ucfirst ()First letter to lowercase: lcfirst ()Capitalize all letters: Strtoupper ()
Example
The code is as follows
Copy Code
SQL has many statements to manipulate the database. But the common and comparative needs are so few statements. The UPDATE statement is used to modify data in a database table.
UPDATE table_name SET column1 = Value1,column2 = value2 ... WHERE
In PHP's original code installation package, into the etc/pdo_mysql. Let's say your PHP is installed in the/usr/local/php.
Execute/usr/local/php/bin/phpize
2. To compile
Database Tutorials
----Table structure for table ' category '--CREATE TABLE IF not EXISTS ' category ' (' id ' int (one) not NULL auto_increment,' Catpath ' varchar (255) DEFAULT NULL,' Name ' varchar (255) DEFAULT NULL,PRIMARY KEY (' id '))
The first line of code is a forced download;
The second line of code is to specify a name for the downloaded content;
The third line of code is to read the downloaded content into the file.
Prompts the user to save a generated PDF file (the
Generate thumbnails $c = Array (' dir ' => './images ', ' newdir ' => './thumb ', ' W ' => ', ' h ' => ' 200 ');Process only files that contain small in the file name, and if all files are processed, set to '. '$only = '. ';
Set this row to 0 if
// Double-precision data determinationIs_doubleIs_double -- is_float () aliasDescriptionThis function is an alias function of is_float. The code is as follows:Copy code $ Temperature = 15.23;If (is_double ($ Temperature )){ Print ("Temperature
1. Obtain the unix timestamp of the specified dateStrtotime ("2009-1-22") example:1. echo strtotime ("2009-1-22 ")Result: 1232553600Returns the January 22, 2009 00:00:00 timestamp.2. Obtain the date and time of the English textExample:For ease of
Php Tutorial date () convert mktime () to readable dateThe date/time function allows you to extract and format the date and time on the server.The mktime () function returns the unix timestamp of a date.The parameter always represents the gmt date,
Max () returns the maximum value.SyntaxMax (x, y) parameter descriptionX is required. A number.Y is required. A number.DescriptionMax () returns the maximum value in the parameter.If there is only one parameter and it is an array, max () returns the
Php Tutorial explode () functionPhp string functionDefinition and usageThe explode () function separates strings into arrays.SyntaxExplode (separator, string, limit) parameter descriptionSeparator is required. Specifies where to split the
In php Tutorial 5.2, the built-in filter module is used for variable verification and filtering.For more information about how to filter variables, see what I previously mentioned. Here we will look at how to filter user input directly.The
(1) dateUsage:Date (format, [time]);If there is no time parameter, the current time is used.The format is a string. The following characters have special meanings:U is replaced by the number of seconds since the start time (like January 1, 1970).Y
Many of my friends asked me how to use a php program to connect to a common class of SQL Server database. In fact, this is not very difficult. The key point is to be careful, patient, and understanding with passion.Class DB {Var $ Host = "192.168.0.1
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service