|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2000-06-11 21:31 UTC] fredo at pandora dot be
Ok, here goes, I don't think this is a real bug, but I can't find a solution for it,
$db_query = "INSERT INTO UserInfo (Name, Email) ".
"VALUE ('$username', '$email')";
$db_result = odbc_exec($db_conn, $db_query);
This works smoothly as long as no value contains a "special" sign. Example,
$username="Olivier D'hooghe"
Several people told me to use addslashes() but that doesn't solve it, here follows the error message,
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''Olivier D\'Hooghe', 'oli@home.net')'., SQL state 37000 in SQLExecDirect in common.php on line 101
The problem is the <'> in the username. I'm stuck.
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Jul 06 15:01:35 2025 UTC |
<? $username = "Olivier D'hooghe"; $username = ereg_replace("'", "''", $username); echo $username; ?> Solves it...