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 > $
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
<table style="width: 1000px"><tr>
<td style="height: 38px; width: 35px;">
ÐÕÃû</td>
......
¹ýÍêÄêҪȥÎ人ÁË£¬ÏëÁ˽âÒ»ÏÂPHPÅàѵ±È½ÏÕý¹æ?
Ŷ ¶ÔÁË£¬»¹ÓУ¡PHPÊÖ²á±ØÐëµÃŪһ¸ö
àÅ ÌìÌìÔÚ¿´Ê¥¾£¨Ò»ÌìÒ²¾ÍÖ»ÄÜ¿´¸ö¶þʮҳ£©£¬PHP100ÊÓÆµ½Ì³Ì¿´ÁË33½²ÁË£¨Ò»ÌìÒ²Ö»¿´Ò»½²£©
ÎÒ»á¼á³Ö°ÑÕâ±¾ÊéºÍÊÓÆµ¸ã¶¨ ......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......