Crear archivo de texto luego de consulta

[linuxzero]

Fijate con esto ;)

Código PHP:

<?php
include("conexion.php"); //conexion
 
//Funciones
function add_ceros($numero,$ceros) {
$order_diez = explode(".",$numero); 
$dif_diez = $ceros - strlen($order_diez[0]); 
for($m = 0 ; 
$m < $dif_diez;
$m++) 
{ 
@$insertar_ceros .= 0;
} 
return $insertar_ceros .= $numero; 
}
 
 
//Estructura de la tabla
$tabla[] = "<table border=1>";
$tabla[] = "<tr>";
$tabla[] = "<td>CSUBDIA</td>";
$tabla[] = "<td>CCOMPRO</td>";
$tabla[] = "<td>CFECCOM</td>";
$tabla[] = "<td>CCODMON</td>";
$tabla[] = "<td>CSITUA</td>";
$tabla[] = "<td>CTIPCAM</td>";
$tabla[] = "<td>CGLOSA</td>";
$tabla[] = "<td>CTOTAL</td>"; 
$tabla[] = "<td>CTIPO</td>";
$tabla[] = "<td>CFLAG</td>";
$tabla[] = "<td>CDATE</td>";
$tabla[] = "<td>CHORA</td>";
$tabla[] = "<td>CUSER</td>";
$tabla[] = "<td>CFECCAM</td>";
$tabla[] = "<td>CORIG</td>";
$tabla[] = "<td>CFORM</td>";
$tabla[] = "<td>CTIPCOM</td>";
$tabla[] = "<td>CEXTOR</td>";
$tabla[] = "<td>CFECCOM2</td>";
$tabla[] = "<td>CFECCAM2</td>";
$tabla[] = "<td>COPCION</td>";
$tabla[] = "</tr>";
 
 
//Definicion de Variables
$c="06";
$numero="1";
$CCODMON="MN";
$CSITUA="F";
$CTIPCAM="0.000000";
$CTIPO="M";
$CFLAG="N";
$CUSER="SIST";
$COPCION="S";
 
 
 
//Consulta a la bd
$sql = mysql_query("SELECT * FROM tabla1") or die ("Error en el query: ".mysql_error());
 
while($rs=mysql_fetch_array($sql)){ 
//Variables
$MESANIO=$rs['MESANIO'];
$CCOMPRO=substr($MESANIO,-2);
$CCOMPRO_CORRELATIVO=add_ceros($numero,4);
$numero++;
$CCOMPRO_CONCATENADOS=$CCOMPRO.$CCOMPRO_CORRELATIV O;
 
 
 
 
 
 
 
$tabla[] = "<tr>";
$tabla[] = "<td>$c</td>";
$tabla[] = "<td>$CCOMPRO_CONCATENADOS</td>";
$tabla[] = "<td>$rs[FECHA]</td>"; 
$tabla[] = "<td>$CCODMON</td>"; 
$tabla[] = "<td>$CSITUA</td>"; 
$tabla[] = "<td>$CTIPCAM</td>";
$tabla[] = "<td>$rs[PROVEEDOR]</td>"; 
$tabla[] = "<td>$rs[TOTAL]</td>"; 
$tabla[] = "<td>$CTIPO</td>";
$tabla[] = "<td>$CFLAG</td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td>$CUSER</td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td></td>";
$tabla[] = "<td>$COPCION</td>";
 
 
 
$tabla[] = "</tr>";
 
}
$tabla[] = "</table>";
 
$tabla = join('', $tabla);
 
file_put_contents('fichero.txt', $tabla);
 
?>