2024-04-24 PHP之CURD

基本的查询业务逻辑，返回 列表数据：data；操作信息：msg；操作状态：status

    $query = "SELECT * from os_system";
</span><span style="color: #800080;">$data</span> = <span style="color: #800080;">$mysqli</span>-&gt;query(<span style="color: #800080;">$query</span>) or <span style="color: #0000ff;">die</span>(<span style="color: #800080;">$mysqli</span>-&gt;<span style="color: #000000;">error);
</span><span style="color: #800080;">$total</span> = <span style="color: #800080;">$mysqli</span>-&gt;query("SELECT found_rows() as total") or <span style="color: #0000ff;">die</span>(<span style="color: #800080;">$mysqli</span>-&gt;<span style="color: #000000;">error);

</span><span style="color: #800080;">$result</span> = <span style="color: #0000ff;">array</span>('list' =&gt; <span style="color: #0000ff;">array</span>(), 'total' =&gt; 0<span style="color: #000000;">);
</span><span style="color: #800080;">$result</span>['total'] = <span style="color: #800080;">$total</span>-&gt;fetch_assoc()['total'<span style="color: #000000;">];
</span><span style="color: #0000ff;">while</span> (<span style="color: #800080;">$row</span> = <span style="color: #800080;">$data</span>-&gt;<span style="color: #000000;">fetch_assoc()) {    
    </span><span style="color: #008080;">array_push</span>(<span style="color: #800080;">$result</span>['list'], <span style="color: #800080;">$row</span><span style="color: #000000;">);
}
</span><span style="color: #0000ff;">exit</span>(JSON(<span style="color: #0000ff;">array</span>('data' =&gt; <span style="color: #800080;">$result</span>, 'msg' =&gt; 'success', 'status' =&gt; '0')));</pre>