function htm_img_hid($val)
{
$ret = "";
$arr = preg_split("/[,]/i", $val);
foreach ($arr as $bname) {
if ('0' == $bname || strlen($bname) == 0) {
continue;
}
$fname = MysqlUti::src_of($bname);
//"../../odb/hiero/ccer-h/$bname.gif";
$ret .= "<img src='{$fname}'/>{$bname}";
}
return $ret;
}
$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>
</html>
$_SESSION["database"] = $db;
syslog(0, "Hieroglyphics prepare for undo:" . $sql_undo);
if ("+" == $op) {
$newVal = MysqlUti::merge_str_links($Oldval, $uval);
} else {
if ("-" == $op) {
$newVal = MysqlUti::remove_str_links($Oldval, $uval);
} else {
die("err op={$op}");
}
}
if ($newVal == $Oldval) {
die("err new==old same");
}
$sql = "UPDATE Hieroglyphics SET {$sc}='{$newVal}' WHERE hid='{$keyId}'";
$type_of_str_link = MysqlUti::type_of_str_links($newVal);
if ("err" == $type_of_str_link) {
syslog(0, "err type of str jink:" . $sql);
die("err mixed type for update");
}
syslog(0, "to run sql:" . $sql);
$ret = $odb->execute($sql);
if (0 == $ret) {
die("err " . $sql);
}
print $sql;
die("");
} else {
die("err wrong db=" . $db);
}
}
