°ïæ¿´ÏÂÄÄ´íÁË£¬phpÁ¬½Ómysql£¡£¡£¡£¡
ËÀÑ»·£¬Ö»Êä³öµÚÒ»Ìõ¼Ç¼£¬Ó¦¸ÃûÎÊÌâ°¡£¬ÊDz»ÊÇÈí¼þ·½ÃæÒýÆðµÄ°¡£¿Á¬½ÓÊý¾Ý¿âÖеÄÓиö±í¿ÉÒÔÕý³£Êä³ö¡£
PHP code:
<?php
$host="172.19.29.168";
$name="root";
$pswd="123";
$link=mysql_connect($host, $name, $pswd) or die("ÎÞ·¨Á¬½Ó£¡".mysql_error());
mysql_select_db("mou_lib",$link);
$sql=mysql_query("select * from books");
$row = mysql_fetch_array($sql);
while($row)
{
echo $row['bID']." ".$row['title']." ".$row['press']."<br />";
}
mysql_close($link);
?>
PHP code:
<?php
$host="172.19.29.168";
$name="root";
$pswd="123";
$link=mysql_connect($host, $name, $pswd) or die("ÎÞ·¨Á¬½Ó£¡".mysql_error());
mysql_select_db("mou_lib",$link);
$sql=mysql_query("select * from books");
while($row = mysql_fetch_array($sql)) //mysql_fetch_array($sql)Òª·ÅÔÚwhile裡
{
echo $row['bID']." ".$row['title']." ".$row['press']."<
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
¸÷λ´óЩ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ
¼Û¸ñ²»ÒªÌ«ÀëÆ×¾ÍÐÐ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
PHP code:
$date = '2009-12-25';
$ptn = '/([\d]{4})[- \/](0?[\d]|1[0-2])[-\/ ](0?[\d]|[1-2][\d]|3[0-1])/';
if (preg_match($ptn,$date,$out))
{
print_r($out);exit();
}
½á¹ûΪ:
PHP code:
......