Insert multiple csv fields into 1 database field

Question

I am uploading a csv to my database, in the csv there are 2 fields Firstname and Lastname. On my database I want to combine them into one Name column. However I am not sure exactly how to do so

        $compname = $data[4] . ',' . $data[5];
    $import="INSERT into gaa_ccinvoices_contacts(id,name,contact,email,contact_note) values('$data[0]','". $compname ."','". $compname ."','$data[6]','". $compname ."')";

DON'T do this... never denormalize your data. and as written, you're vulnerable to sql injection attacks. — Marc B
– Marc B, Commented Jun 29, 2015 at 20:31
What you've written should work. Are you getting an error when you try it? — Barmar
– Barmar, Commented Jun 29, 2015 at 20:40

ScaisEdge · Accepted Answer · 2015-06-29 20:49:40Z

1

If you really wanto to insert only a composed field in the database use string concatenation :

 $dataComposed = $data[0] . ',' . $data[1];
 $import="INSERT into table(name) values('" . $dataComposed ."')";

edited Jun 29, 2015 at 20:49

answered Jun 29, 2015 at 20:35

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

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

3 Comments

user2168066 Over a year ago

I get what you are trying to do here, can't seem to avoid the syntax error now.

user2168066 Over a year ago

I've tried that as well, updating code above with exactly what I have

user2168066 Over a year ago

Strange, It's just a syntax error but everything seemed to upload correctly. Thanks for the help

Collectives™ on Stack Overflow

Insert multiple csv fields into 1 database field

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related