Database Exception in yii2

Question

please help mee, can you tell me way ?

$totalah = Sah::find()
      ->select('mhs, SUM(IF(status_kehadiran = 1,status_kehadiran , 0))AS K3211335')
      ->where([
           'kode_mk'=> 'K3211335'
      ])
      ->groupBy('mhs')
      ->all();

 echo "<pre/>"; print_r($totalah);
 die;

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS K3211335 FROM sah WHERE kode_mk='K3211335' GROUP BY mhs' at line 1 The SQL being executed was: SELECT mhs, SUM(IF(status_kehadiran = 1, status_kehadiran, 0))ASASK3211335FROMsimak_absen_harianWHEREkode_mk='K3211335' GROUP BY mhs`

Md. Salahuddin · Accepted Answer · 2020-09-27 09:17:33Z

1

For multiple data in select you can use array. You also need a space before AS:

 $totalah = Sah::find()
  ->select(['mhs', 'SUM(IF(status_kehadiran = 1,status_kehadiran , 0)) AS K3211335'])
  ->where([
       'kode_mk'=> 'K3211335'
  ])
  ->groupBy('mhs')
  ->all();

answered Sep 27, 2020 at 9:17

Md. Salahuddin

1,07215 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vvpanchev · Accepted Answer · 2020-09-27 09:32:30Z

0

If I undestand you purpose, you sum status_kehadiran when status_kehadiran = 1, why you don't just SUM status_kehadiran where status_kehadiran = 1

$totalah = Sah::find()
  ->select(['mhs', 'SUM(status_kehadiran) AS K3211335'])
  ->where([
       'kode_mk'=> 'K3211335',
       'status_kehadiran' => 1
  ])
  ->groupBy('mhs')
  ->all();

edited Sep 27, 2020 at 9:32

answered Sep 27, 2020 at 9:24

vvpanchev

5771 gold badge6 silver badges14 bronze badges

Collectives™ on Stack Overflow

Database Exception in yii2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related