(php±¨´í£©Number of bind variables doesn't mat
Number of bind variables doesn't match number of fields in prepared statement
´úÂëÈçÏ£º
<?php
$mysqli = new mysqli("localhost","root","123456", "gfgd",3308);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$admin1 = "admin";
/* create a prepared statement */
if ($stmt = $mysqli->prepare("SELECT * from admin a WHERE a.admin_no=?"))
{
/* bind parameters for markers */
$stmt->bind_param("s", $admin1);
/* execute query */
$stmt->execute();
/* bind result variables */
$stmt->bind_result($district);
echo $district;
/* fetch value */
//$stmt->fetch();
/* close statement */
$stmt->close();
}
/* close connection */
$mysqli->close();
?>
?>
SELECT * from admin a WHERE a.admin_no=?"Õâ¸öÊDz»ÊÇÉÙ¸öas?
²»ÓÃasÒ² ¿ÉÒÔ£¬Ö»ÊDz»ÖªµÀÂ¥Ö÷Ïë¸ÉÂï
ÉÙÁ˸öas ÊÇʲôÒâ˼£¬Çë½Ì¡£ ÎÒ¶Ôphp²»ÊǺÜÊì
Ô¤´¦Àí£¿
¾ÍÊÇÔ¤´¦Àí°¡
$stmt->bind_param("s", $admin1);
Õâ¸öµØ·½ °ó¶¨µÄÓ¦¸ÃÊǸö±äÁ¿ ¶ø²»ÊDZíÃû °ó¶¨
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......