php¶ÁÊý¾Ý¿âÂÒÂë
<?php
// Á¬½Ó£¬Ñ¡ÔñÊý¾Ý¿â
$dbconn = pg_connect("host=localhost dbname=publishing user=www password=foo")
or die('Could not connect: ' . pg_last_error());
// Ö´ÐÐ SQL ²éѯ
$query = 'SELECT * from authors';
$result = pg_query($query) or die('Query failed: ' . pg_last_error());
// Óà HTML ÏÔʾ½á¹û
echo "<table>\n";
while ($line = pg_fetch_array($result, null, PGSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
// ÊͷŽá¹û¼¯
pg_free_result($result);
// ¹Ø±ÕÁ¬½Ó
pg_close($dbconn);
?>
http://php.chinaunix.net/manual/zh/ref.pgsql.php
ps:Ò³ÃæÉêÃ÷±àÂ룺ÔÚHTML´úÂëHEADÀïÃæ£¬¿ÉÒÔÓÃ<meta http-equiv="Content-Type" content="text/html;
charset="XXX" />À´¸æËßä¯ÀÀÆ÷ÍøÒ³²ÉÓÃÁËʲô±àÂ룬ĿǰÖÐÎÄÍøÕ¾¿ª·¢ÖÐÖ÷ÒªÓõÄÊÇGB2312ºÍUTF-8Á½ÖÖ±à
Âë¡£
ÌáÈ¡µÄÊý¾Ý±àÂëÓë "<META http-equiv=Content-Type content="text/html; charset=gb2312">" ÍøÒ³Ò³Ãæ
±àÂëÒ»ÖÂ,ÕâÑùÍøÒ³ÖоÍûÓÐÂÒÂëÁË¡£
$db->query("set client_encoding to 'gbk'");
Èç¹û²»Ïë¸ÄÅäÖÃÎļþ
ÔÚÒ³Ãæ´úÂëÖмÓÈëЧ¹ûÒ»Ñù!
ÔÀ´ÊÇÕâÑù£¬¿ÉÒÔÉèÖÿͻ§¶Ë±àÂëµÄ£¬ÎÒÒ»Ö±¸øÊý¾Ý¿â¶¨ÒåΪ
[code]
CREATE DATABASE hent
WITH OWNER = postgres
ENCODING = 'EUC_CN'
TABLESPACE = pg_default;
[/code]
¸ÄÈý¸öÅäÖÃÎļþ¼´¿É.Æäʵ´ó¼Ò¶¼ÖªµÀÊÇÄÄÈý¸öÁË.
php.ini my.cnf httpd.conf ¾ÍºÃÁË.°Ñ±àÂëÓйصͼÉèÖÃ³É utf-8¼´¿É.
µ«ÊÇ»¹²»ÐÐ.ÒòΪÎÒ°²×°ÁË. php-mbstring .ËùÒÔÔÚphp.iniÀïÃæÒ»¶¨Òª¿ªÆô mbstring ÇÒ±àÂëÒ²ÒªÉèÖóÉ
utf-8.
php.ini ;default_charset = "iso-8859-1" ¸Ä³É default_charset = "UTF-8"
<?
header('content-Type=text/html;charset=utf-8')
php
echo "t
Ïà¹ØÎĵµ£º
½«Ò»¸ö1άÊý×é·Ö¸î³É2άÊý×é array_chunk()
$input_array = array('a', 'b', 'c', 'd', 'e');
print_r(array_chunk($input_array, 2));
±È½Ï2¸öÊý×飬array_diff_assoc£¨£©»òÕßarray_diff£¨£©£¬Èç¹û·µ»ØÖµÎª¿Õ£¬±íʾÁ½¸öÊý×éÏàͬ£¬·ñÔò¾Í²»Í¬¡£
ÓÃÒ»¸öº¯ÊýÀ´¹ýÂËÊý×éÖеÄÊýÖµarray_filter()
functi ......
ÎÊÌ⣺
ÄãÏë´´½¨Ò»¸ö¶ÔÏ󣬲¢ÔÚÆäÖÐÌí¼ÓһЩÊôÐÔ£¬µ«ÊÇÄãÈ´²»Ïë°ÑËü×÷Ϊһ¸öÃ÷È·µÄÀàÕýʽµØ¶¨ÒåËü¡£ÕâÒ»µãÔÚһЩÇé¿öÏÂÊÇÏ൱ÓÐÓõģ¬ÀýÈçµ±ÄãÐèÒª¶¨ÒåÒ»¸ö·½·¨À´·µ»Ø´øÓÐijЩÊôÐÔ£¨²»È·¶¨µÄ£©µÄ¶ÔÏóʱ£¬¾ÍÈçͬ´Ómysql_fetch_object( ) »òÕß imap_header( )µÄʹÓÃÒ»Ñù¡£
һάÊý×é,ÎÒÏÖÔÚÌØ±ðϲ»¶°ÑËüд³É¶ÔÏó,ÒòΪ¼üÅÌ´ ......
Ò»¡¢ÒýÂÛ
PHP,Ò»ÃÅ×î½ü¼¸ÄêÐËÆðµÄwebÉè¼Æ½Å±¾ÓïÑÔ,ÓÉÓÚËüµÄÇ¿´óºÍ¿ÉÉìËõÐÔ,½ü¼¸ÄêÀ´µÃµ½³¤×ãµÄ·¢Õ¹,phpÏà±È´«Í³µÄaspÍøÕ¾,ÔÚËÙ¶ÈÉÏÓоø¶ÔµÄÓÅÊÆ,Ïëmssqlת6ÍòÌõÊý¾ÝphpÈçÐèÒª40Ãë,asp²»ÏÂ2·ÖÖÓ.µ«ÊÇ,ÓÉÓÚÍøÕ¾µÄÊý¾ÝÔ½À´Ô½¶à,ÎÒÃÇ¿ÊÇóÄܸü¿ìËٵĵ÷ÓÃÊý¾Ý,²»±ØÒªÃ¿´Î¶¼´ÓÊý¾Ý¿âµô,ÎÒÃÇ¿ÉÒÔ´ÓÆäËûµÄµØ·½,±È·½Ò»¸öÎļþ,»òÕßij¸ ......
phpÎļþ
<?php
mysql_connect("localhost","","");
mysql_query("set names 'gb2312'");
mysql_select_db("shop");
$sqlstr="select * from goods";
require 'smarty/libs/Smarty.class.php';
$smarty = new Smarty;//ÉèÖø÷¸öĿ¼µÄ·¾¶£¬ÕâÀïÊǰ²×°µÄÖØµã
$smarty->template_dir ="smarty/templates/templa ......
$ip = "1.1.1.255".chr(0)."haha";
if(ereg("^[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$",$ip)) {
echo $ip;
} else {
echo "unknown";
}
Õâ¸öeregÕýÔòÏÞÖÆÁË$ipµÄÊý¾ÝΪxxx.xxx.xxx.xxxÕâÑùµÄÐÎʽ£¬±íÃæÉÏ¿´ÉÏÃæµÄ´úÂëÓ¦¸ÃÊä³ö"unknown"£¬¶øÊµ¼ÊÈ´Êä³öÁË"1.1.1.255haha"£¬ÒòΪeregº¯Êý´æÔÚNULL½Ø¶Ï ......