Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 > $


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sql ËÑË÷Óï¾ä - .NET¼¼Êõ / ASP.NET

<table style="width: 1000px"><tr>
  <td style="height: 38px; width: 35px;">
  ÐÕÃû</td>
  ......

Î人ÄÄÀïPHPÅàѵ±È½ÏÕý¹æ - PHP / »ù´¡±à³Ì

¹ýÍêÄêҪȥÎ人ÁË£¬ÏëÁ˽âÒ»ÏÂPHPÅàѵ±È½ÏÕý¹æ?

Ŷ ¶ÔÁË£¬»¹ÓУ¡PHPÊÖ²á±ØÐëµÃŪһ¸ö

àÅ ÌìÌìÔÚ¿´Ê¥¾­£¨Ò»ÌìÒ²¾ÍÖ»ÄÜ¿´¸ö¶þʮҳ£©£¬PHP100ÊÓÆµ½Ì³Ì¿´ÁË33½²ÁË£¨Ò»ÌìÒ²Ö»¿´Ò»½²£©
ÎÒ»á¼á³Ö°ÑÕâ±¾ÊéºÍÊÓÆµ¸ã¶¨ ......

Çó½ÌPHPÖÐstr_replaceº¯ÊýÎÊÌâ - PHP / »ù´¡±à³Ì

ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ