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 > $
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
--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 ......