How to insert additional data into mysql while using implode

Question

here is the code:

    if (($handle = fopen($source_file, "r")) !== FALSE) {
    $columns = fgetcsv($handle, $max_line_length, ",");
    foreach ($columns as &$column) {
        $column = str_replace(".","",$column);
    }
    while (($data = fgetcsv($handle, $max_line_length, ",")) !== FALSE) {
        while(count($data) < count($columns)) {
            array_push($data, NULL);
        }
        $c = count($data);
        for($i = 0; $i < $c; $i++) {
            $data[$i] = "'{$data[$i]}'";
        }

        $sql[] = '(' . implode(',',$data) . ','.$_POST[group].')';
    }
            $sql = implode(',',$sql);

    $query = "INSERT INTO mytable (".mysql_real_escape_string(implode(",",$columns)).",Custgroup,user_id) VALUES " 
                      . $sql . "\n";
    mysql_query($query) or trigger_error(mysql_error());

    fclose($handle);
      }
     }

If my csv file is:

lastname,firstname,gender

bob,ah,male

So now the query will be : INSERT INTO mytable (lastname,firstname,gender) VALUES ('bob','ah','male'). But how if I want to insert extra data into mysql together with the data in csv file? Such as I have a value $_POST['group'] = 'family' and $_POST['user_id'] = '10', so I tried:

$sql[] = '(' . implode(',',$data) . ','.$_POST[group].','.$_POST[user_id].')';

$query = "INSERT INTO $target_table (".mysql_real_escape_string(implode(",",$columns)).",custgroup,user_id) VALUES " 
                      . implode(',',$sql) . "\n";

But in the query it will become : INSERT INTO mytable (lastname,firstname,gender,custgroup,user_id) VALUES ('bob','ah','male',family,10). It didn't have single quote , so I have error to insert the record.Can I know how to solve this problem?

what's the point in doing mysql_real_escape_string(implode(',', $columns))? — Your Common Sense
– Your Common Sense, Commented Nov 9, 2011 at 8:20

user973254 · Accepted Answer · 2011-11-09 07:53:14Z

1

try this:

$sql[] = '(' . implode(',', $data) . ", '" . $_POST['group'] . "'," . $_POST['user_id'] . ')';

$query = "INSERT INTO $target_table (" . mysql_real_escape_string(implode(',', $columns)) . ',custgroup,user_id) VALUES ' . implode(',', $sql);

answered Nov 9, 2011 at 7:53

user973254

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

2 Comments

Irene Ling Over a year ago

Thankyou so much.Now the query is: INSERT INTO UserAddedRecord (lastname,firstname,cell,custgroup,user_id) VALUES ('Last','First','042819679', 'Family',1)

Your Common Sense Over a year ago

what's the point in doing mysql_real_escape_string(implode(',', $columns))?

vdegenne · Accepted Answer · 2011-11-09 09:11:52Z

0

for the sake of readability you might consider the following :

$sql = sprintf("(%s,'%s',%d)",
    implode(',', $data),
    $_POST['group'],
    $_POST['user_id']
);

which gives you more flexibility and understanding in what your code actually performs.

answered Nov 9, 2011 at 9:11

vdegenne

13.5k18 gold badges86 silver badges118 bronze badges

Collectives™ on Stack Overflow

How to insert additional data into mysql while using implode

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related