MySQL and PHP
Copyright 1997-2021 the PHP Documentation Group.
Session::quoteName
Add quotes
public string mysql_xdevapi\Session::quoteName(string name);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.
name
The string to quote.
The quoted string.
Example 5.122 mysql_xdevapi\Session::quoteName
example
<?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:
string(12) "MySQL's test" string(14) "`MySQL's test`" string(28) "Another `test` "like" `this`" string(34) "`Another ``test`` "like" ``this```"