In Progress

PHP/SQL Lookup - App Repair / Issue Resolution

We have an on-prem, small PHP webapp running on IIS (Server 2016) that looks up a telephone number and returns the result to our phone system. Our phone system routes incoming calls based on whether the CallerID number exists in a database, what type of company (client, vendor, unknown). When we migrated the application to Windows Server 2016, some functionality relating to the second database lookup stopped working.

Here is the workflow:

--> Incoming Call

--> Phone system (Switchvox) passes the callerID to the app which then looks up the number in our CRM database. This is done on the Switchvox side using an event trigger - [login to view URL]

--> If CallerID number is in the CRM database, the app sends the name of the caller, the type of caller (client, vendor, or unknown) back to the phone system along with the extension the call should be routed to. The phone system then handles the call from there.

--> If CallerID number is not in the CRM database, the app then queries a second database which contains company name, first/last name, telephone number and contact type - client/vendor. The apps then sends the name of the caller, company, CallerID and what extension the call should be routed to. The phone system then handles the call from there.

-->If the CallerID is not in either database, it then routes the call based on the area code of the incoming call.

As previously mentioned, the second database lookup is not working. If we go to the event trigger URL manually, we get a 500 error.

Skills: IIS, PHP, SQL

See more: flash php sql highscore, create online reservation system php sql apache, basic php sql page, php, mysql, sql, iis, php sql site, dynamic link php sql database, web development languages html php sql, mssql php sql injection, ikariam php sql, php sql sample code, php sql oscommerce, convert static web page dynamic php sql, create login connection php sql, https support freelancer com index php, this one https www freelancer com projects php modificar plantilla wordpress 8868367, https support freelancer com visitor index php livechat chat start, https support freelancer com index php chat

About the Employer:
( 10 reviews ) New York, United States

Project ID: #17704325

27 freelancers are bidding on average $551 for this job

tarunmehan

Hello, I am ready to help you on an immediate basis to develop to make amendment in existing website and fix all issues like you are getting 500 error. Can you share any reference which you have in your mind? I More

$750 USD in 14 days
(72 Reviews)
7.5
AleenaIlyas

Hi there, I have read the details I am experienced with IIS, PHP, SQL. I can help you with this job, Please come to chat so we can discuss this job.

$1250 USD in 20 days
(28 Reviews)
7.2
technorizen

Hello, I have 6 years of experienced on mobile application and development web services I have gone through your project requirement specification and as per my previous experience with this I am capable to do this More

$500 USD in 10 days
(75 Reviews)
7.7
junkyfunky

Hello, I've read your project description and I want to tell you that I can fix issues on your php web app running on IIS (Server 2016) for you exactly as per your requirements. Lets have a quick chat to discuss thi More

$290 USD in 7 days
(118 Reviews)
6.7
lavizsolutions

Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. 1. Case Management system. [login to view URL] you can crea More

$555 USD in 10 days
(22 Reviews)
6.5
AzzkaNoor

It seems like an interesting project. I would like to discuss all the requirements with you, so I can mark the scope of this project. Please also note that final estimation will be provided once all the requirements wi More

$555 USD in 10 days
(17 Reviews)
6.5
androidc

Hello, I have recently built this CRM [login to view URL] I can share login details on chat so you can check my work. I've 7 year experience in website design and development. Thanks and Regard More

$555 USD in 10 days
(86 Reviews)
6.3
shiningdevelopor

⭐⭐⭐⭐⭐⭐⭐Hello, I can finish your project in short time⭐⭐⭐⭐⭐⭐⭐ Look my profile My speed is rocket speed. if you see my profile, you will be amazing.. :) Because We have finished serveral big project for short time. More

$555 USD in 10 days
(44 Reviews)
5.9
technorizensoft

Hello , I have gone through your requirement and understand that,you are looking to develop a mobile app (Android & Ios ) In which app I have worked on many apps in various domain like App Repair / Issue Resolutio More

$400 USD in 10 days
(7 Reviews)
5.5
tangramua

Hi, my name is Oleksii. After reviewing your request, I am ready to fix your problem with IIS web application. I have 19 years’ experience in System Administration and Programming. I would like propose partnership More

$750 USD in 10 days
(15 Reviews)
5.5
webdroid01

Dear Client, Greetings!! We have few queries kindly ping us. Thanks for giving us the opportunity to bid over the requirement. As per your requirement, you would like to develop a PHP website. We would like to More

$611 USD in 10 days
(18 Reviews)
5.1
KGeorgy

Hi, Thanks for your job posting. I've read your project description carefully. As a php & mysql expert, I have rich experience in this kind of project. I am sure I can handle this project as you expected. If you ha More

$555 USD in 10 days
(25 Reviews)
4.9
lexul

Hello Ready to take this project from you. Please have all the details ready so that we can start working immediately. Such as remote desktop credentials. If you have any questions please open up a chat with us. More

$400 USD in 3 days
(16 Reviews)
4.9
drudev

Hi, I see you are looking for web developer to Repair PHP/SQL Lookup - App that looks up a telephone number and returns the result to your phone system. The phone system routes incoming calls based on whether the Cal More

$250 USD in 10 days
(39 Reviews)
5.4
symaticssolution

Dear Client, I have developed many website in PHP IIS server Please have a look some developed portals:- In My Past,I have developed the SaaS based web Application that enables users to upload, play and share vid More

$555 USD in 10 days
(47 Reviews)
6.1
fleedsteed

Greetings I read all of your project description and i can do your project within 2 days Looking forward to hearing from you Regards bingbing

$555 USD in 10 days
(8 Reviews)
4.0
limillion819

Hello sir. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. PHP and SQL are very friendly languages for me and in just some days, you'll get a More

$722 USD in 15 days
(9 Reviews)
3.8
dammak13

Dear Employer, I would like to introduce, We, Sumay InfoTech is an IT Company provide innovative Mobile Application, Website Development and Solution as well as Services. Company Profile : [login to view URL] More

$400 USD in 3 days
(10 Reviews)
3.8
avto35217

Hi,sir, I'm sure that I can be a excellent candidate for your project. Please contact me, so that we can discuss more over chat. I value my credits from clients. Thank you for your reading. I have worked for a long ti More

$555 USD in 3 days
(6 Reviews)
3.6
shwetankit

Dear Sir, I would like to discuss few thing for better understanding of [login to view URL] share details and ping me for further discussion. Spare a moment on our previous work [login to view URL] http://profeenlinea. More

$250 USD in 5 days
(5 Reviews)
3.3