Viewing file:  actualizar_rubros_viejos.php (1.83 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
session_start();
$pagina_actual="actualizar-rubros";
$categoria_actual="rubros";
require_once("includes/config.php");
require_once("includes/funciones.php");?>
<!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>Documento sin título</title>
</head>
<body>
<?
//$query = $mysqli->query("TRUNCATE TABLE banking_rubros_viejo");
//$lines = file('extraer/rubros.txt');
/*foreach ($lines as $line_num => $line) {
$datos = explode(" ", $line);
$ww=0;
while ($ww<=1)
{$datos[$ww]=trim($datos[$ww]);
$datos[$ww] = str_replace( "'", "_", $datos[$ww] );
$ww=$ww+1;
} */
$rubros=$mysqli->query("
SELECT cod_rubro, descripcion
FROM banking_rubros
");
while ($rubro = mysqli_fetch_assoc($rubros)){
$cod_rubro=$rubro['cod_rubro'];
$n_rubro=utf8_decode($rubro['descripcion']);
//$n_rubro=$mysqli->real_escape_string($rubro['descripcion']);
$insertSQL = $mysqli->query("INSERT INTO banking_rubros (cod_rubro, descripcion) VALUES ('$cod_rubro','$n_rubro')");
} //fin while
//$query = $mysqli->query("TRUNCATE TABLE banking_rubros");
$subrubros=$mysqli->query("
SELECT cod_rubro, cod_subrubro, descripcion
FROM banking_subrubros
");
while ($subrubro = mysqli_fetch_assoc($subrubros)){
$cod_rubro=$subrubro['cod_rubro'];
$cod_subrubro=$subrubro['cod_subrubro'];
$cate=$cod_rubro.".".$cod_subrubro;
$n_subrubro=utf8_decode($subrubro['descripcion']);
$insertSQL = $mysqli->query("INSERT INTO banking_rubros (cod_rubro, descripcion) VALUES ('$cate','$n_subrubro')");
} //fin while
?><script language="javascript">location.href = "actualizar_articulos.php";</script>
</body>
</html>
|