function clearTransaction($orderNumber, $response)
 {
     sqlconnect();
     $sql = "update monetTransaction set paymentStatus = " . toSql($response->paymentStatus) . ", authCode = " . toSql(null) . ", updated=NOW(), payId=" . toSql(null) . " where orderNumber = " . toSql($orderNumber);
     $this->log->write($sql);
     sqlExecute($sql);
 }
Exemple #2
0
<?php

require "mysqlconf.php";
header("content-type:application/json;charset:utf-8;");
$res = array();
function sqlExecute($db, $data)
{
    $stmt = $db->prepare("update `test_8051` set A101 = :A101, A102 = :A102, A103 = :A103, A104 = :A104,\n\t\t\t\t A201 = :A201, A202 = :A202, A203 = :A203, A204 = :A204");
    $stmt->execute(array(":A101" => $data["A101"], ":A102" => $data["A102"], ":A103" => $data["A103"], ":A104" => $data["A104"], ":A201" => $data["A201"], ":A202" => $data["A202"], ":A203" => $data["A203"], ":A204" => $data["A204"]));
    return $stmt->rowCount();
}
try {
    if (isset($_POST)) {
        if (isset($_POST["method"])) {
            $res = array("result" => '' . sqlExecute($dbc, json_decode($_POST["method"], true)));
        } else {
            $res = array("result" => '0');
        }
    }
} catch (PDOException $e) {
    echo $e;
}
echo json_encode($res, JSON_HEX_TAG);
    switch ($result) {
        case "success":
            error("添加成功!", "alertGoTo", $_SERVER['HTTP_REFERER']);
            break;
        case "error":
            error($news->getActionError(), "alertGoTo", $_SERVER['HTTP_REFERER']);
            break;
    }
}
if ($action == "doRm") {
    $id = isset($_POST["id"]) ? intval($_POST["id"]) : "";
    if (empty($id)) {
        jsonError("fail", "id为空");
    }
    $sql = "delete {$mysqlConfig["db_perfix"]}web_news where id = {$id} limit 1";
    sqlExecute($sql, "", "json");
    jsonError("succ");
}
if ($action == "doMod") {
    $news = new news();
    $result = $news->modi();
    switch ($result) {
        case "success":
            error("添加成功!", "alertGoTo", $_SERVER['HTTP_REFERER']);
            break;
        case "error":
            error($news->getActionError(), "alertGoTo", $_SERVER['HTTP_REFERER']);
            break;
    }
}
jsonError("fail", "action is null");
Exemple #4
0
 public function modi()
 {
     $this->news["id"] = isset($_REQUEST["id"]) ? $_REQUEST["id"] : "";
     if (empty($this->news["id"])) {
         $this->addActionError("id", "id为空");
         return parent::ERROR;
     }
     $this->news["news_title"] = isset($_REQUEST["news_title"]) ? $_REQUEST["news_title"] : "";
     if (empty($this->news["news_title"])) {
         $this->addActionError("news", "标题为空");
         return parent::ERROR;
     }
     $this->news["news_type"] = isset($_REQUEST["news_type"]) ? $_REQUEST["news_type"] : "1";
     $this->news["news_content"] = isset($_REQUEST["news_content"]) ? $_REQUEST["news_content"] : "";
     if (empty($this->news["news_content"])) {
         $this->addActionError("news", "文章内容为空");
         return parent::ERROR;
     }
     /*截取前20个字, strip_tags指去掉html标记*/
     $this->news["news_content_short"] = substr(clearHtml($this->news["news_content"]), 0, 20);
     $this->news["news_content_short"] = empty($this->news["news_content_short"]) ? "此条新闻没有文本内容" : $this->news["news_content_short"];
     $this->news["uid"] = isset($_REQUEST["uid"]) ? $_REQUEST["uid"] : "admin";
     $this->news["isPublish"] = isset($_REQUEST["isPublish"]) ? $_REQUEST["isPublish"] : "1";
     $this->news["news_post_time"] = !empty($_REQUEST["news_post_time"]) ? $_REQUEST["news_post_time"] : date("Y-m-d H:i:s", time());
     $sql = "update " . $this->mysqlConfig["db_perfix"] . "web_news \r\n\t\t\t\tset \r\n\t\t\t\tnews_title = '{$this->news["news_title"]}',\r\n\t\t\t\tnews_content = '{$this->news["news_content"]}',\r\n\t\t\t\tnews_type_id = '{$this->news["news_type"]}',\r\n\t\t\t\tnews_content_short = '{$this->news["news_content_short"]}',\r\n\t\t\t\tuid = '{$this->news["uid"]}',\r\n\t\t\t\tisPublish = '{$this->news["isPublish"]}',\r\n\t\t\t\tnews_post_time = '{$this->news["news_post_time"]}',\r\n\t\t\t\tnews_title = '{$this->news["news_title"]}'\r\n\t\t\t\twhere id = {$this->news["id"]}\r\n\t\t\t\t";
     $rs = sqlExecute($sql);
     return parent::SUCCESS;
 }
        $sql = getSqlSchema(Db::$dbName, Db::$tablePrefix);
        if (isset($_POST['createDatabase']) && $_POST['createDatabase'] == true) {
            // create the database if needed.
            try {
                $dbh = new PDO('mysql:host=' . Db::$dbHost . ';port=' . Db::$dbPort, Db::$dbUser, Db::$dbPwd);
                $dbh->exec($sql['base']['create']) or die('Erreur lors de la création de la base<br />' . print_r($dbh->errorInfo(), true));
            } catch (PDOException $e) {
                die("DB ERROR: " . $e->getMessage());
            }
        }
        if (isset($_POST['dropTables']) && $_POST['dropTables'] == true) {
            sqlExecute($sql['User']['drop']);
            sqlExecute($sql['favorite']['drop']);
        }
        sqlExecute($sql['User']['create']);
        sqlExecute($sql['favorite']['create']);
        $result .= '<p class="true">Les tables correspondantes ont été initialisées dans la Base-de-données</p>';
        /* This is nowDoc (hereDoc 2.0 ;-) */
        $config = <<<'EOD'

namespace Transitive;

/*
 * Architecture-related
 */
define('ROOT_PATH', dirname(dirname(__FILE__)));
define('SELF', (dirname($_SERVER['PHP_SELF']) == '/' ? '' : dirname($_SERVER['PHP_SELF'])));
define('CONTROLLERS_INC', ROOT_PATH.'/controllers/');
define('MODELS_INC', ROOT_PATH.'/models/');
define('VIEWS_INC', ROOT_PATH.'/views/');
define('DATA_PATH', ROOT_PATH.'/data/');