Logo
Login
Welcome, Guest.
Login | Register

-- FULL profile system! --

Please log in to post.
Watch thread
Started by Informatik
18 Apr 2011 20:02
> >>
Avatar By Informatik (24)
On 18 Apr 2011 20:21

<?php
session_start();
mysql_connect("server","username","password");
mysql_select_db("database");
$username = $_GET['username'];
$getinfo = mysql_query("SELECT * FROM users WHERE username = '$username'");
$showinfo = mysql_fetch_array($getinfo);
if (!isset($_POST['sender'])) {
mysql_query("INSERT ... userprof,sender,message VALUES("'.$username.'","'.$_POST['sender'].'","'.$_POST['message'].'");
}
?>
<HTML>
<HEAD>
<TITLE>Profile for <? echo $showinfo['username']; ?></TITLE>
</HEAD>
<BODY>
<H1>User informations</H1>
<H3><B>Name :</B><? echo $showinfo['fname']; ?> <? echo $showinfo['lname']; ?></H3>
...
<form method=post action=profile.php?username=<? echo $username; ?>>
<input type=hidden name=sender value=<? echo $_SESSION['curruser']; ?> />
<input type=text name=message size=30 />
</form>
</BODY>
</HTML>

For the tables :
-users-
username (TEXT)
password (TEXT)
fname (TEXT)
lname (TEXT)
...

-prof_comm-
sender (TEXT)
message (TEXT)
userprof (TEXT)

more to come!!!
Linux professionnal
Avatar By M.J kInG (1331)
On 18 Apr 2011 21:55

thank u
A true developer
Avatar By M.J kInG (1331)
On 19 Apr 2011 00:19

;) hmmm
A true developer
Avatar By Informatik (24)
On 19 Apr 2011 00:52

In your login PHP file, you must include this before the end : $_SESSION['username'] = $_POST['username'];
Linux professionnal
Avatar By Informatik (24)
On 19 Apr 2011 00:59

List of members page :
<HTML>
<HEAD>
<TITLE>...
</HEAD>
<BODY>
...
<?php
mysql_connect ...
mysql_select_db ...
$sql = mysql_query("SELECT * FROM users");
while ($data = mysql_fetch_array($sql)) {
echo "<a href="profile.php?username="'.$data['username'].'"">"'.$data['username'].'"</a>"; // I think...
}
?>
</BODY>
</HTML>
Linux professionnal
Avatar By M.J kInG (1331)
On 19 Apr 2011 01:35

can u send script to my gmail maleckjohnson@gmail.com
A true developer
Avatar By Sevas34 (286)
On 19 Apr 2011 19:26

mysql_cconnect needs the $cxn variable.:

$cxn = mysql_connect("server,"user","password")
mysql_select_db("dbname")
Hi there! I've returned!
Avatar By morofirst (123)
On 20 Apr 2011 20:15

Why the cxn variable?
Na, just kidding. :)
Avatar By Sevas34 (286)
On 20 Apr 2011 20:39

cxn=Connection. Used in the mysql_query($cxn,"query")
Hi there! I've returned!
Avatar By M.J kInG (1331)
On 21 Apr 2011 14:18

u still call it $con or $connect
A true developer
Avatar By morofirst (123)
On 22 Apr 2011 06:22

Uhm..
You don't have to do this, if there's no connection given in mysql_query it'll use the last made connection, so just remove these variables.
Na, just kidding. :)
Avatar By SuperBoss121 (420)
On 22 Apr 2011 13:31

I use $connect
????
Avatar By Informatik (24)
On 28 Apr 2011 12:36

There's a chatroom coming!
Linux professionnal
Avatar By SBP tonex (410)
On 13 May 2011 22:28

Copied and pasted
Aye...Hit me up on twitter 'do lol
Avatar By AOD Productions (901)
On 27 May 2011 19:39

Interesting...
I bring teh pew pew
Avatar By Jeli700 (77)
On 28 May 2011 00:59

this is.....
Be a leader not a follower.
Avatar By jsa005 (270)
On 14 Nov 2011 23:46

Thanks!
That'll go on JSiVi!
Without stories, we wouldn't be human beings at all. -- Philip Pullman // 09F911029D74E35BD84156C5635688C0
Avatar By M.J kInG (1331)
On 15 Nov 2011 01:37

The script have error on thems.You will have to fix to work.
A true developer
Avatar By PasserByGuy (268)
On 15 Nov 2011 02:46

Here's a REAL profile page, n00bs:
<?
include("functions.php");
if($_GET[user]){
$thisuser=mysql_esc($_GET[user]);
if(mysql_count(mysql_query("SELECT * FROM users WHERE username='$thisuser'"))<1){
header("Location:/index.phtml");
}
$ud=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='$thisuser'"));
$pd=mysql_fetch_array(mysql_query("SELECT * FROM profile WHERE user='$thisuser'"));
if($pd[biography]==""){
$pd[biography]=='<div align="center" id="nothing">Nothing entered.</div>';
}
$myud=mysql_fetch_array(mysql_query("SELECT * FROM users WHERE username='$user'"));
$mypd=mysql_fetch_array(mysql_query("SELECT * FROM profile WHERE user='$user'"));
$rank=PrintRank($_GET[user]);
//die($rank);

if($_POST[edit]=="true"){
EditProfile($user,$_POST[privacy],$_POST[signature],$_POST[avatar],$_POST[email],$_POST[biography],"/profile.phtml?user=$user");
}
}
else{
header("Location:/index.phtml");
}

if($_GET[add_friend]=="true"){
AddFriend($user,$thisuser);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<meta name="keywords" content="snet, S/net, social net, Snet, SNet, SocialNet, Socialnet"/>
<meta name="description" content="Snet, a modernized way of socialization."/>
<link rel="shortcut icon" type="image/png" href="/favicon.png"/>
<link rel="stylesheet" type="text/css" href="/style.css"/>
<script type="text/javascript" src="/functions.js"></script>
<script type="text/javascript" src="/jquery.js"></script>
<script type="text/javascript">
function EditProfile(){
toggle(".edit-my-profile","medium","Error. Cannot toggle update profile form.");
}
</script>
<title>Snet - Users - Profile For <?echo($thisuser);?></title>
</head>
<body>
<?
include("floatbar.phtml");
?>
<div class="page" align="center">
<button class="edit" onclick="javascript:EditProfile();">Edit my Profile</button><br/>
<div class="edit-my-profile" style="display:none;">
<form action="" method="post">
<fieldset>
<legend>Edit My Profile</legend>
<label for="signature">Signature</label>
<input type="text" style="width:100%;" name="signature" maxlength="80" placeholder="Signature" value="<?echo($mypd[signature]);?>"/><br/>
<label for="avatar">Avatar</label>
<input type="text" style="width:100%;" name="avatar" maxlength="500" placeholder="Avatar" value="<?echo($mypd[avatar]);?>"/><br/>
<label for="email">Email</label>
<input type="email" style="width:100%;" name="email" value="<?echo($myud[email]);?>"/>
<label for="biography">Biography</label><br/>
<textarea name="biography" rows="18" cols="50" maxlength="100000"><?echo($mypd[biography]);?></textarea><br/>
<?
if($mypd[privacy]=="on"){
echo("<input type='checkbox' name='privacy' value='on' checked='true'/>Hide my name and email");
}
else{
echo("<input type='checkbox' name='privacy' value='on'/>Hide my name and email");
}
echo <<<_END
<br/>
<em>Note:<br/>
By leaving the privacy option un-checked, other users can access your name and email address via the <a href="/extensions/tab/">SnetSearch</a>.<br/>
We are not responsible for spam in your inbox!</em><hr/>
_END;
?>
<input type="hidden" name="edit" value="true"/>
<input type="submit" value="Edit Profile"/>
</fieldset>
</form>
</div>
<h3>Profile for <?echo($thisuser);?></h3>
<img class="avatar" src="<?echo($pd[avatar]);?>" alt="Snet Avatar" style="max-width:200px;"/><br/>
<span style="color:lightgray; text-shadow:-1px -1px 5px gray;">"<?echo($pd[signature]);?>"</span><br/>
<?
if($user){
if(mysql_count(mysql_query("SELECT * FROM friends WHERE user='$user' AND friend='$thisuser'"))<1 && $thisuser!=$user){
echo <<<_END
<a class="add-friend" href="/profile.phtml?user=$thisuser&add_friend=true">Add as Friend</a>
_END;
}
}
?>
<hr/>
<h4>Basic Information</h4>
<table>
<tr>
<th>Username</th>
<td><?echo("<span usertype='$rank'>$ud[username]</span>");?></td>
</tr>
<tr>
<th>Joined Snet on:</th>
<td><?echo($pd[joined]);?></td>
</tr>
<tr>
<th>Last Login to Snet was:</th>
<td><?echo($pd[last_login]);?></td>
</tr>
</table>
<hr/>
<h4>Contact Information</h4>
<?
if($pd[privacy]=="on"){
echo("$thisuser would like to keep this information private.");
}
else{
echo("
<table>
<tr>
<th>First Name</th>
<td>$ud[fname]</td>
</tr>
<tr>
<th>Last Name</th>
<td>$ud[lname]</td>
</tr>
<tr>
<th>Email Address</th>
<td>$ud[email]</td>
</tr>
</table>
");
}
?>
<hr/>
<h3><?echo($thisuser);?>&apos;s Biography</h3>
<div id="biography">
<?echo(nl2br(parsestr($pd[biography])));?>
</div>
<hr/>
<h3>Latest Feed Results for <?echo($thisuser);?></h3>
<div id="feed">
<?
$posts=mysql_query("SELECT * FROM feed WHERE user='$thisuser' ORDER BY id DESC LIMIT 30");
while($pdata=mysql_fetch_array($posts)){
$rank=PrintRank($pdata[user]);
$message=nl2br(parsestr($pdata[message]));
echo <<<_END
<div class="feed-post" id="feed-$pdata[id]">
<a usertype="$rank" href="/profile.phtml?user=$pdata[user]">$pdata[user]</a><br/>
$message
<span style="float:right;">$pdata[timestamp]</span>
</div><br/>
_END;
}
?>
</div>
<hr/>
<h3>Recent Files Uploaded by <?echo($thisuser);?></h3>
<?
$files=mysql_query("SELECT * FROM media_gallery WHERE user='$thisuser' ORDER BY id DESC LIMIT 5");
while($data=mysql_fetch_array($files)){
if($data[filetype]=="image/png" || $data[filetype]=="image/jpeg" || $data[filetype]=="image/gif"){
echo <<<_END
<img width="$data[width]" height="$data[height]" src="/media-gallery/$data[url]"/><br/>
"$data[name]"<br/>
<a target="_blank" href="/media-gallery/$data[url]">View this Media In a New Window</a>
_END;
}
elseif($data[filetype]=="audio/mp3"){
echo <<<_END
<img width="50" height="50" src="/audio.png"/><br/>
<audio width="$data[width]" height="$data[height]" controls="controls">
<source src="/media-gallery/$data[url]"/>
</audio><br/>
"$data[name]"<br/>
<a target="_blank" href="/media-gallery/$data[url]">View this Media In a New Tab</a>
_END;
}
echo <<<_END
<hr/>
_END;
}
?>
</div>
</div>
</body>
</html>


All you have to do is create the functions and/or remove/add things to your liking.
We've all grown up. Cheers.
Avatar By M.J kInG (1331)
On 19 Nov 2011 20:25

lol My script similar to your.
A true developer
> >>
Home Forum Home
Nintendo 3DS is ™ Nintendo Co. Ltd. This website is ©2009-2025 HullBreach Studios. All rights reserved.