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();