Suggestions on format - XML, JSON, XXX...
-
Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice! For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine :-) Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service. Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend? (I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) -
Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice! For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine :-) Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service. Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend? (I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Hi, It is better to use XML way, which is more understandable and easy.But JSON is much efficient and fast.
-
Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice! For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine :-) Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service. Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend? (I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)If i correct understand you this help you http://php.net/manual/en/book.json.php[^] If have another question you can write me in the skype, bloodmoonshard is my id.
-
Although I'm not a noob when it comes to programming, I have zero experience of web services so I'm seeking advice! For one of our departments at work I have developed a simple CRUD application using Apache, MySQL and PHP on a local network server. This works fine :-) Due to expansion of the department, the database is to be migrated to the main DB server to which I will not be able to make direct calls from my PHP code due to security. They are happy however to create a webservice that I can use that will in turn access the database. I have total say in how the data will be returned to me for interpretation by my PHP pages and how I send data to the web service. Which is the recommended way (I hear alot of 'talk' about JSON nowadays) and do you know of any good tutorials that you would recommend? (I'm posting here as I'm not sure where is best, and from my side of things PHP will be doing all the communication with the service)
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)I did understand that you would develop the serverside application with PHP But I didn't understand what would be the client application, Would it be web browser? or are you going to develop Application to extract the reply from HTTP server.
I know I am coward since the day I know that fortune favors the brave
-
I did understand that you would develop the serverside application with PHP But I didn't understand what would be the client application, Would it be web browser? or are you going to develop Application to extract the reply from HTTP server.
I know I am coward since the day I know that fortune favors the brave
The Client will be a web browser using PHP/Apache on a local server. The local PHP scripts will communicate with the remote web service.
Web Browser <-> Local Apache/PHP <-> Web Service <-> Remote Apache/MySQL/PHP
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn) -
The Client will be a web browser using PHP/Apache on a local server. The local PHP scripts will communicate with the remote web service.
Web Browser <-> Local Apache/PHP <-> Web Service <-> Remote Apache/MySQL/PHP
Dave
Binging is like googling, it just feels dirtier. Please take your VB.NET out of our nice case sensitive forum. Astonish us. Be exceptional. (Pete O'Hanlon)
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Both will be perfect, or you just can create a user with permitting only one host ip with the limitation of tables connection. It wont do any herm
I know I am coward since the day I know that fortune favors the brave