//##### VARIABILI_DB_DATI_UTENTI #####
//$db_host = "localhost";
//$db_port = "";
//$db_user = "";
//$db_password = "";
//$db_name = "imssnc";
//##### VARIABILI_DB_DATI_UTENTI #####
$db_host = "ptah05.seeweb.it";
$db_port = "";
$db_user = "imssnc_it28735";
$db_password = "ims20530";
$db_name = "imssnc_it28735";
?>
require_once("DBConnection.class.inc" );
require_once("DateTimeUtilities.class.inc");
require_once("UserData.class.inc") ;
class DBCommon extends DBConnection
{
function DBCommon( $host, $port , $db_name , $user, $password )
{
parent::DBConnection( $host, $port , $db_name , $user, $password ) ;
}
function validateUser( $userid, $password )
{
$queryString = "SELECT * FROM utenti WHERE userid = '$userid' AND password='$password'";
$resultSet = mysql_db_query( $this->getDbName() , $queryString )
or die( "DBCommon::validateUser() [" . $this->getErrorMsg() . "][" . $queryString . "]" ) ;
$count = mysql_affected_rows() ;
if( $count == 0 )
{
return false;
}
else
{
return true;
}
}
//
function getUserData( $userid )
{
$queryString = "SELECT * FROM utenti WHERE userid = '$userid' ";
$result = mysql_db_query( $this->getDbName() , $queryString )
or die( "DBCommon::getUserData() [" . $this->getErrorMsg() . "][" . $queryString . "]" ) ;
$count = mysql_affected_rows() ;
if( $count == 1 )
{
$dbrow = mysql_fetch_array( $result, MYSQL_ASSOC ) ;
mysql_free_result( $result ) ;
$user = new UserData( $dbrow["userid"], $dbrow["password"], $dbrow["attivo"], $dbrow["ruolo"]) ;
return $user ;
}
else
{
die( "DBCommon::getUserData() [ dati errati ][". $queryString . "]" ) ;
}
}
function getarea( $userid )
{
$queryString = "SELECT * FROM utente_aree WHERE userid = '$userid'";
$resultSet = mysql_db_query( $this->getDbName() , $queryString )
or die( "DBCommon::getarea() [" . $this->getErrorMsg() . "][" . $queryString . "]" ) ;
$dbrow = mysql_fetch_array( $resultSet, MYSQL_ASSOC ) ;
mysql_free_result( $resultSet ) ;
return $dbrow["idarea"] ;
}
function addUser( $nome, $cognome, $userid, $password, $email, $attivo )
{
$insquery = "INSERT INTO utenti (nome, cognome, userid, password, email, attivo, ruolo) ";
$insquery .= "VALUES ('$nome','$cognome', '$userid', '$password', '$email', '$attivo', 'user')";
$result = mysql_db_query( $this->getDbName(), $insquery)
or die("DBCommon::addUser() - 3 -
" . $this->getErrorMsg() . "
[" .$insquery . "]" );
return $result;
}
function addUserArea( $userid, $area )
{
$insquery = "INSERT INTO utente_aree (userid, idarea) ";
$insquery .= "VALUES ('$userid', '$area')";
$result = mysql_db_query( $this->getDbName(), $insquery)
or die("DBCommon::addUserArea() - 3 -
" . $this->getErrorMsg() . "
[" .$insquery . "]" );
return $result;
}
function UserExist( $user )
{
$queryString = "SELECT userid FROM utenti WHERE userid = '$user' ";
$result = mysql_db_query( $this->getDbName() , $queryString )
or die( "DBCommon::UserExist() [" . $this->getErrorMsg() . "][" . $queryString . "]" ) ;
$count = mysql_affected_rows() ;
if ( $count == 0 )
{
return false;
}
return true;
}
function getUtenti( &$count , &$result_set )
{
$querystring = "SELECT * FROM utenti ";
$result = mysql_db_query( $this->getDbName() , $querystring )
or die( "DBCommon::getUtenti() " . $this->getErrorMsg() );
while( $db_row = mysql_fetch_array( $result, MYSQL_ASSOC) )
{
$result_set[]= $db_row ;
}
$count = mysql_affected_rows() ;
mysql_free_result( $result ) ;
}
function getUtente( $userid, &$result_set )
{
$querystring = "SELECT * FROM utenti WHERE userid='$userid'";
$result = mysql_db_query( $this->getDbName() , $querystring )
or die( "DBCommon::getUtente() " . $this->getErrorMsg() );
$result_set = mysql_fetch_array( $result, MYSQL_ASSOC);
mysql_free_result( $result ) ;
}
function getAreaUtente( $userid, &$result_set )
{
$querystring = "SELECT * FROM utente_aree WHERE userid='$userid'";
$result = mysql_db_query( $this->getDbName() , $querystring )
or die( "DBCommon::getAreaUtente() " . $this->getErrorMsg() );
$result_set = mysql_fetch_array( $result, MYSQL_ASSOC);
mysql_free_result( $result ) ;
}
function updUser( $nome, $cognome, $userid, $password, $email, $attivo )
{
$updquery = "UPDATE utenti SET nome='$nome', cognome='$cognome', password='$password', email='$email', attivo='$attivo' WHERE userid='$userid' ";
$result = mysql_db_query( $this->getDbName(), $updquery)
or die("DBCommon::updUser() - 3 -
" . $this->getErrorMsg() . "
[" .$updquery . "]" );
return $result;
}
function updUserArea( $userid, $area )
{
$updquery = "UPDATE utente_aree SET idarea='$area' WHERE userid='$userid' ";
$result = mysql_db_query( $this->getDbName(), $updquery)
or die("DBCommon::updUserArea() - 3 -
" . $this->getErrorMsg() . "
[" .$updquery . "]" );
return $result;
}
function delUtente( $userid)
{
$delquery = "DELETE FROM utenti WHERE userid='$userid' ";
$result = mysql_db_query( $this->getDbName(), $delquery)
or die("DBCommon::delUtente() - 3 -
" . $this->getErrorMsg() . "
[" .$delquery . "]" );
return $result;
}
function delUtente_aree( $userid)
{
$delquery = "DELETE FROM utente_aree WHERE userid='$userid' ";
$result = mysql_db_query( $this->getDbName(), $delquery)
or die("DBCommon::delUtente() - 3 -
" . $this->getErrorMsg() . "
[" .$delquery . "]" );
return $result;
}
}
?>