Airtable API,查询base里数据,根据某字段查询
根据base里某个字段,来查询每条数据,循环查询
Airtable API, filterByFormula过滤公式, fields查询指定条件
实现对接Airtable API 用PHP_curl 请求连接,实现查询base里面的数据
//问卷
function list_airtible_wenjuan($email)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// curl_setopt($ch, CURLOPT_URL, "https://api.airtable.com/v0/appZrn7WwQjXWwDuD/tbldh5oiNdY8KwfgD?filterByFormula=(%7BUser+Name+(Email)%7D+%3D'"."$email"."')");
curl_setopt($ch, CURLOPT_URL, "https://api.airtable.com/v0/appZrn7WwQjXWwDuD/tblMbTTcXEcZvydup?filterByFormula=(%7Bemail+(%E4%BB%8E%E4%B8%8B%E5%8D%95%E7%BD%91%E9%A1%B5%E6%9D%A5)%7D+%3D'"."$email"."')&sort%5B0%5D%5Bfield%5D=Order%20Created&sort%5B0%5D%5Bdirection%5D=desc");
curl_setopt($ch, CURLOPT_HTTPHEADER, [
"Content-Type: application/json",
"Authorization: Bearer keyl10gU5MxcVF6Nt"
]);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'GET');
$result = curl_exec($ch);
// print_r($result);
curl_close($ch);
return $result;
}
循环此列表
<div class="tit2">
<div class="left">
<p>订单号:<span>span>p>
<p>订单总价格:<span>span><a href="javascript:;" class="jiage">价格详情a>p>
div>
<div class="right">
<p>订单日期:<span>span>p>
div>
div>
这里是根据邮箱进行查询,循环到列表上
这里需要用到
filterByFormula用法公式过滤数据自段
原创©本文章为教腾豪原创,未经许可,禁止转载
0条评论