Advertisement
Guest User

Untitled

a guest
Apr 18th, 2014
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. $var =$_POST['feature'];
  2.  
  3. $status = 'passed';
  4. $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
  5. $allTest->bindValue(":var", "^$var", PDO::PARAM_STR);
  6. $allTest->execute(array(':status' => $status));
  7.  
  8. while($row = $allTest->fetch(PDO::FETCH_ASSOC))
  9. {
  10. foreach($row as $key)
  11. {
  12. $totalTestPassed[] = $key;
  13. }
  14. }
  15. print_r($totalTestPassed);
  16.  
  17. $var =$_POST['feature'];
  18.  
  19. $status = 'passed';
  20. $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
  21. $allTest->bindValue(":var", "^$var", PDO::PARAM_STR);
  22. $allTest->bindValue(":status", $status);
  23. $allTest->execute();
  24.  
  25. while($row = $allTest->fetch(PDO::FETCH_ASSOC))
  26. {
  27. foreach($row as $key)
  28. {
  29. $totalTestPassed[] = $key;
  30. }
  31. }
  32. print_r($totalTestPassed);
  33.  
  34. $allTest->execute(array(':status' => $status, ':var' => ^$var));
  35.  
  36. $status = 'passed';
  37. $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
  38. $allTest->bindValue(":var", $var, PDO::PARAM_STR);
  39. $allTest->bindValue(":status", $status, PDO::PARAM_STR);
  40. $allTest->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement