PHP datagrid::add_select_field Exemples

Exemple #1

Fichier : option_page_404.php Projet : nhathong1204/bdshungthinh

?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo $util->get_current_parameters('search');
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>
<?php 
$table_name = $table_prefix . 'WP_SEO_404_links';
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->add_select_field('ID');
$grid->add_select_field('link');
$grid->add_select_field('referrer');
$grid->set_order(" ID desc ");
if ($util->get('search') != '') {
    $search = $util->get('search');
    $grid->set_filter(" link like '%%{$search}%%' or ctime like '%%{$search}%%'\n\t\tor referrer like '%%{$search}%%'   or country like '%%{$search}%%'   or ip like '%%{$search}%%'\n\t\tor os like '%%{$search}%%' or browser like '%%{$search}%%'\n\t\t ");
}
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(1, 'width', '140px');
$grid->set_col_attr(1, 'align', 'center');
$grid->set_col_attr(3, 'width', '20px');
$grid->set_col_attr(3, 'align', 'center');
$grid->set_col_attr(4, 'align', 'center');
$grid->set_col_attr(5, 'align', 'center');
$grid->set_col_attr(5, 'width', '130px');

Exemple #2

Fichier : option_page_post_redirection_list.php Projet : adwleg/site

echo htmlentities($util->get('search', 'title'));
?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo $util->get_current_parameters('search');
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>
<?php 
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->add_select_field('ID');
$grid->add_select_field('postID');
$grid->add_select_field('redirect_from');
$grid->add_select_field('redirect_from_type');
$grid->add_select_field('redirect_to');
$grid->add_select_field('redirect_to_type');
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(5, 'width', '50px');
$grid->set_col_attr(5, 'width', '50px', 'header');
$grid->set_col_attr(1, 'width', '20px', 'header');
$grid->set_col_attr(2, 'width', '20px', 'header');
$grid->set_order(" ID desc ");
$grid->set_filter("url_type=2");
if ($util->get('search') != '') {
    $search = $util->get('search');
    $grid->set_filter("url_type!=1 and (redirect_from like '%%{$search}%%' or redirect_to like '%%{$search}%%' or redirect_type like '%%{$search}%%'  )");

Exemple #3

Fichier : option_page_custome_redirection_list.php Projet : adwleg/site

echo htmlentities($util->get('search'), ENT_QUOTES);
?>
" size="40">
		<a onclick="go_search()" href="#"><div class="search_link">Search</div></a> 
		<a href="<?php 
echo htmlentities($util->get_current_parameters('search'), ENT_QUOTES);
?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>
<?php 
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->add_select_field('ID');
$grid->add_select_field('redirect_from');
$grid->add_select_field('redirect_from_type');
$grid->add_select_field('redirect_to');
$grid->add_select_field('redirect_to_type');
$grid->add_select_field('enabled');
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(5, 'width', '50px');
$grid->set_col_attr(3, 'width', '50%');
$grid->set_col_attr(4, 'width', '50%');
$grid->set_col_attr(5, 'width', '50px', 'header');
$grid->set_col_attr(1, 'width', '20px', 'header');
$grid->set_col_attr(2, 'width', '20px', 'header');
$grid->set_order(" ID desc ");
$grid->set_filter("url_type=1");
if ($util->get('search') != '') {

Exemple #4

Fichier : option_page_history.php Projet : nhathong1204/bdshungthinh

?>
"><div class="see_link">Show All</div></a>
		</td>
	</tr>
</table>
</div>

<?php 
$grid = new datagrid();
$grid->set_data_source($table_name);
$grid->set_order(" ID desc ");
if ($util->get('search') != '') {
    $search = $util->get('search');
    $grid->set_filter(" rfrom like '%%{$search}%%' or rto like '%%{$search}%%' or ctime like '%%{$search}%%'\n\t\tor referrer like '%%{$search}%%'   or country like '%%{$search}%%'   or ip like '%%{$search}%%'\n\t\tor os like '%%{$search}%%' or browser like '%%{$search}%%' or rsrc like '%%{$search}%%' or rtype like '%%{$search}%%' \n\t\t ");
}
$grid->add_select_field('rID');
$grid->add_select_field('postID');
$grid->add_select_field('referrer');
$grid->add_select_field('country');
$grid->add_select_field('ip');
$grid->add_select_field('os');
$grid->add_select_field('browser');
$grid->add_select_field('rsrc');
$grid->add_select_field('rfrom');
$grid->add_select_field('rto');
$grid->add_select_field('ctime');
$grid->set_table_attr('width', '100%');
$grid->set_col_attr(1, 'width', '60px');
$grid->set_col_attr(3, 'width', '20px');
$grid->set_col_attr(3, 'align', 'center');
$grid->set_col_attr(4, 'width', '20px');