Advertisement
rfv123

questions/41282473/ PDO not working

Dec 22nd, 2016
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. $sql = 'SELECT @summer := 0, wrapper.* FROM
  2.        (SELECT
  3.            bs_file.*,
  4.            @summer := IFNULL(@summer,0),
  5.            @summer := @summer+1 as summer
  6.        FROM bs_file  
  7.    ) as wrapper
  8.    WHERE wrapper.summer = 3';
  9.  
  10. $pdo = appDIC('run')->getDbConnection();
  11.  
  12. $stmt = $pdo->prepare($sql);
  13. $res = $stmt->execute();
  14. $rows = $stmt->fetchAll();
  15.  
  16. \Kint::dump($rows);
  17.  
  18.  
  19. ┌──────────────────────────────────────────────────────────────────────────────┐
  20. │                                    $rows                                     │
  21. └──────────────────────────────────────────────────────────────────────────────┘
  22. array (1) [
  23.     array (6) [
  24.         '@summer := 0' => integer 0
  25.         'id' => integer 3
  26.         'datacol01' => string (6) "row-03"
  27.         'whencreated' => string (19) "2016-12-22 13:16:46"
  28.         '@summer := IFNULL(@summer,0)' => string (1) "2"
  29.         'summer' => float 3
  30.     ]
  31. ]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement