Pulling data from multiple tables in the same database

[swells808]

Using the CRUD demo as an example I was wondering how to pull data from multiple tables inside the same database. Here is my example:

There are 2 databases "users" and "data". The CRUD table pulls the following fields from users - first name, last name, hire date. Then pulls the following from data - department, manager, division.

What I need is when a user creates a new entry is they fill in the first name, last name, department, manager, and division fields with hire date auto populating.

The 2 issues I have are: how do I script the get_users.php to connect to 2 sources (and of course script this into the CRUD) and how do I ensure the hire date field auto populates.

Thanks in advance.

[jsbsan]

swells808:

We have made a step by step example of how to work as multiple tables, tables present data and dialogues. You can get it at:

Format .pdf:
http://www.lulu.com/shop/julio-sanchez-berro-and-johan-guerreros-montoya/creando-una-aplicaci%C3%B3n-web-paso-a-paso-usando-php-y-javascript-jquery-y-jeasyui/ebook/product-22137504.html

And

Format paper book
http://www.lulu.com/shop/julio-sanchez-berro-and-johan-guerreros-montoya/creando-una-aplicaci%C3%B3n-web-paso-a-paso-usando-php-y-javascript-jquery-y-jeasyui/paperback/product-22137592.html


The source code is also available if you buy the .pdf and / or paper book


video about the application step described in the manual:
https://www.youtube.com/watch?v=deJq5g0g260