PHP RecordSet::run 예제들

 private function updateProductPath($product, $version)
 {
     global $productId, $productVersion;
     $db = new RecordSet($this->dbConnectionInfo, false, true);
     $db->run("UPDATE webhelp SET value='" . addslashes(__BASE_URL__) . "' WHERE parameter='path' AND product='" . $product . "' AND version='" . $version . "';");
     $db->run("UPDATE webhelp SET value='" . addslashes(__BASE_DIR__) . "' WHERE parameter='dir' AND product='" . $product . "' AND version='" . $version . "';");
     $db->run("UPDATE webhelp SET value='" . addslashes(__PRODUCT_NAME__) . "' WHERE parameter='name' AND product='" . $product . "' AND version='" . $version . "';");
     $db->Close();
 }

예제 #2

파일 보기

파일: do_install.php 프로젝트: hphelion/tools

function installProduct($dbConnectionInfo)
{
    global $productId, $productVersion;
    try {
        $db = new RecordSet($dbConnectionInfo, false, true);
        $db->Run("DELETE FROM webhelp WHERE parameter='path' AND product='" . $productId . "' AND version='" . $productVersion . "';");
        $db->Run("DELETE FROM webhelp WHERE parameter='installDate' AND product='" . $productId . "' AND version='" . $productVersion . "';");
        $db->Run("DELETE FROM webhelp WHERE parameter='dir' AND product='" . $productId . "' AND version='" . $productVersion . "';");
        $db->Run("DELETE FROM webhelp WHERE parameter='name' AND product='" . $productId . "' AND version='" . $productVersion . "';");
        $db->run("INSERT INTO `webhelp` (`parameter`, `value`, `product`, `version`) VALUES\n\t\t\t\t\t\t('installDate','" . date('YmdHis') . "','" . $productId . "','" . $productVersion . "'),\n\t\t\t\t\t\t\t('path','" . addslashes(Utils::getParam($_POST, 'baseUrl')) . "','" . $productId . "','" . $productVersion . "'),\n\t\t\t\t\t\t\t('dir','" . addslashes(dirname(dirname(__FILE__))) . "','" . $productId . "','" . $productVersion . "'),\n\t\t\t\t\t\t\t('name','" . addslashes(Utils::getParam($_POST, 'productName')) . "','" . $productId . "','" . $productVersion . "')\n\t\t\t\t\t\t\t;");
        $db->Close();
    } catch (Exception $e) {
        error_log("Exception installing product " . $productId . " version " . $productVersion . " details: " . $e->getMessage());
        echo "Exception installing product " . $productId . " version " . $productVersion . " details: " . $e->getMessage();
        throw $e;
    }
}