Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Bookmarks
/
CHESS_ON
:
identifie.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php session_start(); include('database.php'); DB_connexion(); $_SESSION['chessmaster'] = "clone_chessmaster_new"; $_SESSION['classement'] = "clone_classement_new"; $_SESSION['parties'] = "clone_parties_new"; $_SESSION['evolution'] = "clone_evolution_new"; $_SESSION['membres'] = "membres"; $_SESSION['elo_affectation'] = "clone_elo_affectation"; $ret = findIdPlayer("Henrique"); if(is_null($ret)) { echo "Failed"; } else { echo "Good"; } function findIdPlayer($joueur) { //$joueur = "Henrique"; //$sql = "SELECT * FROM " .$_SESSION['parties'] ." WHERE w_name = '$joueur' "; //OR b_name = '$joueur' "; // desc LIMIT 20"; $sql = "SELECT * FROM parties_new WHERE w_name = '$joueur' "; // OR b_name = '$joueur' "; // desc LIMIT 20"; echo $sql; $results = mysql_query($sql); $nb_parties = mysql_num_rows($results); if( $nb_parties != 0) { while ($row = mysql_fetch_array($results)) { $result = $row["w_playerID"]; echo $result; break; } } else { $sql = "SELECT * FROM parties_new WHERE b_name = '$joueur' "; // OR b_name = '$joueur' "; // desc LIMIT 20"; $nb_parties = mysql_num_rows($results); if( $nb_parties != 0) { while ($row = mysql_fetch_array($results)) { $result = $row["w_playerID"]; echo $result; break; } } else { echo "Pas de partie disputées !."; $result = NULL; } } return $result; } ?>