[[WebSignup? &tpl=`FormSignup` &groups=`Registered Users`]]
☆ A M B ☆
$sql = "INSERT INTO ".$modx->getFullTableName("web_user_attributes")." (internalKey, fullname, email, blocked, zip, state, country)
VALUES($key, '$fullname', '$email', ,1, '$zip', '$state', '$country');";
$rs = $modx->db->query($sql);
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’1, ’’, ’’, ’’)’ at line 2 »
SQL: INSERT INTO `my_database`.`modx_web_user_attributes` (internalKey, fullname, email, blocked, zip, state, country) VALUES(9, ’username’, ’email address’, ,1, ’’, ’’, ’’);
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0020 s (35 Requests)
PHP: 0.0342 s
Total: 0.0362 s
// save user attributes
$sql = "INSERT INTO ".$modx->getFullTableName("web_user_attributes")." (internalKey, fullname, email, blocked, zip, state, country)
VALUES($key, '$fullname', '$email', ,1, '$zip', '$state', '$country');";
$rs = $modx->db->query($sql);
☆ A M B ☆
$sql = "INSERT INTO ".$modx->getFullTableName("web_user_attributes")." (internalKey, fullname, email, blocked, zip, state, country)
VALUES($key, '$fullname', '$email', 1, '$zip', '$state', '$country');";
$rs = $modx->db->query($sql);
