1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
|
<?php
$table = array();
$dbh= odbc_connect("lotusOpen",'', '');
$tablelist = odbc_tables($dbh);
while ($table[] = odbc_fetch_array($tablelist));
foreach ($table as $POST) {
$champs[] = array();
$champs2[] = array();
$outval = odbc_columns($dbh,$POST["TABLE_NAME"] );
while (odbc_fetch_into($outval, $pages)) {
if($pages[2] ==$POST["TABLE_NAME"] ){
$champs[] = $pages[3];
$champs2[] = $pages[5];
}
}
$condition = "";
foreach ($champs as $key => $value) {
if ( !is_array($value)&& $champs2[$key]=="VARCHAR"){
// print_r($value);echo "</br>";
// echo $value ." ".$POST["TABLE_NAME"]."</br>";
$condition .= " ".$value ." LIKE '%CR004#9591%' or ";
}
}
$condition = substr($condition,0,-3);
$lotusOpen = odbc_connect ("lotusOpen",'','') or die("erreur conexion lotus open");
$qry="SELECT * FROM ".$POST["TABLE_NAME"]." where ".$condition;
$result = odbc_exec($lotusOpen,$qry);
while ($datas = odbc_fetch_array($result))
print_r($datas);echo "<br /><br />";
}
?> |
Partager