Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

(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íÃû °ó¶¨


Ïà¹ØÎÊ´ð£º

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......

ÎÊÒ»¸öPHPºÍsmartyµÄÈÕÆÚÎÊÌâ - PHP / »ù´¡±à³Ì

index.phpÄÚÈÝ£º
  $smarty->assign('name',strtotime('-0'));
  $smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......

Ïëѧphp - PHP / »ù´¡±à³Ì

Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡

ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ

Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â

php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£

È¥ÂòÊ¥¾­°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......

±±¾©2ÄêPHP¾­ÑéÇó¼æÖ° - PHP / Framework

±±¾©2ÄêPHP¾­ÑéÇó¼æÖ°
½Ó·Ö

·¹ý½Ó·Ö£¡.¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

jf~~~~~~~~~~~~~~Ö§³Ö

ßÀ¡£¡£ÎÒÃÇÐèÒª¼æÖ°£¬¿ÉÊÇÔõôÁªÏµÄãѽ£¿

¶¥¡£¡£¡£ »Ø¸´ÄÚÈÝ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡

º¼ÖÝÄãÈ¥²»È¥°¡ ¡£¡£¡£¡£¡ ......

PHP+MYSQLÊý¾Ý¼¯´¦Àí - PHP / »ù´¡±à³Ì

1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ