|
Title: Pulling data from multiple tables in the same database Post by: swells808 on January 11, 2015, 09:33:20 PM 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. Title: Re: Pulling data from multiple tables in the same database Post by: jsbsan on April 22, 2015, 02:14:57 AM 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 |