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) {