How can I insert a dash separated string into my database?

Question

I have this string as my input string:

12345-45678-543245

So in my database table I want to insert these dash separated strings as followed:

   part_id  |  Part numbers
------------------------------
   1        |     12345
   2        |     45678
   3        |    543245

I have no idea how to do this? Maybe some hints and advices would help me.

Hard for me to distinguish input having dash then separately save them and have no idea how to do it — Brandon Jake Sullano, May 26 '15 at 10:58
two things to do: explode your string and then prepare the statement for the multiple insert in database. — Masiorama, May 26 '15 at 10:58
`$input="12345-45678-543245"; $data = explode('-',$input); save $data to database` — KTAnj, May 26 '15 at 10:59
how to accept ? I will ? sorry I was new in stackoverflow I just registered today — Brandon Jake Sullano, May 26 '15 at 11:11
@BrandonJakeSullano ^ Click on the link in my last comment, there you see how you can accept any answer — Rizier123, May 26 '15 at 11:15
@BrandonJakeSullano Before you now try to accept all answers. You can only accept one. — Rizier123, May 26 '15 at 11:20

score 3 · Accepted Answer · answered May 26 '15 at 11:04

This should work for you:

Just PDO::prepare() your INSERT statement and then loop through your explode()'d input and insert the values into your db.

<?php

    $input = "12345-45678-543245";
    $arr = explode("-", $input);

    $host = "localhost";
    $dbname = "myDBName";
    $user = "root";
    $password = "";

    try {

        $dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $password);
        $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

        $stmt = $dbh->prepare("INSERT INTO myTable (`part_id`, `Part numbers`) VALUES(?, ?)");
        foreach($arr as $k => $v)
            $stmt->execute([($k+1), $v]);

    } catch(PDOException $e) {
        echo $e->getMessage();
    }

?>

score 1 · Answer 2 · answered May 26 '15 at 11:00

1

$string  = '12345-45678-543245';
$array = explode('-',$string);
Foreach($array as $arr){
    //Here add to database...
}

But that is very simple PHP... Please visit php.net for more info ¬.¬'

answered May 26 '15 at 11:00

Kyto

181
3
12

thanks! yes forgot to search first before asking questions here – Brandon Jake Sullano May 26 '15 at 11:02

jakecfc1992 · Answer 3 · 2015-05-26T11:02:36.560

1

You can explode your string to separate it into sections.

<?php
$string = "12345-45678-543245"

$parts = explode("-", $string);

$p0 = $parts[0];  //12345
$p1 = $parts[1];  //45678
$p2 = $parts[2];  //543245
?>

edited May 26 '15 at 11:02

answered May 26 '15 at 11:01

jakecfc1992

196
11

How can I insert a dash separated string into my database?

3 Answers3