Category Archives: DataServices

Steps to Convert a SQL Query to a Data Service

Posted on November 27, 2008 by dimuthu

With WSF/PHP Data Service library, you can convert a SQL query to a Data Service very easily in few steps. Decide your SQL query first, For the query you may require some input parameters, and you have to decide what … Continue reading →

Posted in DataServices, php, SOA, SQL, Tutorial/Guide, web services, wsf/php, wso2 | Tagged , , , , | Leave a comment

WSO2 Carbon Explained In Pictures

Posted on November 27, 2008 by dimuthu

WSO2 Carbon is getting ready to come out very soon. You want to know what exactly WSO2 Carbon is?. Just check this samisa’s blog about “Carbon In Pictures”.

Posted in DataServices, SOA, web services, wso2 | Tagged , , | Leave a comment

Data Services – Databases For SOA

Posted on November 23, 2008 by dimuthu

Database plays a big role in any day-today application. It is a major component from accounting, web portal, CMS, SaaS applications, search engines to all enterprise applications. In traditional MVC(Model-View-Controller) applications we talk about the Model component which represent the … Continue reading →

Posted in DataServices, php, REST, SOA, web services, wsf/php, wso2 | Tagged , , , | Leave a comment

WS-SecurityPolicy With PHP

Posted on November 19, 2008 by dimuthu

WS-SecurityPolicy specification defines standards for defining security policies for your web service. WSF/PHP allows you to declare your security policies according to these standards. You can take one of following approaches to associate policies to your web service or client. … Continue reading →

Posted in DataServices, php, REST, security, Tutorial/Guide, web services, WSDL, wsf/php, wso2, xml, xml schema | Tagged , , , , , , | 14 Comments

RESTful URL Mapping in WSF/PHP

Posted on November 16, 2008 by dimuthu

In a RESTful design, choose of URLs for resources are really important. The URL uniquely represents a resource. Service consumers can change some parts in the URL to access different other resources. So it is clear that the URL consists … Continue reading →

Posted in DataServices, php, REST, RESTful, SQL, Tutorial/Guide, web services, wsf/php, wso2 | Tagged , , , , , , | 1 Comment

WSF/PHP Samples Explained

Posted on November 7, 2008 by dimuthu

Here is a simple categorization of the WSF/PHP samples. You can access all the wsf/php samples from http://labs.wso2.org/wsf/php/solutions/samples/index.html. Sample Category Example Client Source Code Example Service Source Code Online Demo Beginners echo_client.php echo_service.php Demo REST echo_client_rest.php echo_service_with_rest.php Demo WSDL Mode … Continue reading →

Posted in DataServices, php, REST, security, Tutorial/Guide, web services, WSDL, wsf/php, wso2 | Tagged , , , , , , , , , , , | Leave a comment

Use of MySQL ‘GROUP BY’ to Derive Statistics

Posted on November 6, 2008 by dimuthu

We use ‘GROUP BY’ SQL construct to query the data with aggregating some rows according to a field. For an example say if your blog database store your blogs in a table call ‘Blog’ and it has ‘Date’ as a … Continue reading →

Posted in DataServices, drupal, SQL, Tutorial/Guide | Tagged , , | Leave a comment

Data Services with SQLite in PHP

Posted on October 5, 2008 by dimuthu

Yesterday I wrote a how-to on doing MSSQL DataService in PHP. It was just about installing necessary PDO drivers and setting the following configurations about your Database. // database configurations $config = array( “db” => “mssql”, “username” => DB_USERNAME “password” … Continue reading →

Posted in DataServices, Tutorial/Guide, web services | Tagged , , , , | 1 Comment

MSSQL(Microsoft SQL) Data Services In PHP

Posted on October 4, 2008 by dimuthu

PHP in most percentage is used with MySQL Server in LAMP or WAMP stacks. But there may be situations where PHP uses MSSQL databases in back-end. And PHP scripts can be used to make Web services exposing MSSQL Databases. That … Continue reading →

Posted in DataServices, REST, Tutorial/Guide, web services, WSDL, wsf/php | Tagged , , , , , | 4 Comments

Online Tools for PHP Web Services Developers

Posted on September 28, 2008 by dimuthu

PHP Web Services Demo Site contains a set of nice tools that help development of web services in PHP. WSDL2PHP tool – This allow you to generate PHP code for your WSDL. Note that this need your wsdl to be … Continue reading →

Posted in DataServices, web services, WSDL, wsf/php, wso2 | Tagged , , , , , , , , | Leave a comment