Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $dsn = "mysql:host=localhost;dbname=DATABASE;charset=utf8mb4";
- $options = [
- PDO::ATTR_EMULATE_PREPARES => false,
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- ];
- try {
- $pdo = new PDO($dsn, "USERNAME", "PASSWORD", $options);
- } catch (Exception $e) {
- error_log($e->getMessage());
- exit('Something weird happened');
- }
- $stmt = $pdo->prepare("INSERT INTO allOptionalServices(Agent_ID,
- Tran_Year,
- Tran_Period,
- Original_Mobile_ID,
- Mobile_ID,
- Device_ID,
- Account_Number,
- Optional_Service,
- Customer_Name,
- Activation_Date,
- Access_Charge,
- SFO,
- Model,
- Agent_SS,
- Adj_Amount2,
- SPIFF_Amount2)
- VALUES (?, ?, ?, ?,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- $stmt->execute([$Agent_ID,
- $Tran_Year,
- $Tran_Period,
- $Original_Mobile_ID,
- $Mobile_ID,
- $Device_ID,
- $Account_Number,
- $Optional_Service,
- $Customer_Name,
- $Activation_Date,
- $Access_Charge,
- $SFO,
- $Model,
- $Agent_SS,
- $Adj_Amount2,
- $SPIFF_Amount2]);
- $stmt = null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement