|
|
Posted by Joshie Surber on 09/09/06 21:12
In your insertIntoDB function, change:
$values = implode(array_values($fields_values), ',');
to this:
$values = implode(array_values($fields_values), '","');
and this:
$sqlStatement = 'INSERT INTO `'.$table.'` ('.$fields.') VALUES
('.$values.')';
to this:
$sqlStatement = 'INSERT INTO `'.$table.'` ('.$fields.') VALUES
("'.$values.'")';
This should quote everything. I don't remember if quoting non-string
values matters, if so you would need to loop through $values and append
quotes if is_string($value[n]) instead.
IchBin wrote:
> I am trying to do a SQL table insert. OK, no big deal. Well I am having
> a problem with this code. I build a data structure $fields_values and
> pass it to a function insertIntoDB() to issue the insert.
>
> The problem is in the actual INSERT Statement. The values for the column
> data do not have "" around the Col values. So SQL flags the fields as
> wrong. Example:
>
> INSERT INTO `Log` (ipAddress,action,groupPageName,namePageName,system)
> VALUES (127.0.0.1,browse,Main,HomePage,Testing new code)
>
> Can some one point me in the right direction on wrapping " around the
> data values so it will insert into the table.
>
> $table = 'myTable';
>
> $fields_values = array
> (
> 'ipAddress' => $_SERVER['REMOTE_ADDR'],
> 'action' => $action,
> 'groupPageName' => FmtPageName('$Group', $pagename),
> 'namePageName' => FmtPageName('$Name', $pagename);,
> 'system' => $system
> );
>
> insertIntoDB($strTableName, $fields_values);
>
> function insertIntoDB($table, $fields_values)
> {
> $fields = implode(array_keys($fields_values), ',');
> $values = implode(array_values($fields_values), ',');
> $sqlStatement = 'INSERT INTO `'.$table.'` ('.$fields.') VALUES
> ('.$values.')';
> $res = mysql_query($sqlStatement)OR die(mysql_error());
> return true;
> }
>
> --
> Thanks in Advance...
> IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
> 'If there is one, Knowledge is the "Fountain of Youth"'
> -William E. Taylor, Regular Guy (1952-)
Navigation:
[Reply to this message]
|