$_POST[] comma seperated string, exlode and explode again before insert into DB

[antonyf]

Hi i have a comma separated. Each seperated value contains a string which is seperated by a "|".. I need to explode the second string and insert the multiple data into the dB..

here is my code:



here is my post data example:

//    name|surname|acc@domain.com|contact,johnny|smith|jsmith@jjjjj.com|contact, and so on.. I need to insert the individual data into the db and if successful echo 1 else error..

$contacts = $_POST['conts'];
if(!empty($contacts)){
$one[] = explode(',',$contacts);
foreach($one as $two){
$three[] = explode('|', $two);
foreach($three as $four){
            $sql="INSERT INTO jos_mycont (`prop_userid`,`category`,`firstname`,`surname`,`email`) VALUES ('$thisJRUser->id','$four[3]','$four[0]','$four[1]','$four[2]')";
            mysql_query($sql,$contLink);
}
        
            if (!mysql_query($sql,$contLink)){
            echo "Unable to insert client details";
            exit;
            } else {
            echo '1';
            exit;
            }     
}
            } else {
            echo 'No contacts selected';
            exit;
            } 

[djr33]

Ok. Is there a question? Please be specific about what is not working in the code.

[traq]

You might look at the str_getcsv() function. Beyond that, you'd need to be more specific about what your question is.