$i=0;
foreach($result as $resultbook){
//print_r($resultbook[\'Book\'][\'Name\']);
$viewURL = $resultbook[\'Book\'][\'ViewUrl\'];
$splitURL = split(\'/\', $viewURL);
$splitURL2 = split(\'\\?\',$splitURL[4]);
$bookID = $splitURL2[0];
$query = \"insert into books(book_id,book_name,article_id,preview) values(\'\".$bookID.\"\',\'test\',\'\".$articleID.\"\',\".$isPreview.\")\";
echo \"<br>\";
print_r($query);
try{
$database->setQuery($query);
$database->query();
}catch(Exception $e){
echo $e->getMessage();
}
//$database->setQuery($query);
//$database->query();
}
-