php to xml

I have a select query in mysql and I want with a php file to produce an xml

the query is :













`ocpl_order`.total AS order_total,


`ocpl_order`.`order_status_id` AS STATUS,

ocpl_order_product.product_id AS product_item,

[login to view URL] AS product_name,

[login to view URL] AS product_model,

[login to view URL] AS product_quantity,

ocpl_order_option.order_product_id AS option_product,

ocpl_order_option.product_option_id AS option_id,

[login to view URL] AS option_name,

[login to view URL] AS option_value,

[login to view URL] AS product_total,

[login to view URL],


























FROM `ocpl_order`

LEFT JOIN ocpl_order_product ON `ocpl_order`.order_id = `ocpl_order_product`.order_id

LEFT JOIN ocpl_order_status ON `ocpl_order`.order_status_id = `ocpl_order_status`.order_status_id

LEFT JOIN ocpl_order_option ON `ocpl_order_product`.order_product_id = ocpl_order_option.order_product_id

WHERE `ocpl_order_status`.order_status_id = 1

group BY





ocpl_order_option.product_option_id ASC

and the format of xml I want to produce is :

<?xml version="1.0" encoding="UTF-8"?>




<date>23/05/2017 23:01:50</date>


<OrderComments>bla bla</OrderComments>









Compétences : JavaScript, MySQL, PHP, Architecture Logicielle, XML

En voir plus : php to xml converter, php xml to json, php parse xml string, php xml to array, php simplexml example, php load xml file, php display xml in browser, php create xml, currency api php xml, php xml input proper utf indicate encoding, flash php xml, php xml reader url, php show website encoding, php xml form, php xml respond post, php xml receive via post, php xml mysql, posting php xml, php xml builder, php xml save parse

Concernant l'employeur :
( 1 commentaire ) METAMORFOSI, Greece

Nº du projet : #17425634

Décerné à:


Greetings, Sure can create PHP and Wordpress based web application as per your needs. [login to view URL] [login to view URL] [login to view URL] [login to view URL] Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% EUR en 0 jours
(15 Commentaires)

9 freelances font une offre moyenne de 25 € pour ce travail

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(104 Commentaires)

Hello, I have checked your job description and I am okay to get this done for you. I can able to produce an xml file using PHP with your query. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(62 Commentaires)

i understood the query i can convert the query in php to xml as requested i can solve the issue - I have checked your project requirement - I worked on more than 200 websites - More than 150+ Websites de Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 0 jours
(171 Commentaires)
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(26 Commentaires)

Hello. I am professional php mysql developer. I would like to help you on this. Lets talk more details on private chat.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(16 Commentaires)

Hi, I am interested in your project and willing to participate in it. It is just like to fetch the order list and you need web services / web API in SOAP waiting for your reply thanks and regards, Kashif Saeed

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 2 jours
(1 Évaluation)

I can do it

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(1 Évaluation)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% EUR en 3 jours
(0 Commentaires)