<div>
yes that works using only mysql.<br />
Thank you.
</div>


yes that works using only mysql.
Thank you.

<div>
I guess you could write a function, but it might be easier to write a single line PHP statement like this:<br />
<br />
$old = '5454';<br />
$new = 'begin' . $old . 'end';
</div>


I guess you could write a function, but it might be easier to write a single line PHP statement like this:

$old = '5454';
$new = 'begin' . $old . 'end';

<div>
<div class="content wysiwyg-content">
using mysqli, or pdo<br />
<br />
I would like a php function that prepends 'begin' and postpends 'end' to an existing varchar field<br />
<br />
table.column1 int primary key autoincrement<br />
table.column2 varchar<br />
table.column3 varchar<br />
<br />
<br />
example output<br />
5454 &nbsp;begin5454end<br />
656 &nbsp; &nbsp;begin656end<br />
4 &nbsp; &nbsp; &nbsp; &nbsp;begin4end<br />
A &nbsp; &nbsp; &nbsp; &nbsp;beginAend
</div>
</div>


using mysqli, or pdo

I would like a php function that prepends 'begin' and postpends 'end' to an existing varchar field

table.column1 int primary key autoincrement
table.column2 varchar
table.column3 varchar


example output
5454  begin5454end
656    begin656end
4        begin4end
A        beginAend

run column2 through a function and output would be in column3

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.