Ejemplo n.º 1
0
        }
    }
}
if ($paySuccess == true) {
    // 결제 성공시 DB처리 하세요.
    $_ROW_COUNT = 0;
    $_SADARI_EXISTING_POINT = 0;
    $_SADARI_NEW_POINT = 0;
    $_SADARI_RC_ROW_ID = 0;
    $_SADARI_RC_USER_ID = 0;
    $_SADARI_RC_HOWMUCH = 0;
    try {
        $dsn = "mysql:host=localhost;port=33006;dbname=sadari;charset=UTF8;";
        $flags = array(PDO::ATTR_PERSISTENT => true, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
        $con = new PDOEx($dsn, "sadari", "3F4868C0E88995CBE3D47DC990BE0C16", $flags);
        $con->query("SET SESSION CHARACTER_SET_CONNECTION=utf8");
        $con->query("SET SESSION CHARACTER_SET_RESULTS=utf8");
        $con->query("SET SESSION CHARACTER_SET_CLIENT=utf8");
        $stmt = $con->prepare("SELECT o.point AS point, \n\t\t\t\t\trc.id AS rc_id, rc.user_id AS user_id, rc.how_much AS how_much \n\t\t\t\t\tFROM `sadari`.`operator` AS o\n\t\t\t\t\tINNER JOIN `sadari`.`request_charge` AS rc\n\t\t\t\t\tON (o.id = rc.user_id)\n\t\t\t\t\tWHERE rc.moid = '{$Moid}' LIMIT 1");
        if (!$stmt->execute()) {
            echo "PDO Error 1.1\\<br/>";
            print_r($stmt->errorInfo());
            exit;
        }
        while ($rs = $stmt->fetch(PDO::FETCH_OBJ)) {
            $_SADARI_EXISTING_POINT = $rs->point;
            $_SADARI_NEW_POINT = $_SADARI_EXISTING_POINT + $Amt;
            $_SADARI_RC_ROW_ID = $rs->rc_id;
            $_SADARI_RC_USER_ID = $rs->user_id;
            $_SADARI_RC_HOWMUCH = $rs->how_much;
            $_ROW_COUNT++;