mysql - 将每个 td 的数组数据插入 mysql 数据库

Question

请帮助我如何从这样的表中为每个 td 插入数组数据:

我要插入示例:

TRXID > 表 mysql TRXID VALUE 1045629 等。

这是我的代码

$dom = new DOMDocument();
libxml_use_internal_errors(true);
$dom->loadHTML($output);
libxml_clear_errors();
$xpath = new DOMXpath($dom);

$data = array();

// get all table rows and rows which are not headers
//$table_rows = $xpath->query('//table[@class="report_table"]//tr[2]//td[8]');//tabel sukses
$table_rows = $xpath->query('//table[@class="report_table"]');

foreach($table_rows as $row => $tr) {
    foreach($tr->childNodes as $td) {
        $data[$row][] = preg_replace('~[\r\n]+~', '', trim($td->nodeValue));
    }
    $data[$row] = $data[$row];
    //$data[$row] = $data[$row][1];
   // $data[$row] = $data[$row][2];
    //$data[$row] = $data[$row][3];
    
}

echo '<pre>';
print_r($data);

代码显示这样的数组

Array
(
    [0] => Array
        (
            [0] => Trx ID                  Member ID                  NoHP Pengirim                  Waktu Mulai                  Waktu Selesai                  NoHP Di isi                  Kode Voucher                  Keterangan
            [1] => 1045629                          SY3345                          +6288215527644                          2015-08-28 16:00:32                          2015-08-28 16:01:32                          081325415747                                              TS100                          SUKSES
            [2] => 1042300                          SY3345                          +6288215527644                          2015-08-22 18:45:41                          2015-08-22 18:48:55                          081325415747                                              TS20                          SUKSES
            [3] => 1037299                          SY3345                          jpcom_cs                          2015-08-14 20:08:49                          2015-08-14 20:11:58                          081325415747                                              TS50                          SUKSES
        )

    [1] => 
    [2] => 
)

所以，请帮助我如何将每个 TR/TD 插入到表使用的 mysql 数据库中:TRID、MEMBERID 等。

Answer 1

假设第一行包含表格标题并且它们保持不变我已经根据代码数组的样子创建了以下代码(我考虑了一个示例表格名称并且代码是根据您的要求自定义的)

    <?php
$test_array = Array
(
array
        (
            'Trx ID                  Member ID                  NoHP Pengirim                  Waktu Mulai                  Waktu Selesai                  NoHP Di isi                  Kode Voucher                  Keterangan',
            '1045629                          SY3345                          +6288215527644                          2015-08-28 16:00:32                          2015-08-28 16:01:32                          081325415747                                              TS100                          SUKSES',
             '1042300                          SY3345                          +6288215527644                          2015-08-22 18:45:41                          2015-08-22 18:48:55                          081325415747                                              TS20                          SUKSES',
             '1037299                          SY3345                          jpcom_cs                          2015-08-14 20:08:49                          2015-08-14 20:11:58                          081325415747                                              TS50                          SUKSES'
        ),
array(),
array()
);

//This is to filter out empty array elements to reduce number of iterations
$test_array = array_filter($test_array);

//String to hold values to be inserted
$str_values_to_insert = '';

foreach($test_array as $value)
{
    foreach($value as $key => $value_to_insert)
    {
        //Skip the headers section here
        if($key === 0)
        {
            continue;
        }
        else
        {
            $str_values_to_insert.= "('".str_replace('                          ', "', ", $value_to_insert)."'), ";
        }
    }

}

$str_values_to_insert = rtrim($str_values_to_insert, ', ');

$str_insert_sql = "INSERT INTO TABLE XYZ ('Trx ID','Member ID', 'NoHP Pengirim', 'Waktu Mulai', 'Waktu Selesai', 'NoHP Di isi                  Kode Voucher', 'Keterangan') VALES {$str_values_to_insert}";

print_r($str_insert_sql);
exit;
?>

希望对你有帮助