Webhook Integration and Phone Verification through Nexmo

Overview We need help building actions that happen once a user submits a form on an external site. These actions are outlined below: [login to view URL] Webhooks to insert a record in our MySQL database [login to view URL] Nexmo Verify API to send a verification code to the phone number provided as part of the form submission [login to view URL] to a page which shows the phone number to which verification code was sent and has a textbox for the user user to enter that [login to view URL] the verification code is incorrect, display an appropriate message to the user and allow to re-enter the code [login to view URL] the verification code is correct, redirect to page showing a success message. Update the corresponding record (using phone number and date as the key) in MySQL database to indicate this Platform This needs to be built entirely in PHP. We have an existing WordPress site alongside which this will be hosted. Our hosting is a LAMP package. To verify phone number we will use Nexmo Verify API. We will provide the table structure for MySQL. All the code written needs to function flawlessly on our existing LAMP hosting. References Nexmo Verify API: [login to view URL] Submission form: [login to view URL] UnBounce: [login to view URL] Milestones & Payment Schedule Each of the steps defined in the Overview forms a milestone / distinct functionality of the overall request. Please be aware that we are unable to release payment in advance and will be defining two separate milestones as below: 1. 40% of payment to be released after full functionality is demonstrated on your test server or through a video call on your local machine 2. 30% of payment to be released after code is released and deployed on our hosting platform 3. 30% will be released after we have QA-ed and confirm the full functionality as requested Other Details Nexmo API token will be needed. Please use your own free token by creating an account on Nexmo MySQL table structure will be provided. This will include all the form fields that UnBounce will post using Webhook Important Requirements [login to view URL] that the webhook request being sent is coming from 1 of the 2 specified IP addresses (provided by UnBounce and known in advance). Any other requests should be discarded 2. Perform an *update* instead of an *insert* if the form submission is identical to one submitted previously. This is determined by querying first for existing records based on date, category, phone and email - and if that returns 1 or more records, perform an update. In all other cases, perform an insert operation [login to view URL] styling on the page is requested [login to view URL] will be no URL parameters with form data. Everything should be collected through the webhook only [login to view URL] error checking and logs needs to be maintained. We can create additional tables as needed for this [login to view URL] needs adequate documentation and comments. Variables used need to be suitably named and need to be logical [login to view URL] version or compatibility issues will need to be resolved. Alternately phrased, everything needs to function on our hosting environment. Please inquire in advance on all details you need in this regard