DMXzone Database Connector PHP Support Product Page
How do I create one connection that includes all my needed tables?
Asked 16 Mar 2015 17:50:02
1
has this question
16 Mar 2015 17:50:02 David Hunter posted:
I had just reported that I could not see a View I had created.Then, helpfully, I saw this problem referred to a year ago.As suggested in the solution I went through the steps of creating a new connection.Then I saw the View show up.So, solved. However, I work with a PHP coder that always asks when I open up a project if I want to 'synch the project' with the database it is based on and reports how many days have gone by since the last synch of project files with current localhost database.
Because this is written in PDO, evidently, I cannot simply point to one database and have all tables accessible with one connection.
I cannot figure out how to put all the tables I want to use in my project into one connector.When I use the + to add more tables, one by one, the Query Wizard always pops up and insists on creating a JOIN condition for each table I am adding!
The connection method so far to me is not intuitive.And so far has not allowed me in one connection to work with multiple tables simultaneously in the same database.
Replies
Replied 17 Mar 2015 13:13:30
17 Mar 2015 13:13:30 Teodor Kuduschiev replied:
Hi David,
What exactly do you mean by: "to put all the tables I want to use in my project into one connector" ?
When you create a database connection, you have access to ALL of your tables in your database... From this one database connection you can create as many database sources, that you can use on your page.
And - of course you are being ansked to JOIN tables when you add more than one in the query builder if you want to access several different tables just create different database sources and then add them to your page.
Please follow the tutorials and/or the product manual.
What exactly do you mean by: "to put all the tables I want to use in my project into one connector" ?
When you create a database connection, you have access to ALL of your tables in your database... From this one database connection you can create as many database sources, that you can use on your page.
And - of course you are being ansked to JOIN tables when you add more than one in the query builder if you want to access several different tables just create different database sources and then add them to your page.
Please follow the tutorials and/or the product manual.
Replied 17 Mar 2015 22:43:44
17 Mar 2015 22:43:44 David Hunter replied:
Hi Teodor, thanks for your response.
What I mean is the PHP connector requires me to go through the steps of creating a connection by specifying 1 table. The connection does not simply enable all tables in the database.
And you say if I need more tables, as I always do, I have to Create different database sources one at a time for each table.
MYSQLI was more convenient. Define One connection one time.
Not a separate connection for each Table.
I discovered this by seeing that I could NOT add more tables to a connection even though there was + sign.
It always triggered the Join wizard.
When I worked with the old Dreamweaver behaviors, as much as I detested that funky method, at least I had access to all tables as soon as I needed them.
At any rate, I have apparently discovered something right off the bat that I have not read about PDO.
I will have to keep phpmyadmin going in a separate window to view the tables I need.
Thank you, again!
What I mean is the PHP connector requires me to go through the steps of creating a connection by specifying 1 table. The connection does not simply enable all tables in the database.
And you say if I need more tables, as I always do, I have to Create different database sources one at a time for each table.
MYSQLI was more convenient. Define One connection one time.
Not a separate connection for each Table.
I discovered this by seeing that I could NOT add more tables to a connection even though there was + sign.
It always triggered the Join wizard.
When I worked with the old Dreamweaver behaviors, as much as I detested that funky method, at least I had access to all tables as soon as I needed them.
At any rate, I have apparently discovered something right off the bat that I have not read about PDO.
I will have to keep phpmyadmin going in a separate window to view the tables I need.
Thank you, again!