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; } } ?> IMSSNC
 
 
 
Inserire Userid e Password
Insert Userid and password
   
 
Userid
 
Password