PHP MysqlJiaguwen::execute Exemples

Exemple #1

Fichier : Jiaguwen_update_hink_addone.php Projet : wdingsoft/test1.jit

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

Exemple #2

Fichier : i_update.php Projet : wdingsoft/test1.jit

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

Exemple #3

Fichier : trad2simp.php Projet : wdingsoft/test1.jit

// ? 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>

Exemple #4

Fichier : MysqlJiaguwen.php Projet : wdingsoft/test1.jit

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