Fatal error: Uncaught exception
‘mysqli_sql_exception’ with message
‘No index used in query/prepared
statement’

$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;