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