Submit Multi-Dimensional Array to mySQL

Question

I have a mySQL table with the fields:

preview_url
large_url

And I have an object that I submit with the following structure:

var $urls = {largeImg:[],preview:[]}

$urls.largeImg values have to be inserted into 'large_url' and

$urls.preview_url values have to be inserted into 'preview_url'

$urls.largeImg[0] has to go in the same mysql table row as $urls.preview[0],

$urls.largeImg[1] into the same row as $urls.preview[1] and so on.

my php:

$urls = $_POST['urls'];

function cache_urls($urls){
global $db;


foreach($urls as $url){
    $sql = "INSERT INTO cache ";
    $sql .= "(preview_url, large_url) ";
    $sql .= "VALUES (";
    $sql .= "'" . db_escape($db, $url['preview']) . "', ";
    $sql .= "'" . db_escape($db, $url['largeImg']) . "'";
    $sql .= ");";

    $result = mysqli_query($db, $sql);
}

And then I also tried this:

foreach($urls as $url){
    foreach($url as $key => $value){
        $sql = "INSERT INTO cache ";
        $sql .= "(preview_url, large_url) ";
        $sql .= "VALUES (";
        if($key==="preview"){
            $sql .= "'" . db_escape($db, $value) . "', ";
        }
        if($key==="largeImg"){
            $sql .= "'" . db_escape($db, $value) . "'";
        }

        $sql .= ");";

        $result = mysqli_query($db, $sql);
    }       
}

So I assume the SQL bit must be wrong but I'm really at the end of my knowledge! Any help much appreciated.

I am not getting anything back, I am submitting this with ajax (jQuery). I tried to return $sql but I get nothing back. — Melvin
– Melvin, Commented Sep 9, 2019 at 1:39
well, try this echo "<script type='text/javascript'>alert(" + $sql + ")</script>"; — Ed Bangga
– Ed Bangga, Commented Sep 9, 2019 at 1:40

LF-DevJourney · Accepted Answer · 2019-09-09 02:42:24Z

1

You should do it like this way,

$sql = "INSERT INTO cache (preview_url, large_url) values";
foreach($urls["largeImg"] as $index => $large_url){
    $preview_url = $urls["preview"][$index];
    $sql .= "('" . db_escape($db,$preview_url) . "','" . db_escape($db,$large_url) . "'),";
}
$sql = rtrim($sql,",");

edited Sep 9, 2019 at 2:42

answered Sep 9, 2019 at 1:55

LF-DevJourney

28.7k30 gold badges170 silver badges321 bronze badges

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

12 Comments

Melvin Over a year ago

thanks a lot for your answer. i get this error back: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'cdn.pixabay.com/photo/2017/09/30/15/10/…' at line 1

Melvin Over a year ago

the url above in the error message is the second value from the array urls.preview (urls.preview[1]) if that helps?

LF-DevJourney Over a year ago

@Melvin can you show you sql and error with text, not an image here.

Melvin Over a year ago

that's the error message i get back, including the image url.

LF-DevJourney Over a year ago

what's the value of sql

|

Collectives™ on Stack Overflow

Submit Multi-Dimensional Array to mySQL

1 Answer 1

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related