how to create my site api for access data from other site

Hi,
I want to create a api for my site which are access the data from other sites database where this api are integrate so plz tell me a flow for creating api..........

 

Depending on what type of data you want to give out trough your api.

Create an /api/ directory in your folder root. Inside, create an index.php file where you get the data you want to display, json encode it and display it right away. That's the simple way. You will find more tricks later but this will get you started.

 

You can also consider having access-keys (which the users trying to access your data will use in the request), if you plan on having subscriptions, also in that case you do NOT want to expose the content directly on a webpage, unless the access is done with a valid token.
Also, you might wanna include ways the users of the API can limit or specify the data received - less bandwidth-usage for both them and you.

 

using JSON is the easiest way to develop api, create a page to take get/post request, fetch the data from the database according to GET/POST request and give to user by encoding in JSON format, the user can use the JSON data for their use

 

I'd create a subdomain or a new directory for APIs, and then create pages that receive input via GET or POST requests (in PHP accessible through $_GET[] and $_POST[] arrays) and return data using JSON

http://php.net/manual/en/book.json.php

Cheers!