Wordpress - 从自己的插件中保存数据

Question

My own wordpress plugin generates this data of a file:

filename|creator|date

    This is my filename|Max Mustermann|20.11.2017
    This is my filename|Anne Mustermann|26.11.2017
    This is my filename|Alex Mustermann|27.11.2017

How is wordpress built to save this data? How do I do that the right way?

Thanks for your answers!

Lingo

Answer 1

Try this example,

function bot_install()
{
    global $wpdb;
    $table = $wpdb->prefix."bot_counter";
    $structure = "CREATE TABLE $table (
        id INT(9) NOT NULL AUTO_INCREMENT,
        bot_name VARCHAR(80) NOT NULL,
        bot_mark VARCHAR(20) NOT NULL,
        bot_visits INT(9) DEFAULT 0,
    UNIQUE KEY id (id)
    );";
    $wpdb->query($structure);
 
    // Populate table
    $wpdb->query("INSERT INTO $table(bot_name, bot_mark)
        VALUES('Google Bot', 'googlebot')");
    $wpdb->query("INSERT INTO $table(bot_name, bot_mark)
        VALUES('Yahoo Slurp', 'yahoo')");
}

You get the result.

</div>