Reading jos_users

Have a programming question regarding your component, plug-in, extension or core hacks? Have an interesting tidbit, FAQ or programming tip you’d like to share? This is the place for you.

Moderators: tjay, seadap, Rogue4ngel, matthewhayashida

Forum rules
Post Reply
mlewis
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Mar 14, 2006 1:35 am

Reading jos_users

Post by mlewis » Mon Mar 10, 2008 10:49 pm

Not being a programmer, need a little help on this one :).

Need to read users from jos_users (or when using community builder, perhaps another table?) from a script and output to a text file with one user on each line.

Can someone give me a mysql command which will allow me to do this from a script.

Thanks very much.

Mike
Top
Bodom78
Joomla! Apprentice
Joomla! Apprentice
Posts: 19
Joined: Fri Nov 04, 2005 9:23 am

Re: Reading jos_users

Post by Bodom78 » Tue Mar 11, 2008 9:48 am

If you have phpMyAdmin on the server, it allows you to export tables to a heap of different formats like CSV, Excel etc...

If you do have it, you will be able to find guides on how to export data
Top
mlewis
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Mar 14, 2006 1:35 am

Re: Reading jos_users

Post by mlewis » Tue Mar 11, 2008 1:26 pm

I do have it but I need this to be a command line script so that I can automate it.
Unless you're saying I can use it from the command line to achieve what I'm after?

What I need is output which can be read by another program later. That the output show only new accounts created and accounts removed. Not sure how it would show removed since they would be gone.

Mike
Top
Post Reply

Return to “Joombie Coding Q/A”