PHP Keys & Values > MySQL Columns

[htorbov]

This:

echo "<pre>";
print_r($torrent->content());
echo "</pre>";

 

Returns:

Array
(
    [Eureka.S05E01.HDTV.XviD-ASAP\Eureka.S05E01.HDTV.XviD-ASAP.avi] => 367011826
    [Eureka.S05E01.HDTV.XviD-ASAP\eureka.s05e01.hdtv.xvid-asap.nfo] => 4798
    [Eureka.S05E01.HDTV.XviD-ASAP\Sample\eureka.s05e01.hdtv.xvid-asap.sample.avi] => 7883092
)

 

Needs to be inserted to MySQL like:

 

In other words, the array $torrent->content() needs to be inserted to MySQL as new lines at columns "filename" and "size".

 

Please help me..

 

[htorbov]

Nevermind, I did it with:

$torrentid = 1;
foreach($torrent->content() as $filename => $size) {
$sqldb->query("INSERT INTO files (torrent, filename, size) VALUES('{$torrentid}','{$filename}','{$size}')");
}