duanang58939 2015-10-23 03:32
浏览 25
已采纳

如何使用php登录网页,导航和下载csv文件?

I want to write a php script that:

A. logs into a web site B. navigates to specific page (which is a csv file download) C. store the results in a string.

Something like:

$site->connect("dashboard.site.com");
$site->post_vars(array("username"=>"mike","password"=>"2345");
$csv_file = $site->download("dashboard.site.com/file.csv");

I've read about the snoopy class, but documentation seems to not exist so I can't be sure if this is something it can do.

  • 写回答

1条回答 默认 最新

  • dtp87205 2015-10-23 17:42
    关注

    I figured out how to use Curl to do it. My own login and password and merchant group of course are hidden in this code. But here's how to do it: I hope this helps anyone in the same situation.

    $cookie_jar = tempnam('/tmp','cookie');
    
    // log in
    $c = curl_init('https://dashboard.powerreviews.com/dashboard/login');
    curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($c, CURLOPT_COOKIEJAR, $cookie_jar);
    curl_setopt($c, CURLOPT_FOLLOWLOCATION, false);
    $page = curl_exec($c);
    curl_close($c);
    
    $post_fields = array("j_username" => "USERNAME", "j_password" => "PASSWORD", "command"=>"Login");
    $post_data = http_build_query($post_fields);
    
    $c = curl_init('https://dashboard.powerreviews.com/process_login');
    curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($c, CURLOPT_COOKIEFILE, $cookie_jar);
    curl_setopt($c, CURLOPT_COOKIEJAR, $cookie_jar);
    curl_setopt($c, CURLOPT_POST, true);
    curl_setopt($c, CURLOPT_FOLLOWLOCATION, true);
    curl_setopt($c, CURLOPT_POSTFIELDS, $post_data);
    $page = curl_exec($c);
    curl_close($c);
    
    // switch to Reviews Account
    $c = curl_init('https://dashboard.powerreviews.com/programs/epc?accessMerchantGroup=xxxxx');
    curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($c, CURLOPT_COOKIEFILE, $cookie_jar);
    curl_setopt($c, CURLOPT_COOKIEJAR, $cookie_jar);
    $csv_file = curl_exec($c);
    curl_close($c);
    
    
    // download RA unsubscribes
    $c = curl_init('https://dashboard.powerreviews.com/dashboard/unsubscribes.csv');
    curl_setopt($c, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($c, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($c, CURLOPT_COOKIEFILE, $cookie_jar);
    curl_setopt($c, CURLOPT_COOKIEJAR, $cookie_jar);
    $csv_file = curl_exec($c);
    curl_close($c);
    echo $csv_file;
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥20 Python安装cvxpy库出问题
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥15 python天天向上类似问题,但没有清零
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题