| @@ 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"; |
|