Guest User

Untitled

a guest
Nov 20th, 2017
252
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. try {
  2.  
  3. $user = "usname";
  4. $pass = "password";
  5. $host = "host";
  6. $dbname = "dbname";
  7.  
  8. $DBH = new PDO("dblib:host=$host;dbname=$dbname", $user, $pass);
  9. $DBH->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  10. /*foreach($DBH->query('SELECT * from card_peoples') as $row) {
  11. echo "<pre>";
  12. print_r($row);
  13. echo "</pre>";
  14. }*/
  15.  
  16. $STH = $DBH->prepare('INSERT INTO table (PEOPLE_ID, DIVISION_ID, SEX, MARRITAL_STATUS, LANG, BIRTHDAY, PHOTO, SOURCE, NOTES, UPDATE_DATE, F_NAME, M_NAME, L_NAME, FULL_NAME, INN, FLAGS, DELETED, LOGIN, TEXT_PASSWORD, EXTERNAL_CODE, GROUP_ID, UNPAY_TYPE_ID, ATTRIBUTE_A, ATTRIBUTE_B, GUID, TRANSACT_GUID) values (:PEOPLE_ID, :DIVISION_ID, :SEX, :MARRITAL_STATUS, :LANG, :BIRTHDAY, :PHOTO, :SOURCE, :NOTES, :UPDATE_DATE, :F_NAME, :M_NAME, :L_NAME, :FULL_NAME, :INN, :FLAGS, :DELETED, :LOGIN, :TEXT_PASSWORD, :EXTERNAL_CODE, :GROUP_ID, :UNPAY_TYPE_ID, :ATTRIBUTE_A, :ATTRIBUTE_B, :GUID, :TRANSACT_GUID)');
  17.  
  18.  
  19. $peopleid = "1";
  20. $divisionid = "1";
  21. $sex = "1";
  22. $marrital_status = "1";
  23. $lang = "1";
  24. $birthday = "1";
  25. $photo = "1";
  26. $source = "1";
  27. $notes = "1";
  28. $update_date = "1";
  29. $f_name = "1";
  30. $m_name = "1";
  31. $l_name = "1";
  32. $full_name = "1";
  33. $inn = "1";
  34. $flags = "1";
  35. $deleted = "1";
  36. $login = "1";
  37. $text_password = "1";
  38. $external_code = "1";
  39. $group_id = "1";
  40. $unpay_type_id = "1";
  41. $attribute_a = "1";
  42. $attribute_b = "1";
  43. $guid = "1";
  44. $transact_guid = "1";
  45.  
  46. $STH->bindParam(':PEOPLE_ID', $peopleid);
  47. $STH->bindParam(':DIVISION_ID', $divisionid);
  48. $STH->bindParam(':SEX', $sex);
  49. $STH->bindParam(':MARRITAL_STATUS', $marrital_status);
  50. $STH->bindParam(':LANG', $lang);
  51. $STH->bindParam(':BIRTHDAY', $birthday);
  52. $STH->bindParam(':PHOTO', $photo);
  53. $STH->bindParam(':SOURCE', $source);
  54. $STH->bindParam(':NOTES', $notes);
  55. $STH->bindParam(':UPDATE_DATE', $update_date);
  56. $STH->bindParam(':F_NAME', $f_name);
  57. $STH->bindParam(':M_NAME', $m_name);
  58. $STH->bindParam(':L_NAME', $l_name);
  59. $STH->bindParam(':FULL_NAME', $full_name);
  60. $STH->bindParam(':INN', $inn);
  61. $STH->bindParam(':FLAGS', $flags);
  62. $STH->bindParam(':DELETED', $deleted);
  63. $STH->bindParam(':LOGIN', $login);
  64. $STH->bindParam(':TEXT_PASSWORD', $text_password);
  65. $STH->bindParam(':EXTERNAL_CODE', $external_code);
  66. $STH->bindParam(':GROUP_ID', $group_id);
  67. $STH->bindParam(':UNPAY_TYPE_ID', $unpay_type_id);
  68. $STH->bindParam(':ATTRIBUTE_A', $attribute_a);
  69. $STH->bindParam(':ATTRIBUTE_B', $attribute_b);
  70. $STH->bindParam(':GUID', $guid);
  71. $STH->bindParam(':TRANSACT_GUID', $transact_guid);
  72.  
  73.  
  74. $STH->execute();
  75.  
  76.  
  77. } catch (PDOException $e) {
  78. print "Error!: " . $e->getMessage() . "<br/>";
  79. die();
  80. }
Add Comment
Please, Sign In to add comment