print MysqlHieroglyphics::htm_img($hid); print "<a>==</a>"; $orglnk = $row['hink']; print MysqlHieroglyphics::htm_img($orglnk); print "<br>"; $newlnk = MysqlHieroglyphics::replace_root_of_links($oldroot, $newroot, $orglnk); //preg_replace("/$oldroot/i", $newroot, $orglnk); print $newlnk . "<br>"; print MysqlHieroglyphics::htm_img($hid); print "<a>==</a>"; print MysqlHieroglyphics::htm_img($newlnk); print "<br>"; if (isset($_REQUEST["confirm"]) && $_REQUEST["confirm"] == "on") { $sql = "UPDATE Hieroglyphics SET hink='{$newlnk}' WHERE hink='{$orglnk}'"; print "<a>{$sql}</a><br>"; $myarr = $harr->execute($sql); } else { print "confirm is not set to 1. no db changes.<br>"; } print "<br><br><br>"; } print "<br>"; $_REQUEST["oldroot"] = null; $_REQUEST["newroot"] = null; $_REQUEST["confirm"] = null; //print_r($myarr); ?> </body> </html>
//"jink".$i; if ($name != "jink") { continue; } //if( !isset($_REQUEST[$name])) contin; if (strlen($val) < 1) { continue; } $val = trim($val); if ($hid == $val) { die("err: self jink error"); } $arr[] = $val; } if (count($arr) == 0) { die("err: no jink val"); } $arr = array_unique($arr); sort($arr); $linkjidcodes = ""; foreach ($arr as $val) { $linkjidcodes .= $val . ","; } $jgw = new MysqlHieroglyphics(); $sql = "UPDATE Hieroglyphics SET hink='{$linkjidcodes}' WHERE hid='{$hid}'"; //0:idx,1:hid,2:zid,3:freq $ret = $jgw->execute($sql); //if( !$ret) die("err: $sql"); //print_r( $result ); printf("update ret=%d : %s-->%s", $ret, $hid, $linkjidcodes); print_r($_REQUEST);
<?php session_start(); require_once "../MysqlJiaguwen.php"; require_once "../MysqlHieroglyphics.php"; //mysql_query("UPDATE Persons SET Age = '36' //WHERE FirstName = 'Peter' AND LastName = 'Griffin'"); //"UPDATE animals SET animal_name='bruce' WHERE animal_name='troy'" //print_r($_REQUEST); if (isset($_SESSION["database"]) && isset($_SESSION["sql_undo"])) { $odb = null; if ("Jiaguwen" == $_SESSION["database"]) { $odb = new MysqlJiaguwen(); } else { if ("Hieroglyphics" == $_SESSION["database"]) { $odb = new MysqlHieroglyphics(); } else { print_r($_SESSION); die("err _SESSION[database] "); } } syslog(0, "undo::" . $_SESSION["sql_undo"]); $ret = $odb->execute($_SESSION["sql_undo"]); die("ok undo,ret={$ret}, sql=" . $_SESSION["sql_undo"]); } echo "err undo"; print_r($_SESSION);
foreach ($ret as $indx => $row) { $jidstr .= $row[0] . ","; } //print_r($ret); //echo $jidarr; //syslog(0, "jidstr=". $jidstr); //echo $jidstr; return $jidstr; } } $h2j = new Hid2jinks(); //echo $jc->get_jinks($hid); $sql = "SELECT hid FROM Hieroglyphics"; // $hiero = new MysqlHieroglyphics(); $ret = $hiero->query($sql); foreach ($ret as $indx => $row) { $hid = $row[0]; $htoj = $h2j->get_jinks($hid); if ("" == $htoj) { continue; } //echo $htoj ; //echo "<br>"; $sql = "UPDATE Hieroglyphics SET htoj='{$htoj}' WHERE hid='{$hid}'"; $sql = "UPDATE Hieroglyphics SET htoj='{$htoj}' WHERE hid='{$hid}'"; $ret = $hiero->execute($sql); echo $sql . "<br>"; } die; //'58740,61788,58733,58723,61786,58721,58724,58725,58741,58742,63044,58754,63379,61539,61772,61789,58722,63296,'
$_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); } }