Find Jobs
Hire Freelancers

Create Excel File from SQL Statements in PHP

$25-50 USD / hour

进行中
已发布将近 11 年前

$25-50 USD / hour

Greetings, I'd like for you to create the following tool: A php script that loops through the contents of a subdirectory and reads each file and executes the SQL query contained within the file, with the resulting recordset from the query exported as an xls file and emailed. Basically I have about 4-5 monthly reports that I run and I'd like to receive and email for each. I'll provide the sql. Your deliverable: A php script that when called loops through a subdirectory called "sql" and does an export and email for each sql file atttached using the name of the sql file for the attachment name and email subject. For example, if there are 3 text files within the sql folder named report1 report2 and report3 - there would be three emails sent - one with a csv file named [login to view URL], another email with a csv file named [login to view URL], and a third email with a csv file named [login to view URL] The export could be csv or xls. Please include the text phpxls06052013 as the first word on the first line of your response for consideration. php version is 5.3.3 mysql version is 5.0.95 mailer is sendmail Potential File Structure / [login to view URL] --/sql/ [login to view URL] [login to view URL] [login to view URL] I am expecting this project to require less than 4 hours to complete. Thanks and good luck bidding!
项目 ID: 4594439

关于此项目

10提案
远程项目
活跃11 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
phpxls06052013 PHP expert here. I can start on it right away and get it done for you. Awaiting your reply, Hari
$25 USD 在2天之内
4.7 (228条评论)
6.2
6.2
10威客以平均价$29 USD/小时来参与此工作竞价
用户头像
phpxls06052013 Ready for service sir, thanks.
$27 USD 在4天之内
4.9 (67条评论)
5.5
5.5
用户头像
We can do this.
$26 USD 在4天之内
5.0 (18条评论)
4.5
4.5
用户头像
i can help you on this project! if you are ready to work chose me!
$38 USD 在4天之内
5.0 (3条评论)
3.2
3.2
用户头像
I've read all your requirements. It seems easy,but I got confused in some point. May you contact me now to let me know something ... Thanks
$27 USD 在30天之内
5.0 (7条评论)
3.1
3.1
用户头像
hi i can do this for you. regards.
$27 USD 在4天之内
5.0 (2条评论)
2.9
2.9
用户头像
Available immediately. Please check PM.
$42 USD 在4天之内
5.0 (6条评论)
2.8
2.8
用户头像
Dear sir, lets start the job...m
$27 USD 在3天之内
5.0 (1条评论)
0.0
0.0
用户头像
phpxls06052013 i'm ready
$25 USD 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Springfield, United States
5.0
332
付款方式已验证
会员自8月 24, 2004起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。