File "PagosT.php.bak"

Full Path: C:/wamp64/www/Carteras/PagosT.php.bak
File size: 3.09 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?PHP
header("Content-type: application/octet-stream"); 
header("Content-Disposition: attachment; filename=CLIENTES.xls"); 
header("Pragma: no-cache"); 
header("Expires: 0");

	// Datos de la base de datos
	$usuario = "SANMARINO";
	$password = "sanmarino2021*";
	$servidor = "localhost";
	$basededatos = "pagos";
	
	// creación de la conexión a la base de datos con mysql_connect()
	$conexion = mysqli_connect( $servidor, $usuario, "$password" ) or die ("No se ha podido conectar al servidor de Base de datos");
	
	// Selección del a base de datos a utilizar
	$db = mysqli_select_db( $conexion, $basededatos ) or die ( "No se ha podido conectar a la base de datos" );

$n=1;



?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Archivo Programacion</title>
</head>

<body>
<center>
  <p><strong>LISTADO DE CLIENTES AVICAMPO PEREIRA</strong>
  </p>
  <p>&nbsp;</p>
</center>
<table width="1680" border="1" cellspacing="0" bordercolor="#999999">
  <tr bgcolor="#CCCCCC">
	<td width="132"><center><strong>Id</strong></center></td>
    <td width="132"><center><strong>Cedula</strong></center></td>
    <td width="268"><center><strong>Sucursal</strong></center></td>
    <td width="112"><center><strong>Nit+Suc</strong></center></td>
    <td width="86"><center><strong>Nombre Completo Cliente</strong></center></td>
    <td width="86"><center><strong>Estado</strong></center></td>
    <td width="96"><center><strong>Bloqueo C</strong></center></td>
    <td width="94"><center><strong>Bloqueo Cupo</strong></center></td>
    <td width="164"><center><strong>Bloqueo Mora</strong></center></td>
    <td width="106"><center><strong>Cupo Cliente</strong></center></td>
    <td width="106"><center><strong>Plaz Cliente</strong></center></td>
  </tr>
          <?php
		  $DATO=" ";
		  
		$tabla = mysqli_query($conexion,"SELECT * FROM carteraCL   ");	
			while ($row_consulta_form = mysqli_fetch_array($tabla))
		{   //$FECHAV	=$row_consulta_form['NIT'];
			$D1		=$row_consulta_form['id'];
			$D2		=$row_consulta_form['cedula'];
			$NIT=$row_consulta_form['suc'];
			$RAS=$row_consulta_form['nombre'];
			$FD=$row_consulta_form['estado'];
			$FV=$row_consulta_form['bloqueocartera'];
			$DI=$row_consulta_form['bloqueocupo'];
			$PA=$row_consulta_form['bloqueomora'];
			$COR=$row_consulta_form['cupocliente'];
			$TRE=$row_consulta_form['placocliente'];
	else
			{			
		 
	?>
  <tr >
    <td><?php echo $D1; ?></td>
    <td><?php echo $D2; ?></td>
    <td><?PHP echo $NIT;?></td>
    <td><?PHP echo $RAS;?></td>
    <td><?PHP echo $FD;?></td>
     <td><?PHP echo $FV;?></td>
    <td><?PHP echo $DI;?></td>
     <td><?PHP echo $PA;?></td>
     <td><?PHP echo $COR;?></td>
     <td><?PHP echo $TRE;?></td>
	<td><?PHP echo $SES;?></td>
  </tr>
  <?php 
			$n=$n+1;}}
  
  ?>
</table>

</body>
</html>
<?php
echo "<META HTTP-EQUIV=Refresh CONTENT=\"0; URL=subefoto.PHP\"  >";

?>