<?PHP
//½ñÌìÓë2004Äê10ÔÂ27ÈÕÏà²î¶àÉÙÌì
$Date_1=date("Y-m-d");
$Date_2="2004-10-27";
$d1=strtotime($Date_1);
$d2=strtotime($Date_2);
$Days=round(($d1-$d2)/3600/24);
Echo "½ñÌìÓë2004Äê10ÔÂ27ÈÕÏà²î".$Days."Ìì";
Echo "<br>";
//½ñÌìµ½2008Äê9ÔÂ9ÈÕ»¹ÓжàÉÙÌì
$Date_1=date("Y-m-d");
$Date_2="2008-09-09";
$d1=strtotime($Date_1);
$d2=strtotime($Date_2);
$Days=round(($d2-$d1)/3600/24);
Echo "½ñÌìµ½2008Äê9ÔÂ9ÈÕ»¹ÓÐ".$Days."Ìì";
?>
//---------------------------------------------
$arrayStartDate =explode("/",$myStartDate);
$arrayEndDate = explode("/",$myEndDate);
  ......
PHP5Á¬½ÓMSSQL 2005µÄ·½·¨ Ò»¸öCaseÐèҪʹÓÃPHP5Á¬½ÓMS SQL Server 2005£¬ÕÒÁËЩ×ÊÁÏ×Ô¼º×ÁÄ¥ÁËÏ£¬¸ã¶¨ÁË.
»·¾³£º
- Apache 2.2.6
- PHP 5.2.5
- SQL Server 2005
- Windows XP SP2 ²½Ö裺 1. Ê×ÏȰ´Í¨³£×ö·¨ÅäÖúÃPHP5Á¬½ÓMS SQL Server
2. ÏÂÔØÕýÈ·°æ±¾µÄ ntwdblib.dll (2000.80.194.0)£¬µØÖ·£º http://webzila.com/dll/1/ntwdblib.zip
3. ¸²¸Ç apache2.2.6\bin\ntwdblib.dll
4. ¸²¸Ç php5.2.5\ntwdblib.dll
5. ÔËÐÐ SQL Server ÅäÖùÜÀíÆ÷£ºSQL Server Configuration Manager£¬´ò¿ªÐÒé Protocols
6. ÔÊÐíÃüÃû¹ÜµÀ "named pipes" ºÍ "tcp/ip"
7. ÓÒ¼üµã»÷ "tcp/ip"£¬´ò¿ªÊôÐÔ Properties ±êÇ© "IP addresses"
8. ÔÚ TCP ¶¯Ì¬¶Ë¿Ú "TCP Dynamic Ports" ÌîÈë 1433
9. ÖØÆô SQL Server¡¢ApacheºÍPHP
ʹÓÃÒÔÏ·½Ê½Á¬½ÓMS SQL Server 2005£º
mssql_connect('localhost,1433', USERNAME, PASSWORD); ----------------------------------------------------------------------------------------------- ÅäÖÃphp 1¡¢´ò¿ªphp.in½«extension=php_mssql.dllµÄ×¢ÊÍ·ûºÅÈ¥µô¡£ 2¡¢´ ......
ÏÔʾ½á¹û£º connect to MSSQL SERVER
±íTestÖÐÊý¾ÝΪ£º ¹íÁú ÄÐ 18 ¹í·ï ÄÐ 19 ÏÄÌì ÄÐ 18 ÏÄÓî ÄÐ 19 Zack ÄÐ 18 Dark ÄÐ 18 ÀäÙý ÄÐ 20 Ã×÷è÷ë ÄÐ 18 ½ðÔª·á ÄÐ 19 Å·Ñô¸É ÄÐ 19 ½ðÐãÒÁ ÄÐ 20 ÄÏѧ³¤ ÄÐ 20 Íô¶«³Ç ÄÐ 18 ÌÆÓíÕÜ ÄÐ 20 ------------------------------------------------------------------------- ......
Èç¹ûʵÏÖÁËPHPºÍMySQLÁ´½ÓÁË£¬PHPºÍMSSQLµÄÁ´½ÓÆäʵºÜ¼òµ¥£»
Ö§³ÖMSSQLµÄ±¾µØÁ´½ÓºÍÔ¶³ÌÁ´½Ó£¬ÒÔ±¾µØÁ´½ÓΪÀý£º
»úÆ÷Éϰ²×°ÁËMS SQLServer 2005£»
Á¬½ÓǰÅäÖÃϵͳ: 1.¼ì²éÎļþ php5.2.5\ntwdblib.dll ĬÈÏÏÂÃæÓÐÒ»¸ö,²»ÄÜÁ¬½ÓÔÙÌæ»». ÏÂÔØÕýÈ·°æ±¾µÄ ntwdblib.dll (2000.80.194.0)£¬µØÖ·£º http://webzila.com/dll/1/ntwdblib.zip
2.ÅäÖÃphp a¡¢´ò¿ªphp.in½«extension=php_mssql.dllµÄ×¢ÊÍ·ûºÅÈ¥µô¡£ b¡¢´ò¿ªphp.in½«mssql.secure_connection = Off¸ÄΪon¡£ c¡¢½«php_mssql.dll¿½±´µ½php.inÖÐextension_dir Ö¸¶¨µÄĿ¼»òÕßϵͳsystem32Ŀ¼Ï¡£(php_mssql.dllÔÚphpµÄѹËõ°²×°°üÖÐÓÐ)¡£ ÒÔÉϲ½ÖèÍê³ÉºóÐèÒªÖØÆôapache¡£ ×¢Ò⣺ʵ¼ÊʹÓÃÖз¢ÏÖ Èç¹ûͨ¹ýphpѹËõÎļþÊÖ¹¤°²×°phpµ½iisÏ£¬±ØÐëÖØÆô»úÆ÷¶ø²»½ö½öÊÇiis¡£ 3.ÅäÖÃsqlserver
a. ÔËÐÐ SQL Server ÅäÖùÜÀíÆ÷£ºSQL Server Configuration Manager£¬´ò¿ªÐÒé Protocols
b. ÔÊÐíÃüÃû¹ÜµÀ "named pipes" ºÍ "tcp/ip"
c. ÓÒ¼üµã»÷ "tcp/ip"£¬´ò¿ªÊôÐÔ Properties ±êÇ© "IP addresses"
d. ÔÚ TCP ¶¯ ......
1¸öServlet£ºSetCharacterEncodingFilter.java
package com.util;
import java.io.IOException;
import javax.servlet.*;
public class SetCharacterEncodingFilter implements Filter{
protected String encoding = null;
protected FilterConfig filterConfig = null;
protected boolean ignore = true;
public void destroy()
{
this.encoding = null;
this.filterConfig = null;
}
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException
{
if (ignore || (request.getCharacterEncoding() == null))
{
String encoding = selectEncoding(request);
if (encoding != null)
request.setCharacterEncoding(encoding);
}
chain.doFilter(request, response);
......
¾³£Óöµ½¹ØÓÚJSPÒ³ÃæÂÒÂëµÄÎÊÌ⣬ÔÚÍøÉÏÒ²²éÁËÏà¹ØµÄÌû×Ó£¬¹ÊÔÚ´Ë×ö¸ö¹ØÓÚJSPÒ³ÃæÂÒÂë´¦ÀíµÄ×ܽᣬºÍ´ó¼Òһͬ·ÖÏí¡£
Ê×ÏÈÏȽéÉܼ¸¸ö¹ØÓÚÒ³Ãæ±àÂë²ÎÊýÉèÖõÄÊôÐÔ¡£
<
META
http-equiv
=
Content
-Type
content
=
"text/html; charset=gb2312"
>
Õâ¾ä»°µÄÒâ˼ÊÇÄãä¯ÀÀÆ÷²é¿´ÍøÒ³µÄ±àÂ뷽ʽΪÖÐÎÄ£¬ÀàËÆÓÚä¯ÀÀÆ÷Éϲ鿴ѡÏîµÄ×Ö·û±àÂëÉèÖã¬Èç¹ûÄã²é¿´ÖÐÎĵÄÒ³Ãæ£¬ÄãÉèÖÃΪUTF8²é¿´µÄ»°£¬¾Í»áÏÔʾΪÂÒÂë»òÕß˵ÊÇÎʺš£ËùÒÔÕâ¸öÊôÐÔÖ»ÊÇÓÃÀ´ÉèÖÃä¯ÀÀÆ÷ÏÔʾÊý¾ÝµÄ×Ö·û±àÂë¡£
ÏÂÃæÎÒÃǾßÌå˵һÏÂÕâ¸öÊôÐÔ
META£¬ÍøÒ³HtmlÓïÑÔÀïHeadÇøÖØÒª±êǩ֮һ
HTTP-EQUIVÀàËÆÓÚHTTPµÄÍ·²¿ÐÒ飬Ëü»ØÓ¦¸øä¯ÀÀÆ÷һЩÓÐÓõÄÐÅÏ¢£¬ÒÔ°ïÖúÕýÈ·ºÍ¾«È·µØÏÔÊ¾ÍøÒ³ÄÚÈÝ¡£³£ÓõÄHTTP-EQUIVÀàÐÍÓУº
Content-TypeºÍContent-Language (ÏÔʾ×Ö·û¼¯µÄÉ趨)
˵Ã÷£ºÉè¶¨Ò³ÃæÊ¹ÓõÄ×Ö·û¼¯£¬ÓÃÒÔ˵Ã÷Ö÷Ò³ÖÆ×÷ËùʹÓõÄÎÄ×ÖÒÔ¼°ÓïÑÔ£¬ä¯ÀÀÆ÷»á¸ù¾Ý´ËÀ´µ÷ÓÃÏàÓ¦µÄ×Ö·û¼¯ÏÔʾpageÄÚÈÝ¡£
<
Meta
......