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
Ïà¹ØÎÊ´ð£º
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
PHPÖÐ ÉùÃ÷±äÁ¿µÄʱºòÒ»¸ö$¸úÁ½¸ö$µÄÇø±ð
±ÈÈç˵
$var="333"; ±íʾ±äÁ¿ÃûΪ$varµÄ±äÁ¿µÄֵΪ333
$var="myvar";$$var="333";±íʾ±äÁ¿ÃûΪ$myvarµÄ±äÁ¿µÄֵΪ333
ÕâÑù˵Çå³þÁËÂð£¿
......
ÊÇÓñðÈËдµÄÀà×öµÄ£¬»¹ÔʱÌáʾ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 ......