将数组的值插入MYSQL [英] Inserting values of array into MYSQL

问题描述

我有一个文本文件，我将其值放入数组中，
这是php代码：

I have a text file, who's value i have put into arrays, this is the php code:

<?php
    $homepage = file_get_contents('hourlydump.txt');
    $x = explode('|', $homepage);
    $desc = array();
    $cat = array();
    $link = array();
    $m = 1;
    $n = 2;
    $p = 3;

    for ($i = 1; $i <= count($x) / 4; $i++) {
       $m = $m + 4;
       $desc[] = $x[$m];
       $n = $n + 4;
       $cat[] = $x[$n];
       $p = $p + 4;
       if ($x[$p])
          $link[] = $x[$p];
    }
    echo "<pre>";
    print_r($desc);
    print_r($cat);
    print_r($link);
?>

输出类似于：

Array
(
    [0] => Kamal Heer - Facebook Official Video 720p Dual Audio [Hindi + Punjabi]76 mb by rANA.mkv
    [1] => 50 HD Game Wallpapers Pack- 1
)
Array
(
    [0] => Movies
    [1] => Other
)
Array
(
    [0] => http://kickass.to/kamal-heer-facebook-official-video-720p-dual-audio-hindi-punjabi-76-mb-by-rana-mkv-t7613070.html
    [1] => http://kickass.to/50-hd-game-wallpapers-pack-1-t7613071.html
)
//
//
//

任何人请帮我，我不知道如何将这三个数组$ desc，$ cat和$ link
的值插入mysql表，名为description，category，link的列

anyone please help me i dont know how to insert the values of these three arrays $desc, $cat and $link into mysql table, columns named description, category, link

我知道简单的插入查询，但不知道如何处理这些数组。

i know simple insert queries but dont how to deal with these arrays.

推荐答案

以下是读取文件的简单示例和您检索的网站一样ve并将其插入到数据库中以清理数据：

Here is a simple sample to read your file as is from the website you retrieve it as well as inserting it to the database sanitizing the data:

<?php
// fill with your data
$db_host = 'localhost';
$db_user = '';
$db_pass = '';
$db_name = '';
$db_table = 'myTable';

$file = "hourlydump.txt.gz";
if($filehandle = gzopen($file, "r"))
{
    $content = gzread($filehandle, filesize($file));
    gzclose($file);
}
else
    die('Could not read the file: ' . $file);

$con = mysqli_connect($db_host,$db_user,$db_pass,$db_name);
if($con->connect_error)
    die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

$sql = "INSERT INTO $db_table (description, category, link) VALUES (?, ?, ?)";
if (!$insert = $con->prepare($sql))
    die('Query failed: (' . $con->errno . ') ' . $con->error);

foreach (explode("\n", $content) as $line)
{
    list($md5hash,$desc,$cat,$link,$torrent) = explode("|", $line);
    if (!$insert->bind_param('sss',$desc,$cat,$link))
        echo 'Binding parameters failed: (', $insert->errno, ') ', $insert->error;

    if (!$insert->execute())
        echo 'Insert Error ', $insert->error;
}

$insert->close();
$con->close();

注意：您可能想检查文件是否已成功加载，是否爆炸的字段存在或不存在，以防止进一步的问题，但总的来说应该可以。

NOTE: you may want to check if the file was loaded with success, if the fields from the explode exist or not to prevent further problems but in general this should work just fine.

另外，您可能需要更改 $ sql 反映您的MySQL表以及顶部的 $ db_table 。

Also you may want to change the $sql to reflect your MySQL table aswell as the $db_table at the top.

更新：插入全部值更改此值：

UPDATE: to insert all values change this:

$sql = "INSERT INTO $db_table (description, category, link) VALUES (?, ?, ?)";

收件人：

$sql = "INSERT INTO $db_table (md5, description, category, link, torrent) VALUES (?, ?, ?, ? ,?)";

然后：

if (!$insert->bind_param('sss',$desc,$cat,$link))

收件人：

if (!$insert->bind_param('sssss',$md5hash,$desc,$cat,$link,$torrent))

在 s 每个项目需要一个 s 您有5个项目，因此有5个 s 是S表示字符串，D表示双精度字，I整数，表示B Blob 您可以在此处了解更多信息。

Note above the s for each item you need a s you have 5 items so 5 s's the S means string, D double, I integer, B blob you can read more at about it here.

还请注意，我们将为每个项目提供 $ sql 在 bind_param 上使用我们有？。

Also note the $sql for each item we will use on the bind_param we have a ?.

这篇关于将数组的值插入MYSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！