class Ms{
private $host;
private $user;
private $pwd;
private $db_name;
public function __construct($host,$user,$pwd,$dbName)
{
$this->host = $host;
$this->user = $user;
$this->pwd = $pwd;
$this->db_name = $dbName;
}
public function mysql($sql)
{
$con = mysqli_connect($this->host,$this->user,$this->pwd,$this->db_name);
if(!$con){
die('Could not connect : '.mysqli_error());
}
$result = mysqli_query($con,$sql);
if (!$result) {
printf("Error: %s\n", mysqli_error($con));
}
$list = [];
while ($row = mysqli_fetch_array($result)) {
array_push($list,$row);
}
return $list;
mysqli_close($con);
}
}
class menu
{
public function getList()
{
$con = new Ms('localhost','root','root','adv5');
$sql = "select * from cmf_admin_menu";
$result = $con->mysql($sql);
echo "<pre>";
print_r($result);die;
}
}
$menu = new menu();
echo $menu->getList();