Laravel Database functions

Select

$result = $db->select("SELECT * FROM targets WHERE name = ? and age = ?", array($_POST['item1'], $_POST['item2']));
foreach ($result as $row) {
$myname = $row['name'];
$myage = $row['age'];
}

Insert

$db->insert("INSERT INTO table1 (name,email,telephone) VALUES (?, ?, ?)", array($name, $email, $telephone));


Update

$db->update("UPDATE table1 SET token = ? WHERE email = ?", array($myvar, $myemail));

Delete

$db->delete("DELETE FROM table1 WHERE id = ?", array($myvar));

Get one result + Sum function

$result = current($db->select("SELECT sum(clicks) FROM table1 WHERE date = ? ", array($thisday)));
echo $totalclicks = current($result);