阅读背景:

Drupal 7使用If条件mysql数据库选择查询

来源:互联网 
function tablesort_example_page() {
//$date2=date('m-d-Y', strtotime('t.added_date'));
// if('t.status'==1){
// $status='Active';
// }else{
// $status='Inactive';
// }
  // We are going to output the results in a table with a nice header.
  $header = array(
    // The header gives the table the information it needs in order to make
    // the query calls for ordering. TableSort uses the field information
    // to know what database column to sort by.
    array('data' => t('S No'), 'field' => 't.id'),
    array('data' => t('Country Name'), 'field' => 't.country_name'),
    array('data' => t('Status'), 'field' => 't.status'),
    array('data' => t('Added Date'), 'field' => 't.added_date'),
    array('data' => t('Action'), 'field' => 't.id',),
    array('data' => t('Action'), '',),
  );

  // Using the TableSort Extender is what tells the the query object that we
  // are sorting.
  $limit = 10;


  $query = db_select('countries', 't')->extend('TableSort')->extend('PagerDefault')->limit($limit)->orderby('id', ASC);
  $query->fields('t');

  // Don't forget to tell the query object how to find the header information.
  $result = $query
      ->orderByHeader($header)
      ->execute(); 
if('$row->status'==0){
$status='Active';
} else {
$status='Inactive';
}
  $rows = array();
  $i=1;
  foreach ($result as $row) {
//print_r($row);


    // Normally we would add some nice formatting to our rows
    // but for our purpose we are simply going to add our row
    // to the array.
    $rows[] = array(
    $row->id,
    $row->country_name,
    $status, ----> **
function tablesort_example_page() {
//$date2=da



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: