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)