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

php +sql server ·ÖÒ³ÎÊÌâ

ÏÂÃæÊÇÓÃÍøÉÏËÑÀ´µÄÒ»¶Î´úÂë
<html> 
<head> 
<title>PHP·ÖÒ³</title> 
</head> 
<body> 
<? 
//ΪÁ˱ãÓÚÀí½âºÍ¸ü¿ìµØÓ¦Óõ½¹¤×÷ÖÐÈ¥£¬ÎÒÃÇÒÔMS SQL ServerµÄNorthWindÊý¾Ý¿âCustomers±íΪÀý¡£ 
$gPageSize= 10; //ÿҳÏÔʾµÄ¼Ç¼Êý 
$hostname = "localhost"; //MSSQL Server 
$dbuser = "sa"; //Óû§Ãû 
$dbpasswd = "sa"; //ÃÜÂë 
//Á¬½ÓÊý¾Ý¿â 
$id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("ÎÞ·¨Á¬½ÓÊý¾Ý¿â·þÎñÆ÷£¡"); 
//Ñ¡ÔñÊý¾Ý¿â£¬ÎªÁË·½±ã£¬ÕâÀïÒÔMSSQL ServerµÄNorthWindÊý¾Ý¿âΪÀý 
$db = mssql_select_db("library",$id) or die("ÎÞ·¨Á¬½ÓÊý¾Ý¿â£¡"); 
//ÒÔCustomers±íΪÀý,¹¹½¨²éѯ×Ö·û´® 
$query = "select Bcode,name,id from v_book where name like '%ËÕ¶«ÆÂ%'"; 
//Ö´ÐвéѯÓï¾ä 
$rresult = mssql_query($query) or die("ÎÞ·¨Ö´ÐÐSQL£º$query"); 
//$page±äÁ¿±êʾµ±Ç°ÏÔʾµÄÒ³ 
if(!isset($page)) $page=1; 
if($page==0) $page=1; 
//µÃµ½µ±Ç°²éѯµ½µÄ¼Í¼Êý $nNumRows 
if(($nNumRows= mssql_num_rows($rresult))<=0) 

echo "<p align=center>ûÓмͼ"; 
exit; 
}; 
//µÃµ½×î´óÒ³ÂëÊýMaxPage 
$MaxPage = (int)ceil($nNumRows/$gPageSize); 
if((int)$page > $


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......

³ÏÕÐÓо­ÑéµÄPHP¹¤³Ìʦ£¨¿É¼æÖ°) - PHP / »ù´¡±à³Ì

1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......

php »ñÈ¡Ò³ÃæÄÚÈÝ - PHP / »ù´¡±à³Ì

Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ