@@ 354-358 (lines=5) @@ | ||
351 | while (!empty($rs) && !$rs->EOF && !empty($cols)) |
|
352 | { |
|
353 | $sql = ' WHERE 1=1 '; |
|
354 | foreach ($cols as $c) |
|
355 | { |
|
356 | $val = $this->ParseSqlData($rs->fields[$c], $rs_cols[strtoupper($c)]->type); |
|
357 | $sql .= " and $c=$val "; |
|
358 | } |
|
359 | array_push($ar_where, $sql); |
|
360 | $rs->MoveNext(); |
|
361 | } |
|
@@ 454-459 (lines=6) @@ | ||
451 | $sql_i = "INSERT INTO $tbl (" . implode(',', $cols) . " ) VALUES ( \n"; |
|
452 | // Fields data |
|
453 | $ar = array(); |
|
454 | foreach ($cols as $c) |
|
455 | { |
|
456 | $val = $rs->fields[$c]; |
|
457 | $type = $rs_cols[strtoupper($c)]->type; |
|
458 | array_push($ar, $this->ParseSqlData($val, $type)); |
|
459 | } |
|
460 | $sql_i .= implode(',', $ar) . "\n"; |
|
461 | // Insert sql end |
|
462 | $sql_i .= ");\n"; |