<?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>