public function load() { $jjj = new MysqlJiaguwen(); $sql = "SELECT * FROM `Jiaguwen`"; $this->jgw = $jjj->query($sql); return $this; }
<?php require_once "../MysqlJiaguwen.php"; //print_r($_REQUEST); $jid = $_REQUEST["jid"]; $jgw = new MysqlJiaguwen(); $sql = "SELECT * FROM `Jiaguwen` WHERE jid={$jid}"; //0:idx,1:jid,2:zid,3:freq $ret = $jgw->query($sql); //print_r( $result ); printf("%s, &#%s;%s, (id=%d, frq=%d)", $ret[0][1], $ret[0][2], $ret[0][2], $ret[0][0], $ret[0][3]);
public function GenXmlDataForTree() { $againstDir = "../uti/jgw/mer/compound/p/"; $againstDir = "../../odb/tbi/img/jgif/"; if (!file_exists($againstDir)) { echo "<font color='red'>no file exist:</font>"; } $sql = "SELECT * FROM Jiaguwen ORDER BY jid"; $sql = "SELECT * FROM Jiaguwen"; $sql = "SELECT * FROM Jiaguwen WHERE jtoh LIKE '%,%' LIMIT 0,10"; $sql = "SELECT jnm, jid FROM Jiaguwen WHERE jnm<>'0' AND jnm <>'-' AND jnm<>'' ORDER BY jnm LIMIT 0,10000"; if (isset($_REQUEST["sql"]) && strlen($_REQUEST["sql"]) > 0) { $sql = $_REQUEST["sql"]; } else { $_REQUEST["sql"] = ""; } if (preg_match("/Hieroglyphics/i", $sql) == 1) { //$db = new MysqlHieroglyphics(); } $db = new MysqlJiaguwen(); $ret = $db->query($sql); $this->info = "count=" . count($ret) . ", " . $sql . "<br>"; $attrName = "jnm"; $newsXML = new SimpleXMLElement("<li>0</li>"); $newsXML->addAttribute('id', "treview"); self::AddChildNode($newsXML, $attrName, "1", null, ""); self::AddChildNode($newsXML, $attrName, "2", null, ""); self::AddChildNode($newsXML, $attrName, "3", null, ""); self::AddChildNode($newsXML, $attrName, "4", null, ""); self::AddChildNode($newsXML, $attrName, "5", null, "-"); self::AddChildNode($newsXML, $attrName, "6", null, "-"); ////////////////////////////////////// //add list table //$newTable = $newsXML->addChild('table'); foreach ($ret as $row) { $jnm = $row['jnm']; $jid = $row['jid']; if (!isset($jnm) || !isset($jid)) { } $imgSrc = $againstDir . $jid . ".gif"; $arrJnm = explode(".", $jnm); $count = count($arrJnm); $arrId = array(); $arrId[] = "{$jnm}"; for ($i = $count - 1; $i >= 0; $i -= 1) { unset($arrJnm[$i]); $arrId[] = implode(".", $arrJnm); } $FindNode = null; $FindJNM = "{$jnm}"; foreach ($arrId as $idx => $ID) { $result = $newsXML->xpath("//*[@" . $attrName . "='" . $ID . "']"); //get all nod with attr is valold. while (list(, $node) = each($result)) { //$node[$attrName]=$attrValNew; $FindNode = $node; $FindJNM = $ID; } if ($FindNode) { break; } } if ($FindNode != null) { if ($FindJNM != $jnm) { $lis = $FindNode->xpath(".."); $li = null; while (list(, $node) = each($lis)) { //$node[$attrName]=$attrValNew; $li = $node; break; } if ($li != null) { $uls = $li->xpath("./ul"); $ul = null; while (list(, $node) = each($uls)) { //$node[$attrName]=$attrValNew; $ul = $node; break; } $FindNode = self::AddChildNode($li, $attrName, $jnm, $ul, null); } else { } } } else { if (null === $FindNode) { $FindNode = self::AddChildNode($newsXML, $attrName, $jnm, $FindNode, null, null); } } $img = $FindNode->addChild('img'); $img->addAttribute("src", $imgSrc); $img->addAttribute("class", "ooimg"); //class="ooimg" $img->addAttribute("title", "{$jnm}::{$jid}"); //class="ooimg" } $xstr = $newsXML->asXML(); echo "\n\n" . $xstr . "\n\n"; }
</script> <body> <?php require_once "../uti/Ureaddir.php"; require_once "../uti/MysqlJiaguwen.php"; $againstDir = "../uti/jgw/mer/compound/p/"; $againstDir = "../../odb/tbi/img/jgif/"; $jdb = new MysqlJiaguwen(); $sql = "Select zid1, jid from Jiaguwen"; $rows = $jdb->query($sql); $arr = array(); foreach ($rows as $row) { $zid1 = $row["zid1"]; $jid = $row["jid"]; if (!isset($arr[$zid1])) { $arr[$zid1] = array(); } $arr[$zid1][] = $jid; } echo "var ZJ=new Array(); //zid1 to jid associated list. Tot=" . count($arr) . "<br><br>"; $idx = 0; foreach ($arr as $zid1 => $ar) { if ($zid1 == 0) { continue; }
require_once "../uti/Ureaddir.php"; require_once "../uti/MysqlHieroglyphics.php"; require_once "../uti/MysqlJiaguwen.php"; require_once "../uti/DbRow2Htm.php"; $againstDir = "../uti/jgw/mer/compound/p/"; $againstDir = "../../odb/tbi/img/jgif/"; 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);
<?php require_once "../uti/Ureaddir.php"; require_once "../uti/MysqlJiaguwen.php"; require_once "../uti/DbRow2Htm.php"; $againstDir = "../uti/jgw/mer/compound/p/"; $againstDir = "../../odb/tbi/img/jgif/"; //$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 $ccs->get_view_content($BOOKDIR); //reload if already exist to save time. print "<br>Uniq Chinese from book:<br>"; $chinesezid = array(); foreach ($ccs->WordFreqArr as $key => $arr) { $chinesezid[] = substr($key, 2, 5); } sort($chinesezid); print "<br>Tot simplified words in book=" . count($chinesezid); foreach ($chinesezid as $zid) { //print "&#".$zid. ";" . $zid; } print "<br>Available simplified Chinese from Jiaguwen zid1:<br>"; $jdb = new MysqlJiaguwen(); $sql = "SELECT zid1 FROM Jiaguwen GROUP BY zid1"; $ret = $jdb->query($sql); $jcarr = array(); foreach ($ret as $row) { //echo "&#".$row[0] . ";" .$row[0]; $jcarr[] = $row[0]; } sort($jcarr); print "<br>Tot Jgw=" . count($jcarr); print "<br>"; foreach ($jcarr as $zid) { print "&#" . $zid . ";" . $zid; } //find chinese not in jiaguwen $in = array(); $no = array(); foreach ($chinesezid as $zid) {
public function echo_count_of_layer5() { $sql = "SELECT COUNT(*) FROM Jiaguwen WHERE L='5'"; $db = new MysqlJiaguwen(); $ret = $db->query($sql); print $ret[0][0]; }
public function gen_RootsDangled() { $jia = new MysqlJiaguwen(); $sql = "SELECT * FROM Jiaguwen"; $ret = $jia->query($sql); foreach ($ret as $row) { $lnk = $row['jink']; $lnk = trim($lnk); if (strlen($lnk) >= 5) { continue; } if (strlen($lnk) > 0) { die("error jink data={$lnk}"); } $jid = $row['jid']; if (isset($this->RootsFreq[$jid])) { continue; } $this->RootsDangledFreq[$jid] = $row['freq']; } }
$rt = $jid2jroot["{$val}"]; if (strlen($rt) < 1) { $roots .= $val . ","; } else { $roots .= $rt; } } } $rootarr = explode(",", $roots); $rootarr2 = array_unique($rootarr); asort($rootarr2); $rt2 = implode(",", $rootarr2); $rt2 = trim($rt2, ","); $rt2 .= ","; $sql3 = "UPDATE bronze0000shang SET jgroots='{$rt2}' WHERE idx=" . $row['idx'] . ";"; $ret = $db3up->query($sql3); $tr = "<tr><td>" . $row['idx'] . "</td><td>" . $jk . "</td><td>" . $rt2 . " (" . count($rootarr2) . ")<br>{$sql3}<br>{$ret}</td></tr>\n"; echo $tr; //$r2htm->htm_tr_dat_rd($sql2,$row); } 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}"; } } ?>
//selected col name $db = $_REQUEST["db"]; //database name $ff = $_REQUEST["ff"]; $vi = $_REQUEST["vi"]; $fi = $_REQUEST["fi"]; $uval = $_REQUEST["setid"]; $keyId = $_REQUEST["where"]; $sql = ""; if ("Jiaguwen" == $db) { $sql = "SELECT * FROM Jiaguwen WHERE jid='{$keyId}'"; //0:idx,1:hid,2:zid,3:freq syslog(0, "sql=" . $sql); //die("err test"); $odb = new MysqlJiaguwen(); $ret = $odb->query($sql); if (count($ret) != 1) { die("err query:" . $sql); } $row = $ret[0]; $dbstr = "row | "; foreach ($row as $key => $val) { if (is_numeric($key)) { continue; } $dbstr .= $key . "=" . $val . " | "; } syslog(0, $dbstr); if (!isset($row[$sc])) { $row[$sc] = ""; }
public function delete_img($params) { ////////////////////////////////////////////// print_r($_REQUEST); syslog(0, "params=" . $params); echo "\n"; $tok = explode(",", $params); //tabname, primarykey, primaryval, appendkey $tabname = $tok[0]; $primary_key = $tok[1]; $primary_val = $tok[2]; $append_key = $tok[3]; $append_val = $tok[4]; syslog(0, "tabname=" . tabname); syslog(0, "primary_key=" . $primary_key); syslog(0, "primary_val=" . $primary_val); syslog(0, "append_key=" . $append_key); syslog(0, "append_val=" . $append_val); ///////////////////////////////////// $jgw = new MysqlJiaguwen(); ///////////////// $mysql = "SELECT * FROM {$tabname} WHERE {$primary_key}='{$primary_val}'"; syslog(0, "mysql=" . $mysql); $ret = $jgw->query($mysql); print_r($ret); $append_orig = ""; foreach ($ret as $row) { $append_orig = $row[$append_key]; break; } syslog(0, "append_orig =" . $append_orig); //////////////// $append_newval = preg_replace("/{$append_val}\\,/", "", "{$append_orig}"); // syslog(0, "append_newval=" . $append_newval); if (substr($append_newval, 0, 1) == ",") { $append_newval = substr($append_newval, 1); } ////////// $mysql = "UPDATE {$tabname} SET {$append_key}='{$append_newval}' WHERE {$primary_key}='{$primary_val}'"; syslog(0, "mysql=" . $mysql); $jgw->execute($mysql); }