コード例 #1
0
ファイル: comprobante.php プロジェクト: hrherrera/proyecto
<?php

session_start();
include "GestionBD.php";
$obj = new GestionBD();
$cn = $obj->conectar();
$_SESSION["n"]++;
//echo "session N° ".$_SESSION["n"]."<br>";
if ($_SESSION["n"] == 1) {
    $cadena = "Select nrofac from facturas order by nrofac desc";
    $rs = $obj->ejecutarConsulta($cadena);
    $fila = mysql_fetch_array($rs);
    $nrofact = $fila[0] + 1;
    $nuevonro = str_pad($nrofact, 6, 0, 0);
    $_SESSION['nf'] = $nuevonro;
}
$hoy = date("Y-m-d");
$vcodcli = substr($_SESSION['ope'], 14, 3);
$cadena2 = "Select sum(total) from carrito where codope='" . $_SESSION['ope'] . "'";
$rs2 = $obj->ejecutarConsulta($cadena2);
$fila2 = mysql_fetch_array($rs2);
$total = $fila2[0];
$cadena3 = "Select * from carrito where codope='" . $_SESSION['ope'] . "'";
$rs3 = $obj->ejecutarConsulta($cadena3);
$cadena4 = "Select * from clientes where codcli='" . $vcodcli . "'";
//echo $cadena4;
$rs4 = $obj->ejecutarConsulta($cadena4);
$fila4 = mysql_fetch_array($rs4);
$vapecli = $fila4[1];
$vnomcli = $fila4[2];
$vdircli = $fila4[3];