如何在function里操作pdo呀
代码如下
require("../inc/pdo.php");<br /><br />function output($action,$select,$name){<br />$select=$dbc->prepare("select id,ztname,zttype,zttime,headimg,riseimg from naszt where 1=1 and zttype=:zttype");<br />$select->bindValue(":zttype",$action);<br />$select->execute();<br />$result='';<br />while($row=$select->fetch()){<br />$result.='<ul id="thumbs"><li class="'.$name.'">';<br />$result.='<div class="img-container">';<br />$result.='<div class="item-img">';<br />$result.='</div><ul>';<br />$result.='<li>测试1</li>';<br />$result.='<li>测试12</li></ul></div><div class="item-info">';<br />$result.='<h3 class="title">'.$row['ztname'].'</h3>';<br />$result.='<span class="category">'. $row['zttype'].'</span>'; <br />$result.='<p class="intro">1推荐日期:'.$row['zttime'].'</p></div></li>';<br /> }<br />return $result;<br />}
<?php<br />header("Content-Type:text/html;charset=utf-8");<br />$dbtype='mysql';<br />$host='127.0.0.1';<br />$dbName='nas';<br />$user='227227';<br />$pass='227227';<br />$db="$dbtype:host=$host;dbname=$dbName";<br />try{<br />$dbc=new PDO($db,$user,$pass);<br />$dbc->exec('SET CHARACTER SET utf8');<br />$dbc->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); //禁用prepared statements的仿真<br /> }catch(PDOException $e){<br />echo $e->getMessage();<br />}<br />?>
我想在function调用pdo
是不是在pdo里面写class function要继承这个类？
求大神出手指点该如何写！
——解决方案——————–
推荐看一下这个呀
http://php.xlxz.org/2013/11/370/
<?php<br /> <br />include 'sql_build_query.php';<br />include 'pdo_query.php';<br />$db = new pdo_db;<br /> <br />$sql = $db->pdo_query('show databases ');<br /> <br />var_dump( $sql, $db->dbVersion() );<br /> <br />exit;<br /> <br />$sql = $db->select( 'i.kd k, io.id dk, iil.ii ds' )->from( 'test t' )<br /> ->leftjoin( 'post p', 't.id = ?', array( 2 ) )<br /> ->order( 'name DESC, id ASC' )<br /> ->where( array( 'xin = ? AND do > ?' => array<em>8本文来源gao.dai.ma.com搞@代*码(网$</em><pre>搞代gaodaima码
( 1,3 )))
->having( array(‘xin’ => ‘dkls’ ))
->group( ‘id’ )
->limit( 3,4 )
->queryAll();
exit;
//var_dump( $sql );
$sql = $db->from( ‘test’)
->insert( array( ‘kd’ => ‘233’, ‘dkwe’ => 323 ));
$sql = $db->from( ‘test’ )
->where( array( ‘( dk = ? and kd > ?) or ( dk = ? and ddd = ?)’ => array( 2,3,5,4 )))
->limit( 2 , 4 )
->update( array( ‘dkddl’ => ‘d’, ‘kdls’ => ‘dkdl’ ));
$sql = $db->from( ‘test,test’ )
->select( ‘test,test’ )
->where( array( ‘id’ => array( 3,3,4,2,3) ))
->limit( ‘3’, 3)
->delete();
——解决方案——————–
WHere后面随便拼 一个变量 需要的时候赋值就是了
转载请注明原文链接：怎么在function里操作pdo呀
