<?php
$db = new MySql();
$query = "SELECT * FROM TABLE WHERE 1";
$select = $db->select($query);
//Mostrar o Array gerado pela Class
echo "<pre>";
print_r($select);
//Total de registros
echo $db->getNumRows($select);
//Inserindo dados no Banco
$queryInsert = "INSERT INTO TABLE (COLUMNS_01) VALUES ('VALUE_01')"
$insert = $db->insert($queryInsert);
//Ultimo ID inserido
echo $db->getId();
//Atualizando uma tabela
$queryUpdate = "UPDATE TABLE SET COLUMNS_01 = 'VALUE_01 WHERE ID_COLUMNS = $var";
$update = $db->insert($queryUpdate);
?>
|
Download
