$VAR14 = { 'image_medium' => 'http://ecx.images-amazon.com/images/I/51p2cN2yIML._SL160_.jpg', 'authors' => 'Tony Stubblebine', 'publication_date' => '2007-07-18', 'title' => 'Regular Expression Pocket Reference: Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET (Pocket Reference (O\'Reilly))', 'isbn' => '0596514271', 'publisher' => 'O\'Reilly Media, Inc.', 'image_small' => 'http://ecx.images-amazon.com/images/I/51p2cN2yIML._SL75_.jpg', 'url_amazon' => 'http://www.amazon.com/Regular-Expression-Pocket-Reference-Expressions/dp/0596514271%3FSubscriptionId%3D1VD4TGW1VSXT1RE5Y2G2%26tag%3Dws%26linkCode%3Dxm2%26camp%3D2025%26creative%3D165953%26creativeASIN%3D0596514271', 'pages' => '126' }; #### $insert = "INSERT into books ( id, title, authors, isbn, pages, publisher, publication_date, image_small, image_medium, url_amazon, createdAt) VALUES ( NULL, '" . $hash{$key}{'title'} . "', '" . $hash{$key}{'authors'} . "', '" . $hash{$key}{'isbn'} . "', '" . $hash{$key}{'pages'} . "', '" . $hash{$key}{'publisher'} . "', '" . $hash{$key}{'publication_date'} . "', '" . $hash{$key}{'image_small'} . "', '" . $hash{$key}{'image_medium'} . "', '" . $hash{$key}{'url_amazon'} . "', NULL)"; $sth = $dbh->prepare($insert);