Extracting Data from a MySQL website using a web service call

[Ogi]

Hi

Sorry to ask such an ambiguous question and I know some of this is way out of my knowledge but here is what I would like to do:-

Call a hidden page on my website to get data out of the MySql database, either by a VB.NET application or a mobile application.

A breakdown of what I would like to do is:-

Set a server side php file to extract data when asked

In the application I would like to do, for example:

Allow user to type in an email address and a password, click login button
Ask Website to search for the email address and return the results
If no record exists, tell user email is invalid
If record exists compare password - if wrong, tell user password is invalid
If record exists compare password - if correct, allow user to continue

Can anyone point me to examples (am searching Google but struggling on the syntax) to find the follow:-

Examples of a server side php extract where the page is given the SQL statement rather than it being hardcoded
Examples of sending data from application to the server
Examples of reading data returned from the server

I know it's a bit ask and a bit cheeky but I appreciate all help given in advance.

Many thanks
Carl.

 

[ChrisHirst]

http://lmgtfy.com/?q=php+web+service+example

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[Ogi]

Thanks Chris, got a bit further with this. Plus, I do like the "lmgtfy" website

Carl.