PDO

$query = "
    INSERT INTO `tbl`(`col0`, `col1`, `col2`, `col3`, `col4`, `col5, `col6`, `col7`)
    VALUES (:one,:two,:three,:four,:five,:six,:seven,:eight)";

$record = $db->prepare($query);

if($record->execute([':one'=>$one,':two'=>$two,':three'=>$three,':four'=>$four,':five'=>$five,':six'=>$six,':seven'=>$seven,':eight'=>$eight])){
    echo "ok";
}else{
    echo "failed";
}