Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PHP²Ù×÷mysqlÊý¾Ý¿â¼òµ¥Ê¾Àý

ÏÈ´´½¨Ò»¸öÊý¾Ý¿âMyDB
CREATE DATABASE `mydb` ;
ÔÙ´´½¨Ò»¸ö¼òµ¥µÄÊý¾Ý±í
CREATE TABLE `MyDB`.`MyTable` (
`Name` VARCHAR( 20 ) NOT NULL ,
`Age` INT NOT NULL
) ENGINE = MYISAM
²åÈëһЩÊý¾Ý
INSERT INTO `mydb`.`mytable` (
`Name` ,
`Age`
)
VALUES (
'Jim', '15'
), (
'Amy', '16'
), (
'Jack', '12'
), (
'Mike', '21'
);
н¨Ò»¸öPHPÍøÒ³
<?php
$m_DB = mysql_connect("localhost","root","123"); //Á¬½ÓÊý¾Ý¿â
mysql_select_db("MyDB",$m_DB); //Ñ¡ÔñÒª²Ù×÷µÄÊý¾Ý¿â
$sql = "SELECT * from MyTable"; //¹¹Ôì²éѯÓï¾ä
$re = mysql_query($sql,$m_DB); //Ö´Ðвéѯ
while($row=mysql_fetch_array($re)){ //Ñ­»·Êä³öÊý¾Ý
print_r($row); //´òÓ¡³öÀ´
print("<br/>");
}
mysql_close($m_DB);
?>
ÔËÐнá¹ûÈçÏ£º
Array ( [0] => Amy [Name] => Amy [1] => 16 [Age] => 16 )
Array ( [0] => Jim [Name] => Jim [1] => 15 [Age] => 15 )
Array ( [0] => Jack [Name] => Jack [1] => 12 [Age] => 12 )
Array ( [0] => Mike [Name] => Mike [1] => 21 [Age] => 21 )


Ïà¹ØÎĵµ£º

PHPѧϰ±Ê¼Ç£¨Ê®Ììѧ»áPHP£©

Ò». 1. ǶÈë·½·¨£º »òÕß 2. Ó¦ÓÃÎļþ£º £¨1£©require("MyRequireFile.php")£º·ÅÔÚphp³ÌÐòµÄ×îÇ°Ãæ£¬ÔÚphp³ÌÐòÖ´ÐÐǰÒýÈë £¨2£©include("MyIncludeFile.php")£º·ÅÔÚÁ÷³Ì¿ØÖƵĴ¦Àí²¿·Ö£¬ÔÚÔËÐе½includeʱÔÙ¶ÁÈ¡½øÀ´ 3. ×¢ÊÍ·½·¨£º »ìºÏCºÍ»ã±à£º// £¬/* */£¬ #   4. ±äÁ¿ÀàÐÍ£º £¨1£©PHP±äÁ¿Ò ......

php ºº×Öת»¯³É ¶þ½øÖÆ Ê®½øÖÆ Ê®Áù½øÖÆ Êý×Ö

<?php
/**
* °ÑÒ»¸öºº×ÖתΪunicodeµÄͨÓú¯Êý£¬²»ÒÀÀµÈκο⣬ºÍ±ðµÄ×Ô¶¨Ò庯Êý£¬µ«ÓÐÌõ¼þ
* Ìõ¼þ£º±¾ÎļþÒÔ¼°º¯ÊýµÄÊäÈë²ÎÊýÓ¦¸ÃÓÃutf-8±àÂ룬²»È»Òª¼Óº¯Êýת»»
* ÆäʵÒà¿ÉÇáÒ×±àд·´Ïòת»»µÄº¯Êý£¬ÉõÖÁ²»¾ÖÏÞÓÚºº×Ö£¬Ææ¹ÖΪʲôPHPûÓÐÏֳɺ¯Êý
* @author xieye
*
* @param {string} $word ±ØÐëÊÇÒ»¸öºº ......

PHPѹËõÓë½âѹËõPCLZIP(±ê×¼°æ)

<?php
include_once('include/pclzip.lib.php');
$archive = new PclZip('archive.zip');
//½âѹËõµ½extract/folder/Õâ¸öĿ¼ÖÐ
$list = $archive->extract(PCLZIP_OPT_PATH, "extract/folder/");

//Ôö¼ÓÕâ¸öĿ¼ÔÚѹËõµµÖУ¬Íê³ÉÒÔºóѹËõµµÀïÃæ»áÓÐbackupÕâ¸öĿ¼£¬backupÀïÃæ»áÓÐÕâÁ½¸öµµ°¸ ......

MySQL collation·½·¨

ÎÊÌâÊÇÕâÑùµÄ£º
Ò»ÕÅtestµÄ±í£¬×Ö·û¼¯²ÉÓõÄlatin1¡£
select to_id from test where to_id='cnÏó_Íõ';
+---------------+
| to_id |
+---------------+
| cnÌÕ_ÌÕ |
| cnÏó_Íõ |
+---------------+
2 rows in set (0.00 sec)
È¡cnÏó_ÍõµÄÊý¾Ý,¾ÓÈ»°ÑcnÌÕ_ÌÕµÄÊý¾ÝҲȡ»ØÀ´ÁË¡£
ÕâÏÔÈ»ÊDz»ÔÊÐíµÄ¡£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ