Convert array to another array

Question

I have one array that I am showing like this:

echo '<table>';
foreach ($rowData as $row => $tr) {
    echo '<tr>'; 
    foreach ($tr as $td)
        echo '<td>' . $td .'</td>';
    echo '</tr>';
}
echo '</table>';

The second and fourth columns are always the name of the column. The result is something like:

Name: John Locke - NickName: Locke

Age: 20 - Adress: Ok

See the pattern?

How can I put these array in my database?

As my database table structure is:

ID - Name - NickName - Age - Adress

I don't have a clue how to do that with the array i'm using..

--UPDATE

$table = $html->find('table', 0);
$rowData = array();

foreach($table->find('tr') as $row) {
    // initialize array to store the cell data from each row
    $flight = array();

    foreach($row->find('td') as $cell) {

        foreach($cell->find('span') as $e){
            $e->innertext = '';
        }

        // push the cell's text to the array
        $flight[] = $cell->plaintext;
    }
    $rowData[] = $flight;
}

echo '<table>';
foreach ($rowData as $row => $tr) {
    echo '<tr>'; 
    echo '<td>' . $row . '</td>'; 
    foreach ($tr as $td)
        echo '<td>' . $td .'</td>';
    echo '</tr>';
}
echo '</table>';

Pierre-Luc Bolduc · Accepted Answer · 2015-07-27 13:58:36Z

1

you can do that:

$insert = "";
foreach ($rowData as $row => $tr) {
        $insert .= "('".$tr[0]."','".$tr[0]."','".$tr[0]."','".$tr[0]."'),";

}
$insert = substr($insert, 0, -1)
$sql = "Insert into YourTable values ".$insert;

edited Jul 27, 2015 at 13:58

answered Jul 27, 2015 at 3:36

Pierre-Luc Bolduc

4831 gold badge5 silver badges18 bronze badges

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

4 Comments

ziad.ali Over a year ago

@pbolduc The result is: Insert into myTable values ('ID:', '1', 'NAME:' ,'JOHN'), ('NICKNAME:','LOCKE','AGE:','20'); - How can i change to be Insert into myTable (ID, NAME, NICKNAME) values ('1', 'LOCKE', ..) ?

Pierre-Luc Bolduc Over a year ago

Can you show me your array i will make you a better solution thx. I would like to you see the index of your array. Does it is numbers or a string?

ziad.ali Over a year ago

@pbolduc have you ever used simplehtml dom parser? i'm creating the array as i get the return of "find". I updated the post so you can se better.

Pierre-Luc Bolduc Over a year ago

No i never used it. I have updated my post, try to change the index of td by the one that you want exemple : tr[1] or tr[2] ...

CodingInTheUK · Accepted Answer · 2015-07-28 05:06:31Z

0

As you already know what the array positions relate to, IE positions 0 through 3. You can simply iterate as you are doing now and compile a query instead.

Just drop this snippet into your code, ive knocked this up on the fly and its a bit hackish, probably a better way. Just look at what it does on your screen and see where if any it needs correcting.

$insert = '';
for ($i=0; $i<=3; $i++):

   $insert .= "'" . $tr[$i] . "'";

   if ($i !== 3):
       $insert .= ',';
   endif;

endfor;

echo $insert;

Once you are seeing what looks like a correct insert then you can (using safe methods) insert it into your database.

edited Jul 28, 2015 at 5:06

answered Jul 27, 2015 at 3:45

CodingInTheUK

9687 silver badges18 bronze badges

2 Comments

ziad.ali Over a year ago

Don't know if am doing the right way (probably not), but i'm getting a lot of "$tr[$i],$tr[$i]". @Chris

CodingInTheUK Over a year ago

Sorry i added single quotes around it, which makes php read it verbatim. you will need edited.

Collectives™ on Stack Overflow

Convert array to another array

2 Answers 2

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related