CODEWITHSUNDEEP
php
user2168066
user2168066

Reputation: 635

Insert multiple csv fields into 1 database field

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 ."')";

Upvotes: 0

Views: 62

Answers (1)

ScaisEdge
ScaisEdge

Reputation: 133400

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 ."')";

Upvotes: 1

Related Questions