Hello!
I am new to PHP ( about 1 week ) and I need to use cookie but I need to check first if the currect data ( a number ) is in my database.
Here is the current code I have :
<html>
<head>
<title>[ P ] atriot</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="patriot.css" rel="stylesheet" type="text/Css">
</head>
<body>
<?php
require_once("header.php");
AfficherEntete();
?>
<?php
// db variables
$host = "myip.balbla.blab";
$user = "USERNAME";
$pass = "PASSWORD";
$db = "TESTING";
$table = "Usagers";
//Connection a la base de donnee
$link = mysql_connect ($host, $user, $pass)
or die("Impossible de se connecter : " . mysql_error());
//Selection de la base utilisee
mysql_select_db($db);
//Prend les parametres
$varId=$_POST['User_id'];
//Prend le numéro de de l'équipe
$sql = 'SELECT usagers_nom FROM usagers WHERE usagers_id = ' .$varId;
//Execute l'ordre sql
$result = mysql_query($sql)
or die ("NO USER FOUND");
$numRow = mysql_num_rows($result);
if ($numRow > 0)
{
//Prend la valeur de retour
$Nom = mysql_result($result,0);
echo($Nom. '(#' .$varId.') is logged');
//**********************************
//**********************************
//HERE IS WHERE I NEED TO PUT THE COOKIE
//**********************************
//**********************************
setcookie ("patriot_user_id" , $varId , time()+600);
}
else
{
echo('Loggin failed');
}
mysql_free_result($result);
// closing the db link
mysql_close ($link);
?>
</body>
</html>
I pass by parameter a number, after I check if it's valid and if YES then I put a cookie...
PLEASE help me, I've lost so much time and never succeed 🙁
