Dave

Yes, the wpdb class is an option. I’ll probably end up using a PHP app generator and running the results on a sub-folder or sub-domain.

Thanks.

Thanks, Tobias.
You are correct. Join queries to avoid incredibly wide “flat” files.
I can solve my problem….just not in WordPress.
Regardless, TablePress is a very impressive plugin.
Congrats Tobias.
d.

I have the same problem upon updating to ver. 5.5

Does this feature still carry the “coming soon” label?

THAT PAGE SEEMS TO HAVE BEEN HI-JACKED. BE CAREFUL.

Thank you!
I saw something in another post where it suggested that account.php should be copied to the child theme but in a folder:
ultimate-member/templates/account.php

My guess is that if you put the page-account.php in the root of your child theme, that was POSSIBLY (don’t know for sure) a potential problem.

Thanks again.

Dear @nadiaam67,
It would be VERY helpful if you could post exactly what you did to solve the problem.

TIA!

Please consider using the native WordPress capabilities and control mechanisms before inventing something.

What you should consider is ROLES within WordPress. If that isn’t sufficient, then think about doing what you’re asking about.

WordPress ROLES are very powerful and easily expanded.

HTH.
Dave

Peter/John:
With regard to the primary key (ID, name) and the assumption that you want “name” to be unique, why not simply declare a UNIQUE INDEX on name?

Just my $0.02! (USD)
Dave

Peter,
The explicit table.fieldname (c_songtitles.hymnary_org_url) does NOT work;
HOWEVER, the ALIAS works PERFECTLY!

What a dream come true!
I’ve been fooling with “custom fields” and FAILING.

I think the appropriate expression (perhaps outdated) is: YOU da bomb, Peter!

THANKS!
d.

OK!
Hard-coded URL works but the concat() string MUST have a “comma” at the end of the line.

I’m guessing now that what you’re working on MIGHT provide the ability to replace the hard-coded URL with the actual data in a selected field?

I’m “all in” for something like that! And can wait until the “coronavirus” comes around and then I have to run because I’m 15 years past the youngest members of the high-risk group!

THANKS, Peter!
d.

I don’t recognize what should be substituted in that concat string, except that “target” will likely be “_blank”.

Does label = the field name and url/your-url = the data?

Sorry to be so “dense between the ears”!
d.

It is becoming CLEARER, Peter!
But WHERE does the JSON get added to the column?
Thanks.
Dave

Hi Peter,
Here is the core of my view.
Fields that I would like to have as active hyperlinks are:
c_songtitles.hymnary_org_url
and
c_mtracks.url
– – –
select
c_songtitles.st_id AS st_id,
c_songtitles.st_title AS st_title,
c_songtitles.st_genre AS st_genre,
c_songtitles.music_key AS music_key,
c_songtitles.hymnary_org_url AS hymnary_org_url,
c_song_genres.id AS id,
c_song_genres.genre AS genre,
midi_sequencers.ms_id AS ms_id,
midi_sequencers.ms_name AS ms_name,
c_mtracks.mst_id AS mst_id,
c_mtracks.sequencer_id AS sequencer_id,
c_mtracks.url AS url,
midi_voicing.mv_id AS mv_id,
midi_instrumentation.mi_id AS mi_id,
midi_voicing.mv_desc AS mv_desc,
midi_instrumentation.mi_desc AS mi_desc
from (((((c_songtitles
join c_song_genres)
join midi_sequencers)
join c_mtracks)
join midi_voicing)
join midi_instrumentation)
where
(
(c_mtracks.mst_id = c_songtitles.st_id) and
(c_mtracks.sequencer_id = midi_sequencers.ms_id) and
(c_song_genres.id = c_songtitles.st_genre) and
(c_mtracks.voicing = midi_voicing.mv_id) and
(c_mtracks.instrumentation = midi_instrumentation.mi_id)
)
order by
c_songtitles.st_title
– – – – –
TIA.
Dave

• This reply was modified 5 years ago by Dave.

I’ve been following this thread with great interest!

Mike,
Does BlueHost NOT allow you to create your unique database administration users and then allow you to assign one or more to each database?

I run on DreamHost and their cPanel gives me total control over which users have access to databases, whether the access is via WordPress, phpMyAdmin or any other PHP code. (i.e., I have some apps that were created with SQL Maestro’s “PHP Generator).

Just curious!
Dave

• This reply was modified 5 years ago by Dave.