Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. $host = 'localhost';
  2. $db = 'cssnewlogin';
  3. $user = 'root';
  4. $pass = '';
  5. $charset = 'utf8';
  6.  
  7. //We do the connection:
  8. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  9. $opt = [
  10. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  11. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  12. PDO::ATTR_EMULATE_PREPARES => false,
  13. ];
  14. $pdo = new PDO($dsn, $user, $pass, $opt);
  15. $pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, FALSE);
  16.  
  17. $sthinsert = $pdo->prepare(
  18.  
  19. "INSERT INTO lithuania_customers_2016
  20.  
  21. (user_id, customer_db_id, campaign_id)
  22.  
  23. VALUES (:user_id, :customer_db_id, :campaign_id)"
  24.  
  25. );
  26.  
  27. $sthinsert->bindValue(':user_id', $user_id, PDO::PARAM_INT);
  28. $sthinsert->bindValue(':customer_db_id', $customer_db_id, PDO::PARAM_INT);
  29. $sthinsert->bindValue(':campaign_id', $campaign_id, PDO::PARAM_INT);
  30.  
  31. $sthinsert->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement