Databases
StackOverflow2013
Postsdbo
POInserting data into a table in Wordpress database using Wordpress $wpdb
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInserting data into a table in Wordpress database using Wordpress $wpdb
    primarykey
    data
    text
    <p>I am starting out plugin development and have followed the tutorials on the Wordpress Codex sites. I am now stuck - I have a database called "wp_imlisteningto", where the <code>wp_</code> was inserted using:</p> <pre><code>$table_name = $wpdb-&gt;prefix . "imlisteningto"; </code></pre> <p>When the plugin is activated. </p> <p>The database itself has three columns, set up when the plugin is activated:</p> <pre><code>$sql = "CREATE TABLE $table_name ( id mediumint(9) AUTO_INCREMENT, album VARCHAR(50), artist VARCHAR(50), PRIMARY KEY (id) );"; </code></pre> <p>I am trying to insert data (by creating a new row) into this database from a php form.</p> <p>Within the Wordpress admin, I create a new page which has the very simple form:</p> <pre><code>&lt;form action="/wp-content/plugins/listeningto/formhtml.php" method="post"&gt; Album: &lt;input type="text" name="album" /&gt; Artist: &lt;input type="text" name="artist" /&gt; &lt;input type="submit"&gt; &lt;/form&gt; </code></pre> <p>Which as you can see calls <code>formhtml.php</code>, which is:</p> <pre><code>&lt;?php global $wpdb; $wpdb-&gt;insert( $table_name, array( 'album' =&gt; $_POST['album'], 'artist' =&gt; $_POST['artist'] ), array( '$s', '$s' ) ); ?&gt; </code></pre> <p>When I submit the form, I get an <code>Error 500.0</code> when running the plugin in Worpdress on <code>IIS7.0</code>, and a <code>"Page Not Found"</code> when running on another web server which runs <code>apache</code>.</p> <p>If I change <code>formhtml.php</code> to:</p> <pre><code>&lt;?php echo $_POST['album']; echo $_POST['artist']; ?&gt; </code></pre> <p>Works fine - I get the album and artist that I put in the form. Obviously something I'm doing wrong when inserting the data (in a new row) into the database.</p> <p>Any thoughts as to what that might be?</p> <p>UPDATE</p> <p>Ok, so if I update <code>formhtml.php</code> with this:</p> <pre><code>&lt;?php require_once('../../../wp-config.php'); $table_name = $wpdb-&gt;prefix . "imlisteningto"; $wpdb-&gt;insert( $table_name, array( 'album' =&gt; $_POST['album'], 'artist' =&gt; $_POST['artist'] ), array( '$s', '$s' ) ); ?&gt; </code></pre> <p>I no longer get an error message, but data still doesn't get put into the database.</p> <p><strong>UPDATE 2</strong></p> <p><strong>This worked for me:</strong></p> <pre><code>&lt;?php require_once('../../../wp-config.php'); global $wpdb; $table_name = $wpdb-&gt;prefix . "imlisteningto"; $wpdb-&gt;insert( $table_name, array( 'album' =&gt; $_POST['album'], 'artist' =&gt; $_POST['artist'] ) ); ?&gt; </code></pre> <p>as did this:</p> <pre><code>&lt;?php require_once('../../../wp-load.php'); global $wpdb; $table_name = $wpdb-&gt;prefix . "imlisteningto"; $wpdb-&gt;insert( $table_name, array( 'album' =&gt; $_POST['album'], 'artist' =&gt; $_POST['artist'] ) ); ?&gt; </code></pre> <p>So, for some reason <code>$wpdb</code> was not working unless I required either <code>wp-config</code> or <code>wp-load.php</code>. If include <code>wp-load.php</code>, <code>$wpdb</code> gets values and all is well.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USenam
    1. USAmmyKami83
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POInserting data into a table in Wordpress database using Wordpress $wpdb
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POInserting data into a table in Wordpress database using Wordpress $wpdb
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    3. VO
      singulars
      1. POInserting data into a table in Wordpress database using Wordpress $wpdb
      1. This table or related slice is empty.
      1. VTUpMod
    1. COrequire_once(ABSPATH . 'wp-settings.php'); should work as well. ABSPATH is defined @wp-load.php
      singulars
      1. POInserting data into a table in Wordpress database using Wordpress $wpdb
      1. USenam
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload