如何在php中确认插入sqlite数据库中的数据

i am new in php. i am trying to inset the data in sqlite database and my code is

          $query= $dbh->prepare("INSERT INTO favorite_apps(version, apppkgname, appname, appdescriptive, appClass, applink, place) VALUES (?,?,?,?,?,?,?)");
            $query->bindParam(1,$Version);
            $query->bindParam(2,$Package);
            $query->bindParam(3,$AppName);
            $query->bindParam(4,$AppDescription);
            $query->bindParam(5,$ClassName);
            $query->bindParam(6,$AppLink);
            $query->bindParam(7,$Place);
            $res = $query->execute();

but i am getting null in $res, so how to confirm the data is inserted or not in sqlite database

thanks

PDO's execute method returns either true or false, so there must be a problem in your php code... Try using $query->debugDumpParams(); to output the prepared query and test it.