Insert array into database in custom PHP

Question

This is my array and I want to insert it in PostgreSQL table in PHP custom. I don't know how to do this.

Array

(
    [yearlyno] => Array
        (
            [0] => 999
            [1] => 22
        )

    [mothername] => Array
        (
            [0] => rabia
            [1] => alia
        )

    [husbandname] => Array
        (
            [0] => dan
            [1] => ali
        )

    [mothersage] => Array
        (
            [0] => 22
            [1] => 45
        )

)

I have searched but could not find any solution.

Please help! I am beginner in PHP.

what kind of issue are you facing while inserting the record in db? — prakash tank
– prakash tank, Commented Nov 22, 2017 at 5:40
not sure about pgsql, but how about having a seperate table for this. This may now seem small set of data but can grow bigger. create a table people_table with array keys as columns (mothername etc) — popeye
– popeye, Commented Nov 22, 2017 at 5:48
You can use pg_insert docs here. Or convert it in postgresql array (example) — gofr1
– gofr1, Commented Nov 22, 2017 at 6:28

usama sherkhan · Accepted Answer · 2017-11-27 11:25:53Z

0

use while loop and echo $cmdrr [] with DB name in a array

while($cmdrr=$dbf->returnDBarray("psql",$_cmdresult)){
  ?>
 <tr>
  <td><?php echo $cmdrr['yearlynumber']; ?></td>
     <td><?php echo $cmdrr['mothername']; ?></td>
     <td><?php echo $cmdrr['husbandname']; ?></td>
     <td><?php echo $cmdrr['mothersage']; ?></td>

answered Nov 27, 2017 at 11:25

usama sherkhan

225 bronze badges

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

Comments

Gyandeep Sharma · Accepted Answer · 2017-11-22 05:42:40Z

0

Use implode(). This will convert your array in string, or You can convert it in JSON also by json_encode().

Examples

Implode - implode($your_array);
JSON    - json_encode($your_array)

answered Nov 22, 2017 at 5:42

Gyandeep Sharma

2,3274 gold badges24 silver badges40 bronze badges

Comments

Milan Chheda · Accepted Answer · 2017-11-22 05:48:38Z

0

You have 2 options here. Either use serialize() or json_encode() And while retrieving data, you should use unserialize() or json_decode() respectively.

answered Nov 22, 2017 at 5:48

Milan Chheda

8,2593 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

Insert array into database in custom PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related