PHP fopen读取url内容

先说说读取的函数fopen()打开URL获得网页内容,使用fgets()这个函数来获取字符串。fgets()函数是从文件指针中读取一行。文件指针必须是有效的，必须指向由 fopen() 或 fsockopen() 成功打开的文件(并还未由 fclose() 关闭)。最后使用fclose()函数关闭。

代码：

<?php
/**
 * Created by PhpStorm.
 * User: liang
 * Date: 2017/6/19
 * Time: 15:59
 */
require_once(dirname(__FILE__)."/config.php");
include DedeInclude('templets/sale_yijian.htm');

//增加权限检查
if(empty($dopost)) $dopost = "";
$get = fopen('http://www.***?type=productType', 'r');
if($get) {
    while(!feof($get)){
        $oneline = fgets($get);
        $contents = explode("**",$oneline);
        $id = $contents[0];
        $name = $contents[1];
        $er = $contents[2];
        $err = $contents[3];
        if($name==null||$err!=null){
            echo "本条数据格式不正确，上传失败".'<br/>';
        }else{
            echo $id."|".$name.'<br/>';
            $inquery = "INSERT INTO `#@__products_type`(id,name) VALUES ('$id','$name')";
            $dsql->ExecuteNoneQuery($inquery);
        }
    }
}else{
    echo "更新产品类型失败！请使用“上传产品资料”功能更新数据！".'</br>';die;
}
$fh = fopen('http://www.***?type=product', 'r');
if($fh){
echo "内容为:".'<br/>';
while(!feof($fh)){
    $oneline = fgets($fh);
    $contents = explode("**",$oneline);
    $id = $contents[0];
    $progress = $contents[1];
    $testDepartmentID = $contents[2];
    $ProductName = $contents[3];
    $ProductModel = $contents[4];
    $ProductType = $contents[5];
    $ProductTypeName = $contents[6];
    $SendCompany = $contents[7];
    $SendCompanyAddress = $contents[8];
    $SendCompanyZIP = $contents[9];

    $SendCompanyPhone = $contents[10];
    $SendCompanyFax = $contents[11];
    $SendCompanyAtificialPerson = $contents[12];
    $ReportNo = $contents[13];
    $ReportResult = $contents[14];
    $XKZNo = $contents[15];
    $XKZValidDate_Begin = $contents[16];
    $XKZValidDate_End = $contents[17];
    $deleted = $contents[18];
    $er = $contents[19];
    $err = $contents[20];

    if($deleted==null||$err!=null){
        echo "本条数据格式不正确，上传失败".'<br/>';
    }else{
        $row =$dsql->GetOne("SELECT id FROM `#@__products` WHERE ReportNo = '$ReportNo'");
        $shuzu = $row['id'];
        echo $id ."|". $progress ."|". $testDepartmentID ."|". $ProductName ."|". $ProductModel ."|". $ProductType ."|". $ProductTypeName ."|". $SendCompany ."|". $SendCompanyAddress ."|". $SendCompanyZIP ."|". $SendCompanyPhone ."|". $SendCompanyFax ."|". $SendCompanyAtificialPerson ."|". $ReportNo ."|". $ReportResult ."|". $XKZNo ."|". $XKZValidDate_Begin ."|". $XKZValidDate_End ."|". $deleted . '<br/>' ;
        if(!empty($shuzu)){
        $update = "update `#@__products` SET id='$id',progress='$progress',
        testDepartmentID='$testDepartmentID',
        ProductTypeName = '$ProductTypeName',
        SendCompany='$SendCompany',
        SendCompanyAddress = '$SendCompanyAddress',
        SendCompanyZIP='$SendCompanyZIP',
        SendCompanyPhone = '$SendCompanyPhone',
        SendCompanyFax='$SendCompanyFax',
        SendCompanyAtificialPerson = '$SendCompanyAtificialPerson',
        ReportNo='$ReportNo',
        ReportResult = '$ReportResult',
        XKZNo='$XKZNo',
        XKZValidDate_Begin = '$XKZValidDate_Begin',
        XKZValidDate_End='$XKZValidDate_End',
        deleted = '$deleted'   
        WHERE ReportNo = '$ReportNo' ";
            $dsql->ExecuteNoneQuery($update);
        }
        else{
            $inquery = "INSERT INTO `#@__products`(id,progress,testDepartmentID,ProductName,ProductModel,ProductType,ProductTypeName,SendCompany,SendCompanyAddress,SendCompanyZIP,SendCompanyPhone,SendCompanyFax,SendCompanyAtificialPerson,ReportNo,ReportResult,XKZNo,XKZValidDate_Begin,XKZValidDate_End,deleted) 
 VALUES ('$id','$progress','$testDepartmentID','$ProductName','$ProductModel','$ProductType','$ProductTypeName','$SendCompany','$SendCompanyAddress','$SendCompanyZIP','$SendCompanyPhone','$SendCompanyFax','$SendCompanyAtificialPerson','$ReportNo','$ReportResult','$XKZNo','$XKZValidDate_Begin','$XKZValidDate_End','$deleted')";
            $dsql->ExecuteNoneQuery($inquery);
        }
    }
}
}else{echo "更新产品数据失败！请使用“上传产品资料”功能更新数据！";}
fclose($get);
fclose($fh);

根据url内容的固定格式(url是固定好格式的文本文档)，进行分割字符串。然后存储到数据库中。通过后台系统就可以实现一键更新数据的功能。