How to insert a string in PHP and MySQL

Question

dbms_assert.enquote_literalused for single string quotes in Oracle. Is there a similar function in MySQL and PHP?

Answer 1

You can use a custom function to do this.

Example:

function str_enq($string = '')
{
    $char = '\'';
    return str_pad($string, strlen($string) + 2, $char, STR_PAD_BOTH);
}