Julian Fox (greataussiepie)

Cool idea,

I don’t know technically how to accomplish this, but my first guess would be to some how create or find a plugin that allows you to do a search query using a permalink URL.

so example.com/actor/john-smith/ would return a list of results containing the name john-smith that was in the category actor no matter what its permalink was. i.e When someone clicked on John Smith it would take them to his profile, which then the permalink would change, but users could still access john smith from any of the urls.

maybe?

Hi,

There is almost always a plugin that will do what you want to do, have a look at these two plugins, they made serve your needs.

Enhanced Media Library

WP Media Library Categories

btw Google is your best bet when looking for a plugin, i found these two by searching

WordPress create multiple media libraries

Hi,

Check out this plugin ‘Jetpack Widget Visibility‘. This plugin also comes packaged in the main Jetpack plugin.

https://jetpack.me/support/widget-visibility/

Is this what you’re trying to do?

Hi,

Please note this advice from the WP Codex

If for any reason a site does not get upgraded, each site should be upgraded when the admin for that site logs in to the administration for that site. Sites that have been deactived will not be upgraded by this process, however, if a site is reactivated, the site will get upgraded when an admin for that site logs in to the dashboard for that site.

https://codex.www.ads-software.com/Network_Admin_Updates_Screen

Hi,

I advise that you carefully read this documentation on how to add/modify CSS styles to WordPress theme.

https://codex.www.ads-software.com/Child_Themes

This is a strange problem.

Have you have confirmed that your wp-config.php file indeed has the correct settings, and is indeed connecting to CORRECT database.?

After confirming that you are using the correct details in config, have you confirmed that the database that WordPress is connecting to, indeed has posts and other data in the database?

All the pages and media and info are gone if you look from WordPress back end. But I can see all media, files and folders in my server.

Are you saying that your database has been whipped? again please have a close look at your database using phpMyAdmin to see if there is data there or not.

I apologize for not getting to the point.

I’ve looked around and couldn’t find how to create tables directly in wordpress.

It is not necessary to create your own tables in WordPress, because we store all data in the existing tables, we generally do not create new ones. Your situation does not require its own set of tables.

I saw plugins like ‘Edit Any Table’ ‘Ultimate Tables’ but don’t know how to import the data into those tables.

The best way to import raw data into WordPress tables is to access the database directly using a different software named phpMyAdmin.

I don’t mind creating another set of tables to replicate what I created in access, I just need to be able to get the data in the access tables into the new tables.

As i mentioned, we do not create new tables, we only use the existing WordPress tables. Instead of creating new tables, to accomplish your task, you must create a custom post type called ‘Songs’. After you have created a custom post type called ‘Songs’ you would have to carefully import your raw data from Access into the specific tables being used by WordPress to manage your custom post type.

Plugins you can create custom post types with:

• https://www.ads-software.com/plugins/custom-post-type-ui/

A tutorial to get you started creating your Songs custom post type:

• https://www.youtube.com/watch?v=-r1b0wA98Ew

I can’t really explain it anymore than that, you will have to go ahead and start creating custom post types, and then look into the database to see where that data is being stored so you can understand it for yourself.

I am not really sure how to go about moving data from Access to MySQL exactly. You may need to go on over to stackexchange or stackoverflow or a different forum that can answer that specific question, this forum is specifically for WordPress (you are sort of asking a question outside of WordPress). To get you started here is a link i found:

Exporting Access Data to MySQL
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-export.html

And here is a video:

How to migrate ms access database to mysql server
https://www.youtube.com/watch?v=4u6ObJ8y6Vw

a stackoverflow forum question:
How to import an Access MDB format database to MySQL?
https://stackoverflow.com/questions/4809654/how-to-import-an-access-mdb-format-database-to-mysql

sorry i couldn’t help anymore than that.

Strange.

Thanks for showing me that.

Also,

WordPress stores your data in a pre-defined set of tables, unlike MS Access where you have to define your own tables, so you will have to use the tables already defined in WP. check out the WP database structure in this image, when you create the custom post type ‘Songs’ all the titles of those songs will be stored in wp_posts, notice in the wp_posts table how it says ‘author’, that will be you, the person who created the ‘song’ post in WP, not the author of the song itself.

Now when you use WordPress to add lyrics to your songs, that data will be stored in wp_postmeta. Notice how wp_postmeta has a post_id column? that is the ID of the song post type and this how the lyrics are connected to the song title, Notice how wp_postmeta has a key and a value? when you create a song, WP will store meta with the key ‘lyrics’ and the value will be the lyrics of the song you are creating.

This is how WordPress will store data, and how that data will be organised into tables.

First one would have to set-up WordPress so that one could ‘create’ a song in input lyrics and artists using the WordPress interface.

After this step is complete, in your case, one would need to import your current tables into the appropriate tables defined in WP

Sorry i miss read what you wrote, of course your not trying to use them together. ??

So yeh, from what you just said, are indicating that you want to create a custom post type ‘Song’ and then use custom meta data to store lyrics and artists etc in the ‘songs’. These post types and meta data are stored in the WordPress database tables and using WP functions as described above you can query them and display them and allow users to edit that data.

Since u want to make a website out of this data it makes sense to use WordPress, so that means you’re going to have to use WordPress to create the tables, insert the data, and retrieve the data for users.

MS Access and WordPress don’t really need to or as far as i know can work together. MS Access is a database, WordPress uses MySQL which is a database. you don’t need two databases.

If you want to use WordPress, theres really no reason to use Microsoft Access as well.

What i was trying to explain to you before was, WordPress has its own set of commands for reading and writing to the database. There is no point in using Access and WordPress together, just choose one and stick with it.

Ok, sorry about that, I won’t abuse that tag ?? hope that coffee is good.

I’ll tag this article and hopefully a more experienced WordPress developer can explain clearly and precisely what you need to do based on where you’re coming from. I’m still learning WP too, but you also sound like you have some experience with developing.

??