· 8 years ago · Mar 13, 2018, 03:30 AM
1global $tablename,$dbc;
2
3function create_insert ($tablename){
4global$response,$tablename,$dbc;
5
6
7$response=file_get_contents("eligibilitycheck.txt");
8
9
10
11$myspliter=explode(',',$response);
12 global $logo,$valuedata,$crmd,$keys1;
13 global $dbc,$CRMDATA,$value,$fielddata,$tablefields1,$tablefieldsforinsert;
14 $counts=count($myspliter);
15
16 $header1=explode('/',$myspliter[1]);
17 $headers=explode('/',$header1[1]);
18
19
20 foreach($header1 as $header ){
21 $newheader=explode(':',$header);
22 if (strpos(':',$header) == false) {
23 $newheader=explode(':',$header);
24 //print_r($newheader);
25 //echo ("<td><b>$newheader[0]</b></td>");
26
27 $fielddata .= "`$newheader[0]`,";
28 //$fielddata .= str_replace('.','_',"`$newheader[0]`,");
29
30 //$fields=$newheader[0];
31 $fields=str_replace('.','_',$newheader[0]);
32 $keys1="`$fields` VARCHAR(225),";
33 $tablefields1 .=$keys1;
34 //$query = "CREATE TABLE IF NOT EXISTS `crmtest`($keys1)";
35
36
37 $keysforinsert="`$fields`,";
38 $tablefieldsforinsert .=$keysforinsert;
39
40
41}
42 else{
43
44 // echo ("<td><b><$newheader[1]</b></td>");
45 $fielddata .= "`$newheader[1]`";
46 //$fielddata .= str_replace('.','_',"`$newheader[1]`,");
47 //$replace1=str_replace('_','.',$key);
48 //$fields=$newheader[0];
49 $fields=str_replace('.','_',$newheader[0]);
50 $keys1="`$fields` VARCHAR(225),";
51 $tablefields1 .=$keys1;
52
53
54 $keysforinsert="`$fields`,";
55 $tablefieldsforinsert .=$keysforinsert;
56
57
58 }
59 }
60 //$tablefields = implode(',', $keys1);
61$query = "CREATE TABLE IF NOT EXISTS `$tablename`($tablefields1`status1` VARCHAR(225),`transactionmode` VARCHAR(225))";
62
63$result = mysqli_query($dbc,$query);
64
65$q = mysqli_query($dbc,"ALTER TABLE `$tablename` ADD PRIMARY KEY (`@ID`)");
66//echo "</tr></thead><tbody><tr>";
67
68
69//echo "<br>$tablefields1 <br><p>";
70
71
72
73
74 //table fields successfully derieved
75//echo "<br>$tablefieldsforinsert <br><p>";
76
77//end of creating table part of the function
78
79for($i = 2; $i<count($myspliter);$i++){
80 $row =$myspliter[$i];
81
82 //echo "$row";
83
84 $cells =explode('"',$row);
85
86 //print_r( $cells);
87
88 foreach($cells as $newcells){
89
90 $newvalue=explode('"',$newcells);
91
92 //print_r( $newvalue);
93 //echo "$newvalue";
94 }
95
96
97
98 //$cellscrm =array_filter(explode('"',$row));
99
100 $source_array=array_filter(explode('"',$row));
101 //array_map('trim', $source_array);
102 // print_r($source_array);
103
104 $cellscrm =array_map('trim', $source_array);
105 if($cellscrm[1]==""){
106 continue;
107 }
108
109 $newfieddata=str_replace('.','_',$fielddata);
110
111 //print_r($newfieddata);
112
113 //echo "$cellscrm";
114
115 foreach($cells as $key=>$value){
116
117 //$final=array_filter(array_map('trim', $value));
118 if($key % 2==0){
119 continue;
120 }
121
122 $valuedata .= "'$value',";
123
124
125 //$newfields.="$tablefieldsforinsert";
126
127 //echo "INSERT INTO `SNAPPELIGIBILITYCHECK`($tablefieldsforinsert`status1`) VALUES($valuedata'') ON DUPLICATE KEY UPDATE `status` ='Active',`transactionmode`='Online' <br>";
128
129 }
130
131 //echo "$valuedata <br>";
132
133 //print_r($cells);
134
135 $query_values = implode(',',$cells);
136
137 //echo "$query_values<br>";
138
139 // echo "INSERT INTO `SNAPPELIGIBILITYCHECK`($tablefieldsforinsert`status1`) VALUES($valuedata'') ON DUPLICATE KEY UPDATE `status` ='Active',`transactionmode`='Online' <br>";
140
141 $CRMDATA =mysqli_query($dbc,"INSERT INTO `$tablename`($tablefieldsforinsert`status1`) VALUES($valuedata'') ON DUPLICATE KEY UPDATE `status` ='Active',`transactionmode`='Online'");
142 echo "<br>";
143
144
145 // echo "</tr>";
146
147
148
149
150 }//end of for loop
151
152
153
154}// end of account statement functions
155
156
157
158
159
160 $tablename="newtable";
161
162 create_insert ($tablename);