Exemplos de MysqlHieroglyphics::replace_root_of_links em PHP

Exemplo n.º 1

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

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