重构查询构建器Laravel

发布于 2025-01-25 05:02:15 字数 322 浏览 2 评论 0原文

我想在几个表上进行重复获取数据并访问（请参见下面的示例）。有没有办法以清洁的方式编写代码，而不是为所有表重复相同的代码？

$xs = DB::table('table1')->where('text', 'like', '%string')->get();

foreach ($xs as $x) {
           ..
}

$ys = DB::table('table2')->where('text', 'like', '%string')->get();

foreach ($ys as $y) {
           ..
}```

原文

I want to do repetitive get data and foreach on several tables (see example below). Is there a way to write the code in a cleaner way instead of repeating the same code for all the tables?

$xs = DB::table('table1')->where('text', 'like', '%string')->get();

foreach ($xs as $x) {
           ..
}

$ys = DB::table('table2')->where('text', 'like', '%string')->get();

foreach ($ys as $y) {
           ..
}```

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

深海夜未眠 2025-02-01 05:02:15

我的方法是使用数组和foreach

$tables = ['table1', 'table2'];
results = [];

foreach($tables as $table) {
  $data = DB::table($table)->where('text', 'like', '%string')->get();
  foreach($data as $d) {
    // your logic here
  }
  $results[] = ; // return a value from each query to array
}

My approach is using array and foreach

$tables = ['table1', 'table2'];
results = [];

foreach($tables as $table) {
  $data = DB::table($table)->where('text', 'like', '%string')->get();
  foreach($data as $d) {
    // your logic here
  }
  $results[] = ; // return a value from each query to array
}

回复收藏 0 原文

定格我的天空 2025-02-01 05:02:15

您可以编写基本功能并将tableName传递给它并执行某些操作

public function getData($tableName) {
  $query = DB::table($tableName)->where('text', 'like', '%string')->get();
  foreach ($query as $row) {
          ...
   }

  // return result;
}

$tables = ['table1', 'table2', 'table3'];
$queryResponse = [];

foreach($tables as $tableName) {
    $queryResponse[$tableName] =  $this->getData($tableName);
}

You can write a base function and pass tableName to it and execute certain action

public function getData($tableName) {
  $query = DB::table($tableName)->where('text', 'like', '%string')->get();
  foreach ($query as $row) {
          ...
   }

  // return result;
}

$tables = ['table1', 'table2', 'table3'];
$queryResponse = [];

foreach($tables as $tableName) {
    $queryResponse[$tableName] =  $this->getData($tableName);
}

回复收藏 0 原文

~没有更多了~