PHP mysl_error Examples

Example #1

File: ultimoId.inc.php Project: pereiraMichel/redeunavida

 public static function ultimoIdBanco($id, $tabela)
 {
     $sqlUltimoNumero = "SELECT MAX(" . $id . ") AS " . $id . " FROM " . $tabela;
     try {
         $resultUltimoNum = mysql_query($sqlUltimoNumero) or die("Último ID. " . RETURN_SQL . mysl_error());
         $dados = mysql_fetch_array($resultUltimoNum);
         $novoId = $dados[$id] + 1;
         return $novoId;
         mysql_close($resultUltimoNum);
     } catch (Exception $ex) {
         echo EXCEPTION_CON . $ex->getMessage();
     }
 }

Example #2

File: balancete.inc.php Project: pereiraMichel/redeunavida

 public function ultimoId()
 {
     $sqlUltimoNumero = "SELECT MAX(idBalancete) AS idBalancete FROM balancete";
     try {
         $resultUltimoNum = mysql_query($sqlUltimoNumero) or die(RETURN_SQL . mysl_error());
         $dados = mysql_fetch_array(resultUltimoNum);
         $novoId = $dados['idBalancete'] + 1;
         $this->idBalancete = $novoId;
         mysql_close($resultUltimoNum);
     } catch (Exception $ex) {
         echo EXCEPTION_CON . $ex->getMessage();
     }
 }