Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Carteras
:
PagosT.php.bak
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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> </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\" >"; ?>