php mysqli ʹÓÃprepare
1£¬°ó¶¨²ÎÊý
$mysqli=new mysqli($host,$user,$pass,$db);
if(mysqli_connect_errno()){
echo 'Á¬½Ó³öÏÖÒì³£ÁË:'.mysqli_connect_error();
exit(0); }
$sql = 'insert into user(name,pass,email) values(?,?,?)';
$stmt = $mysqli->prepare($sql);
$stmt->bind_param('sss',$name,$paassword,$email);
$name= '2';
$paassword=md5('12345');
$email = 'iamtsgx08@google.com';
$stmt->execute();
echo 'ÐÞ¸ÄÁË'.$stmt->affected_rows.'ÐÐ';
$stmt->close();
$mysqli->close();
2£¬°ó¶¨½á¹û¼¯
$sql = 'select name,pass,email from user';
if($stmt = $mysqli->prepare($sql)){
$stmt->execute();
$stmt->bind_result($name,$pass,$email); //°ó¶¨½á¹û
echo "<table>";
while($stmt->fetch()){
echo "<tr>";
echo "<td>".$name."</td>";
echo "<td>".$pass."</td>";
echo "<td>".$email."</td>";
echo "</tr>";
}
echo "</table>";
$stmt->close();
}
&nbs
Ïà¹ØÎĵµ£º
ÄÚÈÝÕªÒª£ºRSS ¾ÛºÏ×î½ü·Ç³£Á÷ÐУ¬Òò´ËÖÁÉÙ¶Ô RSS ¼°Æ乤×÷·½Ê½ÓÐËùÁ˽âÊÇÒ»Ãû PHP ¿ª·¢ÈËÔ±µÄÆÈÇÐÐèÒª¡£±¾ÎĽéÉÜÁË RSS »ù´¡ÖªÊ¶¡¢RSS ÖÚ¶àÓÃ;ÖеÄһЩÓÃ;¡¢ÈçºÎʹÓà PHP ´ÓÊý¾Ý¿â´´½¨ RSS ÌáÒª£¬ÒÔ¼°ÈçºÎʹÓà XML_RSS Ä£¿é¶ÁÈ¡ÏÖÓÐ RSS ÌáÒª²¢½«Æäת»»Îª HTML¡£
¡¡¡¡Ê²Ã´£¿ÄúûÌý˵¹ý RSS£¿
¡¡¡¡RSS ¾ÛºÏÊÇ×î³£¼ûµÄ ......
index.php:
$smarty = new Smarty;
$smarty->assign('Contacts',
array('555-222-9876',
'zaphod@slartibartfast.com',
array('555-444-3333',
'555-111-1234')));
$smarty->display('index.tpl');
index.tpl:
{$Contacts[0]}<br>
{$Contacts[1]}<br>
{* you can print arrays of arrays ......
<?php
/***************************
* Ò»¸ö·Ç³£ÊµÓøöÐԵķÖÒ³Àà *
****************************
*****************************ʵÀý***********************************
if(!isset($_GET['page'])){$page = 0;}else{$page = $_GET['page'];}
$pagedemo = new pageclass;
$pagedemo->set ......
ÆóÒµ½¨Õ¾×ÔÖú¹ÜÀíϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬¼¯Ò×ÓÃÐÔºÍÇ¿´ó¹¦ÄÜΪһÌåÆóÒµ½¨Õ¾ÏµÍ³£¬¾ßÓзḻ¶à²ÊµÄÍøÕ¾ÆóÒµ½¨Õ¾Ä£°æ£¬Áé»îµÄÀ¸Ä¿¹ÜÀíºÍÎÄÕ¡¢Í¼ÎÄ¡¢ÏÂÔØ¡¢¹ã¸æµÈ¹ÜÀí¹¦ÄÜ£¬Ö§³ÖÔĶÁȨÏÞ¿ØÖƺͻáԱȨÏÞ¹ÜÀí£¬Ö§³ÖHTML¾²Ì¬ÍøÒ³Éú³ÉºÍ¶àÓïÑÔ£¬¿ÉÓÃÓÚ´´½¨¸÷ÖÖÆóÒµÍøÕ¾½¨Éè¡£
Ò»¡¢Ö÷Òª¹¦ÄÜÄ£¿é
»áÔ± ......
×ÛºÏÍøµêϵͳÊÇÓÉEÒ×ÍøÂç(68ws.cn)»ùÓÚphp+mysql¿ª·¢£¬¼æÈݸ÷ÀàÉÌÆ·µÄ·¢²¼¡¢Õ¹Ê¾ºÍ¶©¹º¡£³ýÁ˾ßÓÐÍêÉƵÄÉÌÆ·ÀàÐ͹ÜÀí¡¢ÉÌÆ·¹ÜÀí¡¢ÅäËÍÖ§¸¶¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢»áÔ±·Ö×é¡¢»áÔ±¹ÜÀí¡¢²éѯͳ¼ÆºÍ¶àÏîÉÌÆ·´ÙÏú¹¦ÄÜ£¬»¹¾ßÓÐÍêÕûµÄÎÄÕ¡¢Í¼ÎÄ¡¢ÏÂÔØ¡¢µ¥Ò³¡¢¹ã¸æ·¢²¼µÈÍøÕ¾ÄÚÈݹÜÀí¹¦ÄÜ¡£ÏµÍ³¾ßÓо²Ì¬HTMLÉú³É¡¢UTF-8¶àÓïÑÔÖ§³ ......