Page 1 of 1

Use xataface for running queries in two different db

PostPosted: Wed May 16, 2012 2:26 pm
by abandaband
Hi,

I have two queries (based on entry criteria) of a user, first query runs a db and 2nd query runs on another db using table info of first query, can Xataface be used to create a tool for these queries?

Also, user should be able to provide input on frontend.

Thanks in advance :)

Re: Use xataface for running queries in two different db

PostPosted: Thu May 17, 2012 9:32 am
by shannah
Xataface is only set up to use a single DB but there are workarounds.

1. If you just need certain tables, you can create views the main db that refer to data in other databases. Then this view could be used just like any table - Xataface would have no idea that some of the data is coming from other databases.

2. You can always create additional mysql connections in PHP and query those other databases using regular mysql_query() calls.

-Steve