如何在表中为管理员制作 Drupal 7 可编辑字段

2021-12-29 00:00:00 arrays php mysql drupal drupal-7
 $header = array(
    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'), '',),
  );



$limit = 10; 
  $query = db_select('countries', 't')->extend('TableSort')->extend('PagerDefault')->limit($limit)->orderby('country_name', ASC);
  //condition();
  $query->fields('t');
  //$edit=echo '<i class="fa fa-pencil-square-o"></i>';
  //$edit=echo '<i class="fa fa-pencil-square-o"></i>';
  // Don't forget to tell the query object how to find the header information.
  $result = $query
      ->orderByHeader($header)
      ->execute(); 

  $rows = array();
   $i=1;

  foreach ($result as $row) {

    $rows[] = array(
    $i,
    //($x === 2) ? 0 : $x+1,
    //$row->id,
    $row->country_name,
    //$row->status,
    //$row->status,
    $status = ($row->status == 0) ? 'Inactive' : 'Active',
    date('d-m-Y H:i:s', strtotime($row->added_date)),
    l('Edit', 'mypages/countries/'. $row->id), 
    l('Delete', 'mypages/delete/'. $row->country_name)

    );
//print_r($status);
    $i++;
  }

在这个数据中,我从数据库中获取数据并显示它..现在我想将状态显示为动态,就像管理员可以根据需要修改状态..

In this data where i am getting data from database and displaying it ..Now i want display the status as dynamic like admin can modify the status if he requires..

$status = ($row->status == 0) ? 'Inactive' : 'Active',

他可以在哪里使活跃或不活跃

如果我们可以在下拉菜单中给出 active 或 inactive 更好..管理员可以选择状态..之后自动更新到选定状态......我将 S 显示为编号,即 .. 在第一页中工作的数字,如编号自动递增,其中编号到第二页 .. 编号系统再次从初始开始...

if we can give active or inactive in drop down its better ..where admin can select the status..after that automatically update to selected status... and I am displaying S no as numbering which is ..the numbers working in first page like numbering auto increment where numbering to second page ..the numbering system is starting from the initial again...

以上的解决方法是什么

推荐答案

您可能需要创建另一个标题项来执行激活/停用操作,通过检查 user_access.在行中,您可以根据当前状态添加是否激活/停用的链接.您可以通过传递查询参数、状态和更新状态,在单击激活或停用链接时重定向到编辑页面.

You may have to create another header item to perform the activation/deactivation action, By checking the user_access. In the rows you can add links to whether activate/deactivate depending on the current status. You can redirect to the edit page on clicking the activate or deactivate links by passing query parameters, status and update the status.

相关文章