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;
Ejemplo n.º 2
0
 * Uses the information defined on sys.config.php.
 *
 * @package		ProjectSend
 * @subpackage	Classes
 *
 */
/** Initiate the database connection */
global $dbh;
try {
    switch (DB_DRIVER) {
        default:
        case 'mysql':
            $dbh = new PDOEx("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PASSWORD);
            break;
        case 'mssql':
            $dbh = new PDOEx("mssql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USER, DB_PASSWORD);
            break;
    }
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
} catch (PDOException $e) {
    /*
    	print "Error!: " . $e->getMessage() . "<br/>";
    	die();
    */
    return false;
}
/** Extension class to count the total of executed queries */
class PDOEx extends PDO
{
    private $queries = 0;