$update = new update(); if (!$update->connect('exiva_unis02')) { die('DB>> No connection'); } $update->import_mysql(); $each_page = 5; $end = sizeof($deleted) / $each_page; $data = array(); for ($i = 0; $i < $end; $i++) { $d = array_slice($deleted, $i * $each_page, $each_page); $sql = 'SELECT c.*, p.* FROM constancia c, provedor p WHERE c.exencion IN (' . implode(',', $d) . ') AND c.nit = p.nit ORDER BY c.exencion'; $result = $update->query($sql); while ($row = odbc_fetch_array($result)) { $data[] = $row; } odbc_free_result($result); } $prov = array(); $ce = $cp = $cf = 0; foreach ($data as $row) { $row = $update->trim($row); extract($row); list(, $year, $month, $day) = $update->preg_match('#([0-9]+)\\-([0-9]+)\\-([0-9]+)#si', $fec_exe); $cdate = gmmktime(6, 0, 0, $month, $day, $year); $cdate = $cdate > 0 ? $cdate : 0; $null = empty($concepto) || strstr(strtolower($concepto), 'nula') || !$nit ? true : false; $nit = !$null ? $nit : '0';
<?php define('IN_EX', true); require '../includes/common.php'; require './class.php'; $user->session_start(); // // ODBC database // $update = new update(); if (!$update->connect('exiva_unis01')) { die('DB>> No connection'); } /* $sql = "SELECT * FROM constacia WHERE nit = '18733-0'"; $result = odbc_exec($update->dbid, sql); while ($row = odbc_fetch_array($result)) { print_r($row); echo '<br /><br />'; } */ $sql = "DELETE FROM provedor\r\n\tWHERE nit = '300407-9'"; $update->query($sql);