<?php require_once "../MysqlJiaguwen.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); function errdie($msg) { die("err : {$msg}"); } if (!isset($_REQUEST["jid"])) { die("err : no jid"); } $jid = $_REQUEST["jid"]; if (!isset($_REQUEST["jtoh"])) { die("err : no jtoh"); } $jtoh = $_REQUEST["jtoh"]; $linkjidcodes = uti_db::merge_str_links($jtoh, ""); $jgw = new MysqlJiaguwen(); $sql = "UPDATE Jiaguwen SET jtoh='{$linkjidcodes}' WHERE jid='{$jid}'"; //0:idx,1:jid,2:zid,3:freq $ret = $jgw->execute($sql); if (0 == $ret) { print "err "; } //print_r( $result ); printf("update ret=%d; jid=%s; hinks=%s", $ret, $jid, $linkjidcodes); print_r($_REQUEST);
$newVal = MysqlUti::remove_str_links($Oldval, $uval); } else { die("err op={$op}"); } } if ($newVal == $Oldval) { die("err new==old same"); } $sql = "UPDATE Jiaguwen SET {$sc}='{$newVal}' WHERE jid='{$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 { if ("Hieroglyphics" == $db) { $sql = "SELECT * FROM Hieroglyphics WHERE hid='{$keyId}'"; syslog(0, "sql=" . $sql); //die("err test"); $odb = new MysqlHieroglyphics(); $ret = $odb->query($sql); if (count($ret) != 1) { die("err query:" . $sql); }
// ? 33900 ~~ ? 33900 $T2S[33331] = "33331"; // ? 33331 ~~ ? 33331 $T2S[36646] = "36743"; // ? 36646 ~~ ? 36743 $T2S[28668] = "27898"; // ? 28668 ~~ ? 27898 $T2S[27359] = "26638"; // ? 27359 ~~ ? 26638 $T2S[21533] = "21533"; // ? 21533 ~~ ? 21533 $T2S[29742] = "29742"; // ? 29742 ~~ ? 29742 require_once "../../uti/MysqlJiaguwen.php"; $jia = new MysqlJiaguwen(); $sql = " SELECT zid FROM Jiaguwen "; $ret = $jia->query($sql); foreach ($ret as $row) { $zid = $row[0]; $zid1 = 0; if (isset($T2S[$zid])) { $zid1 = $T2S[$zid]; } echo $zid . "=" . $zid1 . "<br>"; $sql = "UPDATE Jiaguwen SET zid1={$zid1} WHERE zid={$zid}"; $jia->execute($sql); } ?> </body> </html>
public function udpate_item($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 = "UPDATE {$tabname} SET {$append_key}='{$append_val}' WHERE {$primary_key}='{$primary_val}'"; syslog(0, "mysql=" . $mysql); $ret = $jgw->execute($mysql); echo "\n{$ret} : {$mysql}"; }