Joomla Users Table


Joomla Users Table:

1.  jos_users
2.  jos_core_acl_aro
3.  jos_core_acl_groups_aro_map

Adding new registered user:

1. Insert into jos_users
– fields are :   id( = autoincrement field), username, name, email, password, gid (18=registered user,25=super admin)
– these are compulsory fields to fillup.
2.  Insert into jos_core_acl_aro
-fields are :   aro_id ( = autoincrement field), section_value(=”users” string), value(=jos_users.id), name=(=jos_users.name)
3.  Insert into jos_core_acl_groups_aro_map
-fields are :   group_id ( =jos_users.gid), aro_id( =jos_core_acl_aro.aro_id)

If you want your own component for registation then make a table like this:
4.  Insert into your_table.
-fields are :   id ( = autoincrement field), user_id ( =jos_users.id), other fields ( =username,name,email,password are stored in users table , so no need to add here)

source:http://patelraj.wordpress.com/2008/07/12/joomla-users-tablehow-to-create-joomla-user-by-using-other-componenttablehow-many-tables-are-related-with-users/

Various PHP-related Resources


I found a few links which point to PHP-related resources, here we are…

Please note that these files are hosted in servers which located in Indonesia, so access from outside Indonesia may be a bit slower…

PHP E-books:

Joomla:

CakePHP:

Code Igniter:

Software:

Update:

I’ve added links for non-Indonesian users…

PHP

Joomla

PHP-Oracle

PEAR

PHP Security