如何在mysql数组中插入数组（foreach） [英] How insert array in a mysql db (foreach)

问题描述

 $ txt =<<<< EOL 
 934030913 G 9RUPISOLV 20BUST 00001 P 04 
 0055 G 0CIBALGINA DUE FAST * 24CPR 200MG 00001 P 01 
 EOL ; 
 
 $ specialChars = preg_quote（'＃$％^& *（）+ =  -  [] \';，。/ {} | \：<>？〜'， '＃'）; 
 preg_match_all（
'＃（[0-9] {4,9} \s + [AZ] {1} \ s +（['。$ specialChars。'A- Z0-9] +）\s +（[0-9] {3,7}）n？\ s + P \ + +（[0-9] +））＃'，
 $ txt， $ match 
）; 

数组示例：

 [0] =>数组（[0] => 934030913 G 9RUPISOLV 20BUST 00001 P 04 
 [1] => 0055 G 0CIBALGINA DUE FAST * 24CPR 200MG 00001 P 01）
 [1] =>数组（[0] => 934030913 G 9RUPISOLV 20BUST 00001 P 04 
 [1] => 0055 G 0CIBALGINA DUE FAST * 24CPR 200MG 00001 P 01）
 [2] =>数组（[0] => 9RUPISOLV 20BUST 
 [1] => 0CIBALGINA DUE FAST * 24CPR 200MG）
 [3] =>数组（[0] => ; 00001 
 [1] => 00002）
 [4] => ;数组（[0] => 04 
 [1] => 01））

我需要插入匹配[2] [x]匹配[3] [x]匹配[4] [x] （在所有结果中）在一个mysql数据库中，我想与foreach但我不知道如何！

 [2] =>产品列中的数组（[x] => PRODUCT）| 
 [3] =>数量列|中的数组（[x] => QUANTITY） ONE RECORD 
 [4] =>终端列中的数组（[x] => NUMBER）| 

我该怎么做？



我尝试过：

 $ indices = array（2， 3,4）; 
 foreach（$ index为$ index）{
 foreach（$ match [$ index] as $ value）{
 $ sql =INSERT INTO`table`（`product`）VALUES（ '{$值}'）;;的mysql_query（$的SQL）; } 
？> 

解决方案

txt =<<< EOL
934030913 G 9RUPISOLV 20BUST 00001 P 04
0055 G 0CIBALGINA DUE FAST * 24CPR 200MG 00001 P 01
EOL;

specialChars = preg_quote（'＃

< blockquote>％^& *（）+ = - [] \';，。/ {} | \：<>？〜'，'＃'）;
preg_match_all（
'＃（[0-9] {4,9} \s + [AZ] {1} \s +（['。

$txt = <<<EOL
    934030913 G 9RUPISOLV 20BUST 00001 P 04
    0055 G 0CIBALGINA DUE FAST*24CPR 200MG 00001 P 01
        EOL;
        
        $specialChars = preg_quote( '#$%^&*()+=-[]\';,./{}|\":<>?~', '#' );
        preg_match_all(
            '#([0-9]{4,9}\s+[A-Z]{1}\s+([' . $specialChars . 'A-Z0-9 ]+)\s+([0-9]{3,7})n?\s+P\s+([0-9]+))#',
            $txt, $match
        );

Array example:

[0] => Array ( [0] => 934030913 G 9RUPISOLV 20BUST 00001 P 04 
                      [1] => 0055 G 0CIBALGINA DUE FAST*24CPR 200MG 00001 P 01 ) 
       [1] => Array ( [0] => 934030913 G 9RUPISOLV 20BUST 00001 P 04 
                      [1] => 0055 G 0CIBALGINA DUE FAST*24CPR 200MG 00001 P 01 ) 
       [2] => Array ( [0] => 9RUPISOLV 20BUST
                      [1] => 0CIBALGINA DUE FAST*24CPR 200MG ) 
       [3] => Array ( [0] => 00001
                      [1] => 00002 ) 
       [4] => Array ( [0] => 04 
                      [1] => 01) )

I need insert match[2][x] match[3][x] match[4][x] (of all results) in a mysql db, i think with foreach but i don't know how!

[2] => Array ( 	[x] => PRODUCT ) in product column    |
    [3] => Array ( 	[x] => QUANTITY) in quantity column   |  ONE RECORD
    [4] => Array ( 	[x] => NUMBER ) in terminal column    |

How i can do that?

What I have tried:

$indexes = array(2, 3, 4); 
	foreach ($indexes as $index) { 
		foreach ($match[$index] as $value) { 
			$sql = "INSERT INTO `table`(`product`) VALUES ('{$value}');"; mysql_query($sql); } }
?>

解决方案

txt = <<<EOL 934030913 G 9RUPISOLV 20BUST 00001 P 04 0055 G 0CIBALGINA DUE FAST*24CPR 200MG 00001 P 01 EOL;

specialChars = preg_quote( '#

%^&*()+=-[]\';,./{}|\":<>?~', '#' ); preg_match_all( '#([0-9]{4,9}\s+[A-Z]{1}\s+([' .

这篇关于如何在mysql数组中插入数组（foreach）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！