php - INSERT INTO table VALUES - mysql_query to PDO -

trying insert values old mysql_query using new pdo , can't seem it. here's old code works old method:

$query = mysql_query("insert videos values ('','$title',time(),'0','$length','','$name','$cat','$reciter','$genre')"); 

i've tried variations of following code taken question on stack, nothing works me.

$query = "update people           set price=?,               contact=?,               fname=?,               lname=?            id=? ,                  username=?"; $stmt = $dbh->prepare($query); $stmt->bindparam(1, $price); $stmt->bindparam(2, $contact); $stmt->bindparam(3, $fname); $stmt->bindparam(4, $lname); $stmt->bindparam(5, $id); $stmt->bindparam(6, $username);     $stmt->execute(); 

the first value inserted auto increment value in db. @ loss how write new pdo. third attempt @ timestamp. others values exist in script already.

so more along lines of i'm looking for.. have now, doesn't work.

$sql = "insert videos (id, title, timestamp, views, length, image, vid_url, cetegory, reciter, genre)                     values (:id, :title, :timestamp, :views, :length, :image, :vid_url, :category, :reciter, :genre)";  $query = $dbh->prepare($sql);  $results = $query->execute(array(     ":id" => '',     ":title" => $title,     ":timestamp" => time(),     ":views" => '0',     ":length" => $length,     ":image" => '',     ":vid_url" => $name,     ":category" => $cat,     ":reciter" => $reciter,     ":genre" => $genre )); 

if id autoincrement, don't pass query. if specify value inserted autoincrement table, sql attempt insert value. don't include in query, let sql that.

secondly, if third field timestamp, set default to

current_timestamp on update current_timestamp 

sql update timestamp automatically on update or insert (if want on insert put current_timestamp. can drop row.

you can drop images row if aren't inserting there either, no point put in query if you're not using it!

also, key pdo looks doesn't have colon (:) if item :title, array key 'title'. so, code should like:

$sql = "insert videos ( title, views, length,, vid_url, cetegory, reciter, genre)                     values (:title, :views, :length, :vid_url, :category, :reciter, :genre)";  $query = $dbh->prepare($sql);  $results = $query->execute(array(     "title" => $title,     "views" => '0',     "length" => $length,     "vid_url" => $name,     "category" => $cat,     "reciter" => $reciter,     "genre" => $genre ));