In Progress

PHP XML response

Project Overview:

We need a small PHP script that will respond to an HTTP XML post (see attached example) containing a request for product availability and return an XML formatted response.

We have three tables in a local MySQL DB that will be queried once the XML post is received.

xml_auth - which is used to verify that the system sending the request is authorized to do so.

items- products descriptions and list prices

prod_avail - Units available for each product by warehouse

These are the steps we would like the script to follow:

1- Check table 'xml_auth' to make sure sender has submitted valid credentials. If successful continue with local query otherwise return response with status failed.

2- Pull customers pricing multiplier from 'xml_auth' and look up product list price from table 'items'.

3- Query table 'prod_avail' for quantities available in each warehouse.

4- Generate and send XML response.

'multiplier' is used to calculate the net price of an item. Net Price = List Price X multiplier. For example, if the customer multiplier is .8 (20% discount off of list) the Net price of an item that costs $1.00 would be $0.80 (note: round out three decimal places)

If (qty_avail (table 'prod_avail) > Qty requested) return Qty requested otherwise return qty_avail

We would like to keep a log of all requests and responses sent through this system that will be stored in a local table.

If you are interested in bidding on this project and would like more info please send me a PM and I will send over a detailed file layout of both the request and response as well as a sample of the current DB tables the script will use.

Let me know if you have any questions!

Thanks

Skills: PHP, XML

See more: php xml response, php response xml, xml response php, php xmlresponse, response xml php, response php, send xml response php, create php xml response, xml post response, xml php response, php create xml response, php post generate response example, sample project overview, sample of project overview, project overview sample, php verify, php price project, calculate availability, php return xml response, check xml response php, php response example, send xml respnse _post, sending response php, check response xml php, php post request response xml

About the Employer:
( 14 reviews ) Kansas City, United States

Project ID: #235797

Awarded to:

almazX

Hello, Sir! please check pm.

$65 USD in 4 days
(4 Reviews)
4.4

17 freelancers are bidding on average $101 for this job

soner

I can offer my high quality services to you. Please contact if interested.

$240 USD in 5 days
(123 Reviews)
7.9
e3d

Hello, check PM please.

$100 USD in 3 days
(54 Reviews)
7.7
Pektsekye

why they cannot sent a normal variables (not xml) request?

$100 USD in 3 days
(107 Reviews)
5.6
fastwebsolutions

See pmb for more information Thank you.

$250 USD in 6 days
(13 Reviews)
5.5
simik

Please, PM me the details on this project.

$80 USD in 2 days
(40 Reviews)
4.9
satttadv

Hi We can get this ajax part done, check pmb

$70 USD in 2 days
(29 Reviews)
4.8
kamanashisroy

Hi, I can do it.

$60 USD in 1 day
(3 Reviews)
4.3
rayb

Please read PM

$70 USD in 1 day
(1 Review)
3.8
benfaust

Extensive experience writing similar scripts for high-end product/service queries.

$120 USD in 1 day
(6 Reviews)
3.5
hsmcdonald

Hello, Thanks for the opportunity to bid on this project. Im sending a PM for more details. Thanks. - Steve

$95 USD in 1 day
(1 Review)
3.4
bartzitz

please see private message

$60 USD in 1 day
(1 Review)
2.8
FernandoMM

Hello, I'm starting on [url removed, login to view] but i have 3+ years of experience with php + mySQL. Thanks.

$180 USD in 2 days
(0 Reviews)
0.0
wyginwys

I want to hear the details

$80 USD in 4 days
(0 Reviews)
0.0
webaxtion

I have just started freelancing, but have 4 years professional web programming experience. I have worked extensively with XML web services, and this project would not take me more than a day. The bid is low as I am try More

$50 USD in 1 day
(0 Reviews)
0.0
WiredMugen

Hello. I Can do this job for you. easy to me

$50 USD in 1 day
(0 Reviews)
0.0
kovalink

I used to create such scripts before. It will not take more than one day. All I need is a bit of additional info (please see PM).

$40 USD in 1 day
(0 Reviews)
0.0