newbie question
| From: | Fernando Fiore | Date: | Tue, 04 Aug 2020 01:06:19 +0000 |
| Subject: | newbie question | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-327245@lists.php.net to get a copy of this message | ||
why this simple database operation does not work
function AddToUsersTable($mail,$nick,$pw) // $mail is an email add
{
$db = new mysqli("localhost","root","","mydb");
if($db){
$mail = $db->real_escape_string($mail);
//print($mail . "</br>");
$nick = $db->real_escape_string($nick);
$pw = $db->real_escape_string($pw);
$q = $db->query("INSERT INTO users (nick, email, pw) VALUES($nick,
$mail, $pw);");
if($q)
return true;
else{ /* it fails here *;
print($db->error);
return false;
}
}
else{
print("failed to connect to db </br>");
return false;
}
}
// thanks in advance