$MysqL = new MysqLi(DB_SERVER,DB_USER,DB_PASSWORD,DB_NamE) or die('There was a PRoblem connecting to the database');
        if (MysqLi_connect_errno()) {
            printf("DB error: %s",MysqLi_connect_error());
            exIT();
        }

    $get_emp_list = $MysqL->prepare("SELECT id,name From calc");
    if(!$get_emp_list){
        echo "prepare Failed\n";
        echo "error: ",$MysqL->error,"\n";
        return;
    }
    $get_emp_list->execute();
    $get_emp_list->bind_result($id,$emp_list);

这是有能力的架构 –

--
-- Table structure for table `calc`
--

CREATE TABLE IF NOT EXISTS `calc` (
  `id` int(12) NOT NULL,`yr` year(4) NOT NULL,`mnth` vArchar(12) NOT NULL,`name` VARchar(256) NOT NULL,`paidleave` int(12) NOT NULL,`balanceleave` int(12) NOT NULL,`unpaidleave` int(12) NOT NULL,`basesalary` int(12) NOT NULL,`deductions` int(12) NOT NULL,`tds` int(12) NOT NULL,`pf` int(12) NOT NULL,`finalsalary` int(12) NOT NULL,Primary KEY (`id`)
) ENginE=MyISAM DEFAULT CHARSET=latin1;