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