private function setDB()
{
require_once $this->root . "/class/DB_Connect.php";
$ds = new MySQLDataSource(DB_Connect::mysql_db());
//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = 'select s_id, s_user, s_pwd, s_num, s_name, s_mail, s_date, s_role, s_phone, reg_date, last_login, edu_id, edu_name, dept_name, major_name, class_name, class_id from student join class using(class_id) join major using(major_id) join department using(dept_id) join education using(edu_id) ' . $this->where_cla;
$ds->UpdateCommand = "update student set s_pwd=md5('@s_pwd'), s_name='@s_name', s_num='@s_num' where s_id=@s_id";
$this->grid->DataSource = $ds;
}
private function setDB()
{
require_once $this->root . "/class/DB_Connect.php";
$ds = new MySQLDataSource(DB_Connect::mysql_db());
//This $db_con link has been created inside KoolPHPSuite/Resources/runexample.php
$ds->SelectCommand = "select m_id,m_user,m_name,m_pwd,department.dept_id,dept_name from manager right join department using(dept_id)";
$ds->UpdateCommand = "update manager set m_pwd=md5('@m_pwd'), m_user='******', m_name='@m_name', dept_id='@dept_id' where m_id=@m_id";
$ds->InsertCommand = "insert into manager (m_user, m_pwd, m_name, dept_id) values('@m_user',md5('@m_pwd'), '@m_name', '@dept_id')";
$ds->DeleteCommand = "delete from manager where m_id=@m_id";
$this->grid->DataSource = $ds;
}
<script type="text/javascript" src="{$pubDir}/script/common.js"></script>
<title>{$title|default:'Universal Online Examination System'}</title>
</head>
<body>
<?php
//Step 1: Register KoolGrid component to your page
// require_once ("../private/class/autoload.inc");
// require_once "../../KoolPHPSuite/KoolControls/KoolGrid/koolgrid.php";
$KoolControlsFolder = getenv("DOCUMENT_ROOT") . "/KoolPHPSuite/KoolControls";
require_once $KoolControlsFolder . "/KoolAjax/koolajax.php";
require_once $KoolControlsFolder . "/KoolGrid/koolgrid.php";
require_once "../private/class/DB_Connect.php";
$db_con = DB_Connect::mysql_db();
$grid = new koolgrid("grid");
$grid->scriptFolder = $KoolControlsFolder . "/KoolGrid";
$koolajax->scriptFolder = $KoolControlsFolder . "/KoolAjax";
$ds = new MySQLDataSource($db_con);
// $grid->scriptFolder = $KoolControlsFolder."/KoolGrid";
$ds->SelectCommand = "select s_name, s_class from student";
$grid->styleFolder = "default";
$grid->DataSource = $ds;
$grid->Width = "655px";
$grid->AjaxEnabled = true;
$grid->AutoGenerateColumns = true;
// $grid->AllowFiltering = true;//Enable filtering for all rows;
$grid->MasterTable->Pager = new GridPrevNextAndNumericPager();
$grid->MasterTable->Pager->ShowPageSize = false;
$grid->Process();
