Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $var =$_POST['feature'];
- $status = 'passed';
- $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
- $allTest->bindValue(":var", "^$var", PDO::PARAM_STR);
- $allTest->execute(array(':status' => $status));
- while($row = $allTest->fetch(PDO::FETCH_ASSOC))
- {
- foreach($row as $key)
- {
- $totalTestPassed[] = $key;
- }
- }
- print_r($totalTestPassed);
- $var =$_POST['feature'];
- $status = 'passed';
- $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
- $allTest->bindValue(":var", "^$var", PDO::PARAM_STR);
- $allTest->bindValue(":status", $status);
- $allTest->execute();
- while($row = $allTest->fetch(PDO::FETCH_ASSOC))
- {
- foreach($row as $key)
- {
- $totalTestPassed[] = $key;
- }
- }
- print_r($totalTestPassed);
- $allTest->execute(array(':status' => $status, ':var' => ^$var));
- $status = 'passed';
- $allTest = $conn->prepare('SELECT SUM( IF( STATUS = :status, 1, 0 ) ) passed_count FROM tooldata WHERE testCase REGEXP :var GROUP BY family ORDER BY family' );
- $allTest->bindValue(":var", $var, PDO::PARAM_STR);
- $allTest->bindValue(":status", $status, PDO::PARAM_STR);
- $allTest->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement