|
PHPRunner supports the following databases: MySQL, Oracle,
Microsoft SQL Server, MS Access, PostgreSQL, spreadsheet file,
Informix, DB2, SQLite, any other ODBC-enabled database.
Select your database type and press Next>>. Depending on the selected
database type you will see one of the database-specific dialog
boxes shown below.
Use Recent connections
to quickly connect to previously opened databases.
Connecting to
MySQL, PostgreSQL
Type the Host/Server Name (usually localhost), user name, password and
click Connect. More info about how to
install local web server and MySQL server.
Select Database and
click Next >>.
If your MySQL server doesn't allow remote connection, you can
connect it using PHP.
Connecting to
Oracle, Microsoft SQL Server, Informix, DB2
Type the Host/Server name, Database Name, username, password and
click Connect.
Connecting to
MS Access, spreadsheet file, SQLite
Choose this option to select SQLite, MS Access, Excel, FoxPro,
DBase, Paradox or text database file.
Define the file path to your database/spreadsheet file, enter
login name and password if required. Click Next >>.
PHPRunner will try to find what ODBC driver to use to connect to
selected database file. Select the Select ODBC driver manually check box
if you'd like to select ODBC driver manually.
Connecting to
ODBC Data Source
If you already have an ODBC Data Source Name (DSN) associated
with your database, select ODBC DSN from the list box. Enter your
Login and Password if required. Press Next>> to continue.
To create new DSN, press the ODBC Admin button. In the window opened
add new DSN. Then click Refresh
list.
Connecting
through ODBC driver dialog
Choose this option to connect directly through ODBC driver
specific dialog.
Select ODBC driver from the list of available ODBC drivers and
click Next>>.
Create a new
MS Access database
If you do not have a database yet choose this option and click
Next>>. PHPRunner
will help you to create a new empty MS Access database.
Using Create new table
window you can create new tables in your database.
For each field type name, type, size, scale (applies to DECIMAL
datatype in SQL Server, Oracle and MySQL only). Set the Primary key
field. Databases created with PHPRunner will be saved to
C:\Program
Files\PHPRunner6.1 directory (database.mdb, database1.mdb
etc.)
 Note: Don't
change table settings after you've built your project and added
data records. All data will be lost after table modification.
After you successfully connected to database, it is time to
select datasource tables.
|
