J'essaie via mysql (j'utilise le mysqli) d'updater ma table mais sans résultat. Je me suis tout de même basé sur une table utilisateur auquel j'update les information de l'utilisateur qui fonctionne #1.
voici mon code pour l'update de jeu (via ma table) que je fais.
*** le $this->connect et $this->disconnect sert à se connecter à la DB et
à se déconnecter par la suite. (PVI)
-------------------------------------
public function saveModifGame($game)
{
include_once('Game.class.php');
$req = "UPDATE gc_games SET title='" . $game->getTitle() . "', platform='" . $game->getPlatform() . "', releasedate='" . $game->getReleaseDate() . "', developer='" . $game->getDeveloper(). "', publisher='" . $game->getPublisher() . "', designer='" . $game->getDesigner() . "', composer='" . $game->getComposer() . "', gamegenre='" . $game->getGenre() . "', mode='" . $game->getMode() . "', upc='" . $game->getUPC() . "', imagelink='" . $game->getImageLink() . "', description='" . $game->getDescription() . "', availability='" . $game->getAvailability() . "' previousgame='" . $game->getPreviousGame() . "', nextgame='" . $game->getNextGame() . "', editable=" . $game->getEditable() . " WHERE id='" . $game->getID() . "'";
$this->connect();
mysqli_query($this->conn, $req);
$this->disconnect();
}
-------------------------------------
voici ma classe Game
-------------------------------------------
<?php
//<!--Edited by : SpaceHam -->
//<!--Created : July 16th 2011 -->
class Game
{
private $id;
private $platform = "";
private $title = "";
private $developer = "";
private $publisher = "";
private $designer = "";
private $composer = "";
private $genre = "";
private $mode = "Single Player";
private $upc = "";
private $rdate = 1985;
private $description = "";
private $availability = "";
private $imagelink = "defaultgame";
private $previous_game = "";
private $next_game = "";
private $editable = 1;
public function getID()
{
return $this->id;
}
public function setID($ident)
{
$this->id = $ident;
}
public function getPlatform()
{
return $this->platform;
}
public function setPlatform($p)
{
$this->platform = $p;
}
public function getTitle()
{
return $this->title;
}
public function setTitle($n)
{
$this->title = $n;
}
public function getDeveloper()
{
return $this->developer;
}
public function setDeveloper($d)
{
$this->developer = $d;
}
public function getPublisher()
{
return $this->publisher;
}
public function setPublisher($p)
{
$this->publisher = $p;
}
public function getDesigner()
{
return $this->designer;
}
public function setDesigner($d)
{
$this->designer = $d;
}
public function getComposer()
{
return $this->composer;
}
public function setComposer($c)
{
$this->composer = $c;
}
public function getGenre()
{
return $this->genre;
}
public function setGenre($g)
{
$this->genre = $g;
}
public function getMode()
{
return $this->mode;
}
public function setMode($m)
{
$this->mode = $m;
}
public function getUPC()
{
return $this->upc;
}
public function setUPC($u)
{
$this->upc = $u;
}
public function getReleaseDate()
{
return $this->rdate;
}
public function setReleaseDate($d)
{
$this->rdate = $d;
}
public function getDescription()
{
return $this->description;
}
public function setDescription($d)
{
$this->description = $d;
}
public function getAvailability()
{
return $this->availability;
}
public function setAvailability($a)
{
$this->availability = $a;
}
public function getImageLink()
{
return $this->imagelink;
}
public function setImageLink($il)
{
$this->imagelink = $il;
}
public function getPreviousGame()
{
return $this->previous_game;
}
public function setPreviousGame($pg)
{
$this->previous_game = $pg;
}
public function getNextGame()
{
return $this->next_game;
}
public function setNextGame($ng)
{
$this->next_game = $ng;
}
public function getEditable()
{
return $this->editable;
}
public function setEditable($edit)
{
$this->editable = $edit;
}
}
?>
-------------------------------------------
Quelqu'un aurais une idée pourquoi ça ne veux pas sauvegarder, je n'ai même pas de message d'erreur.
A la limite je vous transférerais les informations de la table.
SpaceHamAgent