public static function insert($db, $data)
{
$query = 'INSERT INTO users (id, first_name, last_name, email, username, type, password, phone, address1, address2, city,
zip_code, country, state, created, modified) VALUES (:id, :first_name, :last_name, :email, :username, :type, :password,
:phone, :address1, :address2, :city, :zip_code, :country, :state, NOW(), NOW())';
$stmt = $db->prepare($query);
$stmt->execute(array('id' => $data['id'], 'first_name' => $data['first_name'], 'last_name' => $data['last_name'], 'email' => $data['email'], 'username' => $data['username'], 'type' => 'member', 'password' => \Helpers\User::create_password_hash($data['password']), 'phone' => $data['phone'] ? $data['phone'] : NULL, 'address1' => $data['address1'] ? $data['address1'] : NULL, 'address2' => $data['address2'] ? $data['address2'] : NULL, 'city' => $data['city'] ? $data['city'] : NULL, 'zip_code' => $data['zip_code'] ? $data['zip_code'] : NULL, 'country' => $data['country'] ? $data['country'] : NULL, 'state' => $data['state'] ? $data['state'] : NULL));
return $stmt;
}
