if (!file_exists($againstDir)) {
echo "<font color='red'>no file exist:</font>";
}
echo "<br><br>";
//echo "<a>$sql <br><br><br>";
if (preg_match("/Hieroglyphics/i", $sql) == 1) {
//$db = new MysqlHieroglyphics();
}
$db = new MysqlJiaguwen();
$ret = $db->query($sql);
echo "count=" . count($ret) . ", " . $sql . "<br>";
$r2htm = new DbRow2Htm();
echo "<table border='1'>\r\n";
$r2htm->htm_tr_title($ret[0]);
foreach ($ret as $row) {
$r2htm->htm_tr_dat_rd($sql, $row);
if (isset($row['jtoh'])) {
$r2htm->push2TmpArr($row['jtoh']);
}
}
echo "</table>\r\n";
echo "<br>total hieros=" . count($r2htm->TmpArr);
echo "<br>";
if (isset($r2htm->TmpArr)) {
sort($r2htm->TmpArr);
foreach ($r2htm->TmpArr as $hid) {
$fname = $r2htm->img_src_of($hid, $hid);
print "<img src='{$fname}' /img>{$hid}";
}
}
?>
//$ut = new MysqlUti();
$jia = new MysqlJiaguwen();
$sql = "SELECT * FROM Jiaguwen ORDER BY jid";
$sql = "SELECT * FROM Jiaguwen";
$sql = "SELECT * FROM Jiaguwen WHERE jtoh LIKE '%,%' LIMIT 0,10";
if (isset($_REQUEST["sql"]) && strlen($_REQUEST["sql"]) > 0) {
$sql = $_REQUEST["sql"];
}
//echo $sql . "";
$ret = $jia->query($sql);
echo "count=" . count($ret) . ",sql={$sql}";
$r2htm = new DbRow2Htm();
echo "<table border='1'>\r\n";
$r2htm->htm_tr_title($ret[0]);
foreach ($ret as $row) {
$r2htm->htm_tr_dat_rd($row);
$r2htm->push2TmpArr($row['jtoh']);
}
echo "</table>\r\n";
echo "<br>total hieros=" . count($r2htm->TmpArr);
echo "<br>";
sort($r2htm->TmpArr);
foreach ($r2htm->TmpArr as $hid) {
$fname = MysqlUti::src_of($hid);
//"../../odb/hiero/ccer-h/$bname.gif";
print "<img src='{$fname}' /img>{$hid}";
}
?>
<!-- id="clentarea"-->
</div>
</body>
