Un problème possible dans une requête MySql Pdo

<?php 
require_once ( __DIR__  . "/securite.php");
?>

<?php
/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbbb";
$url = "cccccc";
$v_web_name = "dddd";
/**********************************************/
session_start();
error_reporting(E_ALL);
require ("connexionBDD.php"); // .. ce fichier ne contient pas la connexion à la bdd tel que son nom pourrait le laisser penser ?????
try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
 // Tu n'as pas activé la gestion des erreurs PDO ...
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}

<?php 
// ceci est le  Fichier connexionBDD.php

/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbbb";
$url = "cccccc";
$v_web_name = "dddd";
/**********************************************/
try {
   $connexion =new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd .';charset=utf8',$PARAM_utilisateur, $PARAM_mot_passe);
  // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}
?>    

( ! ) Warning: require(../securite.php): failed to open stream: No such file or directory in D:\fichier-de-depart.php on line 1

<?php
// Fichier D:\fichier-de-depart.php

// pour tester.. on va regarder si le fichier existe
$fileSecurite = __DIR __ . '/securite.php';
if(!file_eixsts($fileSecurite)){
  echo " Fichier " . $fileSecurite . " manquant ou mal ortographié !!";
  exit;
}

require_once  __DIR __ . '/securite.php';

( ! ) Fatal error: require(): Failed opening required '../security.php' (include_path='.;C:\php\pear') in D:\membres\fichier-de-destination.php on line 1

<?php  
// Fichier D:\membres\fichier-de-destination.php

require_once __DIR__ "/../securite.php";

<?php
$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';
?>

<?php
// Fichier D:\fichier-de-depart.php

// pour tester.. on va regarder si le fichier existe
$fileSecurite = 'securite.php';
if(!file_exists($fileSecurite)){
  echo " Fichier " . $fileSecurite . " manquant ou mal ortographié !!";
  exit;}?>

<?php 
// ceci est le  Fichier connexionBDD.php

/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbbb";
$url = "cccccc";
$v_web_name = "dddd";
/**********************************************/

$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';

try {
   $connexion =new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd .';charset=utf8',$PARAM_utilisateur, $PARAM_mot_passe);
  // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}
?> 

<?php
// Fichier D:\fichier-de-depart.php

// pour tester.. on va regarder si le fichier existe
$fileSecurite = __DIR __ . '/securite.php';
if(!file_eixsts($fileSecurite)){
  echo " Fichier " . $fileSecurite . " manquant ou mal ortographié !!";
  exit;
}

require_once  __DIR __ . '/securite.php';

// Puis le reste du code de cette page

<?php  
// Fichier D:\membres\fichier-de-destination.php

require_once __DIR__ "/../securite.php";


// puis le reste du code ...

// Fichier D:\fichier-de-depart.php

// pour tester.. on va regarder si le fichier existe
$fileSecurite = "securite.php";
if(!file_exists($fileSecurite)){
  echo ' Fichier ' . $fileSecurite . ' manquant ou mal orthographié !!';
  exit;}
//require_once __DIR __ . "/securite.php";

$sql = "SELECT * FROM membersbase WHERE user LIKE '".trim($_POST['user'])."' AND active = '1'";
$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

$sql = "SELECT COUNT(1) FROM membersbase WHERE email_regis LIKE '".strtolower($_SESSION['registration']['email_regis'])."'";
$number = $pdo->query($sql)->fetchColumn();

$sql = "SELECT * FROM membersbase WHERE email_corresp LIKE '".$email_user."' AND active = '1'";
$row = $pdo->query($sql)->fetch();

//le fichier suivant ne contient que du html
require('headermysql.php');

/************************************************************************/
if (isset($_SESSION['action'])) {
	$_POST['action'] = $_SESSION['action'];
	unset($_SESSION['action']);
}
/************************************************************************/
if (isset($_POST['action'])) {
	switch ($_POST['action']) {

		case "Login":
			require('check_user.php');
			break;

		case "Registration":
			require('form_registration.php');
			break;

		case "Validation":
			require('validation_inscription.php');
			if (isset($_SESSION['message'])) {
				// Redirect
				$_SESSION['action'] = "Registration";
				header("Location: ".$_SERVER['PHP_SELF']);
				exit;
			} else {

				// Success
			}
			break;

		case "Password_forgotten":
			echo "<form method='post'>";
			echo "Email: <input type='text' name='email' /><br />";
			echo "<input type='submit' name='action' value='Renew_password' /><br />";
			echo "</form>";
			break;

		case "Renew_password":
			require('renew_password.php');
			break;

		default:
			// Print & delete messages
			if (isset($_SESSION['message'])) {
				echo $_SESSION['message']."<br />";
				unset($_SESSION['message']);
			}

			break;
	}
}

/********************************************************************************************************/
if (isset($_SESSION['user']['user'])) {

	// Authorized visitor
	//include('member/page_authorized_visitor.php');
	include("membre/fichier-de-destination.php");
	
} else {

	// Unauthorized visitor
	require('login.php');
	//include('page_unauthorized_visitor.php');
	include('login_failed.php');

}

//le fichier suivant ne contient que du html	
require('footermysql.php');
?>

$sql = "SELECT * FROM membersbase WHERE user LIKE '".trim($_POST['user'])."' AND active = '1'";
$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

SELECT * FROM membersbase WHERE user LIKE '.trim($_POST["user"]).' AND active = '1'

$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbbb";
$url = "cccccc";
$v_web_name = "dddd";
/**********************************************/

$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';

try {
   $connexion =new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd .';charset=utf8',$PARAM_utilisateur, $PARAM_mot_passe);
  // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}

<?php
/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbbb";
$url = "cccccc";
$v_web_name = "dddd";
/**********************************************/

$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';

try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
   // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}
// Fichier D:\fichier-de-depart.php

// pour tester.. on va regarder si le fichier existe
$fileSecurite = "securite.php";
if(!file_exists($fileSecurite)){
  echo ' Fichier ' . $fileSecurite . ' manquant ou mal ortographié !!';
  exit;}
//require_once __DIR __ . "/securite.php";

//le fichier suivant est codé Html5
require('headermysql.php');

/************************************************************************/
if (isset($_SESSION['action'])) {
	$_POST['action'] = $_SESSION['action'];
	unset($_SESSION['action']);
}
/************************************************************************/
if (isset($_POST['action'])) {
	switch ($_POST['action']) {

		case "Login":
			require('check_user.php');
			break;
			
//added new
	case "Logout":
		unset($_SESSION['user']);
		header("Location: ".$_SERVER['PHP_SELF']);
		exit;

	case "Save_new_email":
		require('save_new_email.php');
		break;

	case "Save_new_password":
		require('save_new_password.php');
		break;	
//added end

		case "Registration":
			require('form_registration.php');
			break;

		case "Validation":
			require('validation_inscription.php');
			if (isset($_SESSION['message'])) {
				// Redirect
				$_SESSION['action'] = "Registration";
				header("Location: ".$_SERVER['PHP_SELF']);
				exit;
			} else {

				// Success
			}
			break;

		case "Password_forgotten":
			echo "<form method='post'>";
			echo "Email: <input type='text' name='email' /><br />";
			echo "<input type='submit' name='action' value='Renew_password' /><br />";
			echo "</form>";
			break;

		case "Renew_password":
			require('renew_password.php');
			break;

		default:
			// Print & delete messages
			if (isset($_SESSION['message'])) {
				echo $_SESSION['message']."<br />";
				unset($_SESSION['message']);
			}

			break;
	}
}

/********************************************************************************************************/
if (isset($_SESSION['user']['user'])) {

	// Authorized visitor
	//include('page_authorized_visitor.php');
	include("membre/fichier-de-destination.php");
	
} else {

	// Unauthorized visitor
	require('login.php');
	//include('page_unauthorized_visitor.php');
	include('login_failed.php');

}

//le fichier suivant n'est que du html5
	
require('footermysql.php');
?>

<?php	
// Search email
$email_user = trim(strtolower($_POST['email']));

$sql = "SELECT * FROM membersbase WHERE email_corresp LIKE '".$email_user."' AND active = '1'";
$row = $pdo->query($sql)->fetch();
if ($row) {

	// Create & save code
	$code = uniqid();
	$sql = "UPDATE membersbase SET code = '".$code."' WHERE Rk_members = '".$row['Rk_members']."'";
	$save = $pdo->query($sql);

	// Email for reset password
	$from = $v_editor_name." <".$v_editor_email.">";
	$subject = "Reset password";
	$url_reset_password = $v_url."/reset_password.php?code=".$code;

	$headers = "Mime-Version: 1.0\r\n";
	$headers .= "Content-type: text/html; charset=UTF-8\r\n";
	$headers .= "Content-Transfer-Encoding: 7bit\r\n";
	$headers .= "From: ".$from;

	$text = "Hello ".$row['first_name']." ".$row['last_name']."<br><br>";
	$text .= "To reset your password, you must click on following link, thank you.<br><br>";
	$text .= "<a href='".$url_reset_password."'>Reset password</a><br><br>";
	$text .= "Best regards<br>";
	$text .= $from;

	mail($email_user, $subject, $text, $headers);

	echo "Sent Email to $email_user";

	// Redirect
	//header("Location: ".$_SERVER['PHP_SELF']);
	//exit;

} else {

	// Email not exists
	echo "Email $email_user does not exist or is not active";

	// Redirect
	//header("Location: ".$_SERVER['PHP_SELF']);
	//exit;

}
?>

<?php

// Start session
// Receive request from to reset password
// Receive GET code
session_start();
	error_reporting(E_ALL);
    $PARAM_hote = 'localhost';
	$PARAM_port = '3306';
	$PARAM_nom_bd = 'nomdemabase';
	$PARAM_utilisateur = 'root';
	$PARAM_mot_passe = '';
	// Start session
    try {
        $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(
	PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    } catch (Exception $e) {
        echo 'Erreur : ' . $e->getMessage() . '<br />';
        echo 'N° : ' . $e->getCode();
    }
	// Header seulemnt html5
	require('headermysql.php');

if ($_POST['action'] == "validation") {

	if (strlen($_POST['new_password']) < 7 || strlen($_POST['new_password'] > 16)) {
		echo "<p>Invalid length password (7-16)</p>";

	} else {

		// New password is valid
		$new_password = password_hash(trim($_POST['new_password']), PASSWORD_DEFAULT);
		$sql = "UPDATE membersbase SET password = '".$new_password."', code = '' WHERE code = '".$_POST['code']."'";
		$pdo->query($sql);

		$_SESSION['message'] = "<p>Success! Password changed</p>";
		// erreur probable due à $v_url qu'il faudrait changer en "localhost" ou "killidatamysql" à header("Location: ".$v_url);
		header("Location: ".$v_url);
		exit;
		
	}


} else {

	$sql = "SELECT * FROM membersbase WHERE code = '".$_GET['code']."'";
	//erreur code pour $row = $pdo->query($sql)->fetch();
	$row = $pdo->query($sql)->fetch();

	if ($row) {

		// Exists code
		//probable error for if ($row['active'] == 1) {
		if ($row['active'] == 2) {

			// Active
			?>
			<form method="post">

			<input type="hidden" name="code" value="<?php echo $_GET['code']; ?>">

			<div class="input-group">
				<div class="input-group-prepend">
		    		<span class="input-group-text">New Password</span>
				</div>
				<input type="text" placeholder="8-12 Characters" class="form-control col-4" name="new_password">
			</div>

			<br>
			<button type="submit" name="action" value="validation" class="btn btn-primary centro">Submit</button>
			<br>

			</form>
			<?php

		} else {
			
			// Not active
			echo "<p>Member not active</p>";

		}

	} else {

		// Incorrect code
		echo "<p>Incorrect code received</p>";

	}

}

// Footer
//require('footermysql.php');
?>

<?php
$new_email = strtolower(trim($_POST['new_email']));

// Check if e-mail is valid
if (filter_var($new_email, FILTER_VALIDATE_EMAIL)) {

	// Check not repeated
	$sql = "SELECT COUNT(1) FROM membersbase WHERE email_corresp = '".$new_email."'";
	$number = $pdo->query($sql)->fetchColumn();

	if ($number < 1) {

		$sql = "UPDATE membersbase SET email_corresp = '".$new_email."' WHERE Rk_members = '".$_SESSION['user']['Rk_members']."'";
		$pdo->query($sql);

		echo "New email ".$new_email." recorded";

	} else {

		echo "Email ".$new_email." Email already used";

	}

} else {

	echo "Email ".$new_email." invalid";

}
?>

<?php
$new_password = trim($_POST['new_password']);

// Check length
if (strlen($new_password) >= 7 && strlen($new_password) <= 16) {

	$new_password = password_hash($new_password, PASSWORD_DEFAULT);

	$sql = "UPDATE membersbase SET password = '".$new_password."' WHERE Rk_members = '".$_SESSION['user']['Rk_members']."'";
	$pdo->query($sql);

	echo "New password recorded";

} else {

	echo "New password is invalid. Its length must be between 7 and 16 characters";

}
?>

<?php
//***********Configuration*****************/
// Log navigation for authorized_visitor
$file_log_navigation = "log_authorized_visitor.txt";

// Page for unauthorized_visitor
//$page_no_login = "page_unauthorized_visitor.php";
$page_no_login = "login_failed.php";

/* On all pages only for authorized_visitor in subdirectory membre:
<?php require("securite.php"); ?>
*/

//*****************************************/
//session_start();

if (isset($_SESSION['member'])) {

	// Navigation log

	// 2020-12-31 23:59:59	217.56.78.123	Internet Explorer	127	Manuel López (Spain)	xxxx_yyyy.php
	
	$register = $date('Y-m-d H:m:s')."\t";
	$register .= $_SERVER['REMOTE_ADDR']."\t";
	$register .= $_SERVER['HTTP_USER_AGENT']."\t";
	$register .= $_SESSION['user']['Rk_members']."\t";
	$register .= $_SESSION['user']['first_name']." ";
	$register .= $_SESSION['user']['last_name']." (";
	$register .= $_SESSION['user']['country'].")\t";
	$register .= __FILE__;
	
	file_put_contents($file_log_navigation, $register, FILE_APPEND);

} else {
	
	// No login
	// header('Location: '$page_no_login);
	header('Location: '.$page_no_login);
	exit;
}

session_destroy();
?>

<?php

// Trim all values and save in session
foreach ($_POST['registration'] as $variable => $value) {
	$_SESSION['registration'][$variable] = trim($value);
}

// First Name
if (strlen($_SESSION['registration']['first_name']) < 2) {
	$_SESSION['message'] = "First Name too short<br>";
}

// Last Name
if (strlen($_SESSION['registration']['last_name']) < 2) {
	$_SESSION['message'] .= "Last Name too short<br>";
}

// check E-mail for registration
if (!filter_var($_SESSION['registration']['email_regis'], FILTER_VALIDATE_EMAIL)) {
	$_SESSION['message'] .= "Invalid registration e-mail<br>";
}

// E-mail for registration already used
$sql = "SELECT COUNT(1) FROM membersbase WHERE email_regis LIKE '".strtolower($_SESSION['registration']['email_regis'])."'";
$number = $pdo->query($sql)->fetchColumn();
if ($number == 1) {
	$_SESSION['message'] .= "E-mail registration already used<br>";
}

// check E-mail for corespondence
if (!filter_var($_SESSION['registration']['email_corresp'], FILTER_VALIDATE_EMAIL)) {
	$_SESSION['message'] .= "Invalid correspondence e-mail<br>";
}

// E-mail for correspondence already used
$sql = "SELECT COUNT(1) FROM membersbase WHERE email_corresp LIKE '".strtolower($_SESSION['registration']['email_corresp'])."'";
$number = $pdo->query($sql)->fetchColumn();
if ($number == 1) {
	$_SESSION['message'] .= "E-mail for correspondence already used<br>";
}

// Username = ID
if (strlen($_SESSION['registration']['user']) < 5 || strlen($_SESSION['registration']['user'] > 20)) {
	$_SESSION['message'] .= "Invalid length user (5-20)<br>";
}

// Username (ID) already used
$sql = "SELECT COUNT(1) FROM membersbase WHERE user LIKE '".$_SESSION['registration']['user']."'";
$number = $pdo->query($sql)->fetchColumn();
if ($number == 1) {
	$_SESSION['message'] .= "Username (ID) already selected, please choose another ID<br>";
}

// check if useful to harmonize min-max lengths of ID and PW like Invalid length for password (7 characters or more, up to 15 characters)
if (strlen($_SESSION['registration']['password']) < 7 || strlen($_SESSION['registration']['password'] > 16)) {
	$_SESSION['message'] .= "Invalid length for password (7 characters or more, up to 15 characters)<br>";
}

if ($_SESSION['registration']['day_birthday'] == "--"
	|| $_SESSION['registration']['month_birthday'] == "--"
	|| $_SESSION['registration']['year_birthday'] == "--" ) {
		$_SESSION['message'] .= "Invalid Date of Birthday<br>";
}

if ($_SESSION['registration']['country'] == "--") {
	$_SESSION['message'] .= "Country not selected<br>";
}

if (strlen($_SESSION['registration']['address']) < 20) {
	$_SESSION['message'] .= "Postal Address too short<br>";
}

if (strlen($_SESSION['registration']['profile']) < 20) {
	$_SESSION['message'] .= "Profile too short<br>";
}

if (strlen($_SESSION['registration']['motivations']) < 5) {
	$_SESSION['message'] .= "Motivations too short<br>";
}

// new item; publicized profile or not
if ($_SESSION['registration']['confirmation'] == "--") {
	$_SESSION['message'] .= "Online presentation of profile not selected<br>";
}

// if ($_SESSION['registration']['type_of_activity'] == "--") {
if ($_SESSION['registration']['type_of_activity'] == "--") {
	$_SESSION['message'] .= "Type of activity not selected<br>";
}

if (!isset($_SESSION['message'])) {

	//$_SESSION['registration']['code'] = uniqid();
	$password = password_hash($_SESSION['registration']['password'], PASSWORD_DEFAULT);
	$birthday = $_SESSION['registration']['year_birthday']."-".$_SESSION['registration']['month_birthday']."-".$_SESSION['registration']['day_birthday'];

// check if active is 0 or 1 by default
	$sql = "INSERT INTO membersbase SET
				active = '1',
				first_name = '".$_SESSION['registration']['first_name']."',
				last_name = '".$_SESSION['registration']['last_name']."',
				email_regis = '".strtolower($_SESSION['registration']['email_regis'])."',
				email_corresp = '".strtolower($_SESSION['registration']['email_corresp'])."',
				user = '".$_SESSION['registration']['user']."',
				password = '".$password."',
				birthday_date = '".$birthday."',
				country = '".$_SESSION['registration']['country']."',
				full_present_postal_address = '".$_SESSION['registration']['address']."',
				profile = '".$_SESSION['registration']['profile']."',
				motivations = '".$_SESSION['registration']['motivations']."',
				confirmation = '".$_SESSION['registration']['news']."',
				type_of_activity = '".$_SESSION['registration']['activity']."',
				type = 'standard',
				datetime_registration = NOW(),
				ip_registration = '".$_SERVER['REMOTE_ADDR']."'";
	$pdo->query($sql);

	// Message OK
	echo "<p>You have been pre-registered.<br>";
	echo "We shall send you an acceptance or non-acceptance e-mail to ".strtolower($_SESSION['registration']['email_corresp'])."<br>";
	echo "If within a few days you do not receive that e-mail, check your spam folder.</p>";

	// Send email to admin team
	$from = $v_editor_name." <".$v_editor_email.">";
	$subject = "New Inscription in ".$v_web_name;
	$to = $v_editor_name." <".$v_editor_email.">";
	
	$headers = "Mime-Version: 1.0\r\n";
	$headers .= "Content-type: text/html; charset=UTF-8\r\n";
	$headers .= "Content-Transfer-Encoding: 7bit\r\n";
	$headers .= "From: ".$from."\r\n";

	$text = "First name: ".$_SESSION['registration']['first_name']."<br>";
	$text .= "Last name: ".$_SESSION['registration']['last_name']."<br>";
	$text .= "Email regis: ".strtolower($_SESSION['registration']['email_regis'])."<br>";	
	$text .= "Email corresp: ".strtolower($_SESSION['registration']['email_corresp'])."<br>";
	$text .= "User: ".$_SESSION['registration']['user']."<br>";
	$text .= "Password: ".$_SESSION['registration']['password']."<br>";
	$text .= "Birthday: ".$birthday."<br>";
	$text .= "Country: ".$_SESSION['registration']['country']."<br>";
	$text .= "Postal_address: ".$_SESSION['registration']['address']."<br>";
	$text .= "Profile: ".$_SESSION['registration']['address']."<br>";	
	$text .= "Motivations: ".$_SESSION['registration']['motivations']."<br>";
	$text .= "Confirmation: ".$_SESSION['registration']['news']."<br>";
	$text .= "Type of activity: ".$_SESSION['registration']['activity']."<br>";

	mail($to, $subject, $text, $headers);

	// Delete data users
	unset($_SESSION['registration']);
	unset($_SESSION['message']);
	
}
?>

<?php

// Check user & password
$sql = "SELECT * FROM membersbase WHERE user LIKE '".trim($_POST['user'])."' AND active = '1'";
$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);
if ($row) {

	// Exists user and is active (1)
	// Check password
	if (password_verify($_POST['password'], $row['password'])) {

		// Password correct -> // Store data in session
		foreach ($row as $col => $value) {
			$_SESSION['user'][$col] = $value;
		}

		// Access log
		$file_log_access = "log_authorized_visitor.txt";

		// 2020-12-31 23:59:59	217.56.78.123	Internet Explorer	127	Manuel López (Spain)

		$register = date('Y-m-d H:m:s')."\t";
		$register .= $_SERVER['REMOTE_ADDR']."\t";
		$register .= $_SERVER['HTTP_USER_AGENT']."\t";
		$register .= $_SESSION['user']['Rk_members']."\t";
		$register .= $_SESSION['user']['first_name']." ";
		$register .= $_SESSION['user']['last_name']." (";
		$register .= $_SESSION['user']['country'].")";

		file_put_contents($file_log_access, $register, FILE_APPEND);

		header("Location: ".$_SERVER['PHP_SELF']);		
		exit;	

	} else {

		// User and password incorrect
		echo "Password is incorrect";

	}

}else{

	// User & password incorrect
	echo "User does not exists or user is not active";

}
?>

<?php

// Start session
// Receive request to accept conditions
// Receive GET code
session_start();
	error_reporting(E_ALL);
$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';
	// Start session
    try {
        $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(
	PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    } catch (Exception $e) {
        echo 'Erreur : ' . $e->getMessage() . '<br />';
        echo 'N° : ' . $e->getCode();
    }
	// Header, slt html5
	require('headermysql.php');

if ($_POST['accept'] == "Sign") {

	if ($_POST['condition1'] == '1' && $_POST['condition2'] == '1' && $_POST['condition3'] == '1') {

		$sql = "UPDATE membersbase SET active = '1', code = '' WHERE code = '".$_POST['code']."'";
		$pdo->query($sql);

		$_SESSION['message'] = "<p>Your application for membership is complete. We will reply shortly</p>";
		header("Location: ".$v_url);
		exit;

	} else {

		// Not accepted all conditions
		echo "<p>You have not accepted all required conditions</p>";

	}

} else {

	// Enter first

	$sql = "SELECT * FROM membersbase WHERE code = '".$_GET['code']."'";
	//erreur code pour $row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);
	$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

	if ($row) {

		switch ($row['active']) {

			case '1':
				// is not it '0'?
				// Already active wait confirm
				echo "<p>User waiting for admin staff confirmation… Welcome. You will be an active new member, once security issues are solved by admin staff… if you do not receive an e-mail with warning of a possible problem, it usually takes less than 24 hours to activate your account (please try to enter with ID and PW after that, of if not successful, be more patient !</p>";
				break;

			case '2':
				// is not it '1'?
				// Already active
				echo "<p>User active</p>";
				break;				
			
			default:
				require('form_conditions.php');
				break;
		}

	} else {

		// Incorrect code
		echo "<p>Invalid code received</p>";

	}

}

// le fichier suivant est seulement html5
//require('footermysql.php');
?>

<?php

session_start();

// Delete action
unset($_SESSION['action']);

// Asign values
if(!isset($_SESSION['registration']['first_name'])) $_SESSION['registration']['first_name'] = ""; 
if(!isset($_SESSION['registration']['last_name'])) $_SESSION['registration']['last_name'] = ""; 
if(!isset($_SESSION['registration']['email_regis'])) $_SESSION['registration']['email_regis'] = ""; 
if(!isset($_SESSION['registration']['email_corresp'])) $_SESSION['registration']['email_corresp'] = ""; 
if(!isset($_SESSION['registration']['user'])) $_SESSION['registration']['user'] = ""; 
if(!isset($_SESSION['registration']['password'])) $_SESSION['registration']['password'] = ""; 
if(!isset($_SESSION['registration']['day_birthday'])) $_SESSION['registration']['day_birthday'] = "";
if(!isset($_SESSION['registration']['month_birthday'])) $_SESSION['registration']['month_birthday'] = "";
if(!isset($_SESSION['registration']['year_birthday'])) $_SESSION['registration']['year_birthday'] = "";
if(!isset($_SESSION['registration']['country'])) $_SESSION['registration']['country'] = "";
if(!isset($_SESSION['registration']['full_present_postal_address'])) $_SESSION['registration']['full_present_postal_address'] = "";
if(!isset($_SESSION['registration']['profile'])) $_SESSION['registration']['profile'] = "";
if(!isset($_SESSION['registration']['motivations'])) $_SESSION['registration']['motivations'] = "";
if(!isset($_SESSION['registration']['activity'])) $_SESSION['registration']['activity'] = "";

// Print messages
if (isset($_SESSION['message'])) {
	echo "<p>".$_SESSION['message']."</p>";
	unset($_SESSION['message']);
}
?>

<form method="post">

<br>
<h3>Registration Form</h3>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">First name (only usual name in daily practice) (if suitable or important, please state full list afterwards between brackets)</span>
		</div>
		<input type="text" placeholder="Minimum 2 characters" class="form-control col-4" name="registration[first_name]" value="<?php echo $_SESSION['registration']['first_name'] ?>">
	</div>

	<div class="input-group">		
		<div class="input-group-prepend">
    		<span class="input-group-text">Last name (only usual name in daily practice) (if suitable or important, please state full list afterwards between brackets)</span>
		</div>
		<input type="text" placeholder="Minimum 2 characters" class="form-control col-4" name="registration[last_name]" value="<?php echo $_SESSION['registration']['last_name'] ?>">
	</div>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">E-mail for registration (preferably with name included in it, and, for professionals, it must be your official institutional address)</span>
		</div>
		<input type="text" placeholder="Email address" class="form-control col-4" name="registration[email_regis]" value="<?php echo $_SESSION['registration']['email_regis'] ?>">
	</div>
	
	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">E-mail for correspondence (notably for professionals, if distinct from institutional), otherwise just copy herein Email for registration</span>
		</div>
		<input type="text" placeholder="Email address" class="form-control col-4" name="registration[email_corresp]" value="<?php echo $_SESSION['registration']['email_corresp'] ?>">
	</div>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">Username (=ID) (a username with name then possibly initials is preferred, but not compulsory… beware, this cannot be changed afterwards)</span>
		</div>
		<input type="text" placeholder="5-20 Letters" class="form-control col-4" name="registration[user]" value="<?php echo $_SESSION['registration']['user'] ?>">
	</div>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">Password (=PW) (upper and lower case are different) (this can be changed afterwards, any time, if 7 characters or more)</span>
		</div>
		<input type="password" placeholder="7-16 Characters" class="form-control col-4" name="registration[password]" value="<?php echo $_SESSION['registration']['password'] ?>">
	</div>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">Date of birth (if confidential, mark only the actual year, plus month as 'January' and day as '01', then in practice it will become 1989-01-01)</span>
		</div>
		<select class="form-control col-2" name="registration[day_birthday]">
			<option value="--">--Day--</option>
			<?php for ($i=1; $i<=31; $i++) {
					echo '<option value="'.$i.'" ';
					if ($_SESSION['registration']['day_birthday'] == $i) echo 'selected';
					echo '>'.$i.'</option>';
			} ?>
		</select>
		<select class="form-control col-2" name="registration[month_birthday]">
			<?php $array_months = array('','January','February','March','April','May','June','July','August','September','October','November','December'); ?>
			<option value="--">--Month--</option>
			<?php for ($i=1; $i<=12; $i++) {
					echo '<option value="'.$i.'" ';
					if ($_SESSION['registration']['month_birthday'] == $i) echo 'selected';
					echo '>'.$array_months[$i].'</option>';
			} ?>
		</select>
		<select class="form-control col-2" name="registration[year_birthday]">
			<option value="--">--Year--</option>
			<?php for ($i=1920; $i<=date('Y'); $i++) {
					echo '<option value="'.$i.'" ';
					if ($_SESSION['registration']['year_birthday'] == $i) echo 'selected';
					echo '>'.$i.'</option>';
			} ?>
		</select>
	</div>

	<div class="input-group">
		<div class="input-group-prepend">
    		<span class="input-group-text">Country of Origin (NOT Country of Residence) (name in English)</span>
		</div>
		<select class="form-control col-5" name="registration[country]">
			<option value="--">--Country--</option>
			<?php
				//$sql = "SELECT country_full_english FROM countryform WHERE active = 1 ORDER BY country_full_english";
				$sql = "SELECT country_full_english FROM countryform ORDER BY country_full_english";
				$rows = $pdo->query($sql);
				foreach ($rows as $row) {
					echo '<option value="'.$row['country_full_english'].'" ';
					if ($_SESSION['registration']['country'] == $row['country_full_english']) echo 'selected';
					echo '>'.$row['country_full_english'].'</option>';
				}
			?>
		</select>
	</div>
	
	
// etc.

	<br>
	<h6 class="text-center bg-warning text-dark">All fields are required</h6>
	<button type="submit" name="action" value="Validation" class="btn btn-primary centro">Submit</button>
	<br>
</form>

<?php
/*
 * Fichier cnxBdd.php
 * Permet la connexion à la bdd.
 * Fichie à inclure ( require_once) dans les pages devant effectuer des requêtes SQL PDO.
 */

$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'nomdemabase';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';

try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd . ';charset=utf8', $PARAM_utilisateur, $PARAM_mot_passe);
  // Activation des erreurs PDO
  $connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $connexion->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
  echo 'Erreur : ' . $e->getMessage() . '<br />';
  echo 'N° : ' . $e->getCode();
}
?> 

<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of user
 *
 * @author jreynet
 */
class user {

  //put your code here
  private $bdd = null;

  function __construct($connexion) {
    $this->bdd = $connexion;
  }

  public function getUserByMail($email_user) {
    $sql = "SELECT * FROM membersbase WHERE email_corresp = :email_user AND active = '1'";
    $datas = [':email_user' => $email_user];

    //Execution de la requete
    try {
      $requete = $this->bdd->prepare($sql);
      $requete->execute($datas);
      return $requete->fetch();
    } catch (Exception $e) {
      // en cas d'erreur :
      echo " Erreur ! " . $e->getMessage();
      echo " Les datas : ";
      print_r($datas);
    }
  }
  
  
  public function getUserByCode($code){
    $sql = "SELECT * FROM membersbase WHERE code = :code";
	$datas = [':code'=>$code];
     //Execution de la requete
    try {
      $requete = $this->bdd->prepare($sql);
      $requete->execute($datas);
      return $requete->fetch();
    } catch (Exception $e) {
      // en cas d'erreur :
      echo " Erreur ! " . $e->getMessage();
      echo " Les datas : ";
      print_r($datas);
    }
  }

  public function setUserCode($Rk_members, $code) {
    $sql = "UPDATE membersbase SET code = :code WHERE Rk_members = :Rk_members";
    $datas = [':code' => $code, ':Rk_members' => $Rk_members];
    //Execution de la requete
    try {
      $requete = $this->bdd->prepare($sql);
      $requete->execute($datas);
    } catch (Exception $e) {
      // en cas d'erreur :
      echo " Erreur ! " . $e->getMessage();
      echo " Les datas : ";
      print_r($datas);
    }
  }

  public function reset_password($password, $code) {
    if (!empty($code)) {
      $min = 7;
      $max = 16;
      return strlen($password) < 7 || strlen($password) > 16 ? "<p>Invalid length password (" . $min . " - " . $max . ")</p>" : false;

      $new_password = password_hash(trim($password), PASSWORD_DEFAULT);
      $sql = "UPDATE membersbase SET password = :new_password, code = '' WHERE code = :code";
      $datas = [':new_password' => $new_password, ':code' => $code];

      //Execution de la requete
      try {
        $requete = $this->bdd->prepare($sql);
        $requete->execute($datas);
      } catch (Exception $e) {
        // en cas d'erreur :
        echo " Erreur ! " . $e->getMessage();
        echo " Les datas : ";
        print_r($datas);
      }
    }
  }

  public function renew_password($email_user) {
    /******************Config***********************/
    $v_editor_name = "aaaaa";
    $v_editor_email = "bbbbbb";
    $v_url = "cccccc";
   
    $user = $this->getUserByMail($email_user);
    if (!empty($user)) {

      $Rk_members = $user['Rk_members'];
      $code = uniqid();
      //on met à jour le code
      $this->setUserCode($Rk_members, $code);

      // Email for reset password
      $from = $v_editor_name . " <" . $v_editor_email . ">";
      $subject = "Reset password";
      $url_reset_password = $v_url . "/reset_password.php?code=" . $code;

      $headers = "Mime-Version: 1.0\r\n";
      $headers .= "Content-type: text/html; charset=UTF-8\r\n";
      $headers .= "Content-Transfer-Encoding: 7bit\r\n";
      $headers .= "From: " . $from;

      $text = "Hello " . $user['first_name'] . " " . $user['last_name'] . "<br><br>";
      $text .= "To reset your password, you must click on following link, thank you.<br><br>";
      $text .= "<a href='" . $url_reset_password . "'>Reset password</a><br><br>";
      $text .= "Best regards<br>";
      $text .= $from;

      if(!mail($email_user, $subject, $text, $headers)){
        return " Erreur lors de l'envoi du mail !! ";
      }

      return  "Sent Email to $email_user";
    }else{
      return "Email $email_user does not exist or is not active";
    }
  }
  
  
  public function save_new_email($Rk_members,$new_email){
    $sql = "UPDATE membersbase 
            SET email_corresp = :new_email
           WHERE Rk_members = :Rk_members";
    
	$datas = [':new_email' => $new_email, ':Rk_members' => $Rk_members];

      //Execution de la requete
      try {
        $requete = $this->bdd->prepare($sql);
        $requete->execute($datas);
      } catch (Exception $e) {
        // en cas d'erreur :
        echo " Erreur ! " . $e->getMessage();
        echo " Les datas : ";
        print_r($datas);
      }	
  }
  
  
  public function getUserByUserName($userName){
     $sql = "SELECT * 
       FROM membersbase 
       WHERE user = :userName 
       AND active = '1'";
     
	$datas = [':userName'=>$userName];
     //Execution de la requete
    try {
      $requete = $this->bdd->prepare($sql);
      $requete->execute($datas);
      return $requete->fetch();
    } catch (Exception $e) {
      // en cas d'erreur :
      echo " Erreur ! " . $e->getMessage();
      echo " Les datas : ";
      print_r($datas);
    }
  }


  public function login($userName,$password){
    $user = $this->getUserByUserName($userName);
    if(!empty($user)){
      $pass = $user['password'];
      if(!password_verify($password, $pass)){
        return "Password is incorrect";
      }else{
        return $user;
      }
    }else{
      return "User does not exists or user is not active";
    }
    
  }

  // FIN DE LA CLASS
}

<<?php
//Démarrage des sessions
session_start();

//Affichage des erreurs PHP
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

//on inclus le fichier de connexion à la bdd et la class user
require_once "cnxBdd.php";
require_once "user.class.php";
//on instancie la class user, avec, en paramètre, la variable de connexion à la bdd
$oUser = new user($connexion);



//On traite le formulaire si il a été submit
if ($_POST['action'] == "validation") {
  //Récupération PROPRE des variables AVANT de les utiliser
  $post_password = !empty($_POST['password']) ? trim($_POST['password']) : NULL;
  $code = !empty($_POST['code']) ? $_POST['code'] : NULL;

  $oUser->reset_password($post_password, $post_code);
} else {

//Récupération PROPRE des variables AVANT de les utiliser
  $code = !empty($_GET['code']) ? trim($_GET['code']) : NULL;
}
//On récupère le user en fonction du code
$row = $oUser->getUserByCode($code);

// Header seulemnt html5
require_once 'headermysql.php';


if ($row) {

  // Exists code
  //probable error for if ($row['active'] == 1) {
  if ($row['active'] == 2) {

    // Active
    ?>
    <form method="post" action="">
      <input type="hidden" name="code" value="<?php echo $code; ?>">
      <div class="input-group">
        <div class="input-group-prepend">
          <span class="input-group-text">New Password</span>
        </div>
        <input type="text" placeholder="8-12 Characters" class="form-control col-4" name="new_password" value="<?php echo $post_password; ?>">
      </div>
      <br>
      <button type="submit" name="action" value="validation" class="btn btn-primary centro">Submit</button>
      <br>

    </form>
    <?php
  } else {
    // Not active
    echo "<p>Member not active</p>";
  }
} else {
// Incorrect code
  echo "<p>Incorrect code received</p>";
}

<?php


//--------------------------------------------------------------------------------------------------//
//
// TOUTE LA PARTIE session_start,  require_once ...  new user() ..
// n'est pas necessaire si cette page est incluse (require..) depuis ta page depart
// Par contre, si c'est bien une page à part ouverte, par exemple par : http://tonsite.fr/check_user.php  ... il faut le mettre
//
//--------------------------------------------------------------------------------------------------//
//Démarrage des sessions
session_start();

//Affichage des erreurs PHP
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);

//on inclus le fichier de connexion à la bdd et la class user
require_once "cnxBdd.php";
require_once "user.class.php";
//on instancie la class user, avec, en paramètre, la variable de connexion à la bdd
$oUser = new user($connexion);

//--------------------------------------------------------------------------------------------------//

//Récupération PROPRE des variables AVANT de les utiliser
$userName = !empty($_POST['user']) ? $_POST['user'] : NULL;
$password = !empty($_POST['password']) ? $_POST['password'] : NULL;

$row = $oUser->login($userName, $password);

//si la connexion n'est pas bonne.. affichage du message d'erreur
if (is_string($row)) {
  echo $user;
} else {
  //ici on créé les variables de session
  // Password correct -> // Store data in session
  foreach ($row as $col => $value) {
    $_SESSION['user'][$col] = $value;
  }

  // Access log
  $file_log_access = "log_authorized_visitor.txt";

  // 2020-12-31 23:59:59	217.56.78.123	Internet Explorer	127	Manuel López (Spain)

  $register = date('Y-m-d H:m:s') . "\t";
  $register .= $_SERVER['REMOTE_ADDR'] . "\t";
  $register .= $_SERVER['HTTP_USER_AGENT'] . "\t";
  $register .= $_SESSION['user']['Rk_members'] . "\t";
  $register .= $_SESSION['user']['first_name'] . " ";
  $register .= $_SESSION['user']['last_name'] . " (";
  $register .= $_SESSION['user']['country'] . ")";

  file_put_contents($file_log_access, $register, FILE_APPEND);

  header("Location: " . $_SERVER['PHP_SELF']);
  exit;
}

header('Location: '.$page_no_login);
header("Location : login_failed.php");
header("Location: $page_no_login");

$toto = "jh_kd";
echo "Bonjour jh_kd";  // Affichera Bonjour jh_kd
echo "Bonjour $toto"; // Affichera Bonjour jh_kd
echo 'Bonjour ' . $toto; // Affichera Bonjour jh_kd
echo 'Bonjour $toto'; // Affichera Bonjour $toto

if (isset($_SESSION['member'])) {

} else {
	// Si l'utilisateur n'est pas connecté... il est redirigé  vers la page  No login
	header('Location: '.$page_no_login);
	exit;
}

/************************************************************************/
if (isset($_SESSION['action'])) {
 $_POST['action'] = $_SESSION['action'];
 unset($_SESSION['action']);
}
/************************************************************************/
if (isset($_POST['action'])) {
 switch ($_POST['action']) {

  case

default:
   // Print & delete messages
   if (isset($_SESSION['message'])) {
    echo $_SESSION['message']."<br />";
    unset($_SESSION['message']);
   }

   break;
 }
}

/********************************************************************************************************/
if (isset($_SESSION['user']['user'])) {

<h3>Login processes</h3>

<form class="dropdown-menu dropdown-menu-right p-4" method="post">

 <div class="form-group">
     <label for="exampleDropdownFormEmail2">User (ID)</label>
     <input type="text" name="user" class="form-control" id="exampleDropdownFormEmail2" placeholder="e.g., Smith4925">
 </div>

 <div class="form-group">
     <label for="exampleDropdownFormEmail2">Password (PW)</label>
     <input type="password" name="password" class="form-control" id="exampleDropdownFormEmail2" placeholder="e.g., 11GreatKD20">
 </div>

 <button type="submit" name="action" value="Login" class="btn btn-primary">Sign in</button>

 <br><br>

 <div class="dropdown-divider"></div>
 New around here ? <button type="submit" name="action" value="Registration" class="btn btn-primary">Sign up</button>
 <div class="dropdown-divider"></div>
 Forgot password ? <button type="submit" name="action" value="Password_forgotten" class="btn btn-primary">Reset PW</button>

</form>

$page_login = "login.php";

else {
 
 // No login
 header('Location: '.$page_login);
 //header('Location: '.$page_no_login);
 // header("Location : login_failed.php");
 //header("Location:$page_no_login");
 exit;

file_put_contents($file_log_access, $register, FILE_APPEND);

$row = $pdo->query($sql)->fetch(PDO::FETCH_ASSOC);

<?php
    $sql = "SELECT country_full_english FROM countryform ORDER BY country_full_english";
    $rows = $pdo->query($sql);
    foreach ($rows as $row) {
     echo '<option value="'.$row['country_full_english'].'" ';
     if ($_SESSION['registration']['country'] == $row['country_full_english']) echo 'selected';
     echo '>'.$row['country_full_english'].'</option>';
    }
   ?>

$number = $pdo->query($sql)->fetchColumn();

$row = $pdo->query($sql)->fetch();

$row = $pdo->query($sql)->fetch();

try{
  $sth = $dbh->prepare($sql);
  $sth->execute();
  $row = $sth->fetch();
}catch(Exception $e){
  echo "ERREUR dans la requête <br>".$sql;
  echo "<br> ". $e->getMessage();
}

/******************Config***********************/
$v_editor_name = "aaaaa";
$v_editor_email = "bbbbb";
$url = "cccccc";
$v_web_name = "dddddd";
/**********************************************/
session_start();
error_reporting(E_ALL);
require ("connexionBDD.php");

try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
   // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
 $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}

<?php
$PARAM_hote = 'localhost';
$PARAM_port = '3306';
$PARAM_nom_bd = 'maBDDD';
$PARAM_utilisateur = 'root';
$PARAM_mot_passe = '';

try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd . ';charset=utf8', $PARAM_utilisateur, $PARAM_mot_passe);
  // Activation des erreurs PDO
  $connexion->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $connexion->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
  echo 'Erreur : ' . $e->getMessage() . '<br />';
  echo 'N° : ' . $e->getCode();
}
?>

foreach ($_POST['registration'] as $variable => $value) {
$_SESSION['registration'][$variable] = trim($value);
}

//On récupère proprement la variable AVANT de l'utiliser
$registration = !empty($_POST['registration']) ? $_POST['registration'] : NULL;

//on vérifie qu'elle n'est pas null avant de l'utiliser dans une boucle
if($registration ){
  foreach ($registration as $variable => $value) {
     $_SESSION['registration'][$variable] = trim($value);
   }
}

compliance.php, j'ai des erreurs minimes seulement:
Notice: Undefined index: accept in D:\wamp64\xxxxxxxxxx\compliance.php on line 21
Notice: Undefined index: code in D:\wamp64\xxxxxxxxxx\compliance.php on line 43
et les lignes 21 et 43 sont respectivement:
if ($_POST['accept'] == "Sign") {
$sql = "SELECT * FROM membersbase WHERE code = '".$_GET['code']."'";

$accept = !empty($_POST['accept']) ? $_POST['accept'] : NULL;
if ($accept == "Sign") {
  $sql = "SELECT * FROM membersbase WHERE code = '".$accept."'";

$sql = "SELECT * FROM membersbase WHERE code = :accept ";
$datas = array(':accept '=>$accept);
try{
  $sth = $connexion->prepare($sql);
  $sth->execute($datas);
  $row = $sth->fetch();
}catch(Exception $e){
  echo "ERREUR dans la requête <br>".$sql;
  echo "<br> ". $e->getMessage();
}

Undefined variable: _SESSION in D:\wamp64\xxxxxxxxxx\validation_inscription.php on line 30

 session_start(); 

Notice: Undefined variable: pdo in D:\wamp64\xxxxxxxxxx\validation_inscription.php on line 46

Warning: Cannot modify header information - headers already sent by

 header( ... 

<?php
 error_reporting(E_ALL);
    require ("connexionBDD.php");
    try {
        $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(
 PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
    } catch (Exception $e) {
        echo 'Erreur : ' . $e->getMessage() . '<br />';
        echo 'N° : ' . $e->getCode();
    }

echo //etc.

$requete = $connexion->prepare("SELECT Used_names, Correct_names, Current_trinom_name, Current_status FROM taxabase1 left outer join taxabase2 on (taxabase1.Rk_Hist = taxabase2.Rk_Hist) left outer join taxabase3 on (taxabase3.Rk_Hist = taxabase2.Rk_Hist) WHERE taxabase1.Rk_Hist and Used_names is not null and trim(Used_names) != '' ORDER BY Used_names, Correct_names");
 $requete->bindParam(':Rk_Hist', $Rk_Hist, PDO::PARAM_INT);
 
    $requete->execute();
    $result[1] = $requete->fetchAll();
 $plan7 = '';
 $tabUsed_by_Current_trinom_name = array();
 
 foreach  ($result[1] as $row) {//etc.

require ("connexionBDD.php");
//puis plus loin, la première requête qui plante
$sql = "SELECT COUNT(1) FROM membersbase WHERE email_regis LIKE '".strtolower($_SESSION['registration']['email_regis'])."'";

// E-mail for registration already used
$sql = "SELECT COUNT(1) FROM membersbase WHERE email_regis LIKE '".strtolower($_SESSION['registration']['email_regis'])."'";
$number = $pdo->query($sql)->fetchColumn();
if ($number == 1) {
 $_SESSION['message'] .= "E-mail registration already used<br>";
}

session_start();
error_reporting(E_ALL);
require ("connexionBDD.php");

try {
  $connexion = new PDO('mysql:host=' . $PARAM_hote . ';dbname=' . $PARAM_nom_bd, $PARAM_utilisateur, $PARAM_mot_passe, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
   // Activation des erreurs PDO
  $connexion ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // mode de fetch par défaut : FETCH_ASSOC / FETCH_OBJ / FETCH_BOTH
  $connexion ->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (Exception $e) {
    echo 'Erreur : ' . $e->getMessage() . '<br />';
    echo 'N° : ' . $e->getCode();
}