include_once "init.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Crud Template</title>
</head>
<body>
<?php
//Create
$rows = array('author', 'title', 'category', 'year', 'isbn');
$values = array('Luciano', 'Programação Android', 'Programação', '2014', '222222222');
$insertQuery = Database::Action('insert', 'classics', $rows);
$insertQuery($values);
//Read
$selectAllQuery = Database::Action('getAll', 'classics');
var_dump($selectAllQuery);
echo "<hr>";
$selectQuery = Database::Action('getWhere', 'classics', 'isbn');
var_dump($selectQuery('222222222'));
//Update
$updateQuery = Database::Action('update', 'classics', 'author', 'isbn');
$updateQuery('Marcos', '222222222');
//Delete
$deleteQuery = Database::Action('delete', 'classics', 'isbn');
$deleteQuery('222222222');
?>
</body>
</html>
<?php
include_once "init.php";
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<?php
/*
$arr = array('author','title','category','year','isbn');
$values = array('TesteMarcos','PHP com Closures','Programação','2014','999999999');
$insertLivro = Database::Action('insert','classics',$arr);
$insertLivro($values);
*
*/
$updateLivro = Database::Action('update', 'classics', 'author', 'isbn');
$updateLivro('TesteMarcosUpdated', '999999999');
?>
</body>
</html>
