Addition in mysql query Magento

$10-30 USD

Ukończony

Opublikowano

ponad 9 lat temu

$10-30 USD

Płatne przy odbiorze

I have this query which fetches all customer info + billing info + payment info. I want to fetch customer password as well from magento db. So need addition of customer password column. SELECT increment_id,customer_email,[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],[login to view URL],sfoa.country_id,[login to view URL],[login to view URL],sfop.cc_owner,sfop.cc_type,sfop.cc_exp_month,sfop.cc_exp_year,sfop.cc_secure_verify,sfop.cc_approval,sfop.cc_last4,sfop.cc_number_enc FROM `sales_flat_order` as sfo left join sales_flat_order_address as sfoa on sfoa.parent_id = sfo.entity_id left join sales_flat_order_payment as sfop on sfop.parent_id=sfo.entity_id where sfoa.address_type='billing' Need it done ASAP!

Magento

MySQL

PHP

Identyfikator projektu: 6938674

Informację o projekcie

6 ofert

Zdalny projekt

Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@jesus2010

Hi, I'm magento developer certified ([login to view URL]), and you can not show the field "password" exactly, but you can show "password hash" field with md5 encryptation. Thanks.

$25 USD w 1 dzień

3,0

(1 opinia)

2,7

6 freelancerzy składają oferty o średniej wysokości $34 USD dla tej pracy

@devikagupta

hello sir, i can do your project.... please accept my bid so that i can start it... i m expert in this type of project... u can also see my portfolio... please sir accept my bid.. please hope u will do i m waiting for your response.. thank you.. :)

$24 USD w 0 dzień

4,9

(149 opinii)

5,6

@davaidwilliam

A proposal has not yet been provided

$25 USD w 1 dzień

5,0

(34 opinii)

5,5

@amiardeshana

Hello Client, Lets complete your task immediately. I would like to take opportunity to work with you on your Magento & MYSQL requirement. Basically, I need to fetch customer password from the DB. Lets make it done quickly. We are Logic Express providing IT Services remotely for our global clients since +8yrs Our Expert Team have a strong hand on following Tech/Languages: | Twitter Bootstrap | PHP | HTML 5 | CSS 3 | AJAX | MySQL | jQuery | JSON | CMS | Designing | javascript Looking forward to discuss on scope in detail. My Skype: le_amee Thanks & Regards, Ami

$21 USD w 1 dzień