<?php
/**
* Exemplos de uso para class connection
* @author Antonio Santos
* @version 0.1
*/
$db = new connection();
/**
* Exemplo de insert
*/
$fields_insert = array('field1' => 'first inserted field', 'field2' => 'second inserted field', 'field3' => 'third inserted field');
$result = $db->insert('table_name', $fields_insert, 'id');
/**
* Exemplo de select
*/
$result = $db->select('table_name', array('*'), array('id' => 1));
/**
* Exemplo de update
*/
$fields_update = array('field1' => 'first updated field', 'field2' => 'second updated field', 'field3' => 'third updated field');
$conditions = array('user' => 'tester');
$result = $db->update('table_name', $fields_update, $conditions, 'id');
/**
* Exemplo de delete
*/
$conditions = array('id' => 1);
$result = $db->delete('table_name', $conditions);
/**
* Exemplo de outras queries
*/
<html>
<head>
<title>PHP Test</title>
</head>
<body>
<?php
require "db.php";
echo "Launching missile : {$_GET['missile']}<br>";
echo "Latitude locked : {$_GET['lat']}<br>";
echo "Longitude locked : {$_GET['lnt']}<br>";
$conn = new connection("localhost", "root", "f0nXsBgB", "nuclear");
$conn->insert("nuclear", ["lat", "lng", "type"], [$_GET["lat"], $_GET["lnt"], $_GET["missile"]]);
$data = $conn->shift($conn->select("nuclear", ["*"]));
foreach ($data as $row) {
foreach ($row as $d) {
echo "{$d}<br>";
}
echo "<br>";
}
?>
</body>
</html>
