How to INSERT simple PHP array into MySQL table? [duplicate]

Question

I have two results/outputs from a couple of scripts.

Script 1 result:

    print_r($unit);

OUTPUT =  

Array ( [0] => http://one.com, [1] => http://two.com, [2] => http://three.com/, )

Script 2 result:

    echo $item."<br>"; 

OUTPUT = 

http://one.com,
http://two.com,
http://three.com,

I'm embarrassingly failing to failing to import either one into a MySQL table which has just two fields: ID and URL.

//Connect to MySQL...

// Attempt insert query execution

    $list=implode($unit);

    $sql = "INSERT INTO urls (url) VALUES ('$list')";
    if(mysqli_query($conn, $sql)){
        echo "Records added successfully.";
    } else{
        echo "ERROR: Could not able to execute $sql. " . mysqli_error($conn);
    }

    // Close connection
    mysqli_close($conn);

The insert works but the code is inserting all 3 urls into a single field:

id  url
1   http://one.com,http://two.com,http://three.com,

DESIRED MySQL table result for both script 1 and 2:

id  url
1   http://one.com
2   http://two.com
3   http://three.com

THANKS for your thoughts!

@MateoBarahona 10-4 = "acknowledged". grazie = "thank you". ;-) — Funk Forty Niner
– Funk Forty Niner, Commented Nov 3, 2015 at 21:19
@MateoBarahona prego (welcome) and there you have it, your Italian lesson for the day! (I'll bet you already knew that) (10-4, is widely used in the services area of the world, police, army, navy, etc.) ;-) — Funk Forty Niner
– Funk Forty Niner, Commented Nov 3, 2015 at 21:20

Dharman · Accepted Answer · 2020-07-31 16:27:26Z

4

you are doing a bit wrong here, you need to explode the $unit on the basis of ',' instead of implode

here it is

if (is_array($unit)) {
    $unit = implode(',', $unit);
} // check if array, convert to string
$list = explode(',', $unit);
$stmt = mysqli_prepare($conn, "INSERT INTO urls(url)  VALUES (?)");
mysqli_stmt_bind_param($stmt, 's', $url);
foreach ($list as $url) {
    if (empty($url)) {
        continue;
    }

    mysqli_stmt_execute($stmt);
    echo "Records added successfully.";
}

edited Jul 31, 2020 at 16:27

Dharman♦

33.9k27 gold badges106 silver badges157 bronze badges

answered Nov 3, 2015 at 21:19

Mubin

4,4655 gold badges37 silver badges56 bronze badges

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

10 Comments

Funk Forty Niner Over a year ago

$list=implode(",", $unit); I guess I meant "explode"; my bad.

Terry Over a year ago

You're not sanitizing your values. That's EXTREMELY dangerous.

Mubin Over a year ago

yes, but OP only wants to insert at the moment(this could also be a local project) @Terry

Terry Over a year ago

Local project is no excuse for using sloppy code.

ven Over a year ago

The explode results in "Warning: explode() expects parameter 2 to be string, array given..." and the foreach line results in "Warning: Invalid argument supplied for foreach()..."

|

Collectives™ on Stack Overflow

How to INSERT simple PHP array into MySQL table? [duplicate]

1 Answer 1

10 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Linked

Related