public function buscaTodosProgramas()
{
DataBase::createConection();
$res = mysql_query($this->_sel);
if ($res === FALSE) {
echo "programa desconhecido: " . $this->_sel;
return null;
} else {
return $res;
}
}
<?php
include_once 'DBConnection.php';
DataBase::createConection();
class FamiliaDAO
{
private $_ins = "INSERT INTO familia (`cep`, `logradouro`, `numero`, `bairro`, `cod_cidade`) VALUES";
private $_rem = "DELETE FROM familia WHERE";
private $_alt = "UPDATE familia set";
private $_sel = "SELECT * FROM familia";
private $_sel_max_id = "SELECT max(id_familia) as max_id_familia FROM familia";
public function cadastraFamilia($cep, $logradouro, $numero, $bairro, $cod_cidade)
{
$this->_ins .= " ('{$cep}', '{$logradouro}', {$numero}, '{$bairro}', '{$cod_cidade}')";
$_res = mysql_query($this->_ins) or mysql_errno();
if ($_res != TRUE) {
echo 'falha na operação';
}
return $_res;
}
public function removeFamiliaById($idFamilia)
{
$this->_rem .= " id_familia={$idFamilia}";
return mysql_query($this->_rem) or die(mysql_error());
//this.testeInsert($_res);
}
public function buscaFamiliaById($idFamilia)
{
$select = "SELECT * FROM familia WHERE id_familia= {$idFamilia}";
$res = mysql_query($select);
if ($res === FALSE) {
