如何在PHP中使用simple_html_dom导入多个URL？

Question

The concept is, I have to import excel which contains links. When we import excel, then insert multiple links into the database. How to give multiple urls using file_get_html. My code is here,

<?php if(!empty($_FILES["excel_file"]))  {  
  $connect = mysqli_connect("localhost", "root", "", "mydb");  
  $file_array = explode(".", $_FILES["excel_file"]["name"]);  
  if($file_array[1] == "xlsx")  
  {  
       include("PHPExcel/IOFactory.php");  
       $output = '';  
       $output .= "  
       <label class='text-success'>Data Inserted</label>  
            <table class='table table-bordered'>  
                 <tr>  
                      <th>link</th>  

                 </tr>  
                 ";  
       $object = PHPExcel_IOFactory::load($_FILES["excel_file"]["tmp_name"]);  
       foreach($object->getWorksheetIterator() as $worksheet)  
       {  
            $highestRow = $worksheet->getHighestRow();  
            for($row=2; $row<=$highestRow; $row++)  
            {  

         $link = mysqli_real_escape_string($connect, $worksheet->getCellByColumnAndRow(1, $row)->getValue());

         include('simple_html_dom.php'); $html = file_get_html("$link");


foreach($html->find('table#job-content') as $article) {

$item['jobtitle']    = $article->find('b.jobtitle',0)->plaintext;

$item['companyname']    = $article->find('span.company',0)->plaintext;

$item['city']    = $article->find('span.location',0)->plaintext;

$item['job_type']    = $article->find('span.no-wrap',0)->plaintext;

$item['description'] = $article->find('td.snip',0)->plaintext;

$articles[] = $item;} $query = "INSERT INTO jobpost (jobtitle, companyname, city, job_type, description, status, employeeemail, link) VALUES ('". mysqli_real_escape_string($connect, $item['jobtitle'])  ."', '". mysqli_real_escape_string($connect, $item['companyname'])  ."', '". mysqli_real_escape_string($connect, $item['city'])  ."', 'Full-time', '". mysqli_real_escape_string($connect, $item['description'])  ."', '', '[e-mail]', '$link')";



                 mysqli_query($connect, $query);  
                 $output .= '  <tr>  <td>'.$link.'</td>  </tr>  ';  } $output .= '</table>';  echo $output;  }  else  {  echo '<label class="textdanger">Invalid File</label>';  }  }?>  

Please help me, Thanks in advance.

Answer 1

I got an answer.

<?php  if(!empty($_FILES["excel_file"])) {  
  $connect = mysqli_connect("localhost", "root", "", "mydb");  
  $file_array = explode(".", $_FILES["excel_file"]["name"]);  
  if($file_array[1] == "xlsx")  
  {  
       include("PHPExcel/IOFactory.php");  
       $output = '';  
       $output .= "  
       <label class='text-success'>Data Inserted</label>  
            <table class='table table-bordered'>  
                 <tr>  
                      <th>link</th>  

                 </tr>  
                 ";  
       $object = PHPExcel_IOFactory::load($_FILES["excel_file"]["tmp_name"]);  
       foreach($object->getWorksheetIterator() as $worksheet)  
       {  
            $highestRow = $worksheet->getHighestRow();  
            for($row=2; $row<=$highestRow; $row++)  
            {  



                 $link = mysqli_real_escape_string($connect, $worksheet->getCellByColumnAndRow(1, $row)->getValue()); require_once( 'simple_html_dom.php' );$url  = array( "$link" );$html = array();foreach( $url as $key=>$value ) { 

   // get html plain-text for webpage & assign to html array.
      $html[ $key ] = file_get_html( $value ); 





    foreach($html[ $key ]->find('table#job-content') as $article) {

  $item['jobtitle']    = $article->find('b.jobtitle',0)->plaintext;

  $item['companyname']    = $article->find('span.company',0)->plaintext;

  $item['city']    = $article->find('span.location',0)->plaintext;

  $item['job_type']    = $article->find('span.no-wrap',0)->plaintext;

  $item['description'] = $article->find('td.snip',0)->plaintext;

 $articles[] = $item;
}     } echo "<br />" ;$servername = "localhost"; $username = "root"; $password = "";$dbname = "mydb"; $conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);} if(mysqli_real_escape_string($conn, $item['job_type'] == '')){ $sql = "INSERT INTO jobpost (jobtitle, companyname, city, job_type, description, status, employeeemail, link) VALUES ('". mysqli_real_escape_string($conn, $item['jobtitle'])  ."', '". mysqli_real_escape_string($conn, $item['companyname'])  ."', '". mysqli_real_escape_string($conn, $item['city'])  ."', 'Full-time', '". mysqli_real_escape_string($conn, $item['description'])  ."', '', '[e-mail]', '$link')"; } else{ $sql = "INSERT INTO jobpost (jobtitle, companyname, city, job_type, description, status, employeeemail, link) VALUES ('". mysqli_real_escape_string($conn, $item['jobtitle'])  ."', '". mysqli_real_escape_string($conn, $item['companyname'])  ."', '". mysqli_real_escape_string($conn, $item['city'])  ."', '". mysqli_real_escape_string($conn, $item['job_type'])  ."', '". mysqli_real_escape_string($conn, $item['description'])  ."', '', '[e-mail]', '$link')";} if ($conn->query($sql) === TRUE) {
echo "New link successfully inserted"; } else {
echo "Error: " . $sql . "<br>" . $conn->error;} $conn->close();

                 $output .= '  
                 <tr>  
                      <td>'.$link.'</td>  

                 </tr>  
                 ';              

            }  
       }  
       $output .= '</table>';  
       echo $output;  
  }  
  else  
  {  
       echo '<label class="text-danger">Invalid File</label>';  
  }  }   ?>