I’ve two tables in Drupal 8 web site(mysql database).
- Worker
- Wage
I must load Drupal Development Company knowledge bit totally different approach like this in Drupal.
$row = [ 'Employee' => [ 'FirstName; => "test" ], 'Pay' => [ "Salary" => 20000 ] ];
I can get Drupal Development Company knowledge this manner:
$question = Drupal::database()->choose('Worker', 'e'); $query->leftJoin('Wage', 's', 'e.id = s.id'); $query->fields('e', ['FirstName']); $query->fields('s', ['Salary']); $rows = $query->execute()->fetchAllAssoc();
However this provides knowledge as:
$row = [ "FirstName" => "test", "Salary" => 20000 ];
Any steering can be appreciated.