how do I insert an array into a MySQL database using simple_html_dom.php?

Question

I am trying to insert into a MySQL database the results of these statements. The daatbase is setup correctly. When I insert into a database I get 3 dots "..." rather than what I am suppose to get. the last one for tel stores correctly, only the first two do not store into the database but only dots.

for($i = 0; $i < 5; $i++){

    foreach($html->find('span.listado_destacado',$i) as $e){
      if(!empty($e->plaintext)){
        $list[$i] = $e->plaintext;
        echo $list[$i];
      }
    }

    foreach($html->find('span.street-address',$i) as $e){
      if(!empty($e->plaintext)){
        $addr[$i] = $e->plaintext;
        echo $addr[$i];
      }
    }

    foreach($html->find('span.tel',$i) as $e){
      if(!empty($e->plaintext)){
        $tel[$i] = $e->plaintext;
        echo $tel[$i];
      }
    }

    }//for

    for($i = 0; $i < 5; $i++){
      $res=mysql_query("insert into datos (list,addr,tel) values('".$list[$i]."','".$addr[$i]."','".$tel[$i]."')");


    }

Zohaib Hassan Shaikh · Accepted Answer · 2014-03-21 15:02:38Z

1

There is an error in for loop correct code is as follows:

for($i = 0; $i < 5; $i++){

foreach($html->find('span.listado_destacado',$i) as $e){
  if(!empty($e->plaintext)){
    $list[$i] = $e->plaintext;
    echo $list[$i];
  }
}

foreach($html->find('span.street-address',$i) as $e){
  if(!empty($e->plaintext)){
    $addr[$i] = $e->plaintext;
    echo $addr[$i];
  }
}

foreach($html->find('span.tel',$i) as $e){
  if(!empty($e->plaintext)){
    $tel[$i] = $e->plaintext;
    echo $tel[$i];
  }
}

}//for

for($i = 0; $i < 5; $i++){
  $res=mysql_query("insert into datos (list,addr,tel) values('".$list[$i]."','".$addr[$i]."','".$tel[$i]."')");


}

answered Mar 21, 2014 at 15:02

Zohaib Hassan Shaikh

335 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AdRock Over a year ago

I was going to say that

user3368897 Over a year ago

sorry I had those in variables so I changed them to numbers for better understanding.

nbari · Accepted Answer · 2014-03-21 15:09:25Z

0

Give a try to DALMP - multipleinsert or Dalmp - AutoExecute

That can give you an idea of how to insert an array or multiple arrays in one shot.

Basically you prepare your array and later just insert it to the database.

answered Mar 21, 2014 at 15:09

nbari

27.2k13 gold badges87 silver badges148 bronze badges

Collectives™ on Stack Overflow

how do I insert an array into a MySQL database using simple_html_dom.php?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related