diff options
| author | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2011-01-22 10:52:39 +0000 |
|---|---|---|
| committer | Ludovic Pouzenc <ludovic@pouzenc.fr> | 2011-01-22 10:52:39 +0000 |
| commit | b54487ae821da5e7574bf2135b90d0669b30b181 (patch) | |
| tree | 80aa6229d2a0fbb3e03454043158d1746cc193d2 /app/v1_php/api | |
| parent | 190b6eff45149c373786669ca4455e52692ab2c4 (diff) | |
| download | 2011-usi-b54487ae821da5e7574bf2135b90d0669b30b181.tar.gz 2011-usi-b54487ae821da5e7574bf2135b90d0669b30b181.tar.bz2 2011-usi-b54487ae821da5e7574bf2135b90d0669b30b181.zip | |
Ajout du code fait par ludo dans le métro pour commencer à vraiment intégrer les specs
git-svn-id: file:///var/svn/2011-usi/trunk@6 db941bf7-0cb3-4dda-9634-87faf64f93a7
Diffstat (limited to 'app/v1_php/api')
| -rw-r--r-- | app/v1_php/api/game/index.php | 44 | ||||
| -rw-r--r-- | app/v1_php/api/mysql_connect.inc.php | 11 | ||||
| -rw-r--r-- | app/v1_php/api/user/form.html | 28 | ||||
| -rw-r--r-- | app/v1_php/api/user/index.php | 25 |
4 files changed, 108 insertions, 0 deletions
diff --git a/app/v1_php/api/game/index.php b/app/v1_php/api/game/index.php new file mode 100644 index 0000000..a8658ac --- /dev/null +++ b/app/v1_php/api/game/index.php @@ -0,0 +1,44 @@ +<?php + +/* +Table Game +Unique key : +*/ + +require_once("../mysql_connect.inc.php"); + +$authentication_key=$_POST['authentication_key']; + +if ($authentication_key !== "azertyuiop") { + // header 401, "Clé d'authentification non reconnue" + echo "401, Clé d'authentification non reconnue\n"; +} + +$parameters=json_decode($_POST['parameters']); +if ( !is_array($parameters) || !is_numeric($parameters['longpollingduration']) ){ + // header 400, "Erreur" + echo "header 400, Erreur paramètres\n"; +} + +$longpollingduration=$parameters['longpollingduration']; +$nbusersthreshold=$parameters['nbusersthreshold']; +$questiontimeframe=$parameters['questiontimeframe']; +$nbquestions=$parameters['nbquestions']; + +if ( $parameters['flushusertable'] === "true" ) { + $req="TRUNCATE TABLE User;" + $res=mysql_query($req); + //TODO check result +} + +$req="INSERT INTO Game (NULL, $longpollingduration, $nbusersthreshold, $questiontimeframe, $nbquestions)"; +$res=mysql_query($req); + +if ( mysql_num_rows() === 1 ) { + //TODO header 201, "OK : CREATED" + echo "header 201, OK : CREATED\n"; +} else { + // header 400, "Erreur" + echo "header 400, Erreur insertion SQL\n"; +} +?> diff --git a/app/v1_php/api/mysql_connect.inc.php b/app/v1_php/api/mysql_connect.inc.php new file mode 100644 index 0000000..0414480 --- /dev/null +++ b/app/v1_php/api/mysql_connect.inc.php @@ -0,0 +1,11 @@ +<?php + +$mysqlcon=mysql_connect("localhost", "usi2011", "usi2011"); +$res=mysql_select_db("usi2011"); + +if ( ! is_resource($mysqlcon) || $res !== 0) { + //header 400, Erreur connexion SQL + echo "Erreur connexion SQL\n"; + exit(); +} +?> diff --git a/app/v1_php/api/user/form.html b/app/v1_php/api/user/form.html new file mode 100644 index 0000000..a01d2dd --- /dev/null +++ b/app/v1_php/api/user/form.html @@ -0,0 +1,28 @@ +<html> +<head> +</head> + +<body> +<form method="POST"> + <div class="form_line"> + <label name="firstname">firstname</label> + <input type="text" name="firstname"></input> + </div> + <div class="form_line"> + <label name="lastname">lastname</label> + <input type="text" name="lastname"></input> + </div> + <div class="form_line"> + <label name="mail">mail</label> + <input type="text" name="mail"></input> + </div> + <div class="form_line"> + <label name="password">password</label> + <input type="text" name="password"></input> + </div> + <div class="form_line"> + <input type="submit" /> + </div> +</form> +</body> +</html> diff --git a/app/v1_php/api/user/index.php b/app/v1_php/api/user/index.php new file mode 100644 index 0000000..495bd2a --- /dev/null +++ b/app/v1_php/api/user/index.php @@ -0,0 +1,25 @@ +<?php + +/* +Table User : id, firstname, lastname, mail, password +Unique key : mail +*/ + +require_once("../mysql_connect.inc.php"); + +$firstname=mysql_real_escape_string($_POST['firstname']); +$lastname=mysql_real_escape_string($_POST['lastname']); +$mail=mysql_real_escape_string($_POST['mail']); +$password=mysql_real_escape_string($_POST['password']); + +$req="INSERT INTO User (NULL,'$firstname', '$lastname', '$mail', '$password')"; +$res=mysql_query($req); + +if ( mysql_num_rows() === 1 ) { + //TODO header 201, "OK : CREATED" + echo "header 201, OK : CREATED\n"; +} else { + // header 400, "Erreur" + echo "header 400, Erreur\n"; +} +?> |