function login($username, $password) { $ConfigManager = new ConfigManager(); $dbhost = $ConfigManager->getHost(); $dbuser = $ConfigManager->getUser(); $dbname = $ConfigManager->getDatabase(); $dbpass = $ConfigManager->getPassword(); $conn = null; try { $conn = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass); $cmd = "\n\t\t\t\tSELECT \t\n\t\t\t\t\tid as id_operatore,\n\t\t\t\t\tusername as username_operatore,\n\t\t\t\t\tpassword as password_operatore,\n\t\t\t\t\tdescrizione as descrizione_operatore\n\t\t\t\tFROM \trusc_operatori \n\t\t\t\tWHERE \tusername = :username\n\t\t\t\t\t\tAND password = :password"; $result = $conn->prepare($cmd); $result->bindValue(":username", $username); $result->bindValue(":password", $password); $result->execute(); $return_arr = array(); $row_array = array(); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $row_array['idOperatore'] = utf8_encode($row['id_operatore']); $row_array['usernameOperatore'] = utf8_encode($row['username_operatore']); $row_array['descrizioneOperatore'] = utf8_encode($row['descrizione_operatore']); array_push($return_arr, $row_array); } $conn = NULL; return json_encode($return_arr); } catch (PDOException $e) { return json_encode($e->getMessage()); } }
function connetti_query($query) { global $Host, $User, $Password, $Database, $link; $ConfigManager = new ConfigManager(); $Host = $ConfigManager->getHost(); $User = $ConfigManager->getUser(); $Database = $ConfigManager->getDatabase(); $Password = $ConfigManager->getPassword(); // Connessione al database if (!($link = mysql_connect($Host, $User, $Password))) { die("Errore nella connessione al database! -> " . mysql_error()); } // Apertura del database if (!mysql_select_db($Database, $link)) { die("Errore nell'apertura del database mba!" . mysql_error()); } // Esucuzione della query if (!($result = mysql_query($query, $link))) { print "Errore nell'esecuzione della query! <br />"; die(mysql_error()); } //chiusura del collegamento al database mysql_close($link); //restituzione all'ambiente chiamante del risultato della query return $result; }
function elenco() { $ConfigManager = new ConfigManager(); $dbhost = $ConfigManager->getHost(); $dbuser = $ConfigManager->getUser(); $dbname = $ConfigManager->getDatabase(); $dbpass = $ConfigManager->getPassword(); $conn = null; try { $conn = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass); $cmd = "\r\n\t\t\t\tselect \r\n\t\t\t\t\trusc_tipologia.id as id_tipologia,\r\n\t\t\t\t\trusc_tipologia.codice as codice_tipologia,\r\n\t\t\t\t\trusc_tipologia.descrizione as descrizione_tipologia \r\n\t\t\t\tfrom \r\n\t\t\t\t\trusc_tipologia\r\n\t\t\t\torder by rusc_tipologia.codice"; $result = $conn->prepare($cmd); $result->execute(); $return_arr = array(); $row_array = array(); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $row_array['idTipologia'] = utf8_encode($row['id_tipologia']); $row_array['codiceTipologia'] = utf8_encode($row['codice_tipologia']); $row_array['descrizioneTipologia'] = utf8_encode($row['descrizione_tipologia']); array_push($return_arr, $row_array); } $conn = NULL; return json_encode($return_arr); } catch (PDOException $e) { echo $e->getMessage(); } }
function elenco($idOperatore) { $ConfigManager = new ConfigManager(); $dbhost = $ConfigManager->getHost(); $dbuser = $ConfigManager->getUser(); $dbname = $ConfigManager->getDatabase(); $dbpass = $ConfigManager->getPassword(); $conn = null; try { $conn = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass); $cmd = "\r\n\t\t\t\tselect \r\n\t\t\t\t\trusc_conferimenti.id as id_conferimento,\r\n\t\t\t\t\trusc_tipologia.descrizione as descrizione_conferimento, \r\n\t\t\t\t\trusc_conferimenti.data as data_conferimento,\r\n\t\t\t\t\trusc_operatori.descrizione as descrizione_operatore\r\n\t\t\t\tfrom \r\n\t\t\t\t\trusc_conferimenti, \r\n\t\t\t\t\trusc_tipologia,\r\n\t\t\t\t\trusc_operatori\r\n\t\t\t\twhere \r\n\t\t\t\t\trusc_conferimenti.tipologia = rusc_tipologia.id\r\n\t\t\t\t\tand rusc_conferimenti.operatore = rusc_operatori.id\r\n\t\t\t\t\tand rusc_operatori.id = " . $idOperatore; $result = $conn->prepare($cmd); $result->execute(); $return_arr = array(); $row_array = array(); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $row_array['idConferimento'] = utf8_encode($row['id_conferimento']); $row_array['descrizioneConferimento'] = utf8_encode($row['descrizione_conferimento']); $row_array['dataConferimento'] = utf8_encode($row['data_conferimento']); $row_array['descrizioneOperatore'] = utf8_encode($row['descrizione_operatore']); array_push($return_arr, $row_array); } $conn = NULL; return json_encode($return_arr); } catch (PDOException $e) { echo $e->getMessage(); } }
public function __construct() { $ConfigManager = new ConfigManager(); $this->Host = $ConfigManager->getHost(); $this->User = $ConfigManager->getUser(); $this->Database = $ConfigManager->getDatabase(); $this->Password = $ConfigManager->getPassword(); }
<?php require_once "../ConfigManager.php"; $ConfigManager = new ConfigManager(); $dbhost = $ConfigManager->getHost(); $dbuser = $ConfigManager->getUser(); $dbname = $ConfigManager->getDatabase(); $dbpass = $ConfigManager->getPassword(); $conn = null; try { $conn = new PDO("mysql:host={$dbhost};dbname={$dbname}", $dbuser, $dbpass); $idStagione = $_GET['idStagione']; $cmd = "\n\t\tselect \n\t\t\tp.ID as ID,\n\t\t\ta.ID as ID_ATLETA,\n\t\t\ta.NOME as NOME_ATLETA, \n\t\t\ta.COGNOME as COGNOME_ATLETA, \n\t\t\tg.ID as ID_GARA,\n\t\t\tg.NOME as NOME_GARA,\n\t\t\tg.LOCALITA as LOCALITA_GARA,\n\t\t\tg.DATA as DATA_GARA,\n\t\t\ttg.ID as ID_TIPOLOGIA_GARA,\n\t\t\ttg.TIPO as TIPOLOGIA_GARA_DESCRIZIONE,\n\t\t\ttg.PUNTEGGIO as TIPOLOGIA_GARA_PUNTEGGIO,\n\t\t\tp.POSIZIONE_ASSOLUTA as POSIZIONE_ASSOLUTA,\n\t\t\tp.TOTALE_ASSOLUTI as TOTALE_ASSOLUTI,\n\t\t\tp.POSIZIONE_CATEGORIA as POSIZIONE_CATEGORIA,\n\t\t\tp.TOTALE_CATEGORIA as TOTALE_CATEGORIA,\n\t\t\tp.BONUS as BONUS,\n\t\t\ts.ID as ID_STAGIONE,\n\t\t\ts.ANNO as ANNO\n\t\tfrom \n\t\t\tpresenza p,\n\t\t\tatleta a,\n\t\t\tgara g,\n\t\t\ttipologia_gara tg,\n\t\t\tstagione s\n\t\twhere \n\t\t\tp.ID_ATLETA = a.ID\n\t\t\tand p.ID_GARA = g.ID\n\t\t\tand p.ID_TIPOLOGIA_GARA = tg.ID\n\t\t\tand p.ID_STAGIONE = s.ID\n\t\t\tand s.ID = " . $idStagione . "\n\t\tgroup by p.ID\n\t\torder by g.DATA desc, g.NOME, a.COGNOME"; $result = $conn->prepare($cmd); $result->execute(); $return_arr = array(); $row_array = array(); while ($row = $result->fetch(PDO::FETCH_ASSOC)) { $row_array['id'] = utf8_encode($row['ID']); $row_array['idAtleta'] = utf8_encode($row['ID_ATLETA']); $row_array['nomeAtleta'] = utf8_encode($row['NOME_ATLETA']); $row_array['cognomeAtleta'] = utf8_encode($row['COGNOME_ATLETA']); $row_array['idGara'] = utf8_encode($row['ID_GARA']); $row_array['nomeGara'] = utf8_encode($row['NOME_GARA']); $row_array['localitaGara'] = utf8_encode($row['LOCALITA_GARA']); $row_array['dataGara'] = utf8_encode($row['DATA_GARA']); $row_array['tipologiaGara'] = utf8_encode($row['ID_TIPOLOGIA_GARA']); $row_array['tipologiaGaraDescrizione'] = utf8_encode($row['TIPOLOGIA_GARA_DESCRIZIONE']); $row_array['tipologiaGaraPunteggio'] = utf8_encode($row['TIPOLOGIA_GARA_PUNTEGGIO']); $row_array['posizioneAssoluta'] = utf8_encode($row['POSIZIONE_ASSOLUTA']); $row_array['totaleAssoluti'] = utf8_encode($row['TOTALE_ASSOLUTI']);
<?php require_once "../ConfigManager.php"; $configManager = new ConfigManager(); //ENTER THE RELEVANT INFO BELOW $mysqlDatabaseName = $configManager->getDatabase(); $mysqlUserName = $configManager->getUser(); $mysqlPassword = $configManager->getPassword(); $mysqlHostName = $configManager->getHost(); $mysqlExportPath = "../database/backups/db_dump_" . date("Y-m-d") . ".sql"; //DONT EDIT BELOW THIS LINE //Export the database and output the status to the page $command = 'mysqldump --opt -h' . $mysqlHostName . ' -u' . $mysqlUserName . ' -p' . $mysqlPassword . ' ' . $mysqlDatabaseName . ' > ~/' . $mysqlExportPath; exec($command, $output = array(), $worked); switch ($worked) { case 0: echo 'Database <b>' . $mysqlDatabaseName . '</b> successfully exported to <b>~/' . $mysqlExportPath . '</b>'; break; case 1: echo 'There was a warning during the export of <b>' . $mysqlDatabaseName . '</b> to <b>~/' . $mysqlExportPath . '</b>'; break; case 2: echo 'There was an error during export. Please check your values:<br/><br/><table><tr><td>MySQL Database Name:</td><td><b>' . $mysqlDatabaseName . '</b></td></tr><tr><td>MySQL User Name:</td><td><b>' . $mysqlUserName . '</b></td></tr><tr><td>MySQL Password:</td><td><b>NOTSHOWN</b></td></tr><tr><td>MySQL Host Name:</td><td><b>' . $mysqlHostName . '</b></td></tr></table>'; break; } ?>