} } } } 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;
* 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;