Session::quoteName
PHP function
Edit on GitHub ✎
Add quotes
Description
mysql_xdevapi\Session::quoteName(string $name): string
A quoting function to escape SQL names and identifiers. It escapes the identifier given in accordance to the settings of the current connection. This escape function should not be used to escape values.
Parameters
nameThe string to quote.
Return Values
The quoted string.
Examples
mysql_xdevapi\Session::quoteName() example
php
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$first = "MySQL's test";
var_dump($first);
var_dump($session->quoteName($first));
$second = 'Another `test` "like" `this`';
var_dump($second);
var_dump($session->quoteName($second));
?>The above example will output something similar to:
output
string(12) "MySQL's test"
string(14) "`MySQL's test`"
string(28) "Another `test` "like" `this`"
string(34) "`Another ``test`` "like" ``this```"