Edit Question - KnowledgeHub

Title Body

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 wp_ was inserted using: $table_name = $wpdb->prefix . "imlisteningto"; When the plugin is activated. The database itself has three columns, set up when the plugin is activated: $sql = "CREATE TABLE $table_name ( id mediumint(9) AUTO_INCREMENT, album VARCHAR(50), artist VARCHAR(50), PRIMARY KEY (id) );"; I am trying to insert data (by creating a new row) into this database from a php form. Within the WordPress admin, I create a new page which has the very simple form: <form action="/wp-content/plugins/listeningto/formhtml.php" method="post"> Album: <input type="text" name="album" /> Artist: <input type="text" name="artist" /> <input type="submit"> </form> Which as you can see calls formhtml.php , which is: <?php global $wpdb; $wpdb->insert( $table_name, array( 'album' => $_POST['album'], 'artist' => $_POST['artist'] ), array( '$s', '$s' ) ); ?> When I submit the form, I get an Error 500.0 when running the plugin in Worpdress on IIS7.0 , and a "Page Not Found" when running on another web server which runs apache . If I change formhtml.php to: <?php echo $_POST['album']; echo $_POST['artist']; ?> 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. Any thoughts as to what that might be? UPDATE Ok, so if I update formhtml.php with this: <?php require_once('../../../wp-config.php'); $table_name = $wpdb->p

Tags (comma-separated) Cancel