在thinkphp里面的Model里面是内置了query方法的,只是需要new一个空的模型继承Model中的方法。:
$Model = new Model();
$sql = "select * from table ";
$res = $Model->query($sql);
<pre id="recommend-content-1356252069" class="recommend-text mb-10">$Model = M(); //$sql中包含了表名,实例化模型时可以为空。
$res = $Model->query($sql); 或 $res = $Model->execute($sql); //注意query是查功能,execute是增删改功能
<pre name="code" class="html"> /**
+----------------------------------------------------------
* SQL查询
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @param mixed $sql SQL指令
* @param boolean $parse 是否需要解析SQL
+----------------------------------------------------------
* @return mixed
+----------------------------------------------------------
*/
public function query($sql,$parse=false) {
$sql = $this->parseSql($sql,$parse);
return $this->db->query($sql);
}
/**
+----------------------------------------------------------
* 执行SQL语句
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @param string $sql SQL指令
* @param boolean $parse 是否需要解析SQL
+----------------------------------------------------------
* @return false | integer
+----------------------------------------------------------
*/
public function execute($sql,$parse=false) {
$sql = $this->parseSql($sql,$parse);
return $this->db->execute($sql);
}
/**
+----------------------------------------------------------
* 解析SQL语句
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @param string $sql SQL指令
* @param boolean $parse 是否需要解析SQL
+----------------------------------------------------------
* @return string
+----------------------------------------------------------
*/
protected function parseSql($sql,$parse) {
// 分析表达式
if($parse) {
$options = $this->_parseOptions();
$sql = $this->db->parseSql($sql,$options);
}else{
if(strpos($sql,'__TABLE__'))
$sql = str_replace('__TABLE__',$this->getTableName(),$sql);
}
$this->db->setModel($this->name);
return $sql;
}
thinkphp 里面执行SQL语句
最新推荐文章于 2024-08-12 03:22:14 发布