Guest User

Untitled

a guest
Jan 27th, 2018
336
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.14 KB | None | 0 0
  1. public static function setLeadData($franchises, $formData)
  2. {
  3.  
  4. $first_name = $formData[0]['value'];
  5. $last_name = $formData[1]['value'];
  6. $telephone = $formData[2]['value'];
  7. $email = $formData[3]['value'];
  8. $zipcode = $formData[4]['value'];
  9. $networth = $formData[5]['value'];
  10. $liquidcapital = $formData[6]['value'];
  11. $message = $formData[7]['value'];
  12.  
  13. try
  14. {
  15. $db = static::getDB();
  16.  
  17. $sql = "INSERT INTO leads_franchises SET
  18. franchise_id = :franchise_id,
  19. franchisor_id = :franchisor_id,
  20. franchise_name = :franchise_name,
  21. first_name = :first_name,
  22. last_name = :last_name,
  23. telephone = :telephone,
  24. email = :email,
  25. zipcode = :zipcode,
  26. networth = :networth,
  27. liquidcapital = :liquidcapital,
  28. message = :message";
  29. $stmt = $db->prepare($sql);
  30.  
  31. foreach($franchises as $franchise)
  32. {
  33. $parameters = [
  34. ':franchise_id' => $franchise['franchise_id'],
  35. ':franchisor_id' => $franchise['franchisor_id'],
  36. ':franchise_name' => $franchise['franchise_name'],
  37. ':first_name' => $first_name,
  38. ':last_name' => $last_name,
  39. ':telephone' => $telephone,
  40. ':email' => $email,
  41. ':zipcode' => $zipcode,
  42. ':networth' => $networth,
  43. ':liquidcapital' => $liquidcapital,
  44. ':message' => $message
  45. ];
  46.  
  47. $result = $stmt->execute($parameters);
  48. }
  49.  
  50. return $result;
  51. }
  52. catch(PDOException $e)
  53. {
  54. echo $e->getMessage();
  55. exit();
  56. }
  57. }
  58.  
  59. [0] => Array
  60. (
  61. [franchise_id] => 2
  62. [franchisor_id] => 3
  63. [franchise_name] => Franchise One
  64. [logo] => image2.jpg
  65. [logo_thumb] => thumb_image2.jpg
  66. [min_capital] => 200000
  67. [description] => description
  68. [website] => example2.com
  69. [inquiry_email] => info@gmail.com
  70. [created_at] => 2018-01-17 13:05:51
  71. [updated_at] => 2018-01-25 17:09:51
  72. )
  73.  
  74. [1] => Array
  75. (
  76. [franchise_id] => 3
  77. [franchisor_id] => 3
  78. [franchise_name] => Franchise Two
  79. [logo] => image3.jpg
  80. [logo_thumb] => thumb_image3.jpg
  81. [min_capital] => 100000
  82. [description] => description
  83. [website] => example3.com
  84. [inquiry_email] => info@gmail.com
  85. [created_at] => 2018-01-21 18:03:39
  86. [updated_at] => 2018-01-25 17:10:02
  87. )
  88.  
  89. [2] => Array
  90. (
  91. [franchise_id] => 4
  92. [franchisor_id] => 3
  93. [franchise_name] => Franchise Three
  94. [logo] => image4.jpg
  95. [logo_thumb] => thumb_image4.jpg
  96. [min_capital] => 100000
  97. [description] => description
  98. [website] => example4.com
  99. [inquiry_email] => info@gmail.com
  100. [created_at] => 2018-01-25 10:25:52
  101. [updated_at] => 2018-01-25 17:58:08
  102. )
Add Comment
Please, Sign In to add comment