• What I am a looking for is a plugin that will allow a person from the admin panel only to insert NEW data into an already existing database. For exmaple, I have a site which keeps a record of all karaoke songs they offer at their nightclub so people can check it out before heading on down to see if their favorite songs are on the list. Ineed to be able to have the owner of the site go in to to wp admin and be able to add new tracks to his database as he gets them. I know this can be done via a form and php but if this plugin can do it that would be awesome and save a lot of time!!!

    Is this possible with your plugin and if so are there instructions on doing this task?

    Thank you

    Mike

    http://ww.wp.xz.cn/plugins/participants-database/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Roland Barker

    (@xnau)

    Well, if I understand you correctly, this plugin will do what you want. In the admin there is the ability to add and edit records. You can also import existing record using a CSV file, but you have to get everything set up first.

    Thread Starter mike-logan

    (@mike-logan)

    Thanks for the quick answer. The data base is already contruceted with over 15,000 entries so the CSV has already been imported. All it has is one table and 6 fields. So basically, when he gets new songs I just need a way for him to add it into the database with the song info which would be like song title, artist, ect…

    That would be great!!! Any hints or tutorials on how to set this up? It would be for admin use only…nothing public except the output of the database which I already have setup and displaying.

    Thanks again

    Mike

    Thread Starter mike-logan

    (@mike-logan)

    Ok, I activated your plugin and don’t see a way I can connect to an external database (database name, host, user, password) which is where I need to update and add in the information…so I am guessing your plugin only uses the wp database???

    Let me know and thanks!

    Mike

    Plugin Author Roland Barker

    (@xnau)

    Mike, the plugin uses it’s own tables which it creates in the WP database. It’s not for managing another database.

    If you want to use the plugin, you’ll have to set up the plugin database fields before you try to import your records. Go to the “manage database fields” page, delete all the fields you don’t need and create new ones for your database. Don’t try to import the database directly, it’s best to do it in the plugin using CSV. Once you’re familiar with how it stores the data, you can do it any way you want.

    The plugin has two levels of admin access: one for administrators, and another for editors who can add or edit records only.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Inserting Info. In to Database from WP admin panel?’ is closed to new replies.