Concluído

php to xml

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

the query is :

SELECT

`ocpl_order`.order_id,

`ocpl_order`.invoice_no,

`ocpl_order`.store_name,

`ocpl_order`.customer_id,

`ocpl_order`.customer_group_id,

`ocpl_order`.firstname,

`ocpl_order`.lastname,

`ocpl_order`.email,

`ocpl_order`.telephone,

`ocpl_order`.date_added,

`ocpl_order`.date_modified,

`ocpl_order`.total AS order_total,

`ocpl_order`.currency_code,

`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],

`ocpl_order`.custom_field,

`ocpl_order`.payment_method,

`ocpl_order`.payment_code,

`ocpl_order`.payment_firstname,

`ocpl_order`.payment_lastname,

`ocpl_order`.payment_company,

`ocpl_order`.payment_address_1,

`ocpl_order`.payment_address_2,

`ocpl_order`.payment_city,

`ocpl_order`.payment_zone,

`ocpl_order`.payment_postcode,

`ocpl_order`.payment_country,

`ocpl_order`.payment_custom_field,

`ocpl_order`.shipping_method,

`ocpl_order`.shipping_code,

`ocpl_order`.shipping_firstname,

`ocpl_order`.shipping_lastname,

`ocpl_order`.shipping_company,

`ocpl_order`.shipping_address_1,

`ocpl_order`.shipping_address_2,

`ocpl_order`.shipping_city,

`ocpl_order`.shipping_zone,

`ocpl_order`.shipping_postcode,

`ocpl_order`.shipping_country,

`ocpl_order`.shipping_custom_field

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`.order_id

ORDER BY

`ocpl_order`.order_id,

ocpl_order_product.product_id,

ocpl_order_option.product_option_id ASC

and the format of xml I want to produce is :

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

<orders>

<order>

<id>9316</id>

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

<grand_total>169.0000</grand_total>

<OrderComments>bla bla</OrderComments>

<statuses>

<element>

<status><![CDATA[pending]]></status>

<statusid><![CDATA[pending]]></statusid>

<comment><![CDATA[]]></comment>

</element>

</statuses>

<billing>

Habilidades: JavaScript, MySQL, PHP, Arquitetura de software, XML

Veja mais: 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

Acerca do Empregador:
( 1 comentário ) METAMORFOSI, Greece

ID do Projeto: #17425634

Concedido a:

amiewriter

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] Mais

€14 EUR em 0 dias
(15 Comentários)
3.9

9 freelancers estão ofertando em média €25 nesse trabalho

€22 EUR em 1 dia
(104 Comentários)
6.3
mdatiqurrahman7

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

€23 EUR em 1 dia
(62 Comentários)
5.6
madhuarja

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 Mais

€8 EUR in 0 dias
(171 Comentários)
5.6
€55 EUR em 1 dia
(26 Comentários)
4.5
EasyDigiSoft

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

€39 EUR em 1 dia
(16 Comentários)
4.1
mks786

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

€25 EUR in 2 dias
(1 Comentário)
1.2
Milanroman

I can do it

€29 EUR em 1 dia
(1 Comentário)
1.0
€12 EUR in 3 dias
(0 Comentários)
0.0