Hoping you might be able to help me out.
I am playing around with plugin development and would like to take data from a form and put into a database that I have created.
The database is called music (or wp_music after adding the prefix when creating the database upon plugin activation, following this: http://codex.wordpress.org/Creating_Tables_with_Plugins). It has three columns, ID (primary key), Album, Artist. ID is set to auto increment.
The plugin creates its own page in admin, which is an html doc in which has a very small, easy form:
<form action="formhtml.php" method="post"> Album: <input type="text" name="album" /> Artist: <input type="text" name="artist" /> <input type="submit" /> </form>
<?php global $wpdb $album=$_POST['album']; $artist=$_POST['artist']; $wpdb->insert( 'music', array( 'album' => $album, 'artist' => $artist ), array( '%s', '%s' ) ) ?>
And I get an Error 500 internal server error.
I've tried replacing 'music' with 'wp_music' too.
Perhaps someone can steer me in the right direction? let me know if you need any info!