Adding Session / Array to SQL Database

Question

I have the session created and it stores the data, that is working 100%;

I have a foreach loop that converts all the session data into an array of in_fields and in_values.

But the form is not submitting to the database, please assist !

    // sql fields and values
$in_fields = array();
$in_values = array();


foreach($_SESSION as $key => $value) {
    if(!empty($value)) {
        $value = sql_escape($value);
        $key = explode("#",$key);

            $in_fields[] = "`{$key[0]}`";
            $in_values[] = "'{$value}'";
    }
}

if(!empty($in_fields)) {

    $sql  = "INSERT INTO wills(";
    $sql .= implode(", ",$in_fields);
    $sql .= ") VALUES (";
    $sql .= implode(", ",$in_values);
    $sql .= ")";

if(executeSql($sql)) {
        $id = mysql_insert_id();
                executeSql($sql);
            }
        }

I have created a print_r of $in_fields and $in_values and it displays as an array.

The error i am receiving now:

Warning: trim() expects parameter 1 to be string, array given in E:\xampp\htdocs\sc\form\inc\functions.php on line 22

Database query error. Unknown column 'step' in 'field list'

LIne 22 from Functions.php

    $value = get_magic_quotes_gpc() ? stripslashes($value) : trim($value);

why are you looping the session array, why not just use Serialize - php.net/manual/en/function.serialize.php — RobertPitt
– RobertPitt, Commented Mar 17, 2011 at 20:19
printing out sql error will do a little help too. what SQL software it is? — Your Common Sense
– Your Common Sense, Commented Mar 17, 2011 at 20:23
@Col. Shrapnel i get the following: INSERT INTO wills(selection, first_name, age, step) VALUES ('1st_Marriage', 'John', '18', '') — Xavier
– Xavier, Commented Mar 17, 2011 at 20:23

Your Common Sense · Accepted Answer · 2011-03-17 20:35:25Z

1

Database query error. Unknown column 'step' in 'field list'

do you need any further explanations?

answered Mar 17, 2011 at 20:35

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Xavier Over a year ago

@all i got it to work now it was because i had to unset "step" from my session data

Collectives™ on Stack Overflow

Adding Session / Array to SQL Database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related