Guardar en MYSQL una variable al cargar la pagina?

[chronos682]

Puedes hacer el insert luego de obtener el promedio:

Iniciado por diegorpm4

Muchas gracias por responder. Luego de los selectores ya antes mencionados el docente presiona un boton CARGAR PLANILLA y mediante AJAX se ejecuta y muestra el siguiente codigo donde alli calcula el promedio.

Código HTML:

<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "evan.tesis";
	
//Connect to MySQL Server
mysql_connect($dbhost, $dbuser);
	
//Select Database
mysql_select_db($dbname) or die(mysql_error());
	
// Retrieve data from Query String
$carreras = $_GET['carreras'];
$materias = $_GET['materias'];
$turno = $_GET['turno'];
$anio = $_GET['anio'];
	
// Escape User Input to help prevent SQL Injection
$carreras = mysql_real_escape_string($carreras);
$materias = mysql_real_escape_string($materias);
$turno = mysql_real_escape_string($turno);
$anio = mysql_real_escape_string($anio);


require_once 'inc/funciones.php';
$link = ConectarBD();  
$query = mysql_query("SELECT * FROM interactivo_evan WHERE carreraAlumno = '$carreras' AND materiasInscripcion = '$materias' AND turnoAlumno = '$turno' AND anioInscripcion = '$anio'"); 

while ($row = mysql_fetch_row($query)){ ?>
	
   <tr>
   <td><?php echo $row[2]; ?> <?php echo $row[3]; ?></td>
   <td><?php echo $row[1]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'1P','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[27]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'1Pr','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[28]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'2P','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[29]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'2Pr','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[30]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'3P','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[31]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'1TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[32]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'2TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[33]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'3TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[34]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'4TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[35]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'5TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[36]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'6TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[37]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'7TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[38]; ?></td>
   <td contenteditable='true' onBlur="saveToDatabase(this,'8TP','<?php echo $row[0]; ?>')" onClick='showEdit(this);'><?php echo $row[39]; ?></td>
  <?php if ($row[11] == "A") {$row[11] = NULL;}
if ($row[12] == "A") {$row[12] = NULL;}
if ($row[13] == "A") {$row[13] = NULL;}
if ($row[14] == "A") {$row[14] = NULL;}
if ($row[15] == "A") {$row[15] = NULL;}
if ($row[16] == "A") {$row[16] = NULL;}
if ($row[17] == "A") {$row[17] = NULL;}
if ($row[18] == "A") {$row[18] = NULL;}

if (empty($row[32])) {$row[32] = NULL;} else if ($row[32] == "A") {$row[32] = NULL;}
if (empty($row[33])) {$row[33] = NULL;} else if ($row[33] == "A") {$row[33] = NULL;}
if (empty($row[34])) {$row[34] = NULL;} else if ($row[34] == "A") {$row[34] = NULL;}
if (empty($row[35])) {$row[35] = NULL;} else if ($row[35] == "A") {$row[35] = NULL;}
if (empty($row[36])) {$row[36] = NULL;} else if ($row[36] == "A") {$row[36] = NULL;}
if (empty($row[37])) {$row[37] = NULL;} else if ($row[37] == "A") {$row[37] = NULL;}
if (empty($row[38])) {$row[38] = NULL;}	else if ($row[38] == "A") {$row[38] = NULL;}
if (empty($row[39])) {$row[39] = NULL;} else if ($row[39] == "A") {$row[39] = NULL;}

$Conteo =array($row[32], $row[33], $row[34], $row[35], $row[36], $row[37], $row[38], $row[39]);



foreach($Conteo as $index=>$value) {
    if($value === null) unset($Conteo[$index]);
}
$Cant = count($Conteo);	

$SumaNota = $row[32] + $row[33] + $row[34] + $row[35] + $row[36] + $row[37] + $row[38] + $row[39];
if ($SumaNota > 0) {
$Promedio = ($row[32] + $row[33] + $row[34] + $row[35] + $row[36] + $row[37] + $row[38] + $row[39]) / $Cant;} else {$Promedio = NULL;
}
$query = mysql_query("INSERT INTO tabla ('promedio') VALUES ('$Promedio')");
?>
   <td><?php echo $Promedio;?></td>
   
   </tr>
   </tbody>

<?php
} 
	?>
	

Cambias tabla por el nombre dela tabla y promedio por el nombre del campo.