Store array value in Database frontend angular2 backend php?

Question

Hello first of all sorry if this question already ask? But I am stuck in this what exactly I want to is. I am trying to create a rest api for my angular2 frontend. All works fine as I called rest api and from angular2 and start database value in particular table. like

$stmt = $db->prepare("INSERT INTO `create_profile`(`developerType`, `skills`, `level`, `workType`, `message`) VALUES (:developerType, :skills, :level, :workType, :message)");$stmt->bindParam(':developerType', $params->developerType);

But I am stuck how to store a value which contains array at the place of value like in my skills table there is an array with 2 values but how can I store it into database.

I am using like this ..

$stmt->bindParam(':skills', $data);

but its not working I know I missed something but what that I don't know. please help me

vikas_24 · Accepted Answer · 2017-04-18 06:59:41Z

5

you can try

$data = array();
$skillSet = $params->skills;
foreach($skillSet as $team)
    $data[] = "" . addslashes($team->skillName) . "";

$data = implode("," , $data);

$stmt->bindParam(':skills', $data);

you have to implode your array first and after that it can be store in the database hope it will help you.:)

answered Apr 18, 2017 at 6:59

vikas_24

663 bronze badges

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

1 Comment

Suraj Menariya Over a year ago

Thank you buddy your code save my life and its working thanks alot

Collectives™ on Stack Overflow

Store array value in Database frontend angular2 backend php?

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