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>