1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| <?php
$action = $_POST['action'];
pg_connect("...");
if ($action=='add')
{
$player = addslashes($_POST['player']);
/* l'id */
$newid = 1;
/*selection player1 */
$sql = "select player1 from game where id='".$newid."'";
$res = pg_query($sql);
$player1 = pg_fetch_array($res);
/* si le player1 existe ou pas */
if($player1 =='' || $player1 == null)
{
/* Insertion dans la BDD */
$sql = "insert into game values ($newid,'".$player."','', null, null,'".$player."')";
$player1 = $player;
$player2 = "";
}
else
{
/* test du même nom */
if($player == $player1[0])
{
$player.="2";
}
/* Insertion dans la BDD */
$sql = "update game set player2='".$player."' where id='".$newid."'";
$player1 = $player1[0];
$player2 = $player;
}
$res = pg_query($sql);
if (!$res)
{
echo "reqok=false\n";
}
else
{
echo "reqok=true\n";
echo "player1='".$player1."'\n";
echo "player2='".$player2."'\n";
}
} |
Partager