Insert array data on plugin activation

Question

I am working on custom plugin. I need to insert currency names and symbols in table on plugin activation. Right now my database insertion code is :

    global $wpdb;
    $table_name1 = $wpdb->prefix . "woo_currency";
    $curr_name = array('Dollars', 'Ruble', 'Riel');
    $curr_symbol = array('$', 'p.', '៛');

    $insert = $wpdb->insert($table_name1,
            array(
                'name' => $curr_name,
                'symbol' => $curr_symbol,
            ),array('%s', '%s'));

Everthing is working fine except this database insertion on plugin activation. Have you guys any idea. How to do it?

This code gave me error

The plugin generated 416 characters of unexpected output during activation. If you notice “headers already sent” messages, problems with syndication feeds or other issues, try deactivating or removing this plugin.

I want to add Currencies name & symbols these all.

Answer 1

You may please use this code that will help you to insert data into database

register_activation_hook( __FILE__, 'my_plugin_create_db' );

function my_plugin_create_db() {
global $wpdb;
    $table_name1 = $wpdb->prefix . "woo_currency";
    $curr_name = array('Dollars', 'Ruble', 'Riel');
    $curr_symbol = array('$', 'p.', '៛');

    $insert = $wpdb->insert($table_name1,
            array(
                'name' => $curr_name,
                'symbol' => $curr_symbol,
            ),array('%s', '%s'));

}

Hope this will help you to achieve your goal.

Answer 2

Ok, finally i got my answer. Just put the insert query in foreach statement. Here is the code:

$curr_name   = array( 'Dollars', 'peso' );
$curr_symbol = array( '$', 'ƒ' );

foreach( $curr_name as $x => $y )
{
    $insert = $wpdb->insert(
        $table_name1,
         array(
            'name'   => $y,
            'symbol' => $curr_symbol [$x ],

        ),
        array( '%s', '%s' )
    );
}