所有的编程语言都是从数据库的CRUD开始,这是最基础的,只有CRUD学会了,才可以考虑开发逻辑,把CRUD做到极致,考虑到程序面临的各种问题,才能不断提升自己的开发功能。现在,就介绍一下Phpcms面向接口的开发,最简单的CRUD。
<?php
//defined('IN_PHPCMS') or exit('No permission resources.');这里可以不用
//这里我们要引进model基类,就像java里引入包.如果不引入就会报Class 'model' not found in /www/wwwroot/www.xxx.com/api/usermanager.php on line 6
pc_base::load_sys_class('model', '', 0);
echo "进来了";
//进行数据库操作
class download extends model{
function __construct() {
parent::__construct();
$this->db_config = pc_base::load_config('database');
$this->db_setting = 'default';
$this->table_name = 'v9_download';
}
}
//接口里面需要创建对象
$download_db = new download();
//查询根据参数,如果没有条件,也要按顺序穿参数,为空值
$data_down = $download_db->select("","id,url","1,100","id desc");
foreach((array)$data_down as $key=> $item){
echo $key."--单表查询--".$item['url']."<br>";
}
echo "----------------------end------------------------";
$data_down2=$download_db->query("select * from v9_download a left join v9_position_data b on a.id=b.id");
$data_down3=$download_db->fetch_array($data_down2);
foreach((array)$data_down3 as $key =>$item)
{
echo $key."--联表查询--".$item['url']."-----".$item['title']."<br>";
}
//浏览器调用api中不同的方法,可以通过$_GET[‘参数’]来匹配调用不同的参数
$action = $_GET['action'];
//get_ss();
if($action =="single"){
//通过参数传递实现全局变量
get_single($download_db);
}else{
get_double();
}
function get_single($download_db) {
//$download_db = new download();
$data_down = $download_db->select("","id,url","1,100","id desc");
foreach((array)$data_down as $key=> $item){
echo $key."--单表查询--".$item['url']."<br>";
}
echo "----------------------通过传参数实现单表查询结束------------------------";
}
function get_double(){
$download_db = new download();
$data_down2=$download_db->query("select * from v9_download a left join v9_position_data b on a.id=b.id");
$data_down3=$download_db->fetch_array($data_down2);
foreach((array)$data_down3 as $key =>$item)
{
echo $key."--联表查询--".$item['title']."-----".$item['description']."<br>";
}
echo "----------------------联表查询结束------------------------";
}
?>