We have oracle database installed and would like to share our data with others. I would like to develop a simple web service that provide other application to pull data from oracle database for their own use.
I want to use php to start with because this language is the one that I am familiar with compare to any other language. I had developed few interfaces in php to do (create, read, update & delete) CRUD functionalities. We are using Apache as our web server.
For web api, honestly this is something new for me. I need to know how to do the following, assuming extracting employee table from sample table of oracle database (SCOTT account/schema) - (copying data to new table)
1. Create web-api in php to extract employee table (all columns) and output in JSON format.
2. Create php to call this web-api to read extracted employee record (JSON format) and save it to new_employee table under same schema.
3. How to include authentication to this web-api ? so that only specific client can access to this service.
Please don't give me bunch of links unless it really really help me to do specific task as above. I consider myself as beginner to this. I have read a lot but seems does not giving me better understanding on how to do it, especially using php.
Thanks in advance.