how to insert this data into mysql using php

[Virendra]

Array ( [data] => Array ( [0] => Array ( [latitude] => 22.934566 [longitude] => 79.08728 [type] => county [distance] => 44.328 [name] => Narsinghpur [number] => [postal_code] => [street] => [confidence] => 0.5 [region] => Madhya Pradesh [region_code] => MP [county] => Narsinghpur [locality] => [administrative_area] => [neighbourhood] => [country] => India [country_code] => IND [continent] => Asia [label] => Narsinghpur, India ) ) )

Please Help ! Thanks in Advance

[Barand]

0 out of 10 for formatting.

 

What have you tried so far?

What was the outcome?

[Barand]

This should get you started (if you haven't already) ...

$array = array ( 
    'data' => array ( 
        '0' => array ( 
            'latitude' => 22.934566, 
            'longitude' => 79.08728, 
            'type' => 'county', 
            'distance' => 44.328, 
            'name' => 'Narsinghpur', 
            'number' => '',
            'postal_code' => '',
            'street' => '',
            'confidence' => 0.5, 
            'region' => 'Madhya Pradesh', 
            'region_code' => 'MP', 
            'county' => 'Narsinghpur', 
            'locality' => '',
            'administrative_area' => '',
            'neighbourhood' => '', 
            'country' => 'India', 
            'country_code' => 'IND', 
            'continent' => 'Asia', 
            'label' => 'Narsinghpur, India' 
            ) 
        ) 
    );
    
foreach ($array['data'] as $record) {
    // insert $record
}