This is the source code to the EWB 2.05 PHP Database Manager for EDB and MySQL.  The EDB database layer is complete, but the MySQL layer is not.

***** This code is completely unsupported ******

Contents:

ewbdatabase.php - Base EWB database/dataset functionality
ewbdatabasemgr.php - EWB database manager (handles requests)
edbdatabase.php - EDB database/dataset functionality (done, requires EDB PHP extension)
mysqldatabase.php - MySQL database/dataset functionality (not done !!!)

Examples:

multimedia.php - EDB implementation of the multimedia example datasets (database not included)
mysqlorders.php - MySQL implementation of customer/orders example datasets (database not included)

Tim Young
Elevate Software
www.elevatesoft.com

I know there is no support here but think my question is valid if I complete this or develop my own server side code:

On the IDE, database manager, how can I select the MySQL or MS SQL Server database type? I only see ElevateDB, MyIsam and ADO types. Guess that MS SQL Server can be handled via ADO on a windows server, but MySQL has no option on the IDE, visually.

JD

On 4/23/2018 8:12 PM, jdforce wrote:
> I know there is no support here but think my question is valid if I complete this or develop my own server side code:
>
> On the IDE, database manager, how can I select the MySQL or MS SQL Server database type? I only see ElevateDB, MyIsam and ADO types. Guess that MS SQL Server can be handled via ADO on a windows server, but MySQL has no option on the IDE, visually.
>

IDE database manager is there for design time support and those settings
are for native DB connection management for built-in web server .

Runtime EWB just does we web requests with appropriate URL and params so
as long as your web server handles this properly against its database it
all just works.

You can setup an ADO connection if you want simple IDE design
environment. Any dataset columns can be populated from URL so you can
just point to your web server and it gets columns defs. Siomilarly

Similarly you can override the database baseurl in your app startup so
that all requests go to your web server even when using ide

Raul

Sorry for such noob questions but it is my second day with EWB. (well 23 years with delphi and 10 more with turbo pascal help a bit ).
So you say that to call a database served by any language server script, hosted in any OS i just need to make requests to the base URL?  That's an easy one.  Will try that.
Back to the original question here then, which of the php scripts on Tim's post above will be treated as the database base url?

Thanks,
JD

JD,

<< Back to the original question here then, which of the php scripts on Tim's post above will be treated as the database base url? >>

The mysqlorders.php script is the main script that you should direct database requests to.

Tim Young
Elevate Software
www.elevatesoft.com

The same goes for the multimedia.php script.

Tim Young
Elevate Software
www.elevatesoft.com

Great, thanks.
With that criteria will start building my database connectors.

JD