Addition in mysql query Magento

$10-30 USD

已完成

已发布

超过 9 年前

$10-30 USD

货到付款

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

项目 ID: 6938674

关于此项目

6提案

远程项目

活跃9 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 在1天之内

3.0

(1条评论)

2.7

6威客以平均价$34 USD来参与此工作竞价

@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 在0天之内

4.9

(149条评论)

5.6

@davaidwilliam

A proposal has not yet been provided

$25 USD 在1天之内

5.0

(34条评论)

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 在1天之内