php´Ómssql¶ÁblobÀàÐÍÏÔʾͼÏñ - PHP / »ù´¡±à³Ì
ÒòϵͳÐèÇ󣬽«Í¼Ïñ·ÅÈëmssqlÖУ¬×Ö¶ÎÀàÐÍΪblob£¬Í¼ÏñΪjpgÀàÐÍ£¬ÈçÏ´úÂëÖ´ÐÐʱ²¢²»ÄÜÕýÈ·Êä³öͼÏñ£¬Âé·³¸÷λ°ï濴һϣ¬·Ç³£¸Ðл!!
<?php
include_once("db.class.php");
// retrieving
$db = new odbc_conn();
$result = $db->res("SELECT Img_Th_data from LB_IMG ");
$row = odbc_fetch_array($result);
$data = $row['Img_Th_data'];
header('Content-type: image/jpg');
echo "</br>[Img_Th_data]:</br>";
print $data;
?>
¸ÐлÀÏ´óµÄ´ð¸´¡«¡«
echo "</br>[Img_Th_data]:</br>";
Õâ¸öÖ»ÊÇÎÒµ±Ê±µ÷ÊÔʱ¼ÓÉϵıêʶ£¬Ó¦¸ÃûӰÏ죬ȥÁËÖ®ºó»¹ÊDz»ÄÜÏÔÊ¾ÄØ
лл£¬ÎÒÒѾµ÷ÊÔºÃÁË
Ïà¹ØÎÊ´ð£º
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
mssql_select_db("f1",mssql_connect("localhost","sa","sa"));
mssql_select_db("f2",mssql_connect("192.168.0.1","sa","sa") ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
phpÖÐÈçºÎÊä³öǧ·Öλ·Ö¸ô·û¡£¡£¡£¡£¡£
number_format
PHP code:
//ÊÇÕâÖÖЧ¹û°É£¿
echo number_format(123123123, 2, '.', ',');
//½á¹ûÊä³ö123,123,123.00 2ÊÇСÊýµãºóλÊý£¬µÚÈý¸ö²ÎÊýÊÇСÊýµã·Ö¸ô·û ......