Help php trasnfer pdo

[Appius4S]

PHP Code:

 $sql0 = "SELECT title FROM tickets WHERE hash = '".$hash."' AND Solved = 0";
                            $q0 = $web->prepare($sql0);
                            $q0->execute(); 
                            $q0 = mysql_query($sql0);

                            $dat0 = mysql_fetch_assoc($q0);
                            $title = $dat0['title'];

                            if(mysql_num_rows($q) != 0 || mysql_num_rows($q0) != 0) 


is 20% trasnfer to pdo ... who can help me with the rest of script ?

[Analysis']

[Kentika]

PHP Code:

$stmt = $web->prepare('SELECT title FROM tickets WHERE hash = :hash AND Solved = 0');

if($stmt->execute([':hash' => $hash]) {
   $result = $stmt->fetch(); // Fetch 1 row // fetchAll for all rows
   $title = isset($result['title']) ? $result['title'] : null;

   if(!is_null($title)) {
       [...]
   }
} 


Read the manual.