You will have to restructure your code so that in the web page, you only
call google.charts.load() one time. Perhaps move that call out of your
script in the grafevalesc.php file because it is executed every time you
load that file. Move it to the first thing after the document has loaded:
<script type ="text/javascript">
$(document).ready(function(){
google.charts.load(...)
...
On Thu, Aug 4, 2016 at 11:53 AM, Danny FKB <[email protected]> wrote:
> Hola a todo mundo tengo un problema tengo un formulario donde mando
> variables por medio de ajax a una hoja donde hay un google chart. me
> imprime bien la primera ves que mando, pero cuando lo hago de nuevo me dice
> que no puede cargar de nuevo google.charts.load(), alguien me podría ayudar
> !!!!!
>
>
> index.php
>
> <script type ="text/javascript">
> $(document).ready(function(){
> $("#formulario").submit(function(){
> var bim=jQuery('#bim').val();
> var clone=jQuery('#clone').val();
> var matri=jQuery('#matri').val();
> $.ajax({
> type: "POST",
> url: "grafevalesc.php",
> data: {bim:bim, clone:clone, matri:matri} ,
> success: function(datos) {
> $("#datos").html(datos);
> }
> });
> });
> });
> </script>
> <h1>Evaluacion</h1>
> <form id='formulario' action='javascript:void(0);' method='POST'>
> <div class="col-3">
> <label>Escuela
> <select name="bim" id="bim" tabindex="1">
> <option value="0">Elija Una Escuela...</option>
> <option value='1'>Español</option>
> <option value='2'>Matematicas</option>
> <option value='3'>Historia</option>
> </select></label>
> </div>
> <div class="col-3">
> <label>Ciclo escolar
> <select name="clone" id="clone" tabindex="2">
> <option value="">Ciclo Escolar</option>
> <?php
> $prod=mysql_query("SELECT DISTINCT ciclo_escolar FROM
> inscripcion GROUP BY ciclo_escolar ORDER BY ciclo_escolar;");
> while($fila=mysql_fetch_array($prod)){
> $ciclo_escolar=$fila['ciclo_escolar']; ?>
> <option value="<?php echo $ciclo_escolar ?>"><?php echo
> $ciclo_escolar ?></option>
> <?php } ?>
> </select></label>
> </div>
> <div class="col-3">
> <label>Grado<input type="number" name="matri" id="matri"
> placeholder="Grado A Evaluar" tabindex="3" step="any"/>
> </label>
> </div>
> <div id="progress-button" class="progress-button">
> <button type='submit' id='enviar'><span>Mostrar</span></button>
> </div>
> </form>
> <div id='datos' style="width: 100%; height: 400px;"></div>
>
> grafevalesc.php
> $bim = $_POST['bim'];
> $clone = $_POST['clone'];
> $matri = $_POST['matri'];
>
> $buscador = mysql_query("SELECT r.bime, r.matriren, r.ece, i.escuela,
> i.ciclo_escolar, i.gg,
> SUM(esp1) AS esp1, SUM(mat1) AS mat1, SUM(cien1) AS cien1, SUM(etica1)
> AS etica1, SUM(art1) AS art1, SUM(geo1) AS geo1, SUM(his1) AS his1,
> SUM(vivo1) AS vivo1, SUM(natu1) AS natu1, SUM(efis1) AS efis1,
> SUM(esp2) AS esp2, SUM(mat2) AS mat2,
> COUNT(*) as prime
> FROM rendimiento r , inscripcion i
> WHERE i.gg = '$matri'
> AND r.matriren = i.matricula
> AND i.escuela = '$bim'
> AND r.ece = '$clone';") or
> die(mysql_error());
> while (($fila = mysql_fetch_array($buscador))){
> //------ Datos
> $escuela = $fila['escuela'];
> $gg = $fila['gg'];
> $ciclo_escolar = $fila['ciclo_escolar'];
> //----- Califi
> $esp1 = $fila['esp1'];
> $esp2 = $fila['esp2'];
> $mat1 = $fila['mat1'];
> $mat2 = $fila['mat2'];
> $cien1 = $fila['cien1'];
> $etica1 = $fila['etica1'];
> $art1 = $fila['art1'];
> $geo1 = $fila['geo1'];
> $his1 = $fila['his1'];
> $vivo1 = $fila['vivo1'];
> $natu1 = $fila['natu1'];
> $efis1 = $fila['efis1'];
>
> $prime = $fila['prime'];
> //----- calculo de promedio
> $esces = $esp1/$prime;
> $aftes = $esp2/$prime;
> $escma = $mat1/$prime;
> $aftma = $mat2/$prime;
> $escci = $cien1/$prime;
> $escet = $etica1/$prime;
> $escar = $art1/$prime;
> $escge = $geo1/$prime;
> $eschi = $his1/$prime;
> $escvi = $vivo1/$prime;
> $escna = $natu1/$prime;
> $escefi = $efis1/$prime;
> } ?>
>
> <script type ="text/javascript">
> google.charts.load('current', {'packages':['corechart']});
> google.charts.setOnLoadCallback(datos);
>
> function datos() {
> var data = google.visualization.arrayToDataTable([
> ['Materias', 'Escuela',{ role: 'annotation' },'AfterSchool',{
> role: 'annotation' }],
> ['Español', <?php echo number_format($esces+0,2,".",",");?>,
> '<?php echo number_format($esces+0,2,".",",");?>', <?php echo
> number_format($aftes+0,2,".",",");?>, '<?php echo
> number_format($aftes+0,2,".",",");?>'],
> ['Matematicas', <?php echo number_format($escma+0,2,".",",");?>,
> '<?php echo number_format($escma+0,2,".",",");?>', <?php echo
> number_format($aftma+0,2,".",",");?>, '<?php echo
> number_format($aftma+0,2,".",",");?>'],
> ['FCyE', <?php echo number_format($escet+0,2,".",",");?>, '<?php
> echo number_format($escet+0,2,".",",");?>', 0, '0'],
> ['Educacion Fisica', <?php echo number_format($escefi+0,2,".",",")?>,
> '<?php echo number_format($escefi+0,2,".",",")?>', 0, '0'],
> ['Artisticas', <?php echo number_format($escar+0,2,".",",");?>,
> '<?php echo number_format($escar+0,2,".",",");?>', 0, '0'],
> ['Naturaleza y Sociedad', <?php echo
> number_format($escna+0,2,".",",");?>,
> '<?php echo number_format($escna+0,2,".",",");?>', 0, '0']
> ]);
>
> var options = {
> title : 'Escuela <?php echo $escuela; ?> Del Ciclo Escolar <?php
> echo $ciclo_escolar;?> ',
> vAxis: {title: 'Calificacion'},
> hAxis: {title: 'Materias Grado: <?php echo "$gg"; ?>'},
> seriesType: 'bars',
> series: {5: {type: 'line'}},
> animation: {
> duration: 2000,
> easing: 'out',
> startup: true
> }
> };
>
> var chart = new google.visualization.ComboChart(document.
> getElementById('datos'));
> chart.draw(data, options); };
> </script>
>
> Lo que he pensado es poner un botom que limpie el <DIV> o una función .
> Espero me puedan ayudar gracias y saludos a todo el grupo
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Visualization API" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to google-visualization-api@
> googlegroups.com.
> Visit this group at https://groups.google.com/
> group/google-visualization-api.
> To view this discussion on the web visit https://groups.google.com/d/
> msgid/google-visualization-api/9eab5e76-1129-4a16-9593-
> 827c239b99b2%40googlegroups.com
> <https://groups.google.com/d/msgid/google-visualization-api/9eab5e76-1129-4a16-9593-827c239b99b2%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2>
[email protected] <[email protected]> 5CC, Cambridge MA
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJOG%3DFrAB%3DSNb-BgMxkn0f%2B5SB0WBhiQP4QWgxwuS7f%2B5A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
