wDXFKywx

1> <?php
2> $connection = mysqli_connect('localhost','root','','prueba');
3
4> $cont_array = Array("613:m-ent:id=one","930:m-clk:id=one;x=180;y=79;which=1","1080:m-lev:id=one;");
5> $table_name = "user1";
6
7
8> $sql_1 = "DROP TABLE IF EXISTS `".$table_name."`;";
9> $sql_1 .= "CREATE TABLE `".$table_name."` (
10        `id` int(11) NOT NULL AUTO_INCREMENT,
11        `usercod` varchar(20) NOT NULL DEFAULT '',
12        `pid` varchar(1000) NOT NULL DEFAULT '',
13        `name` varchar(1000) NOT NULL DEFAULT '',
14        `time` varchar(1000) NOT NULL DEFAULT '',
15        `all_act` varchar(1000) NOT NULL DEFAULT '',
16        PRIMARY KEY (`id`)
17        ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;";
18
19> mysqli_multi_query($connection,$sql_1);
20
21
22> foreach ($cont_array as $row){
23>     $break_e = explode(':', $row, 2);
24>     $sql="INSERT INTO`".$table_name."` (usercode,pid,name,time,all_act) VALUES ("user","pid_value","user_name",'$break_e [0]','$break_e [1]');";
25>     mysqli_query($connection,$sql);
26> }
27> ?>