PHPÏÔʾ´æÔÚMYSQLÖеĶàÕÅͼƬ - PHP / ¿ªÔ´×ÊÔ´
´ó¼ÒºÃ£¬ÎÒ°ÑͼƬ´æÔÚÁËMYSQLÊý¾Ý¿âÖУ¬ÏÖÔÚÎÒÏëÏÔʾÔÚWEBÒ³ÃæÉÏ¡£Åöµ½ÁËÁ½¸öÎÊÌâ¾ÍÊÇ 1£¬ÏÔʾͼƬµÄPHP´úÂë±ØÐ붥¸ñд£¬Ç°ÃæÈç¹ûÓдúÂëÊä³ö»òÓпոñÖ®Àà¾Í»áÊä³öÂÒÂë¡£´æÈëûÓÐÎÊÌ⣬ÎҾͲ»ÁгöÁË£¬ÏÔʾͼƬ´úÂëÏêϸÈçÏ£º
<?php
// Á¬½ÓÊý¾Ý¿â
$conn = mysql_connect("localhost", "root", "bowen");
mysql_select_db("books",$conn);
// Á¬½ÓÊý¾Ý¿â²éѯ
$sql="select * from image where id=111111";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result);
$row=mysql_fetch_object($result);
echo $row->photo;
mysql_free_result($result);
mysql_close($conn);
?>
ÒÔÉÏ´úÂëÊÇÕý³£µÄ£¬¿ÉÒÔÏÔʾһ¸öͼƬ£¬µ«Èç¹ûд³ÉÏÂÃæÕâÑù£¬¾Í»áÊä³öÂÒÂë¡£
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ÎÞ±êÌâÎĵµ</title>
</head>
<body>
<?php
// Á¬½ÓÊý¾Ý¿â
$conn = mysql_connect("localhost", "root", "bowen");
mysql_select_db("books",$conn);
// Á¬½ÓÊý¾Ý¿â²éѯ
$sql="select * from image where id=111111";
$result=mysql_query($sql);
$num_results=mysql_num_rows($result
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
»òÕßÔÚjsÎļþÀïµ÷ÓÃphpÎļþдµÄseesion£¿
PHP¸ÕÈëÃÅѧϰ,ÓÑÇ鶥һ¸ö
¼±Çó£ºÔÚphp½Å±¾ÀïÔõôµ÷ÓÃjsÎļþÀï·½·¨£¿
//echo '<script>alert("ok");< ......
ÊÇÓñðÈËдµÄÀà×öµÄ£¬»¹ÔʱÌáʾYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO admin(seq,passwd,type,n ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ
¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿
Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ
º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£
sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
ÍøÉϺöà¶þ¼¶Áª¶¯µÄ£¬Ö»ÊǶ¼Ã»ÓвÉÓÃAccessÊý¾Ý¿âµÄ£¬php²»ÊìϤ£¬ÓÐÁ½¸öÊý¾Ý±í·Ö±ðΪlb(Àà±ð£º±àºÅ£¬Àà±ðÃû³Æ£©into_product(²úÆ·¹ÜÀí£ºid,Ãû³Æ£¬Àà±ðµÈ×ֶΣ©
ÏëҪʵÏÖ£ºµÚÒ»¸öÏÂÀ²Ëµ¥Ñ¡ÔñÍêÀà±ðºó£¬µÚ¶þ²Ëµ¥¾Í°Ñ ......