File "db_test.php"

Full Path: /home/analogde/www/Virtual/db_test.php
File size: 929 bytes
MIME-type: text/x-php
Charset: utf-8

<?php

		$db_host    = "localhost";
	    $db_user   = "root";
	    $db_pass   = ""; 
    	$db_name   = "projet";
	
		$connexion = mysql_connect($db_host,$db_user,$db_pass); 
		if(!$connexion)
		{
			die('Could not connect: ' . mysql_error());
		}
 
		mysql_select_db($db_name, $connexion); 
		
		$query = "SELECT * FROM utilisateurs WHERE user = 'apatrice' ";

		$result = mysql_query($query);	
	
		$count  = mysql_num_rows($result);

	if($count==0) {
		print "Invalid Username or Password!";
	}
	else {
		print "You are successfully authenticated!";
	}
	
		

/*	session_start();
	include('database.php');
	DB_connexion(); 
	
	$query = "SELECT * FROM user_online WHERE connexion = 'offline' "

	$liste = mysql_query($query_liste);

	$row_liste = mysql_fetch_assoc($liste);

	$totalRows_liste = mysql_num_rows($liste); 
	
	echo $totalRows_liste;


	mysql_select_db($database, $connection);
	mysql_query("SET NAMES 'utf8'");*/

?>