Ditutup

opencart -sql selection in values in a shell

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

Kemahiran: MySQL, Kart Terbuka, PHP, Kejuruteraan Perisian

Lihat lagi: data crystal reports sql server windows application using, sql server database manipulation using macro, inserting data sql server database aspnet using, php, mysql, css, html, website design, ecommerce, software architecture, open cart, retain values form using javascript, sql 2005 connection string using asp, sql 2000 edit row using vbnet, find sql server base directory using, connect sql server web parts using microsoftapplicationblocks sharepoint, export sql server data excel using vbs, sql calculated values, website using opencart, using affiliate program opencart

Tentang Majikan:
( 0 ulasan ) METAMORFOSI, Greece

ID Projek: #17477842

10 pekerja bebas membida secara purata €34 untuk pekerjaan ini

€50 EUR dalam 0 hari
(218 Ulasan)
6.7
€23 EUR dalam sehari
(74 Ulasan)
6.6
protovosolutions

Hi, We've got the right expertise in Opencart customization, API integration, bug fixing, and advanced development. Recently, we've worked on Custom Affiliate Commission Coupon for Opencart 2.3.x Here are a couple o Lagi

€55 EUR dalam 2 hari
(57 Ulasan)
5.7
shopshoppy

can do

€12 EUR dalam sehari
(15 Ulasan)
4.5
creativewebzzz

Hello, Hope you are doing good! I’m Sas. I’ve carefully gone through your job posting. I am specialised in Web development industry for more than 9 years. I am very much interested in your project with all of yo Lagi

€55 EUR dalam 3 hari
(6 Ulasan)
2.5
ArtemGB

Hey! My name is Artyom. Nice to meet you in advance. I studied your offer. I know Open Cart very well (experience more than 5 years). I engaged both in completions of the existing websites, and development from Lagi

€42 EUR dalam 3 hari
(1 Ulasan)
2.0
webifynet

I can do it .

€28 EUR dalam sehari
(1 Ulasan)
1.5
sakshee1591993

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. Lagi

€29 EUR dalam 2 hari
(3 Ulasan)
1.7
rupaneeraj

Hello dear Hiring manager I have read your job post & being an expert Web developer, I offer myself for the job. I am having extensive knowledge and 5+ years of experience in PHP & WordPress website development u Lagi

€23 EUR dalam sehari
(2 Ulasan)
2.4
€23 EUR dalam sehari
(0 Ulasan)
0.0