<?php include 'connexion.php'; if (isset($_POST['submit'])){ $pseudo = htmlspecialchars(trim($_POST['pseudo'])); $point=10; $params = array(':prenom' => $pseudo,':score' => $point); $sql="SELECT * FROM messcores WHERE prenom=:prenom AND score=:score"; $requete = $connection->prepare ($sql); $requete->execute($params); $resultat = $requete->fetchAll(); //A la place de ton DO .. foreach($resultat as $R){ $javascript .="['".$R['prenom']."', '".$R['score']."'],"; } //fin FOREACH }//fin IF $_POST
<?php
include 'connexion.php';
if (isset($_POST['submit'])){
$pseudo = htmlspecialchars(trim($_POST['pseudo']));
$point=10;
$params = array(':prenom' => $pseudo,':score' => $point);
$sql="SELECT *
FROM messcores
WHERE prenom=:prenom
AND score=:score";
$requete = $connection->prepare ($sql);
$requete->execute($params);
$resultat = $requete->fetchAll();
//A la place de ton DO ..
foreach($resultat as $R){
$javascript .="['".$R['prenom']."', '".$R['score']."'],";
?>
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Score', 'en milliers'],
]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
<?php
echo $javascript;
?>
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<form method="post" action="camembert.php" >
<p>
<input type="text" name="pseudo" required />
<input type="submit" name="submit" value="Valider" />
</p>
</form>
</td>
</tr>
</table>
</body>
</html>
$params = array(':prenom' => $pseudo,':score' => $point); $sql="SELECT * FROM messcores WHERE prenom=:prenom AND score=:score"; try{ $requete = $connection->prepare($sql); $requete->execute($params); $resultat = $requete->fetchAll(); } catch (Exception $e) { echo "<br><b>Exception :<b>", $e->getMessage(), "\n"; echo "<br><b>Requete:</b><br>".$sql; echo "<br><b>params:</b><br>"; print_r($params); }
<?php
include 'connexion.php';
if (isset($_POST['submit'])){
$pseudo = htmlspecialchars(trim($_POST['pseudo']));
$point=10;
$params = array(':prenom' => $pseudo,':score' => $point);
$sql="SELECT *
FROM messcores
WHERE prenom=:prenom
AND score=:score";
try{
$requete = $connection->prepare($sql);
$requete->execute($params);
$resultat = $requete->fetchAll();
} catch (Exception $e) {
echo "<br><b>Exception :<b>", $e->getMessage(), "\n";
echo "<br><b>Requete:</b><br>".$sql;
echo "<br><b>params:</b><br>";
print_r($params);
}
//A la place de ton DO ..
foreach($resultat as $R){
$javascript .="['".$R['prenom']."', '".$R['score']."'],";
?>
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Score', 'en milliers'],
]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
<?php
echo $javascript;
?>
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<form method="post" action="camembert.php" >
<p>
<input type="text" name="pseudo" required />
<input type="submit" name="submit" value="Valider" />
</p>
</form>
</td>
</tr>
</table>
</body>
</html>
<?php include 'connexion.php'; if (isset($_POST['submit'])){ $pseudo = htmlspecialchars(trim($_POST['pseudo'])); $point=10; $params = array(':prenom' => $pseudo,':score' => $point); $sql="SELECT * FROM messcores WHERE prenom=:prenom AND score=:score"; try{ $requete = $connection->prepare($sql); $requete->execute($params); $resultat = $requete->fetchAll(); } catch (Exception $e) { echo "<br><b>Exception :<b>", $e->getMessage(), "\n"; echo "<br><b>Requete:</b><br>".$sql; echo "<br><b>params:</b><br>"; print_r($params); } //A la place de ton DO .. foreach($resultat as $R){ $javascript .="['".$R['prenom']."', '".$R['score']."'],"; } ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php
include 'connexion.php';
if (isset($_POST['submit']))
{
$pseudo = htmlspecialchars(trim($_POST['pseudo']));
$point="10";
$params = array(':prenom' => $pseudo,':score' => $point);
$sql="SELECT *
FROM messcores
WHERE prenom=:prenom
AND score=:score";
try
{
$requete = $connection->prepare($sql);
$requete->execute($params);
$resultat = $requete->fetchAll();
} catch (Exception $e)
{
echo "<br><b>Exception :<b>", $e->getMessage(), "\n";
echo "<br><b>Requete:</b><br>".$sql;
echo "<br><b>params:</b><br>";
print_r($params);
}
//A la place de ton DO ..
foreach($resultat as $R)
{
$javascript .="['".$R['prenom']."', '".$R['score']."'],";
}
}
?>
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Score', 'en milliers'],]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
<?php
echo $javascript;
?>
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<form method="post" action="camembert.php" >
<p>
<input type="text" name="pseudo" required />
<input type="submit" name="submit" value="Valider" />
</p>
</form>
</td>
</tr>
</table>
</body>
</html>
<?php
include 'connexion.php';
if (isset($_POST['submit']))
{
$pseudo = htmlspecialchars(trim($_POST['pseudo']));
$point=10;
$params = array(':prenom' => $pseudo,':score' => $point);
$sql="SELECT *
FROM messcores
WHERE prenom=:prenom
AND score=:score";
try
{
$requete = $connection->prepare($sql);
$requete->execute($params);
$resultat = $requete->fetchAll();
} catch (Exception $e)
{
echo "<br><b>Exception :<b>", $e->getMessage(), "\n";
echo "<br><b>Requete:</b><br>".$sql;
echo "<br><b>params:</b><br>";
print_r($params);
}
//A la place de ton DO ..
foreach($resultat as $R)
{
$javascript .="['".$R['prenom']."', '".$R['score']."'],";
}
}
?>
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", "1", {packages:["corechart"]});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Score', 'en milliers'],]);
var options = {
title: 'My Daily Activities'
};
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, options);
<?php
echo $javascript;
?>
</script>
</head>
<body>
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<form method="post" action="camembert.php" >
<p>
<input type="text" name="pseudo" required />
<input type="submit" name="submit" value="Valider" />
</p>
</form>
</td>
</tr>
</table>
</body>
</html>
<script type="text/javascript"> google.load("visualization", "1", {packages:["corechart"]}); google.setOnLoadCallback(drawChart); function drawChart() { var data = google.visualization.arrayToDataTable([ ['Score', 'en milliers'],]); var options = { title: 'My Daily Activities' }; var chart = new google.visualization.PieChart(document.getElementById('piechart')); chart.draw(data, options); <?php echo $javascript; ?> </script>
<?php
try {
$connection = new PDO('mysql:host=localhost;dbname=test', 'root', '',
array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
} catch ( Exception $e ) {
echo "Connection à MySQL impossible : ", $e->getMessage();
die();
}
?>
<html> <head> <meta charset="utf-8" /> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript"> // Load the Visualization API and the piechart package. google.load('visualization', '1', {'packages':['corechart']}); // Set a callback to run when the Google Visualization API is loaded. // google.setOnLoadCallback(drawChart); function drawChart() { var pseudo = document.getElementById('pseudo').value; var data={pseudo:pseudo}; $.ajax({ type: "POST", url:"getData.php", data: data, async: false, dataType: "json", success: function(jsonData){ // -->> Si ça ne marche pas... // decommente la ligne ci-dessous pour voir: // alert(jsonData); var data = new google.visualization.DataTable(jsonData); var chart = new google.visualization.PieChart(document.getElementById('chart_div')); chart.draw(data, {width: 400, height: 240}); }, error:function(jqXHR, textStatus){ alert('error :' + jqXHR + ' ' + textStatus); }, statusCode:{ 404: function(){alert(LANG_AJX_404);} } }); } </script> </head> <body> <!-- ********** DEBUT DU BODY ************* --> <div id="piechart" style="width: 900px; height: 500px;"></div> <table> <tr> <td> <h1> Quel est votre pseudo ?</h1><br /> <p> <input type="text" name="pseudo" id="pseudo" value="<?php echo $pseudo;?>" required /> <input type="button" name="submit" value="Valider" onclick="drawChart();"/> </p> </td> </tr> </table> <!-- ********** FIN DU BODY ************* --> </body> </html>
<?php //-----------------------------------------------------------------------// // Page getData.php // Permet de renvoyer en JSON les données du graphique //-----------------------------------------------------------------------// include 'connexion.php'; $result=array(); //définition des colonnes $result['cols']=array("Score","en milliers"); $pseudo = isset($_POST['pseudo'])?htmlspecialchars(trim($_POST['pseudo']):''; $point=10; $params = array(':prenom' => $pseudo,':score' => $point); $sql="SELECT * FROM messcores WHERE prenom=:prenom AND score=:score"; try { $requete = $connection->prepare($sql); $requete->execute($params); $resultat = $requete->fetchAll(); } catch (Exception $e) { echo "<br><b>Exception :<b>", $e->getMessage(), "\n"; echo "<br><b>Requete:</b><br>".$sql; echo "<br><b>params:</b><br>"; print_r($params); } // Création des data (lignes) foreach($resultat as $R){ $result['rows'][] = array($R['prenom'],$R['score']); } print json_encode($result); ?>
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
// google.setOnLoadCallback(drawChart);
function drawChart() {
var pseudo = document.getElementById('pseudo').value;
var data={pseudo:pseudo};
$.ajax({
type: "POST",
url:"getData.php",
data: data,
async: false,
dataType: "json",
success: function(jsonData){
// -->> Si ça ne marche pas...
// decommente la ligne ci-dessous pour voir:
var data = new google.visualization.DataTable(jsonData);
var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
chart.draw(data, {width: 400, height: 240});
},
error:function(jqXHR, textStatus){
alert('error :' + jqXHR + ' ' + textStatus);
},
statusCode:{
404: function(){alert(LANG_AJX_404);}
}
});
}
</script>
</head>
<body>
<!-- ********** DEBUT DU BODY ************* -->
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<p>
<input type="text" name="pseudo" id="pseudo" value="<?php echo $pseudo;?>" required />
<input type="button" name="submit" value="Valider" onclick="drawChart();"/>
</p>
</td>
</tr>
</table>
<!-- ********** FIN DU BODY ************* -->
</body>
</html>
<input type="text" name="pseudo" id="pseudo" value="" required />
Ce fichier ne comporte plus la ligne 26 que j'ai décommenté à ta demande du fait que le premier essai ne fonctionnait pas non plus.
alert(jsonData);
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
// google.setOnLoadCallback(drawChart);
function drawChart() {
var pseudo = document.getElementById('pseudo').value;
var data={pseudo:pseudo};
$.ajax({
type: "POST",
url:"getData.php",
data: data,
async: false,
dataType: "json",
success: function(jsonData){
// -->> Si ça ne marche pas...
// decommente la ligne ci-dessous pour voir:
alert(jsonData);
var data = new google.visualization.DataTable(jsonData);
var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
chart.draw(data, {width: 400, height: 240});
},
error:function(jqXHR, textStatus){
alert('error :' + jqXHR + ' ' + textStatus);
},
statusCode:{
404: function(){alert(LANG_AJX_404);}
}
});
}
</script>
</head>
<body>
<!-- ********** DEBUT DU BODY ************* -->
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<p>
<input type="text" name="pseudo" id="pseudo" value="" required />
<input type="button" name="submit" value="Valider" onclick="drawChart();"/>
</p>
</td>
</tr>
</table>
<!-- ********** FIN DU BODY ************* -->
</body>
</html>
var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<html>
<head>
<meta charset="utf-8" />
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script type="text/javascript">
// Load the Visualization API and the piechart package.
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization API is loaded.
// google.setOnLoadCallback(drawChart);
function drawChart() {
var pseudo = document.getElementById('pseudo').value;
var data={pseudo:pseudo};
$.ajax({
type: "POST",
url:"getData.php",
data: data,
async: false,
dataType: "json",
success: function(jsonData){
// -->> Si ??a ne marche pas...
// decommente la ligne ci-dessous pour voir:
alert(jsonData);
var data = new google.visualization.DataTable(jsonData);
var chart = new google.visualization.PieChart(document.getElementById('piechart'));
chart.draw(data, {width: 400, height: 240});
},
error:function(jqXHR, textStatus){
alert('error :' + jqXHR + ' ' + textStatus);
},
statusCode:{
404: function(){alert(LANG_AJX_404);}
}
});
}
</script>
</head>
<body>
<!-- ********** DEBUT DU BODY ************* -->
<div id="piechart" style="width: 900px; height: 500px;"></div>
<table>
<tr>
<td>
<h1> Quel est votre pseudo ?</h1><br />
<p>
<input type="text" name="pseudo" id="pseudo" value="" required />
<input type="button" name="submit" value="Valider" onclick="drawChart();"/>
</p>
</td>
</tr>
</table>
<!-- ********** FIN DU BODY ************* -->
</body>
</html>
$pseudo = isset($_POST['pseudo'])?htmlspecialchars(trim($_POST['pseudo'])):'';
console.log(jsonData);
<?php //-----------------------------------------------------------------------// // Page getData.php // Permet de renvoyer en JSON les données du graphique //-----------------------------------------------------------------------// include 'connexion.php'; $result=array(); //définition des colonnes $result['cols']=array("Score","en milliers"); $pseudo = isset($_POST['pseudo'])?htmlspecialchars(trim($_POST['pseudo']):''; $point=10; $params = array(':prenom' => $pseudo,':score' => $point); $sql="SELECT * FROM messcores WHERE prenom=:prenom AND score=:score"; try { $requete = $connection->prepare($sql); $requete->execute($params); $resultat = $requete->fetchAll(); //-------------------------------------------------// //le temps des tests ! //-------------------------------------------------// $result['sql'] = $sql; $result['params'] = $params; $result['resultats'] = $resultat; //-------------------------------------------------// } catch (Exception $e){ echo "<br><b>Exception :<b>", $e->getMessage(), "\n"; echo "<br><b>Requete:</b><br>".$sql; echo "<br><b>params:</b><br>"; print_r($params); } // Création des data (lignes) foreach($resultat as $R){ $result['rows'][] = array($R['prenom'],$R['score']); } print json_encode($result); ?>
<!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <html> <head> <meta charset="utf-8" /> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript"> // Load the Visualization API and the piechart package. google.load('visualization', '1', {'packages':['corechart']}); // Set a callback to run when the Google Visualization API is loaded. // google.setOnLoadCallback(drawChart); function drawChart() { var pseudo = document.getElementById('pseudo').value; var data={pseudo:pseudo}; $.ajax({ type: "POST", url:"getData.php", data: data, async: false, dataType: "json", success: function(jsonData){ //--------------------------------------------// // le temps des tests uniquement ! //--------------------------------------------// console.log(" jsonData contient : "); console.log(jsonData); //--------------------------------------------// var data = new google.visualization.DataTable(jsonData); var chart = new google.visualization.PieChart(document.getElementById('piechart')); chart.draw(data, {width: 400, height: 240}); }, error:function(jqXHR, textStatus){ alert('error :' + jqXHR + ' ' + textStatus); }, statusCode:{ 404: function(){alert(LANG_AJX_404);} } }); } </script> </head> <body> <!-- ********** DEBUT DU BODY ************* --> <div id="piechart" style="width: 900px; height: 500px;"></div> <table> <tr> <td> <h1> Quel est votre pseudo ?</h1><br /> <p> <input type="text" name="pseudo" id="pseudo" value="" required /> <input type="button" name="submit" value="Valider" onclick="drawChart();"/> </p> </td> </tr> </table> <!-- ********** FIN DU BODY ************* --> </body> </html>
<?php
//-----------------------------------------------------------------------//
// Page getData.php
// Permet de renvoyer en JSON les données du graphique
//-----------------------------------------------------------------------//
include 'connexion.php';
$result=array();
//définition des colonnes
$result['cols']=array("Score","en milliers");
if (isset($_POST['submit']))
{
$pseudo = htmlspecialchars(trim($_POST['pseudo']));
$point=10;
$params = array(':prenom' => $pseudo,':score' => $point);
$sql="SELECT *
FROM messcores
WHERE prenom=:prenom
AND score=:score";
try
{
$requete = $connection->prepare($sql);
$requete->execute($params);
$resultat = $requete->fetchAll();
//-------------------------------------------------//
//le temps des tests !
//-------------------------------------------------//
$result['sql'] = $sql;
$result['params'] = $params;
$result['resultats'] = $resultat;
//-------------------------------------------------//
} catch (Exception $e){
echo "<br><b>Exception :<b>", $e->getMessage(), "\n";
echo "<br><b>Requete:</b><br>".$sql;
echo "<br><b>params:</b><br>";
print_r($params);
}
// Création des data (lignes)
foreach($resultat as $R){
$result['rows'][] = array($R['prenom'],$R['score']);
}
}
print json_encode($result);
?>