Script Profilul Meu

[MelecaCristian]

Buna useri Marplo deci am si eu un site si am membrii totali pe site dar utilizatorul inregistrat nu isi poate edita profilul stiti vreun script ce poate face asta de ex sa fie :

Nume : Marplo

Tara : Romania

Oras : Timisoara

Varsta : 18 ani

...

Si dupa aceste date sa fie jos sau undeva editeaza profil sa isi poata modifica datele daca vor se poate ???

PS. Folosesc scriptul de inregistrare de pe site

Multumesc

index.php

Cod: Selectaţi tot

<?php
$id = $_SESSION['SESS_ID']; 
$sql="SELECT `id`, nume, `prenume`, `email`, `localitate`, `religie`, `data_nasterii`,`ocupatie`,`motto`, `verset`, `despre_mine`, `judet`, `tara` FROM `members` WHERE `id`='$id' LIMIT 1";
$rezultat = mysql_query($sql);
if (mysql_num_rows($rezultat) == 0) {}
else {
while ($rand = mysql_fetch_assoc($rezultat)) {
    echo '<b>Nume: </b> '.$rand['nume'].'<br>';
	echo '<b>Prenume: </b> '.$rand['prenume'].'<br>';
	echo '<b>Data nasterii: </b> '.$rand['data_nasterii'].'<br>';
	echo '<b>Versetul preferat: </b><i> '. $rand['verset'].'</i><br><br>';
	echo '<font size="3" color="red"><b>Adresa</b></font>';
	echo '<hr />';
	echo '<b>Localitate: </b> '.$rand['localitate'].'<br>';
	echo '<b>Judet: </b> '.$rand['judet'].'<br>';
	echo '<b>Tara: </b> '.$rand['tara'].'<br><br>';
	echo '<font size="3" color="red"><b>Contact</b></font>';
	echo '<hr />';
	echo '<b>E-mail: </b> '.$rand['email'].'<br><br>';
	echo '<font size="3" color="red"><b>Despre mine</b></font>';
	echo '<hr />';
	echo '<b>Ocupatie: </b> '.$rand['ocupatie'].'<br>';
	echo '<b>Religie: </b> '.$rand['religie'].'<br>';
	echo '<b>Motto: </b><i> '.$rand['motto'].'</i><br>';
	echo '<b>Despre mine: </b> '.$rand['despre_mine'].'<br>';
  }
} 
?>    
		    <p align="right"><?php
$id = $_SESSION['SESS_ID'];
$query="SELECT `id` FROM `members` WHERE `id`='$id'";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
  $rand=mysql_fetch_array($result);
	echo '<a href="profil_actualizat.php?id='.$rand['id'].' "><center>Editare profil</center> </a> ';
    ++$i;
} 
?>

profil_actualizat.php

Cod: Selectaţi tot

 <?php
$utilizator=mysql_real_escape_string($_GET['id']);
// Se verifica daca sunt date de la formular
if (isset($_POST['nume']) && isset($_POST['email'])) {
// Se preiau datele
$id=trim($_POST['id']);
$nume=$_POST['nume'];
$prenume=$_POST['prenume'];
$data_nasterii=$_POST['data_nasterii'];
$email=$_POST['email'];
$localitate=$_POST['localitate'];
$judet=$_POST['judet'];
$tara=$_POST['tara'];
$religie=$_POST['religie'];
$ocupatie=$_POST['ocupatie'];
$motto=$_POST['motto'];
$verset=$_POST['verset'];
$despre_mine=$_POST['despre_mine'];
// Se face Update
$cerereSQL = "UPDATE `members` SET `id`='".$id."', `nume`='".$nume."', `prenume`='".$prenume."', `data_nasterii`='".$data_nasterii."', `email`='".$email."', `localitate`='".$localitate."', `judet`='".$judet."', `tara`='".$tara."', `religie`='".$religie."', `ocupatie`='".$ocupatie."', `motto`='".$motto."',`verset`='".$verset."', `despre_mine`='".$despre_mine."' WHERE `id`='".$id."' LIMIT 1";
mysql_query($cerereSQL) or die("NU se poate adauga!");
}
// Se face Select-ul pt. afisarea lor
$cerereSQL = 'SELECT * FROM members WHERE id="'.$_GET['id'].'"'; 
$rezultat = mysql_query($cerereSQL);
$num=mysql_num_rows($rezultat);
if ( $num <> 0 )
{
  $rand=mysql_fetch_array($rezultat);
  print '<form action="profil_actualizat.php?id='.$rand['id'].'" method="post">';
  print  '<left>';
  print  '<table  border="0">';
  print  '<tr > <th width="110"><div align="left"> Nr. inreg: </th> <th> <div align="left"><input name="id" readonly= "true" type="text" value="'.$rand['id'].'" > </div></th> ';
  print  '<tr > <th width="110"><div align="left"> Nume: </th> <th> <div align="left"><input name="nume" type="text" value="'.$rand['nume'].'" > </div></th> ';
  print  '<tr> <th width="110"><div align="left"> Prenume: </th> <th><div align="left"> <input name="prenume" type="text" value="'.$rand['prenume'].'" > </div> </th>';
  print  '<tr> <th width="110"><div align="left"> Data nasterii:</th> <th> <div align="left"><input type="text" name="data_nasterii"  id="data_nasterii" value="'.$rand['data_nasterii'].'" >  </div></th>';
  print  '<tr> <th width="110"><div align="left"> E-mail: </th> <th><div align="left"> <input name="email" type="text" value="'.$rand['email'].'" > </div></th>';
  print  '<tr> <th width="110"><div align="left"> Localitate: </th><th><div align="left"><input name="localitate" type="text" value="'.$rand['localitate'].'" >  </div></th>';
   print  '<tr> <th width="110"><div align="left"> Judet: </th> <th><div align="left"><select name="judet" id="judet">
    <option checked="checked" value="'.$rand['judet'].'">'.$rand['judet'].'</option>
<option value="Alba">Alba</option>
<option value="Bihor">Bihor</option>
<option value="Din alta tara">Din alta tara</option>
</select> ';
  print  '<tr> <th width="110"><div align="left"> Tara: </th> <th><div align="left"><select name="tara" id="tara">
    <option checked="checked" value="'.$rand['tara'].'">'.$rand['tara'].'</option>
   <option value="-----"> -----</option>
            <option value="Afganistan">Afganistan</option>
            <option value="Albania">Albania</option>
          </select>';
  print  '<tr> <th width="110"><div align="left"> Religie: </th> <th><div align="left"><select name="religie" id="religie">
    <option checked="checked" value="'.$rand['religie'].'">'.$rand['religie'].'</option>
<option value="Baptista">Baptista</option>
<option value="Catolica">Catolica</option>
<option value="Crestina Adventista de Ziua a Saptea">Crestina Adventista de Ziua a Saptea</option>
<option value="Crestina dupa Evanghelie">Crestina dupa Evanghelie</option>
<option value="Alta">Alta</option>
</select>  </div></th>';
  print  '<tr> <th width="110"><div align="left"> Ocupatie: </th> <th><div align="left"><input name="ocupatie" type="text" value="'.$rand['ocupatie'].'" > </div></th>';
  print  '<tr> <th width="110"><div align="left"> Motto: </th> <th><div align="left"><textarea name="motto" cols="40" rows="3" id="motto" >'. $rand['motto'].'</textarea></div></th>';
  print  '<tr> <th width="110"><div align="left"> Versetul preferat: </th> <th><div align="left"><textarea name="verset" cols="40" rows="3" id="verset" >'. $rand['verset'].'</textarea></div></th>';
  print  '<tr> <th width="110"><div align="left"> Despre mine: </th> <th><textarea name="despre_mine" cols="40" rows="3" id="despre_mine" >'. $rand['despre_mine'].'</textarea> </div></th>';
  print  '</tr>';
  print  '</table><br><br>';
  print  '<left>';
  print '<div align="right"><input type="Submit" value="Salvare"> </div>';
  print '</form>'; 

}  
?>

, incerca asta si actualizeaza-l dupa cum ai u bd si tabele. cu stima trif

cum il pot integra in scriptul de login de pe localhost adica unde trebuie sa il modific ?


Ms.

Salut
Scriptul de Inregistrare /Logare de aici: Script Utilizatori - Inregistrare si Autentificare / Logare contine si pagina personala in care utilizatorul poate adauga si modifica date personale.