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

¼¸ÖÖ³£ÓÃPHPÁ¬½ÓÊý¾Ý¿âµÄ´úÂë

PHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMYSQLÊý¾Ý¿â´úÂë < ?php   
$mysql_server_name='localhost'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿â·þÎñÆ÷  
$mysql_username='root'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÓû§Ãû  
$mysql_password='12345678'; 
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃÜÂë  
$mysql_database='mycounter';
//¸Ä³É×Ô¼ºµÄmysqlÊý¾Ý¿âÃû  
$conn=mysql_connect($mysql_server_name,
$mysql_username,$mysql_password,
$mysql_database);   
$sql='CREATE DATABASE mycounter 
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;   
';   
mysql_query($sql);   
$sql='CREATE TABLE `counter` 
(`id` INT(255) UNSIGNED NOT NULL
AUTO_INCREMENT ,`count` INT(255)
UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY
( `id` ) ) TYPE = innodb;';   
mysql_select_db($mysql_database,$conn);   
$result=mysql_query($sql);   
//echo $sql;   
mysql_close($conn);   
echo "Hello!Êý¾Ý¿âmycounterÒѾ­³É¹¦½¨Á¢£¡";   
?> 
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓACCESSÊý¾Ý¿â´úÂë·½·¨ < ?  
$conn = new com("ADODB.Connection");   
$connstr = "DRIVER={Microsoft
Access Driver (*.mdb)};
DBQ=". realpath("data/db.mdb");  
$conn->Open($connstr);   
$rs = new com("ADODB.RecordSet");   
$rs->Open("select *
from szd_t",$conn,1,1);  
while(! $rs->eof) {   
$f = $rs->Fields(1);   
echo $f->value;   
$rs->MoveNext();   
}   
?>
¸´ÖÆ´úÂëPHPÁ¬½ÓÊý¾Ý¿âÖ®PHPÁ¬½ÓMS SQLÊý¾Ý¿â´úÂë·½·¨
1.°²×°SQL·þÎñÆ÷²¢Ìí¼ÓPHPµÄMSSQLÀ©Õ¹
2.ʹÓÃÒÔÏ´úÂëÁ¬½Ó²¢²âÊÔ < ?php   
$myServer = localhost; //Ö÷»ú  
$myUser = sa; //Óû§Ãû  
$myPass = password; //ÃÜÂë  
$myDB = Northwind; //MSS


Ïà¹ØÎĵµ£º

[ת]Ðø ¡°´´ÔìÊÀ½çÉÏ×î¼òµ¥µÄ php¿ª·¢Ä£Ê½¡±

¡¡¡¡“¼¼ÊõÎÊÌâ¶¼ÊÇ¿ÉÒÔ½â¾öµÄ£¬¼¼ÊõÎÊÌâ²»ÊÇ×î×îÖØÒªµÄ”
¡¡¡¡ ×î½ü°ï¹ýһЩÈ˽â¾ö¼¼ÊõÎÊÌ⣬·¢ÏÖÒ»¸öºÜÑÏÖØµÄÎÊÌ⣬ËûÃǵÄ×ö·¨ºÍÎÒ×ʼд³ÌÐòµÄʱºòÊÇÒ»ÑùµÄ£¬ÕâÑùÏÂÈ¥»á×ߺöàµÄÍä·¡£ÏÖÔÚÓÐÒ»Àà³ÌÐòԱ̫¶à£¬ËûÃÇ×ÜÊÇһζµÄ×·Çó“ËùνµÄ¼¼ÊõÄѵ㔣¬×ÜÊǰÑÐÄÊ·ÅÔÚһЩ±ß±ß½Ç½ÇµÄ“³ÌÐò´úÂë ......

PHP֪ʶ»ýÀÛ

1 ÔÚSQLÓï¾äÖпÉͨ¹ýÌí¼ÓÏÞÖÆÌõ¼þ:left(text,20)ֻȡtextÎı¾µÄǰ20¸ö×Ö;
¡¡¡¡2 ¿ÉÒÔÓÃlimit fromRecord, RecordNum À´×÷Ϊ·ÖҳʹÓÃ,±ÈÈçlimit 0,30±íʾ´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼±éÀú30¸ö¼Í¼;
¡¡¡¡3 Á½¸ö±íµÄÁ¬½Ó¿ÉÒÔÊÇ£ºtable1 join table2 using x(xΪÁ½¸ö±íµÄ¹«¹²×Ö¶Î),»òÕßÊÇtable1 join table2 on table1.x = table2.x
¡¡¡ ......

PHPÊý×Ö¼ÓÃܽâÃÜÀà

<?php
/* ----------------------------------------------------------------------------
* Script Name: encrypt.php
* Creation Date: 2008-4-7 10:36
* Last Modified: 2008-4-12 16:00
* Author: meyu
* Copyright (c) 2007
* Purpose: Êý×Ö×Ö·û´®¼òÒ×¼Ó½âÃÜ
* --------------------------------- ......

php ²»Ö§³ÖÖÐÎÄÎļþÃûµÄ´¦Àí

×î½üдһ¸ö¹ØÓÚ¶ÁÈ¡ÖÐÎÄÎļþÃûµÄСCASEÖÐÓöµ½Á˲»PHP²»Ö§³ÖÖÐÎÄÎļþÃûµÄÎÊÌâ
ÎҵĻ·¾³£º
WINDOWS+Appach +mysql
phpÒ³ MYSQL¾ùΪ±àÂëUTF-8
½â¾ö·½·¨ÈçÏ£º
ÔÚMYSQLÖÐÈ¡³öµÄÖÐÎÄÎļþÃûת»»Æä±àÂë
$fileName=iconv("UTF-8","GBK",$fileName); ......

linux·þÎñÆ÷ÓÃPHPµÄPDOÁ´½Ómyql·½·¨(php pdo)

PDOΪºÎÎï
POD£¨PHP Data Object£©À©Õ¹ÔÚPHP5ÖмÓÈ룬PHP6Öн«Ä¬ÈÏʶÓÃPDOÁ¬½ÓÊý¾Ý¿â£¬ËùÓзÇPDOÀ©Õ¹½«»áÔÚPHP6±»´ÓÀ©Õ¹ÖÐÒÆ³ý¡£¸ÃÀ©Õ¹ÌṩPHPÄÚÖÃÀà PDOÀ´¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬²»Í¬Êý¾Ý¿âʹÓÃÏàͬµÄ·½·¨Ãû£¬½â¾öÊý¾Ý¿âÁ¬½Ó²»Í³Ò»µÄÎÊÌâ¡£
ÎÒÊÇÅäÖÃÔÚwindowsÏÂ×ö¿ª·¢Óõġ£
PDOµÄÄ¿±ê
ÌṩһÖÖÇáÐÍ¡¢ÇåÎú¡¢·½±ãµÄ API
ͳ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ