Exemplos de MysqlHieroglyphics::execute em PHP

Exemplo n.º 1

Arquivo: hiero_db_sql_op_replace_root_in_links.php Projeto: wdingsoft/test1.jit

    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>

Exemplo n.º 2

Arquivo: Hieroglyphics_update.php Projeto: wdingsoft/test1.jit

    //"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);

Exemplo n.º 3

Arquivo: i_update_undo.php Projeto: wdingsoft/test1.jit

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

Exemplo n.º 4

Arquivo: do_auto_update_hiero_jinks.php Projeto: wdingsoft/test1.jit

        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,'

Exemplo n.º 5

Arquivo: i_update.php Projeto: wdingsoft/test1.jit

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