Subversion-Projekte lars-tiefland.prado

<com:TContent ID="body">

<h1>Configuring the DataMapper for PHP</h1>

<p>The SQLMap PHP DataMapper is configured using a central XML descriptor file,

usually named <tt>SqlMap.config</tt>, which provides the details for your data

source, data maps, and other features like caching, and transactions. At

runtime, your application code will call a class method provided by the SQLMap

library to read and parse your <tt>SqlMap.config</tt> file. After parsing the

configuration file, a DataMapper client will be returned by SQLMap for your

application to use.</p>

<h2>DataMapper clients</h2>

<p>Currently, the SQLMap PHP DataMapper framework revolves around the

<tt>TSqlMapper</tt> class, which acts as a facade to the DataMapper framework API.

You can create a DataMapper client by instantiating an object of the

<tt>TSqlMapper</tt> class. An instance of the <tt>TSqlMapper</tt> class (your

DataMapper client) is created by reading a single configuration file. Each

configuration file can specify one database or data source. You can of couse

use multiple DataMapper clients in your application. Just create another

configuration file and pass the name of that file when the DataMapper client

is created. The configuration files might use a different account with the

same database, or reference different databases on different servers. You can

read from one client and write to another, if that's what you need to do.

First, let's take a look at the DataMapper configuration file.

<h1>DataMapper Configuration File (SqlMap.config)</h1>

<p>A sample configuration file for a PHP web application is shown below.

Not all configuration elements are required. See

<a href="?page=Manual.ConfigurationElements">DataMapper Configuration Elements</a>

for details of each configuration elements in a <tt>SqlMap.config</tt> file.

<com:TTextHighlighter Language="xml" CssClass="source">

<?xml version="1.0" encoding="utf-8"?>

<sqlMapConfig>

    <provider class="TAdodbProvider" >

        <datasource ConnectionString="mysql://user:pass@localhost/test1" />

    </provider>

    <sqlMaps>

        <sqlMap name="Account" resource="maps/Account.xml"/>

        <sqlMap name="Order" resource="maps/Order.xml"/>

        <sqlMap name="Category" resource="maps/Category.xml"/>

        <sqlMap name="LineItem" resource="maps/LineItem.xml"/>

    </sqlMaps>

</sqlMapConfig>

</com:TTextHighlighter>

</com:TContent>