Completed

PHP calling MS SQL stored procedure passing array of information and getting control back immediatly

We have a form based application written in PHP / Javascript. When the users submits the form we call a MS SQL stored procedure and pass the values through an array. The Stored Procedure updates the backend tables accordingly. The problem we are having is that the Stored Procedure is taking 30+ seconds to update all the tables ( this is normal ). What we are looking for is a proof of concept and/or approach in writing ( that works ) that can demonstrate how to:

- Pass array of values to stored procedure

- After passing values return positive status to the calling program ( PHP ) and return control

- Have the stored procedure continue and perform the tasks

The calling program is user facing so the user will be able to perform other tasks.

Skills: PHP, Software Architecture, SQL

See more: writing a procedure, what is ms sql, stored, proof of concept, MS SQL, sql javascript, array form, update sql form application, form array, php form array, php sql update, taking information, sql problem, call calling, SQL stored, stored procedure based user, array typewriter control small command buttons, javascript array php array, array javascript, form update sql, calling php, form based php, php sql javascript, piwik visitor information array, php javascript sql

About the Employer:
( 6 reviews ) SEMINOLE, United States

Project ID: #4284560

Awarded to:

weonlydo

Freelance professional and MS SQL Server expert. I assume you meant Microsoft SQL Server not MySQL. My solution outline is in the PM.

$200 USD in 3 days
(33 Reviews)
5.5

6 freelancers are bidding on average $141 for this job

scriptphp87

Hello Please read more than private message thank you

$200 USD in 3 days
(36 Reviews)
5.5
sthakral

Hi, I have an expert++ knowledge of MSSQL. Have a few details in PMB about various approaches for the issue you have. Please check. Best, Sandeep

$150 USD in 2 days
(4 Reviews)
3.8
GNATECHNOLOGIES

Dear Sir, We offer most competitive rates with best quality. We are an experienced team of website development and SEO experts working in this field since last many years. Please check private message. Thanks and Reg More

$170 USD in 15 days
(1 Review)
1.6
sohelonline

Hi! I've gone through your description and the project easily reachable for me. I have skills [login to view URL], Software Architecture, SQL So I would like to take on the project. Thanks

$45 USD in 3 days
(9 Reviews)
1.0
iregain

Hi There, I a, knowledgeable in this field. Lets discuss more details of your project. Looking forward to it.

$150 USD in 5 days
(0 Reviews)
0.0
ceinj

Proposal based on years of experience.

$75 USD in 1 day
(0 Reviews)
0.0
OracleDBAGuru

dear sir i can help you with this projects

$100 USD in 3 days
(0 Reviews)
0.0