Site web

Bonjour,

Je souhaiterai récupérer la valeur de ma boucle while

echo $reqs['iduservote']; pour l'insérer dans requête SQL

$sql = " SELECT * FROM user WHERE id ='$reqs['iduservote']";
ci-joint, le script merci pour votre aide

<?
session_start();
$dbhost="localhost";
$dbuser="";
$dbpass="";
$db='';
$connect=mysqli_connect($dbhost,$dbuser,$dbpass,$db);
if(!$connect){echo "non connecté";}
$_SESSION['usercandidat']= $_GET['id'];
?>
<?php
$req=mysqli_query($connect,"select * from rating where idusercandidat='".$_SESSION['usercandidat']."'") or die (mysqli_error());
while($reqs=mysqli_fetch_array($req)){
?>
<?php
echo $reqs['iduservote'];
?>
<?php }?>

<?php
if (!include('../../pre-art-anecdotes.php')) exit;
function Liens_full($args){
$tab_result = array();
$sql = " SELECT id, titre_art_anecdotes, url_photo_art_anecdotes,texte_art_anecdotes FROM art_anecdotes";
$result = Sql_query($sql);
if ($result){
while($row = Sql_fetch($result)) {
$id = $row['id'];
$tab_result[$id]["id"] = $id;
$tab_result[$id]["url_photo_art_anecdotes"] = Sql_prepareTexteAffichage($row['url_photo_art_anecdotes']);
$tab_result[$id]["titre_art_anecdotes"] = Sql_prepareTexteAffichage($row['titre_art_anecdotes']);
$tab_result[$id]["texte_art_anecdotes"] = Sql_prepareTexteAffichage($row['texte_art_anecdotes']);}}
return $tab_result;}
function Users_chercher($args){
$tab_result = array();
$sql = " SELECT * FROM user WHERE id ='5'";
if (!isset($args['id'])
&& !isset($args['not_tab_ids_users']))
$sql .= $condition;
if (isset($args['order_by']))
$sql .= " ORDER BY ".$args['order_by']." DESC";
if (isset($args['limit']))
$sql .= " LIMIT ".$args['limit'];
Lib_myLog("SQL: $sql");
$result = Sql_query($sql);
if ($result && Sql_errorCode($result) === "00000") {
while($row = Sql_fetch($result)) {
$id = $row['id'];
$tab_result[$id]["id"] = $id;
$tab_result[$id]["url_photo"] = $row['url_photo'];
$tab_result[$id]["prenom"] = Sql_prepareTexteAffichage($row['prenom']);
$tab_result[$id]["nom"] = Sql_prepareTexteAffichage($row['nom']);}}
if (count($tab_result) == 1 && ($args['id'] != '' && $args['id'] != '*'))
$tab_result = array_pop($tab_result);
return $tab_result;}
Lib_myLog("FILE: ",__FILE__);
Lib_myLog("IN: ",$data_in);
function ExecActions($action) {
Lib_myLog("action: ",$action);
global $data_in, $data_out;
global $points_annonces;
if(!isset($_SESSION['email']) || $_SESSION['email'] == '') {
if(isset($_COOKIE['email_mdp']) && $_COOKIE['email_mdp'] != '') header('Location: ../../index.php');
header('Location: ../../index.php');
} else {
$db_link = Sql_connect();
switch($action){
case "Recherche_General" :
{ $args_users['id_user'] = $data_in['id_user'];
$users = Liens_full($args_users);
foreach($users as $user){
if($user['titre_art_anecdotes']) $data_out['user'][$user['id']] = $user;}
ksort($data_out['user']);
switch($action){
case "Recherche_General" :
$data_out['page'] = "index.php";
break;}
if(!empty($users)) foreach($users as $user) $tableau_ids_users[] = $user[$id];
if(!empty($tableau_ids_users)){
foreach($tableau_ids_users as $name => $user){
$test = '1';
if($test == '1') $liste_users[$name] = $user;}}
$data_out['barre_numeros_pages'] = Lib_Limitation_Affichage($liste_users, $data_in['page'], $action, $champs);
$args_resultats['limit'] = Lib_Calcul_Limit($data_in['page']);
if(!empty($data_in['order_by']))
$args_resultats['order_by'] = $data_in['order_by'].'id';
else $args_resultats['order_by'] = 'id';
$data_out['liste_users'] = array();
switch($action){
default :
$data_out['liste_users'] = Users_chercher($args_resultats);
break;}
if(!empty($data_out['liste_users'])) $data_out['resultat'] = 'oui'; else $data_out['resultat'] = 'non';}
break;}}}
if(substr($_SERVER['PHP_SELF'], -11) == 'actions-art-anecdotes.php' && !isset($data_in['action'])) ExecActions('');
elseif(isset($data_in['action'])){
ExecActions($data_in['action']);
include('../../post.php');
Lib_myLog("OUT: ",$data_out);
return $data_out;}
?>

<? if(!function_exists('ExecActions'));
$data_in['id_user'] = $_SESSION['id'];
$data_in['id_user_exterieur'] = $_GET['id'];
ExecActions('Recherche_General'); ?>

<? foreach($data_out['liste_users'] as $user){ ?>
<?=$user['prenom']; ?>
<?=$user['nom']; ?>
<img src="../../img_ftp/<?=$user['url_photo']?>" alt="" class="img-anecdote"/>
<? } ?>