How to Insert Data into Mysql using Dynamically created PHP Variable

Question

Suppose I have variable $image0 , $image1 , $image2 so on Which can varies dynamically and generates from array. And I have sql query to insert data like

 Insert into table_name (id,entityid,value,image) values (1,123,"abc",$image0);
 Insert into table_name (id,entityid,value,image) values (1,123,"abc",$image1);
 Insert into table_name (id,entityid,value,image) values (1,123,"abc",$image2);

As there are 6 insertion query for different images of product.

But its not compulsory that each product images will be same in quantity, some products have 3 images or some have 5 images available.

So How can we check and pass that value to mysql query and neglect other query if only some variable are available.

Thanks

its not very clear to understand, how do you get the images ? do you get an array of images ? did you try using a loop with count for insert query? — Vishnu Nair
– Vishnu Nair, Commented Feb 24, 2016 at 12:47
Why you simply don't check is it corresponding $image empty or not and then execute the query? PHP code will be useful as well. — mitkosoft
– mitkosoft, Commented Feb 24, 2016 at 12:49

Hrabosch · Accepted Answer · 2016-02-24 12:58:49Z

1

I think best way to get all images to array and then just use foreach.

Somethink like this?

<?php
// When you obtaining a images, just let them create a array... this is only example
$arr = array($img1, $img2, $img3, $img4);
foreach ($arr as &$img) {
    //execute your statement with param $img
}

unset($value); // Clean it! ;)
?>

answered Feb 24, 2016 at 12:58

Hrabosch

1,5838 silver badges14 bronze badges

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

Comments

Kickstart · Accepted Answer · 2016-02-24 14:04:00Z

0

Simplist way in php is using the implode function, putting the rest of the insert row into the separator:-

$images = array($image0,$image1,$image2);

$sql = "INSERT INTO table_name (id,entityid,value,image) values (1,123,'abc','".implode("'), (1,123,'abc','", $images)."');"

Note that you should make sure your image names are sanitised first.

answered Feb 24, 2016 at 14:04

Kickstart

21.5k2 gold badges26 silver badges33 bronze badges

2 Comments

Rahul Over a year ago

Hi, but I am not sure how many images will have for products. It varies on products, some have 3, some have 5 like that. so in array what should I defined.

Kickstart Over a year ago

Just keep appending them to the array. Where are the image names coming from?

Collectives™ on Stack Overflow

How to Insert Data into Mysql using Dynamically created PHP Variable

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related