cvs: phpdoc /en/reference/sdodasrel/functions SDO-DAS-Relational-executePreparedQuery.xml

mfp Mon Aug 1 05:23:02 2005 EDT Modified files: /phpdoc/en/reference/sdodasrel/functions SDO-DAS-Relational-executePreparedQuery.xml Log: Add <programlisting> with example code for executePreparedQuery() http://cvs.php.net/diff.php/phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml?r1=1.1&r2=1.2&ty=u Index: phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml diff -u phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml:1.1 phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml:1.2 --- phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml:1.1 Fri Jul 29 14:14:31 2005 +++ phpdoc/en/reference/sdodasrel/functions/SDO-DAS-Relational-executePreparedQuery.xml Mon Aug 1 05:23:02 2005 @@ -1,5 +1,5 @@ <?xml version='1.0' encoding='iso-8859-1'?> -<!-- $Revision: 1.1 $ --> +<!-- $Revision: 1.2 $ --> <refentry id="function.SDO-DAS-Relational-executePreparedQuery"> <refnamediv> <refname>SDO_DAS_Relational::executePreparedQuery</refname> @@ -196,10 +196,63 @@ <refsect1 role="examples"> &reftitle.examples; <para> - Please see the - <link linkend='sdo.das.rel.examples'>Examples</link> - section in the general information about the - Relational DAS for many examples of calling this method. + <example> + <title>Retrieving a data object using executePreparedQuery</title> + <para> + In this example a single data object is retrieved from the database + - or possibly more than one if there is more than one company + called 'Acme'. For each company returned, the + <varname>name</varname> + and + <varname>id</varname> + properties are echoed. + </para> + <para> + Other examples of the use of + <function>executePreparedQuery</function> + can be found in the example code supplied in + <filename>sdo/DAS/Relational/Scenarios</filename> + . + </para> + <programlisting role="php" id="sdo.das.rel.functions.epq.1c-R"> +<![CDATA[ +<?php +require_once 'SDO/DAS/Relational.php'; +require_once 'company_metadata.inc.php'; + +/************************************************************** + * Construct the DAS with the metadata + ***************************************************************/ +$das = new SDO_DAS_Relational ($database_metadata,'company',$SDO_reference_metadata); + +/************************************************************** + * Get a database connection + ***************************************************************/ +$dbh = new PDO(PDO_DSN,DATABASE_USER,DATABASE_PASSWORD); + +/************************************************************** + * Issue a query to obtain a company object - possibly more if they exist + * Use a prepared query with a placeholder. + ***************************************************************/ +$name = 'Acme'; +$pdo_stmt = $dbh->prepare('select name, id from company where name=?'); +$root = $das->executePreparedQuery( + $dbh, + $pdo_stmt, + array($name), + array('company.name', 'company.id')); + +/************************************************************** + * Echo name and id + ***************************************************************/ +foreach ($root['company'] as $company) { + echo "Company obtained from the database has name = " . + $company['name'] . " and id " . $company['id'] . "\n"; +} +?> +]]> + </programlisting> + </example> </para> </refsect1> </refentry>