diff options
| author | Julien Sere <jsere> | 2011-01-22 11:50:29 +0000 |
|---|---|---|
| committer | Julien Sere <jsere> | 2011-01-22 11:50:29 +0000 |
| commit | 12f6cc3a6f90a67c1d922dd3d46a368b1066dee1 (patch) | |
| tree | dce223a8bf2386ba0fa125414a6045df3ac198ca | |
| parent | 0180447ad17eb36e54dca74f9854657d7ec5fa9a (diff) | |
| download | 2011-usi-12f6cc3a6f90a67c1d922dd3d46a368b1066dee1.tar.gz 2011-usi-12f6cc3a6f90a67c1d922dd3d46a368b1066dee1.tar.bz2 2011-usi-12f6cc3a6f90a67c1d922dd3d46a368b1066dee1.zip | |
Implémentation de user et game.
git-svn-id: file:///var/svn/2011-usi/trunk@8 db941bf7-0cb3-4dda-9634-87faf64f93a7
| -rw-r--r-- | .settings/org.eclipse.core.resources.prefs | 3 | ||||
| -rw-r--r-- | app/v1_php/api/game/form.html | 22 | ||||
| -rw-r--r-- | app/v1_php/api/game/index.php | 28 | ||||
| -rw-r--r-- | app/v1_php/api/mysql_connect.inc.php | 5 | ||||
| -rw-r--r-- | app/v1_php/api/user/form.html | 2 | ||||
| -rw-r--r-- | app/v1_php/api/user/index.php | 10 |
6 files changed, 48 insertions, 22 deletions
diff --git a/.settings/org.eclipse.core.resources.prefs b/.settings/org.eclipse.core.resources.prefs new file mode 100644 index 0000000..40dbd80 --- /dev/null +++ b/.settings/org.eclipse.core.resources.prefs @@ -0,0 +1,3 @@ +#Sat Jan 22 11:45:57 CET 2011
+eclipse.preferences.version=1
+encoding/<project>=UTF-8
diff --git a/app/v1_php/api/game/form.html b/app/v1_php/api/game/form.html new file mode 100644 index 0000000..ed4ad72 --- /dev/null +++ b/app/v1_php/api/game/form.html @@ -0,0 +1,22 @@ +<html> +<head> +</head> + +<body> +<form method="POST" action="index.php"> + <div class="form_line"> + <label name="authentication_key">authentication_key</label> + <input type="text" name="authentication_key" value="azertyuiop" /> + </div> + <div class="form_line"> + <label name="parameters">parameters</label> + <textarea rows="10" cols="80" name="parameters"> +{ "longpollingduration" : "60", "nbusersthreshold" : "2", "questiontimeframe" : "10", "nbquestions" : "20", "flushusertable" : "true" } + </textarea> + </div> + <div class="form_line"> + <input type="submit" /> + </div> +</form> +</body> +</html> diff --git a/app/v1_php/api/game/index.php b/app/v1_php/api/game/index.php index a8658ac..154d905 100644 --- a/app/v1_php/api/game/index.php +++ b/app/v1_php/api/game/index.php @@ -2,7 +2,6 @@ /* Table Game -Unique key : */ require_once("../mysql_connect.inc.php"); @@ -10,14 +9,14 @@ 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"; + header("Clé d'authentification non reconnue", true, 401); + exit(); } -$parameters=json_decode($_POST['parameters']); +$parameters=json_decode($_POST['parameters'], true); if ( !is_array($parameters) || !is_numeric($parameters['longpollingduration']) ){ - // header 400, "Erreur" - echo "header 400, Erreur paramètres\n"; + header("Erreur paramètres", true, 400); + exit(); } $longpollingduration=$parameters['longpollingduration']; @@ -26,19 +25,20 @@ $questiontimeframe=$parameters['questiontimeframe']; $nbquestions=$parameters['nbquestions']; if ( $parameters['flushusertable'] === "true" ) { - $req="TRUNCATE TABLE User;" - $res=mysql_query($req); + $req="TRUNCATE TABLE User;"; + mysql_query($req); //TODO check result } -$req="INSERT INTO Game (NULL, $longpollingduration, $nbusersthreshold, $questiontimeframe, $nbquestions)"; +$req="INSERT INTO Game VALUES (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"; + +echo mysql_error(); + +if ( $res===true && mysql_affected_rows() === 1 ) { + header("OK : CREATED", true, 201); } else { - // header 400, "Erreur" - echo "header 400, Erreur insertion SQL\n"; + header("erreur", true, 400); } ?> diff --git a/app/v1_php/api/mysql_connect.inc.php b/app/v1_php/api/mysql_connect.inc.php index 0414480..9cd7211 100644 --- a/app/v1_php/api/mysql_connect.inc.php +++ b/app/v1_php/api/mysql_connect.inc.php @@ -3,9 +3,12 @@ $mysqlcon=mysql_connect("localhost", "usi2011", "usi2011"); $res=mysql_select_db("usi2011"); -if ( ! is_resource($mysqlcon) || $res !== 0) { + +if ( ! is_resource($mysqlcon) || $res !== true) { //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 index a01d2dd..fb2fc67 100644 --- a/app/v1_php/api/user/form.html +++ b/app/v1_php/api/user/form.html @@ -3,7 +3,7 @@ </head> <body> -<form method="POST"> +<form method="POST" action="index.php"> <div class="form_line"> <label name="firstname">firstname</label> <input type="text" name="firstname"></input> diff --git a/app/v1_php/api/user/index.php b/app/v1_php/api/user/index.php index 495bd2a..3b27b03 100644 --- a/app/v1_php/api/user/index.php +++ b/app/v1_php/api/user/index.php @@ -12,14 +12,12 @@ $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')"; +$req="INSERT INTO User VALUES (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"; +if ( $res===true && mysql_affected_rows() === 1 ) { + header("OK : CREATED", true, 201); } else { - // header 400, "Erreur" - echo "header 400, Erreur\n"; + header("erreur", true, 400); } ?> |