$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);
