function main() { $hostname = "localhost"; $username = "******"; $password = "******"; $database = "solarPanel"; //print "function main() start\n"; $json = $_GET['json']; $decoded = json_decode($_GET['json']); $functionString = $decoded->fs; //print "functionString=".$functionString."\n"; $con = mysql_connect($hostname, $username, $password) or die("Error " . mysqli_error($con)); mysql_select_db($database, $con); if (strcmp($functionString, 'saveValues') == 0) { //print "calling saveValues\n"; //print "calling saveValues".$bv3."\n"; saveValues($con, $database, $decoded); } if (strcmp($functionString, 'showTables') == 0) { showTables($con, $database); } if (strcmp($functionString, 'loadValues') == 0) { loadValues($con, $database, $decoded); } if (strcmp($functionString, 'SaveToExcel') == 0) { SaveToExcel($con); } mysql_close($con); }
} switch ($action) { case 'popula': populaGrid(); // Exibe os dados no Grid break; case 'delete': deleteValues(); // Elimina os dados break; case 'edit': editValues(); // Chama para edicao os dados break; case 'save': saveValues(); // Save data break; default: } function populaGrid() { include "functions/db-connection.php"; include "functions/cla-connection.php"; $conn = new cla_connection($hostname, $username, $password, $database); $sql = "DELETE FROM podcast_temp;"; $rs = $conn->query($sql, false); $sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (1) ORDER BY data DESC LIMIT 5 );"; $rs = $conn->query($sql, false); $sql = "INSERT INTO podcast_temp (`id`,`descricao`,`nome_servidor`,`area`,`data`) (SELECT `id`,`descricao`,`nome_servidor`,`area`,`data` FROM podcast WHERE area IN (2) ORDER BY data DESC LIMIT 5 );"; $rs = $conn->query($sql, false);