</tr> <tr> <td align="left">Category Name</td> <td align="left"><input type="text" value="" id="name" name="name" /></td> </tr> <tr> <td align="left">Blog</td> <td align="left"><?php include 'modules/blogs_select_box/blogs.php'; ?> </td> </tr> <tr> <td> </td> <td align="left"><input type="button" value="Add Category" onclick="add_category(this.form)"></td> </tr> </table> </form> </div> <?php $aql = "blog_category{\n\t\t\t\t\t\tid as save,\n\t\t\t\t\t\tid as delete,\n\t\t\t\t\t\tname,\n\t\t\t\t\t\tblog_id,\n\t\t\t\t\t\tiorder\n\t\t\t\t\t\torder by blog_category.id\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t \n \t\t\t\t}\n\t\t\tblog {\n\n\t\t\t}\n\t\t\tblog_website {\n\t\t\t\twhere website_id = {$website_id}\n\t\t\t}\n\t\t\t\t\t\t"; $cols = "id {}\n\t\t\tname {\n label: Category Name;\n }\t\t \n blog_id {\n label: Blog;\n }\n\t\t iorder {\n label: iorder;\n }\n \n\t\t save {\n\t\t script: components/blog_category/id/save.php;\n\t\t }\n\t\t delete{\n\t\t script: components/blog_category/id/delete.php;\n\t\t }\n\t\t "; $param = array('table_class' => 'listing'); grid::render($aql, $col, $param); template::inc('intranet', 'bottom');
<h2>Controle de professores</h2> <div class="btn_action"> <a href="cadastrar.php" class="bar_menu_texto"> <img src="../../public/images/icons/new.png" alt="Novo" width="20" height="20" /> <br />Novo </a> </div> <div class="btn_action"> <a href="pesquisar.php" class="bar_menu_texto"> <img src="../../public/images/icons/lupa.png" alt="Novo" width="20" height="20" /> <br />Pesquisar </a> </div> <div class="btn_action"> <a href="javascript:history.back();" class="bar_menu_texto"> <img src="../../public/images/icons/back.png" alt="Voltar" width="20" height="20" /> <br />Voltar </a> </div> <div class="panel"> <p> <strong>Lista de professores cadastrados</strong> </p> <?php $grid->render($conn->adodb, $sql, 10); ?> <span class="comentario"></span> </div> </body> </html>
/** * Renders the ajax grid * @param ajax_grid_pager $pager */ public function render($pager = null) { $sortdir_name = $this->sortdir->client_id(); if (!$this->_isExternalBuffer) { $this->buffer->start(); } if ($this->_renderFilterTop) { echo $this->render_filters('top'); } if (!is_null($this->pager) && $this->_renderPagerTop) { echo $this->pager->render('top'); } echo parent::render(array('buffer' => $this->buffer->client_id(), 'sortdir_name' => $this->sortdir->client_id(), 'sorting_name' => $this->sorting->client_id())); if ($this->_renderFilterBottom) { echo $this->render_filters('bottom'); } if (!is_null($this->pager)) { echo $this->pager->render('bottom'); } if (!$this->_isExternalBuffer) { $this->buffer->end(); } }
<?php $blog_id = trim($_REQUEST['blog_id']); #sorting variable $sort_by = $_REQUEST['sort_by']; $sort_type = $_REQUEST['sort_type']; $order_by = $sort_by . " " . $sort_type; $condition = ""; if ($blog_id != "") { $condition = " where blog.id ='" . $blog_id . "'"; } echo $aql_blog_title = "blog {\n name\n }\n blog_article {\n title \n }"; $rs_blog = aql::select($aql_blog_title); //print_a($rs_blog); // step 2. specify which columns to add to the grid $cols = "id {}\n\t\t\t\tname {\n label: Blog;\n }\n\t\t\ttitle {\n\t\t\tlabel: Article;\n\t\t}\n\t\t\t\n\t\t\t"; // step 3. display the data grid on the page $param = array('table_class' => ''); grid::render($aql_blog_title, $col, $param);