doujiao1949 2018-02-28 00:07
浏览 258

在浏览器中显示sqlite查询(通过php)

Hi there i am struggling to code a table that will display the query that i have written into the browser. I have tried multiple times but have failed. Can someone help me format a view for the following query ?

$db = new PDO('sqlite:daypilot.sqlite'); 
$start = '2018-02-20'; 
$end = '2018-02-25'; 
$sql = 'SELECT * FROM events WHERE end > ? AND start < ?'; 
$stmt = $db->prepare($sql); $stmt->execute([$start, $end]); 
$events = $stmt->fetchAll(); 

foreach ($events as $event) { 
    var_dump($event); // output with your desired formatting here 
} 
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 一道python难题
    • ¥15 用matlab 设计一个不动点迭代法求解非线性方程组的代码
    • ¥15 牛顿斯科特系数表表示
    • ¥15 arduino 步进电机
    • ¥20 程序进入HardFault_Handler
    • ¥15 oracle集群安装出bug
    • ¥15 关于#python#的问题:自动化测试
    • ¥20 问题请教!vue项目关于Nginx配置nonce安全策略的问题
    • ¥15 教务系统账号被盗号如何追溯设备
    • ¥20 delta降尺度方法,未来数据怎么降尺度