File "identifie.php"

Full Path: /home/analogde/www/Bookmarks/CHESS_ON/identifie.php
File size: 1.47 KB
MIME-type: text/x-php
Charset: utf-8

<?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;
}
				
?>