mysql

<?php
$host = "127.0.0.1";
$username = "root";
$password = "godme";
$port = 3306;
$db = "godme";
$conn = new mysqli($host,$username,$password,$db,$port);
if($conn){
    $sql ="SELECT * FROM person";
    $result = $conn->query($sql);
    while($row = $result->fetch_array()){
        print_r(json_encode($row)."\n");
    }
}else{
    echo "连接失败";
}

结果

{"0":"godme","name":"godme","1":"23","age":"23"}
{"0":"judas","name":"judas","1":"24","age":"24"}

对象query方法为执行语句，不仅是查询，sql语句都可以进行执行。

结果集需fetch，返回样式看选择。

返回数组提供两种方式获取，键值或者下标都可以。

复杂操作看个人。