5 files changed, 112 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";
+}
+?>
diff --git a/app/v1_php/index.html b/app/v1_php/index.html
new file mode 100644
index 0000000..1c70d95
--- /dev/null
+++ b/app/v1_php/index.html
@@ -0,0 +1,4 @@
+<html><body><h1>It works!</h1>
+<p>This is the default web page for this server.</p>
+<p>The web server software is running but no content has been added, yet.</p>
+</body></html>