opencart -sql selection in values in a shell
€8-30 EUR
Pagado a la entrega
we are using Opencart 3.0.2.0. we need to select with a query values inside a shell because the custom fields in OC are in a shell in a row in oc_orders table.
I would like to select in orders table the custom fields. the select command in MySql gives me all the data in shell.
For example
I have in customer 4 custom fields mobile phone , VAT. company name and company profession
I want to select the order_id in MySQL and show me the mobile phone and VAT in different columns.
I want to have in my select command different columns.
for example for the data as follow the next table
sql command : select order_id , custom_field where order_id = 800
gives me this:
{"4":"6946066448","6":"061336572","1":"\u03a6\u03c1\u03b1a\u03b3\u03ba\u03b9\u03b1","3":"\u0395\u03c1\u03b3\u03bf\u03bb\u03ac\u03b2\u03bf\u03c2 \u039f\u03b9\u03ba\u03bf\u03b4\u03cc\u03bc\u03c9\u03bd","5":"\u0397\u03a1\u0391\u039a\u039b\u0395\u0399\u039f\u03a5"}
and I want to have this:
order_id|mobile phone | vat | company name | company profession
800 |6946066448 | 061336572 | \u03a6\u03c1\u03b1a\u03b3\u03ba\u03b9\u03b1 | \u0397\u03a1\u0391\u039a\u039b\u0395\u0399\u039f\u03a5
Also when we finish the query we need to transform the characters for example \u03a5 to greek characters
Nº del proyecto: #17477842
Sobre el proyecto
9 freelancers están ofertando un promedio de €33 por este trabajo
Hello Hope you are fine. Let me introduce myself as l have an experience of 2.5 years in Web development, Web Designing, Open cart,MySQL, JavaScript, HTML,Bootstrap, CSS, Php. Discuss more about your project with me. Más