implode array how to make it right?

Question

I have a form in php wich has some checkboxes named skills[], I want to know how to implode and post the correct way in this code, I was used to the usual msqli or normal post syntax, but now that I made country state city dropdown I can't figure out a way to correctly post it:

<?php
$skills = array('PHP', 'JavaScript', 'jQuery', 'AngularJS');
$commasaprated = implode(',' , $skills);
?>

<?php
//insert.php

if(isset($_POST['country']))
{
    include('database_connection.php');
    $query = "
    INSERT INTO country_state_city_form_data (country, state, city, skills) 
    VALUES(:country, :state, :city, :skills)
    ";
    $statement = $connect->prepare($query);
    $statement->execute(
        array(
            ':country'      =>  $_POST['country'],
            ':state'        =>  $_POST['state'],
            ':city'         =>  $_POST['hidden_city'],
            ':skills'           =>  $_POST['skills'],
        )
    );
    $result = $statement->fetchAll();

    if(isset($result))
    {
        echo 'done';
    }

}

?>

Prepare the query, then foreach $_POST['skills'] and execute the stmt multiple times — DarkBee, Jun 27 '22 at 13:32

score -1 · Accepted Answer · answered Jun 27 '22 at 13:33

Inside you're if(isset($_POST['country']))

After you're include() do:

$checkedSkills = implode(", ", $_POST['skills']);

...

$statement->execute(
    array(
        ':country'      =>  $_POST['country'],
        ':state'        =>  $_POST['state'],
        ':city'         =>  $_POST['hidden_city'],
        ':skills'           =>  $checkedSkills,
    )
);

implode array how to make it right?

1 Answers1