DevProTalk - PDO pitanje

Ok, ovo je metod iz objekta, ocigledno. Ne obazirite se na global $db, ionako je u pitanju test ;)

Naime, update radi savrseno, a insert nece ni da bekne.
Hvatao sam mu i exception (u ovom kodu nema exc. handlinga, ali nije bitno), no nikakav exception nije uhvacen. Samo se nista ne desava pri upisu u bazu... Any ideas???
Hm da, objekat je imao napravljene parametre, nema ID, i kod je prosao froz uslov tamo kuda treba da prodje, samo se nista nije desilo.
Probao sam i sa samo 2 parametra cisto da vidim da ga ne buni neki podatak, ali ne...

PHP kôd:


		
			
    public function save() {

        global $db;

        if ($this->id != null) {

            $sql = "update users set  username = :username ,  password = :password ,  email = :email ,  firstName = :firstName ,  lastName = :lastName ,  address = :address ,  city = :city ,  postCode = :postCode ,  country = :country ,  phone = :phone ,  birthDate = :birthDate ,  startYear = :startYear ,  numDogs = :numDogs ,  kennelName = :kennelName ,  isValidated = :isValidated ,  timeCreated = :timeCreated ,  timeModified = :timeModified  where id = :id";

            $stmt = $db->prepare($sql);

            $stmt->bindParam(':id', $this->id);

            $stmt->bindParam(':username', $this->username);

            $stmt->bindParam(':password', $this->password);

            $stmt->bindParam(':email', $this->email);

            $stmt->bindParam(':firstName', $this->firstName);

            $stmt->bindParam(':lastName', $this->lastName);

            $stmt->bindParam(':address', $this->address);

            $stmt->bindParam(':city', $this->city);

            $stmt->bindParam(':postCode', $this->postCode);

            $stmt->bindParam(':country', $this->country);

            $stmt->bindParam(':phone', $this->phone);

            $stmt->bindParam(':birthDate', $this->birthDate);

            $stmt->bindParam(':startYear', $this->startYear);

            $stmt->bindParam(':numDogs', $this->numDogs);

            $stmt->bindParam(':kennelName', $this->kennelName);

            $stmt->bindParam(':isValidated', $this->isValidated);

            $stmt->bindParam(':timeCreated', $this->timeCreated);

            $stmt->bindParam(':timeModified', $this->timeModified);

            $stmt->execute();

        } else {

            $sql = "insert into users (username, password, email, firstName, lastName, address, city, postCode, country, phone, birthDate, startYear, numDogs, kennelName, isValidated, timeCreated, timeModified) values (:username, :password, :email, :firstName, :lastName, :address, :city, :postCode, :country, :phone, :birthDate, :startYear, :numDogs, :kennelName, :isValidated, :timeCreated, :timeModified)";

            $stmt = $db->prepare($sql);

            $stmt->bindParam(':username', $this->username);

            $stmt->bindParam(':password', $this->password);

            $stmt->bindParam(':email', $this->email);

            $stmt->bindParam(':firstName', $this->firstName);

            $stmt->bindParam(':lastName', $this->lastName);

            $stmt->bindParam(':address', $this->address);

            $stmt->bindParam(':city', $this->city);

            $stmt->bindParam(':postCode', $this->postCode);

            $stmt->bindParam(':country', $this->country);

            $stmt->bindParam(':phone', $this->phone);

            $stmt->bindParam(':birthDate', $this->birthDate);

            $stmt->bindParam(':startYear', $this->startYear);

            $stmt->bindParam(':numDogs', $this->numDogs);

            $stmt->bindParam(':kennelName', $this->kennelName);

            $stmt->bindParam(':isValidated', $this->isValidated);

            $stmt->bindParam(':timeCreated', $this->timeCreated);

            $stmt->bindParam(':timeModified', $this->timeModified);

            $stmt->execute();

            $this->setId($db->lastInsertId());

        }

    }