Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- include "../php/conexion.php";
- $conexion=conexion();
- $tamanoTabla="450px";
- if (!empty($_FILES['csv']['size']) && $_FILES['csv']['size'] > 0) {
- $file = $_FILES['csv']['tmp_name'];
- $handle = fopen($file,"r");
- while ($data = fgetcsv ($handle, 1000, ","))
- {
- //si la linea es igual a 1 no guardamos por que serian los títulos de la hoja del excel.
- $numero = count($data);
- $query = sqlsrv_query($conexion,"INSERT INTO archivoHabilitacionRenta values ('$data[0]','$data[1]','$data[0]-$data[1]')");
- }
- }else{
- $tamanoTabla="0px";
- }
- if (isset($_SESSION['usuario'])) {
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="utf-8">
- <title>Habilitación Articulos</title>
- <?php
- ##Agrego las extenciones y librerias
- require '../view/ext.html';
- ?>
- </head>
- <body>
- <?php include("../view/Menu.php");?>
- <?php require("../view/barra.html");?>
- <?php $sql="select distinct t2.razonSocial,t2.nit,t2.cardCode from AlmacenesRenta t1
- left join clientes t2
- on t1.nit=t2.nit";
- $ResultadoClientes =sqlsrv_query($conexion,$sql); ?>
- <div class="container">
- <br>
- <br>
- <form action="ReglasHabilitacionArticulosRenta.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
- <input name="csv" type="file" id="csv" /> <br />
- <input type="submit" name="Submit" value="Submit" />
- </form>
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement