Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static function setLeadData($franchises, $formData)
- {
- $first_name = $formData[0]['value'];
- $last_name = $formData[1]['value'];
- $telephone = $formData[2]['value'];
- $email = $formData[3]['value'];
- $zipcode = $formData[4]['value'];
- $networth = $formData[5]['value'];
- $liquidcapital = $formData[6]['value'];
- $message = $formData[7]['value'];
- try
- {
- $db = static::getDB();
- $sql = "INSERT INTO leads_franchises SET
- franchise_id = :franchise_id,
- franchisor_id = :franchisor_id,
- franchise_name = :franchise_name,
- first_name = :first_name,
- last_name = :last_name,
- telephone = :telephone,
- email = :email,
- zipcode = :zipcode,
- networth = :networth,
- liquidcapital = :liquidcapital,
- message = :message";
- $stmt = $db->prepare($sql);
- foreach($franchises as $franchise)
- {
- $parameters = [
- ':franchise_id' => $franchise['franchise_id'],
- ':franchisor_id' => $franchise['franchisor_id'],
- ':franchise_name' => $franchise['franchise_name'],
- ':first_name' => $first_name,
- ':last_name' => $last_name,
- ':telephone' => $telephone,
- ':email' => $email,
- ':zipcode' => $zipcode,
- ':networth' => $networth,
- ':liquidcapital' => $liquidcapital,
- ':message' => $message
- ];
- $result = $stmt->execute($parameters);
- }
- return $result;
- }
- catch(PDOException $e)
- {
- echo $e->getMessage();
- exit();
- }
- }
- [0] => Array
- (
- [franchise_id] => 2
- [franchisor_id] => 3
- [franchise_name] => Franchise One
- [logo] => image2.jpg
- [logo_thumb] => thumb_image2.jpg
- [min_capital] => 200000
- [description] => description
- [website] => example2.com
- [inquiry_email] => info@gmail.com
- [created_at] => 2018-01-17 13:05:51
- [updated_at] => 2018-01-25 17:09:51
- )
- [1] => Array
- (
- [franchise_id] => 3
- [franchisor_id] => 3
- [franchise_name] => Franchise Two
- [logo] => image3.jpg
- [logo_thumb] => thumb_image3.jpg
- [min_capital] => 100000
- [description] => description
- [website] => example3.com
- [inquiry_email] => info@gmail.com
- [created_at] => 2018-01-21 18:03:39
- [updated_at] => 2018-01-25 17:10:02
- )
- [2] => Array
- (
- [franchise_id] => 4
- [franchisor_id] => 3
- [franchise_name] => Franchise Three
- [logo] => image4.jpg
- [logo_thumb] => thumb_image4.jpg
- [min_capital] => 100000
- [description] => description
- [website] => example4.com
- [inquiry_email] => info@gmail.com
- [created_at] => 2018-01-25 10:25:52
- [updated_at] => 2018-01-25 17:58:08
- )
Add Comment
Please, Sign In to add comment