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; <
Ïà¹ØÎÊ´ð£º
ÎÒÃÇÁ¥ÊôÖпÆÔº¼ÆËãËùÍøÂçÖØµãʵÑéÊÒ(http://www.ict.ac.cn/survey/channel/detail443.asp)»ù´¡ÉèÊ©¿ÎÌâ×é.
ÏÖÒòÏîÄ¿ºÍÒµÎñÍØÕ¹µÄÐèÒª,ÌØÐèÒªÕÐÆ¸ÓëÏîÄ¿Ïà¹ØµÄÍøÂçÓ¦Óù¤³Ìʦ1-2Ãû¡£
¾ßÌåÒªÇóÈçÏ¡£ÓÐÒâÕß ......
Çë½Ìexcel µÄ±àÂëÎÊÌâ
excelÖдæÔÚ Î÷°àÑÀÓÖÐÎÄ£¬Ó¢Ó¶íÓï °¢À²®ÓµÈ¶àÖÖÓïÑÔ php ¶Áȡʱ»ù±¾Õý³£ÏÔʾ£¬¾ÍÊÇÎ÷°àÑÀÓ·¨ÓïµÄ Groupe électrogène marins ÕâÖÖµ¥´ÊµÄºìÉ«×Ö·û»á³öÏÖÂÒÂë¡£±àÂëÕ ......
<?php
/*
¹¦ÄÜ£ºPHPα¾²Ì¬»¯Ò³ÃæµÄʵÏÖ
¾ßÌåÓ÷¨:
ÀýÈçÁ´½ÓΪ:test.php/year/2006/action/_add.html
mod_rewrite();
$yearn= $_GET["year"];//½á¹ûΪ'2006'
......
ÀýÈç: $s='s:56:" <a href="cp.php?ac=task&taskid=7">ÁìȡÿÈÕ»ý·Ö´óÀñ°ü </a>"dfdfdfds';
±ä³É
$s='& ......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......