Code:
Duplicate entry '' for key 3
.Duplicate entry '' for key 3
Dok kod update mi uradi izmenu svih polja, ali ne bi trebalo to. Prvo u klasi imam niz u kome upisem polja tabele sa kojom ce klasa raditi. Zbog koriscenja svih polja koja se nalazi u tom nizu imam te probleme. Kod inserta mi se preklapa id sa poslednjim id-om, a update radi kako sam vec opisao.
Code:
public function update() {
global $database;
$atributes = $this->cistiAtributi();
$atributePairs = array();
foreach ($atributes as $key => $value) {
$atributePairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ". self::$nazivTabele ." SET ";
$sql .= join(", ", $atributePairs);
$sql .= " WHERE org_id =" . $database->escapeValue($this->org_id);
$database->query($sql);
return ($database->affectedRows() == 1) ? true : false;
} //kraj update
public function create() {
global $database;
$atributes = $this->cistiAtributi();
$sql = "INSERT INTO " . self::$nazivTabele . " (";
$sql .= join(", ", array_keys($atributes)) . ") ";
$sql .= "VALUES ('";
$sql .= join("', '", array_values($atributes));
$sql .= "') ";
if ($database->query($sql)) {
$this->org_id = $database->insertedID();
return true;
} else {
return false;
}
} //kraj create
public function update() {
global $database;
$atributes = $this->cistiAtributi();
$atributePairs = array();
foreach ($atributes as $key => $value) {
$atributePairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ". self::$nazivTabele ." SET ";
$sql .= join(", ", $atributePairs);
$sql .= " WHERE org_id =" . $database->escapeValue($this->org_id);
$database->query($sql);
return ($database->affectedRows() == 1) ? true : false;
} //kraj update
public function create() {
global $database;
$atributes = $this->cistiAtributi();
$sql = "INSERT INTO " . self::$nazivTabele . " (";
$sql .= join(", ", array_keys($atributes)) . ") ";
$sql .= "VALUES ('";
$sql .= join("', '", array_values($atributes));
$sql .= "') ";
if ($database->query($sql)) {
$this->org_id = $database->insertedID();
return true;
} else {
return false;
}
} //kraj create
to su metodi, moze li mi neko dati sugestiju kako bih trebao to uraditi?