转换| 使用PHP将值分隔为新表

Question

Edit: I forgot to add the explode part that I'm having the issues with. I need the query result exploded.

I have been messing with this for a while and have a workable procedure in mysql, however I want to accomplish this as part of a larger script. I have a table filled with IDs and several columns of data with "|" separated values. How can I use or edit the below PHP to query and insert normalized results into a new table?

If I run this with an actual string: "40|180|408|360|40|166|80|59"; It will insert values (not the ID, which I also need) but when I try to pass in query results, I get "Array to string conversion" errors. Any guidance would be appreciated.

$query = "Select id, imageSize from T1";
$result = mysqli_query($conn, $query);
$myArray = explode('|', $result);

foreach($myArray as $value) {
   $sql = "INSERT INTO testExplode VALUES ($value)";
$result = mysqli_query($conn, $sql);
}

Answer 1

If you want to insert all of your results then:

$query = "Select id, imageSize from T1";
$myArray = mysqli_query($conn, $query);

while ($row = mysqli_fetch_assoc($myArray)) {
    $sql = "INSERT INTO testExplode VALUES (" . mysqli_real_escape_string($conn, $row['imageSize']) . ")";
    mysqli_query($conn, $sql);
}

//If just only one:

$query = "Select id, imageSize from T1";
$myArray = mysqli_query($conn, $query);

$row = mysqli_fetch_assoc($myArray);
$sql = "INSERT INTO testExplode VALUES (" . mysqli_real_escape_string($conn, $row['imageSize']) . ")";
mysqli_query($conn, $sql);

NOTE:

• Avoid sql injecions by escaping your variables in your querys.

EDIT:

Based on the OP comment.

$query = "Select id, imageSize from T1";
$myArray = mysqli_query($conn, $query);

while ($row = mysqli_fetch_assoc($myArray)) {
    $values = explode('|', $row['imageSize']);
    foreach ($values as $value) {
        $sql = "INSERT INTO testExplode VALUES (" . mysqli_real_escape_string($conn, $value) . ")";
    mysqli_query($conn, $sql);
    }

}