PHP ½Å±¾ ²»Ö§³Ö PDO->PREPARE()Óï¾ä?
ÖªµÀµÄÀ´ËµÏÂ.
ÎÒÔÚ PHP ½Å±¾ÖÐʹÓÃ
$pdo = new PDO('mysql:yangxianxueya;host:127.0.0.1;' , 'root' , '');
$pdo->prepare('INSERT INTO category (?) VALUES (?)');
var_dump($statement);
$statement->execute(array('name','123'));
ûÓÐÖ´Ðгɹ¦.
ͬʱ˵ php ½Å±¾Öв»Ö§³Ö $pdo->prepare?
´íÎóÌáÊ¾ÄØ£¿
ҪװPDOµÄÀ©Õ¹
½Ó¸ö·Ö
Ö§³Ö µ«ÄãûװPDOÀ©Õ¹
×°ÁË, ÎÒÓà prepare ('select') Óï¾ä¼Ó bindparam ¶¼ÊÇ¿ÉÒÔÔËÐеÄ, µ«ÊÇÔÚÖ¸¶¨ INSERT Óï¾ä¾Í²»ÐÐ
¸ø¸ö´íÎóÌáʾ¿´ÏÂ
//$db->prepare('SELECT * from user where id=:id or id <:id ');
//$db->bindParam(':id','2');
//$db->execute();
ÉÏÃæ¿ÉÔËÐÐ
function insert($table = '' , $array = array())
{
if(empty ($array)) return false;
$count = count($array);
$question = '?' . str_repeat(',?', $count - 1);
$sql = 'INSERT INTO '.$table .' ('. $question .') VALUES ('. $question .')';
$this->prepare($sql);
foreach($array as $k=>$v)
{
$i = 1; <
Ïà¹ØÎÊ´ð£º
ÎÒÓÃPHPÀ©Õ¹Cʱ£¬ÓõÄÊÇÔ´ÂëextĿ¼ÏµÄ./ext_skel
×îºó±àÒë×ÜÊDz»ÄÜÉú³ÉÀ©Õ¹Ä£¿éµÄ.so¶¯Ì¬¿â£¬ÎÒÓõİ汾ÊÇ5.3.0£¬
ÕâÊÇÔõô»ØÊ£¬¸ßÊÖ½â´ðÏÂ
²»ÄÜÉú³ÉʱÓÐɶÌáʾÐÅÏ¢£¿
ÔËÐÐÁË/ext_skel --extname=Ä ......
<?php
if($_SERVER['HTTP_REFERER']!=''){
@header("Content-type:image/jpeg");
echo file_get_contents("xlight.jpg");
}
else{
@header("location:ht ......
ÇëÎÊһϸ÷λ´óϺ£¬ÎÒÓÃphp×ö¸öÍøÒ³ÓÎÏ·£¬µ±È»ÊÇ×îÀ¬»øµÄÄÇÖÖhtmlµÄ£¬
ÏÖÔÚÎÒÏë°ÑËùÓÐÍæ¼ÒºÍ¹ÖÎnpcµÄÊý¾Ý´¢´æ£¬
µ±È»£¬Êý¾Ý¿âÖе±È»ÓУ¬µ«ÊÇÎÒÓÖ²»Ïë¹ý¶àµÄÈ¥²éѯÊý¾Ý¿â£¬
±ÈÈçÕ½¶·ÏµÍ³£¬¿Ï¶¨ÒªÏȳõʼ»¯Ë«·½Êý ......
Ïë°Ñhttp://www.abc.com/aa/bb/aa.php
ÖØÐ´³Éhttp://www.abc.com/aa.php ŪÁ˰ëÌìÒ²²»ÖªµÀÈçºÎŪ¡«¡«
Õâ¸ö¿ÉÒÔʵÏÖô
RewriteRule ^([a-z0-9]+)\/([a-z0-9]+)\/([a-z0-9]+)\.php$ $3.php [L,QSA]
Òý ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......