Advertisement
Guest User

Untitled

a guest
May 27th, 2015
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. // Preparo previamente la consulta
  2. $courseQuestionsByPeriodQuery = $mysqli->prepare('CALL getCourseQuestionsByPeriod(?,?)');
  3.  
  4. foreach($courses as $courseid){
  5. // Asi no funciona utilizando la consulta preparada previamente
  6. $questions = array();
  7. $params = array($courseid, $periodid);
  8. $results = array('questionId', 'topicName', 'questionDescription', 'questionLevel', 'questionStatus', 'userName', 'userCode', 'userLastname', 'userFirstname', 'topicLength');
  9. ExecutePreparedCallableStatement($courseQuestionsByPeriodQuery, 'ii', $params, $results, function($results) use (&$questions){
  10. $question = array();
  11. foreach($results as $key => $value){
  12. $question[$key] = trim($value);
  13. }
  14. $questions[] = $question;
  15. });
  16.  
  17. // De esta manera funciona sin usar la consulta preparada previamente, pero podria causar que llegue al limite de consultas preparadas permitidas
  18. $questions = array();
  19. $params = array($courseid, $periodid);
  20. $results = array('questionId', 'topicName', 'questionDescription', 'questionLevel', 'questionStatus', 'userName', 'userCode', 'userLastname', 'userFirstname', 'topicLength');
  21. ExecutePreparedCallableStatement('CALL getCourseQuestionsByPeriod(?,?)', 'ii', $params, $results, function($results) use (&$questions){
  22. $question = array();
  23. foreach($results as $key => $value){
  24. $question[$key] = trim($value);
  25. }
  26. $questions[] = $question;
  27. });
  28. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement