ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:reference:connection:concat

This is an old revision of the document!


concat

string concat(
       string $inputString
       )

Description

The function concat() takes an input CSV list strings, and returns a database-specific string of concatenated values


Usage

/*
 * Assume MySQL database
 */
$list = 'VOGON,POETRY,READING';
 
$string = $db->concat($list);
 
/*
 * Returns: CONCAT(VOGON,POETRY,READING);
*/

Concatenating Strings And Database Fields

In order to concatenate database fields and strings together it is necessary to quote the strings

/*
* Best methodology
*/
$s = $db->quote(', Arthur Dent');
 
$SQL = "UPDATE hitchhikers 
           SET last_name = {$db->concat(last_name,$s)} 
         WHERE first_name='Arthur' 
           AND last_name='Dent'";
 
$db->execute($SQL);
 
$SQL = "SELECT last_name FROM hitchhikers 
         WHERE first_name='Arthur'";
 
print $db->getOne($SQL);
 
/*
* Prints "Dent, Arthur Dent"
*/
v5/reference/connection/concat.1452983169.txt.gz · Last modified: 2017/04/21 11:36 (external edit)