• L
    User •

    Eliminare utenti dal database con Php.

    Salve ragazzi!

    E' sabato e non c'è giorno migliore per aprire la seguente discussione 😛

    Parto postando i file interessati nel problema:

    Preannuncio che parliamo di un sito in php con cui gestisco gli utenti.

    nella cartella "/controlli" ho il file impostazioni_profilo.php

    [PHP]<?php

    if( !$this->network->id ) {
	$this->redirect('home');
}
if( !$this->user->is_logged ) {
	$this->redirect('signin');
}

$this->load_langfile('inside/global.php');
$this->load_langfile('inside/settings.php');

$D->page_title	= $this->lang('settings_profile_pagetitle', array('#SITE_TITLE#'=>$C->SITE_TITLE));

$D->menu_bdate_d	= array();
$D->menu_bdate_m	= array();
$D->menu_bdate_y	= array();
if( $this->user->info->birthdate == '0000-00-00' ) {
	$D->menu_bdate_d[0]	= '';
	$D->menu_bdate_m[0]	= '';
	$D->menu_bdate_y[0]	= '';
}
for($i=1; $i<=31; $i++) {
	$D->menu_bdate_d*	= $i;
}
for($i=1; $i<=12; $i++) {
	$D->menu_bdate_m*	= strftime('%B', mktime(0,0,1,$i,1,2009));
}
for($i=intval(date('Y')); $i>=1900; $i--) {
	$D->menu_bdate_y*	= $i;
}

$D->submit	= FALSE;
$D->error	= FALSE;
$D->errmsg	= '';

$D->name		= $this->user->info->fullname;
$D->location	= $this->user->info->location;
$D->gender		= $this->user->info->gender;
$D->aboutme		= $this->user->info->about_me;
$D->tags		= implode(', ', $this->user->info->tags);
$D->bdate_d		= 0;
$D->bdate_m		= 0;
$D->bdate_y		= 0;
if( $this->user->info->birthdate != '0000-00-00' ) {
	$D->bdate_d		= intval(substr($this->user->info->birthdate,8,2));
	$D->bdate_m		= intval(substr($this->user->info->birthdate,5,2));
	$D->bdate_y		= intval(substr($this->user->info->birthdate,0,4));
}

$u	= $this->user->info;

$tmphash	= md5($u->fullname.$u->location.$u->birthdate.$u->gender.$u->about_me.serialize($u->tags));

if( isset($_POST['sbm']) ) {
	$D->submit	= TRUE;
	$D->name		= trim($_POST['name']);
	$D->location	= trim($_POST['location']);
	$D->gender		= isset($_POST['gender']) ? trim($_POST['gender']) : '';
	$D->aboutme		= trim($_POST['aboutme']);
	$D->tags		= trim($_POST['tags']);
	$D->bdate_d		= intval($_POST['bdate_d']);
	$D->bdate_m		= intval($_POST['bdate_m']);
	$D->bdate_y		= intval($_POST['bdate_y']);
	if( $D->gender!='m' && $D->gender!='f' ) {
		$D->gender	= '';
	}
	if( !isset($D->menu_bdate_m[$D->bdate_m]) || !isset($D->menu_bdate_d[$D->bdate_d]) || !isset($D->menu_bdate_y[$D->bdate_y]) ) {
		$D->bdate_m	= 0;
		$D->bdate_d	= 0;
		$D->bdate_y	= 0;
	}
	if( $D->bdate_d==0 || $D->bdate_m==0 || $D->bdate_y==0 ) {
		$D->bdate_m	= 0;
		$D->bdate_d	= 0;
		$D->bdate_y	= 0;
		$birthdate	= '0000-00-00';
	}
	else {
		$birthdate	= $D->bdate_y.'-'.str_pad($D->bdate_m,2,0,STR_PAD_LEFT).'-'.str_pad($D->bdate_d,2,0,STR_PAD_LEFT);
	}
	$D->tags	= str_replace(array("\n","\r"), ',', $D->tags);
	$D->tags	= preg_replace('/\,+/ius', ',', $D->tags);
	$D->tags	= explode(',', $D->tags);
	foreach($D->tags as $k=>$v) {
		$v	= trim($v);
		if( FALSE == preg_match('/^[a-z&#1072;-&#1103;0-9\-\_\.\s\+]{2,}$/iu', $v) ) {
			unset($D->tags[$k]);
			continue;
		}
		$D->tags[$k]	= $v;
	}
	$D->tags	= implode(', ', $D->tags);
	
	$db2->query('UPDATE users SET fullname="'.$db2->e($D->name).'", about_me="'.$db2->e($D->aboutme).'", tags="'.$db2->e($D->tags).'", gender="'.$db2->e($D->gender).'", birthdate="'.$db2->e($birthdate).'", location="'.$db2->e($D->location).'" WHERE id="'.$this->user->id.'" LIMIT 1');
	
	$this->user->sess['LOGGED_USER']	= $this->network->get_user_by_id($this->user->id, TRUE);
	$this->user->info	= & $this->user->sess['LOGGED_USER'];
	
	$u	= $this->user->info;
	$tmphash2	= md5($u->fullname.$u->location.$u->birthdate.$u->gender.$u->about_me.serialize($u->tags));
	if( $tmphash != $tmphash2 ) {
		$n	= intval( $this->network->get_user_notif_rules($this->user->id)->ntf_them_if_i_edt_profl );
		if( $n == 1 ) {
			$this->load_langfile('inside/notifications.php');
			$this->load_langfile('email/notifications.php');
			$followers	= array_keys($this->network->get_user_follows($this->user->id)->followers);
			foreach($followers as $uid) {
				$send_post	= FALSE;
				$send_mail	= FALSE;
				$n	= intval( $this->network->get_user_notif_rules($uid)->ntf_me_if_u_edt_profl );
				if( $n == 2 ) { $send_post = TRUE; } elseif( $n == 3 ) { $send_mail = TRUE; } elseif( $n == 1 ) { $send_post = TRUE; $send_mail = TRUE; }
				if( $send_post ) {
					$lng	= array('#USER#'=>'<a href="'.$C->SITE_URL.$this->user->info->username.'" title="'.htmlspecialchars($this->user->info->fullname).'"><span class="mpost_mentioned">@</span>'.$this->user->info->username.'</a>');
					$this->network->send_notification_post($uid, 0, 'msg_ntf_me_if_u_edt_profl', $lng, 'replace');
				}
				if( $send_mail ) {
					$lng_txt	= array('#SITE_TITLE#'=>$C->SITE_TITLE, '#USER#'=>'@'.$this->user->info->username, '#NAME#'=>$this->user->info->fullname, '#A0#'=>$C->SITE_URL.$this->user->info->username);
					$lng_htm	= array('#SITE_TITLE#'=>$C->SITE_TITLE, '#USER#'=>'<a href="'.$C->SITE_URL.$this->user->info->username.'" title="'.htmlspecialchars($this->user->info->fullname).'" target="_blank">@'.$this->user->info->username.'</a>', '#NAME#'=>$this->user->info->fullname, '#A0#'=>'');
					$subject		= $this->lang('emlsubj_ntf_me_if_u_edt_profl', $lng_txt);
					$message_txt	= $this->lang('emltxt_ntf_me_if_u_edt_profl', $lng_txt);
					$message_htm	= $this->lang('emlhtml_ntf_me_if_u_edt_profl', $lng_htm);
					$this->network->send_notification_email($uid, 'u_edt_profl', $subject, $message_txt, $message_htm);
				}
			}
		}
	}
}

$this->load_template('impostazioni_profilo.php');

    ?>[/PHP]

    Il file Template impostazioni_profilo.php contiene invece:

    [PHP]<?php

    $this->load_template('header.php');

    ?>
    <div id="settings">
    <div id="settings_left">
    <div class="ttl" style="margin-right:12px;"><div class="ttl2"><h3><?= $this->lang('settings_menu_title') ?></h3></div></div>
    <div class="sidenav">
    <a href="<?= $C->SITE_URL ?>settings/profile" class="onsidenav"><?= $this->lang('settings_menu_profile') ?></a>
    <a href="<?= $C->SITE_URL ?>settings/contacts"><?= $this->lang('settings_menu_contacts') ?></a>
    <a href="<?= $C->SITE_URL ?>settings/avatar"><?= $this->lang('settings_menu_avatar') ?></a>
    <a href="<?= $C->SITE_URL ?>settings/esporta">Esporta Profilo</a>
    <a href="<?= $C->SITE_URL ?>settings/password"><?= $this->lang('settings_menu_password') ?></a>
    <a href="<?= $C->SITE_URL ?>settings/system"><?= $this->lang('settings_menu_system') ?></a>
    <a href="<?= $C->SITE_URL ?>settings/notifications"><?= $this->lang('settings_menu_notif') ?></a>
    <?php if( function_exists('curl_init') ) { ?>
    <a href="<?= $C->SITE_URL ?>settings/rssfeeds"><?= $this->lang('settings_menu_rssfeeds') ?></a>
    <?php } ?>
    </div>
    </div>
    <div id="settings_right">
    <?php if($D->submit) { ?>
    <?= okbox($this->lang('st_profile_ok'), $this->lang('st_profile_okmsg')) ?>
    <?php } ?>
    <div class="ttl"><div class="ttl2">
    <h3><?= $this->lang('settings_profile_ttl2') ?></h3>
    <a class="ttlink" href="<?= $C->SITE_URL ?><?= $this->user->info->username ?>/tab:info"><?= $this->lang('settings_viewprofile_link') ?></a>
    </div></div>
    <form method="post" action="">
    <table id="setform" cellspacing="5">
    <tr>
    <td class="setparam"><?= $this->lang('st_profile_name') ?></td>
    <td><input type="text" name="name" value="<?= htmlspecialchars($D->name) ?>" class="setinp" maxlength="255" /></td>
    </tr>
    <tr>
    <td class="setparam"><?= $this->lang('st_profile_location') ?></td>
    <td><input type="text" name="location" value="<?= htmlspecialchars($D->location) ?>" class="setinp" maxlength="255" /></td>
    </tr>
    <tr>
    <td class="setparam"><?= $this->lang('st_profile_birthdate') ?></td>
    <td>
    <select name="bdate_d" class="setselect" style="width:55px;">
    <?php foreach($D->menu_bdate_d as $k=>$v) { ?>
    <option value="<?= $k ?>"<?= $k==$D->bdate_d?' selected="selected"':'' ?>><?= $v ?></option>
    <?php } ?>
    </select>
    <select name="bdate_m" class="setselect" style="width:130px;">
    <?php foreach($D->menu_bdate_m as $k=>$v) { ?>
    <option value="<?= $k ?>"<?= $k==$D->bdate_m?' selected="selected"':'' ?>><?= $v ?></option>
    <?php } ?>
    </select>
    <select name="bdate_y" class="setselect" style="width:70px;">
    <?php foreach($D->menu_bdate_y as $k=>$v) { ?>
    <option value="<?= $k ?>"<?= $k==$D->bdate_y?' selected="selected"':'' ?>><?= $v ?></option>
    <?php } ?>
    </select>
    </td>
    </tr>
    <tr>
    <td class="setparam" valign="top"><?= $this->lang('st_profile_gender') ?></td>
    <td>
    <label><input type="radio" name="gender" value="m" <?= $D->gender=='m'?'checked="checked"':'' ?> /> <span><?= $this->lang('st_profile_gender_m') ?></span></label>
    <label><input type="radio" name="gender" value="f" <?= $D->gender=='f'?'checked="checked"':'' ?> /> <span><?= $this->lang('st_profile_gender_f') ?></span></label>
    </td>
    </tr>
    <tr>
    <td class="setparam" valign="top"><?= $this->lang('st_profile_aboutme') ?></td>
    <td><textarea name="aboutme" class="setinp" style="height:90px;"><?= htmlspecialchars($D->aboutme) ?></textarea></td>
    </tr>
    <tr>
    <td class="setparam" valign="top"><?= $this->lang('st_profile_tags') ?></td>
    <td><textarea name="tags" class="setinp"><?= htmlspecialchars($D->tags) ?></textarea></td>
    </tr>
    <tr>
    <td></td>
    <td><input type="submit" name="sbm" value="<?= $this->lang('st_profile_savebtn') ?>" style="padding:4px; font-weight:bold;"/></td>
    </tr>
    </table>
    </form>
    </div>
    </div>
    <?php

    $this->load_template('footer.php');

    ?>[/PHP]

    e nella root principale ho il file di configurazione config.php che contiene:

    [PHP]// MySQL SETTINGS
    //
    $C->DB_HOST = 'host';
    $C->DB_USER = 'sqluser';
    $C->DB_PASS = 'pass';
    $C->DB_NAME = 'nome db';

    e altro... [/PHP]

    Come è facile intuire, il database del mio sito contiene una tabella chiamata users in cui ci sono tutti i dati degli utenti (username, email, password, tel., link facebook etc.)

    Mi sapete dire come fare per creare un link - nella pagina impostazioni - tramite cui l'utente possa eliminare il proprio account? Cerco in rete da giorni ma non ho trovato nulla di buono, non mi funzionano i codici che ho provato.

    Chi sa aiutarmi?

    0
  • S
    User •

    scusa la domanda...quindi vuoi semplicemente cancellare un utente dalla tabella users?

    0
  • L
    User •

    si e sto impazzendo...

    0
  • S
    User •

    Una prima idea(alquanto brutale :smile5:) potrebbe essere modificare il Template impostazioni_profilo.php aggiungendo al fianco del bottone per il submit un link del tipo
    [HTML]<a href="cancella.php?id=<id_utente>">Cancella Account</a>[/HTML]
    inserendo al posto di <id_utente> il relativo valore, dopo di che nella pagina cancella.php ricavi l'id dell'utente da cancellare con
    [PHP]$id = $_REQUEST['id'];[/PHP]
    e crei la query per la cancellazione..

    Spero di essere stato chiaro :sun:

    0
Effettua l'accesso per rispondere