Differences

This shows you the differences between two versions of the page.

--- v5:reference:connection:replace [2016/01/17 01:57] – ↷ Page moved from v5:reference:replace to v5:reference:connection:replace mnewnham
+++ v5:reference:connection:replace [2024/03/04 02:44] (current) – second param is array, typos peterdd
@@ Line 8: / Line 8: @@
      int replace(
          string $table,
-         string $dataFields,
+         mixed $dataFields,
          mixed $keyColumn,
          optional bool $autoQuote = false,
@@ Line 16: / Line 16: @@
 ===== Description =====
-The function ''replace()'' inserts or replace a single record. It can be considered a companion program to [[.connection:autoexecute|autoExecute()]].
+The function ''replace()'' inserts or replace a single record. It can be considered a companion program to [[autoexecute|autoExecute()]].
 ===== Parameters =====
@@ Line 26: / Line 26: @@
 The primary key field name or if compound key, an array of field names
 ==== $autoQuote	====
-Set this value to true to use a hueristic to quote strings. Works with nulls and numbers but does not work with dates nor SQL functions.
+Set this value to true to use a heuristic to quote strings. Works with nulls and numbers but does not work with dates nor SQL functions.
 ==== $primaryKeyIsAuto ====
 If the primary key is an auto-inc field, skip in insert.
@@ Line 45: / Line 45: @@
 $tableName = 'products';
 $indexColumn = 'product_code';
-$ar = array('product_code'=>10201,
+$data = array('product_code'=>10201,
             'product_name' =>"'Nails'",
             'price' => 3.99);
-$status = $db->replace($tableName,$ar ,$indexColumn);
+$status = $db->replace($tableName, $data, $indexColumn);
 /*
  * Status code tells us if operation succeeded