php mysql insert from array item

Question

my array item structure look like

title: "",
createdBy: "",
pointerSet:[
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}

]

Now if my URL hit with this item array data then how can i insert pointerSet array item in database.

my database data goes to two table

table one

title: "",
createdBy: "",

then table two

pointerSet:[
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}
    {position: 1, catagoryId: 1, caption: "", imageUrl: ""}

]

I am using get method.

in table one i can insert but for table two how can i insert .

$_GET['pointerSet'] = array(
  array(position='', catagoryId='',caption='',imageUrl=''),
  array(position='', catagoryId='',caption='',imageUrl=''),
  array(position='', catagoryId='',caption='',imageUrl='')
);

Use a loop that inserts a row for each pointer in the pointer set. — Barmar
– Barmar, Commented Oct 20, 2014 at 20:12

Barmar · Accepted Answer · 2014-10-20 20:20:41Z

1

Here's how you can do it using a PDO prepared statement

$stmt = $pdo->prepare("INSERT INTO pointerTable (position, categoryid, caption, imageurl) VALUES(:position, :categoryid, :caption, :imageurl)");
foreach ($array['pointerSet'] as $pointer) {
    $stmt->execute($pointer);
}

answered Oct 20, 2014 at 20:20

Barmar

789k57 gold badges554 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

php mysql insert from array item

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related