Ver Mensaje Individual
  #2 (permalink)  
Antiguo 12/02/2015, 14:28
dragondark
 
Fecha de Ingreso: febrero-2015
Mensajes: 3
Antigüedad: 9 años, 2 meses
Puntos: 0
Respuesta: problema al guardar los datos

y aqui se ejecuta las condiciones para guardalo:
factproveedorB.php:


<div id= "section" class="grid_12" >
<input type="button" value="Imprimir" onClick="javascript:imprSelec('muestra')" />
<input type="submit" value=" regresar " onclick = "this.form1.action = 'factprovedor.php'" />
<div id="muestra">
<form enctype="multipart/form-data" method="POST" id="form1" name="form1" >
<?php


$idfact= $_POST["idfact"];
$fecha = $_POST["fecha"];

$nombre = $_POST["nombre"];
$apellido = $_POST["apellido"];
$cedula = $_POST["cedula"];
$telefono = $_POST["telefono"];
$lugar = $_POST["lugar"];
$dirre =$_POST["dirre"];

$mer1 = $_POST["mer1"];
$pre1 = $_POST["pre1"];
$cant1 = $_POST["cant1"];
$total1 = $_POST["total1"];

$mer2 = $_POST["mer2"];
$pre2 = $_POST["pre2"];
$cant2 = $_POST["cant2"];
$total2 = $_POST["total2"];

$mer3 = $_POST["mer3"];
$pre3 = $_POST["pre3"];
$cant3 = $_POST["cant3"];
$total3 = $_POST["total3"];

$mer4 = $_POST["mer4"];
$pre4 = $_POST["pre4"];
$cant4 = $_POST["cant4"];
$total4 = $_POST["total4"];

$mer5 = $_POST["mer5"];
$pre5 =$_POST["pre5"];
$cant5 = $_POST["cant5"];
$total5 = $_POST["total5"];

$mer6 = $_POST["mer6"];
$pre6 = $_POST["pre6"];
$cant6 = $_POST["cant6"];
$total6 = $_POST["total6"];

$mer7 = $_POST["mer7"];
$pre7 = $_POST["pre7"];
$cant7 = $_POST["cant7"];
$total7 = $_POST["total7"];

$mer8 = $_POST["mer8"];
$pre8 = $_POST["pre8"];
$cant8 = $_POST["cant8"];
$total8 = $_POST["total8"];

$mer9 = $_POST["mer9"];
$pre9 = $_POST["pre9"];
$cant9 = $_POST["cant9"];
$total9 = $_POST["total9"];

$mer10 = $_POST["mer10"];
$pre10 = $_POST["pre10"];
$cant10 = $_POST["cant10"];
$total10 = $_POST["total10"];

$subtotal = $_POST["subtotal1"];
$iva = $_POST["iva1"];
$desc = $_POST["desc1"];
$totalp = $_POST["totalps"];

$tiporadio=$_POST["status"];

if($tiporadio=="venta"){

$perfiltexto="venta";
if ( $_POST["nombre"]!="" and $_POST["apellido"]!="" and $_POST["cedula"]!="" )
{
$conexion= mysql_connect("localhost","root","");
mysql_select_db("servifrenos",$conexion);
$sql = mysql_query ("INSERT INTO factproveedor(fecha,nombre,apellido,cedula,telefon o,lugar,dirre,status,mer1,pre1,cant1,total1,mer2,p re2,cant2,total2,mer3,pre3,cant3,total3,mer4,pre4, cant4,total4,mer5,pre5,cant5,total5,mer6,pre6,cant 6,total6,mer7,pre7,cant7,total7,mer8,pre8,cant8,to tal8,mer9,pre9,cant9,total9,mer10,pre10,cant10,tot al10,subtotal1,iva1,desc1,totals)" + "VALUES('".$fecha."','".$nombre."','".$apellido."' ,'".$cedula."','".$telefono."','".$lugar."','".$di rre."','".$perfiltexto."','".$mer1."','".$pre1."', '".$cant1."','".$total1."','".$mer2."','".$pre2."' ,'".$cant2."','".$total2."','".$mer3."','".$pre3." ','".$cant3."','".$total3."','".$mer4."','".$pre4. "','".$cant4."','".$total4."','".$mer5."','".$pre5 ."','".$cant5."','".$total5."','".$mer6."','".$pre 6."','".$cant6."','".$total6."','".$mer7."','".$pr e7."','".$cant7."','".$total7."','".$mer8."','".$p re8."','".$cant8."','".$total8."','".$mer9."','".$ pre9."','".$cant9."','".$total9."','".$mer10."','" .$pre10."','".$cant10."','".$total10."','".$subtot al."','".$iva."','".$desc."','".$totalp."')");
echo "<div align='center'>Numero de factura es: $idfact</br>" ;
echo "Fecha: $fecha</br></br>" ;
echo "SERVIFRENOS LM2021.CA</br>" ;
echo "RIF:J-40154425-8</br></br>";
echo "<div align='center'>Cliente:</br>" ;
echo "Nombre: $nombre $apellido</br>" ;
echo "Cedula: $cedula </br>" ;
echo "Telefono: $telefono</br>" ;
echo "Lugar: $lugar</br>" ;
echo "Dirrecion:$dirre </br>" ;
echo "status: $perfiltexto</br></br></div>" ;
echo "<td>Producto----------Precio-----------Cantidad-----------Total</br>" ;
echo "$mer1-----------------$pre1 ------------$cant1------------$total1 </br>" ;
echo "$mer2-----------------$pre2 ------------$cant2------------$total2 </br>" ;
echo "$mer3-----------------$pre3 ------------$cant3------------$total3 </br>" ;
echo "$mer4-----------------$pre4 ------------$cant4------------$total4 </br>" ;
echo "$mer5-----------------$pre5 ------------$cant5------------$total5 </br>" ;
echo "$mer6-----------------$pre6 ------------$cant6------------$total6 </br>" ;
echo "$mer7-----------------$pre7 ------------$cant7------------$total7 </br>" ;
echo "$mer8-----------------$pre8 ------------$cant8------------$total8 </br>" ;
echo "$mer9-----------------$pre9 ------------$cant9------------$total9 </br>" ;
echo "$mer10----------------$pre10 -----------$cant10-----------$total10 </br></br>" ;
echo "Subtotal: $subtotal</br>";
echo "Iva: $iva</br>" ;
echo "Descuento: $desc</br>" ;
echo "Total a cancelar: $totalp</br></div>" ;

echo "<script>alert('Se ha registrado correctamente')</script>";

$consulta=mysql_query($sql,$conexion)or die($sql."no se pudo ejecutar la instruccion".mysql_error($conexion));


}
else{
echo "<script>alert('debe colocar un nombre, apellido y cedula correctamente')</script>";

echo "<script>location.href='factprovedor.php'; </script>";
}
}



elseif($tiporadio=="zero"){

echo "<script>alert('Debe selecionar algo')</script>";
echo "<script>location.href='factprovedor.php'; </script>";
}



?>
</form>
</div>
<script type="text/javascript">
function imprSelec(muestra)
{var ficha=document.getElementById(muestra);var ventimp=window.open(' ','popimpr');ventimp.document.write(ficha.innerHTM L);ventimp.document.close();ventimp.print();ventim p.close();}
</script>