PHP动态添加类属性,mysql表转php json。

<?php

class User{

function __construct(){

$user='test';

$host=''localhost;

$pass=''1234;

$db='test';

$conn=mysqli_conn($host,$user,$pass,$db);

$query=mysqli_query($conn,'show columns from user');

while($row=mysqli_feath_array($query,MYSQLI_ASSOC))

$this->{$row['Field']}=$row['Field'];}

}

$user=new User();

echo json_encode($user);

?>

执行php User.php

可以看到表字段已经绑定到类属性中