Addition in mysql query Magento

$10-30 USD

Completed

Posted

over 9 years ago

$10-30 USD

Paid on delivery

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

Project ID: 6938674

About the project

6 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

3.0

(1 review)

2.7

6 freelancers are bidding on average $34 USD for this job

@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 in 0 day

4.9

(149 reviews)

5.6

@davaidwilliam

A proposal has not yet been provided

$25 USD in 1 day

5.0

(34 reviews)

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 in 1 day