09-20-2007, 11:58 AM
|
#6 (permalink)
|
|
The Prestige
Join Date: Sep 2007
Location: Sweden, Stockholm
Posts: 1,080
Thanks: 115
|
Okey, I got it working without any errors now..
PHP Code:
public function save() {
if(isset($this->data['uid'])) {
// UPDATE query on database
$sql = sprintf(" UPDATE
%s
SET
username = '%s',
password = '%s',
registerdate = '%s',
registerip = '%s'
WHERE
uid = %d",
$this->table['members'],
$this->data['username'],
$this->data['password'],
$this->data['registerdate'],
$this->data['registerip'],
$this->data['uid']);
}
else {
// INSERT query on database
$sql = sprintf(" INSERT INTO
%
VALUES
uid = NULL,
username = '%s',
password = '%s',
registerdate = '%s',
registerip = '%s'",
$this->table['members'],
$this->data['username'],
$this->data['password'],
$this->data['registerdate'],
$this->data['registerip']);
}
$insert = $this->db->query($sql);
if($insert) {
return true;
} else {
return false;
}
}
PHP Code:
$system->user = new member($system->db, 'users');
$system->user->setName('Tanax');
$system->user->setPass('pass');
$system->user->setRegdate(time());
$system->user->setRegip($_SERVER['REMOTE_ADDR']);
if($system->user->save()) {
echo '<br />Admin account created!';
} else {
echo '<br />' .mysql_error();
}
It printed "Admin account created, however.. when I check the database, no users exists.. |
|
|
|