Creating a table in Wordpress admin

Question

I have two problems with WordPress.

First I am trying to create a database table with the prefix "ol" but when I add an email into my form, there is no new table created in the databaze. Here is the code:

if ( isset( $_POST['ol-odeslat'] ) ) {
            $name    = sanitize_text_field( $_POST["ol-name"] );
            $email   = sanitize_email( $_POST["ol-email"] );
            require_once('../../../wp-config.php');
            global $wpdb;
            $table_name = $wpdb->prefix . "ol";
            $wpdb->insert( $table_name, array( 'name' => $_POST['ol-name'], 'email' => $_POST['ol-email'] ) );
        }

Also I am trying to create a table in WordPress admin but I seem to be getting an error that there is an unexpected . (dot) on the line 171. Here is the code:

$sql = "SELECT name,email FROM 'ol' ";
$results = $wpdb->get_results($sql);
if ($results) {
    foreach ($results as $row) {
        echo '<tr>';
        echo '<th>' . $row->name; . '</td>';
        echo '<td>' . $row->email; . '</td>';
        echo '</tr>';
    }
}

In your first code snippet: are you actually creating the table? Does $wpdb->insert() create the table automatically if it doesn't exist? — PaulJ
– PaulJ, Commented Nov 19, 2015 at 18:51
And in your second snippet: the table name should be $wpdb->prefix . 'ol', shouldn't it? — PaulJ
– PaulJ, Commented Nov 19, 2015 at 18:51

JérémyCasper · Accepted Answer · 2015-11-19 18:56:50Z

1

About the table creation, you have extra ; Between >>>;<<< in the code below

$sql = "SELECT name,email FROM 'ol' ";
$results = $wpdb->get_results($sql);
if ($results) {
    foreach ($results as $row) {
        echo '<tr>';
        echo '<th>' . $row->name>>>;<<< . '</td>';
        echo '<td>' . $row->email>>>;<<< . '</td>';
        echo '</tr>';
    }
}

answered Nov 19, 2015 at 18:56

JérémyCasper

1823 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Creating a table in Wordpress admin

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related