Category Archives: drupal

Case Study – PHP Data Services To Extract Content from Drupal Database

In this case study “ PHP Data Services Extract Content from Drupal Database“, I intended to present how Data Service concepts can be applied to extract data with marketing value from¬† a CMS database and publish it as web services.¬† … Continue reading

Posted in case study, data services, drupal, mashup server, php, SOA, wsf/php, wso2 | Tagged , , , | Leave a comment

Using AXIOM/C As The XML Object Model

In Apache Axis2/C AXIOM is used as the basic object model to represent XML. AXIOM provide a DOM like API that allows to traverse and build the XML very easily. Anyway in underneath, AXIOM is different from DOM, as it … Continue reading

Posted in axiom, axis2/c, DataServices, drupal, php, SOA, Tutorial/Guide, web services | Tagged , , , , | Leave a comment

Use of MySQL ‘GROUP BY’ to Derive Statistics

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