How to store the values of array in mysql?

Question

Is it possible to retrieve values from database as an array and save the same values back to the database?

For example, In my table1 it returns an array:

array(1) { 
   [0]=> string(5) "test1" 
}

I wanted to save test1 back to my database.

Codes:

View

  <?php //for viewing data
  foreach ($users as $user) {
     echo $user->empID;
     echo '<br>';
  }
   ?>
   <?php //for inserting data
  foreach ($users as $row) {
     $rec_users[] = $row->empID;
  }
       echo form_multiselect('empRequired[]', $rec_users, $rec_users,  array('class' => 'chosen-select', 'multiple style' => 'width:785px;'));
?>

Controller

    $lid = $this->admin_model->getID();
    foreach ($lid as $id) {
        $last_id = $id['projectID'];
        $data['users'] = $this->admin_model->getUsers($last_id);
    }

    $this->load->view('admin/projects/rec-employee', $data);

$recommended = $this->input->post('empRequired');

foreach ($recommended as $row) {
   $data1 = array(
            'projectID' => $last_id,
            'username' => $row
   );

   $this->admin_model->insertRecEmp($data1);
}

Model

    public function insertRecEmp($data){
        return $this->db->insert('projectemp', $data);
    }


Table 1: primary key
+--------+
|username|
+--------+
| test1  |
+--------+

Table 2: foreign key

+--------+----------+
|empID   |projectID |
+--------+----------+
| test1  |          |
+--------+----------+

I want the test1 in the dropdown to be saved in my database, however when I click next, it results to

Instead of test1, it's returning 0.

mysqli_fetch_array: If you set up a database table with a column, just run a foreach($array as $value) then run an insert query to that column inserting $value — clearshot66
– clearshot66, Commented Mar 7, 2017 at 15:44

brokkosnarf · Accepted Answer · 2017-03-07 15:39:36Z

0

serialize the array and store that in the dbase instead

http://us.php.net/manual/en/function.serialize.php

answered Mar 7, 2017 at 15:39

brokkosnarf

117 bronze badges

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

2 Comments

blakcat7 Over a year ago

The serialize, it's saving the literal value

blakcat7 Over a year ago

yes, I serialized and echoed, it's giving me this result "a:1:{i:0;s:5:"test1";}"

RokiDGupta · Accepted Answer · 2017-03-07 15:55:02Z

0

<?php 
// $session_data contains a multi-dimensional array with session
// information for the current user. We use serialize() to store 
// it in a database at the end of the request. 
$conn = odbc_connect("webdb", "php", "chicken"); 
$stmt = odbc_prepare($conn, "UPDATE sessions SET data = ? WHERE id = ?");
$sqldata = array (serialize($session_data), $_SERVER['PHP_AUTH_USER']); 
if (!odbc_execute($stmt, $sqldata)) { 
$stmt = odbc_prepare($conn, "INSERT INTO sessions (id, data) VALUES(?,?)"); 
if (!odbc_execute($stmt, $sqldata)) { 
/* Something went wrong.. */ } 
}

?>

NOTE: If you want to get this data from database then use unserializ() , which help you to convert your string into array

answered Mar 7, 2017 at 15:55

RokiDGupta

3913 gold badges7 silver badges14 bronze badges

Comments

Pacio · Accepted Answer · 2017-03-07 16:30:07Z

0

Your foreach is overwriting the $data1 array on each pass, the controller should be like this:

   foreach ($lid as $id) {
    $last_id = $id['projectID'];
    $data['users'] = $this->admin_model->getUsers($last_id);
}

$this->load->view('admin/projects/rec-employee', $data);

$recommended = $this->input->post('empRequired');

foreach ($recommended as $row) {
   //this line is the changed one
   $data1[] = array(
            'projectID' => $last_id,
            'username' => $row
   );

   $this->admin_model->insertRecEmp($data1);
}

answered Mar 7, 2017 at 16:30

Pacio

5434 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to store the values of array in mysql?

3 Answers 3

2 Comments

?>

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

?>

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related