select * from dr_1_down_order where uid=1 and cid=1

//原来poscms是这样写的
&param=list action=sql sql='select * from dr_member where uid=1'

{sql sql='select * from dr_1_down_order where uid=1 and cid=1'}
{php $api[$key]=[];}
{php $api[$key]['id']=$t['id'];}
{php $api[$key]['字段']=$t['字段'];}
{/sql}

http://域名/index.php?c=api&m=data2&auth=472869ef85d15227acb937eac8d89243&param=list action=sql sql='select * from dr_1_down_order where uid=动态 and cid=动态'

//比如这样，通过一个中转文件url方式获取指定sn订单号信息
//http://www.baidu.com/order.php?sn=202301011808
<?php
    if(isset($_GET['sn'])){
        header("Access-Control-Allow-Origin: *");
        $cid = $_GET['sn'];
        $api = "https://域名/index.php?c=api&m=data2&format=jsonp&auth=1ffbb79a9b8ec0058d1c389cc5664cc4&param=list action=sql sql='select * from dr_1_down_order where sn=$sn'";
        $json = file_get_contents($api);
        echo $json;
    }
?>