Exemplos de MysqlHieroglyphics::query em PHP

Exemplo n.º 1

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

//if(!isset($_REQUEST["oldroot"])) die("'oldroot' is not set.");
//if(!isset($_REQUEST["newroot"])) die("'newroot' is not set.");
$oldroot = $_REQUEST["oldroot"];
$newroot = $_REQUEST["newroot"];
print "oldroot=" . MysqlHieroglyphics::htm_img($oldroot) . ",newroot=" . MysqlHieroglyphics::htm_img($newroot) . ", confirm=" . $_REQUEST["confirm"] . "<br><br>";
//$oldroot = "A53";
//$newroot = "---";
if (strlen($oldroot) == 0) {
    die(" oldroot is empty.");
}
if (strlen($newroot) == 0) {
    die(" newroot is empty.");
}
$harr = new MysqlHieroglyphics();
$sql = "SELECT hid, hink FROM Hieroglyphics WHERE hink LIKE '%{$oldroot},%'";
$myarr = $harr->query($sql);
foreach ($myarr as $row) {
    $hid = $row['hid'];
    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") {

Exemplo n.º 2

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.º 3

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

        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);
        }
        $row = $ret[0];
        $dbstr = "row | ";
        foreach ($row as $key => $val) {
            syslog(0, "Hieroglyphics prepare for undo:" . $key . "=" . $val);
            if (is_numeric($key)) {
                continue;
            }
            $dbstr .= $key . "=" . $val . " | ";
        }
        syslog(0, $dbstr);
        if (!isset($row[$sc])) {
            $row[$sc] = "";

Exemplo n.º 4

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

<?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($_REQUEST["jid"])) {
    die("err= no hid");
}
$hid = $_REQUEST["jid"];
$jgw = new MysqlHieroglyphics();
$sql = "SELECT hink FROM Hieroglyphics WHERE hid='{$hid}'";
//0:idx,1:jid,2:zid,3:freq
$ret = $jgw->query($sql);
//print_r($ret);
if (isset($ret[0])) {
    print $ret[0]["hink"];
} else {
    print "err: no ret";
}
//print_r( $result );
//printf("update ret=%d : %s-->%s",$ret, $jid, $linkjidcodes);
//print_r($_REQUEST);

Exemplo n.º 5

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

">
<select id="sql" name="sql">
<option></option>
<option>SELECT * FROM Hieroglyphics</option>
<option>SELECT * FROM Hieroglyphics LIMIT 0,10</option>
<option>SELECT * FROM Hieroglyphics WHERE hink LIKE '%,%'</option>
<option>SELECT * FROM Hieroglyphics WHERE hink LIKE '%,%'</option>
</select>
<button type="submit">OK</button>
</form>

<?php 
require_once "../uti/Ureaddir.php";
require_once "../uti/MysqlHieroglyphics.php";
$againstDir = "../uti/jgw/mer/compound/p/";
$againstDir = "../../odb/tbi/img/jgif/";
$jia = new MysqlHieroglyphics();
$sql = "SELECT * FROM Jiaguwen ORDER BY jid";
$sql = "SELECT * FROM Hieroglyphics";
if (isset($_REQUEST["sql"]) && strlen($_REQUEST["sql"]) > 0) {
    $sql = $_REQUEST["sql"];
}
echo $sql . "<br>\n";
$ret = $jia->query($sql);
echo "count=" . count($ret) . "<br>";
$jia->show_table($ret);
?>


</body>
</html>