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
|
<?php
session_start();
?>
<?php
$bdd = new PDO('mysql:host=localhost;dbname=lolstats', 'martin', '');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$length = $_POST['duree_minute'] * 60 + $_POST['duree_seconde'] ;
$prepa = $bdd->prepare('INSERT INTO `matches` (`pseudo`, hero, `kills`, `death`, `assist`, `kill_team`, `death_team`, `assist_team`, `gold`, `damage`, `damage_team`, `multi_kill`, `killing_spree`, `ward`, `duree`, `premade`, `side`, `date`, `first_blood`, `lane`, `result` ) VALUES(`:pseudo`, `:hero`, `:kills`, `:death`, `:assist`, `:kill_team`, `:death_team`, `:assist_team`, `:gold`, `:damage`, `:damage_team`, `:multi_kill`, `:killing_spree`, `:ward`, `:duree`, `:premade`, `:side`, SYSDATE(), `:first_blood`, `:lane`, `:result`');
$prepa->execute(array(
'pseudo'=> $_SESSION['pseudo'] ,
'hero'=> $_POST['hero'] ,
'kills'=> $_POST['kill'] ,
'death'=> $_POST['death'] ,
'assist'=> $_POST['assist'] ,
'kill_team'=> $_POST['kill_team'] ,
'death_team'=> $_POST['death_team'] ,
'assist_team'=> $_POST['assist_team'] ,
'gold'=> $_POST['gold'] ,
'damage'=> $_POST['damage'] ,
'damage_team'=> $_POST['damage_total'] ,
'multi_kill'=> $_POST['multi_kill'] ,
'killing_spree'=> $_POST['killing_spree'] ,
'ward'=> $_POST['ward'] ,
'duree'=> $length,
'premade'=> $_POST['premade'] ,
'side'=> $_POST['side'] ,
'first_blood'=> $_POST['first_blood'] ,
'lane'=> $_POST['lane'] ,
'result'=> $_POST['result'] ,
));
echo 'Match enregistré';
?> |
Partager