Billede på *Bruger profil* mySQL
Jeg er ved at modificere det chat script der hedder 1906_MiniChat3-1.. og have at man skal kunne uploade et billede af sig selv på sin egen profil.selve *user profile* siden ser således ud:
<?
require("config.php");
require("funktioner.php");
$brugerinfo = brugerinfo($_COOKIE[minichat3_id]);
checksession($brugerinfo[sesid]);
$normal = "#eeeeee";
$hover = "#dddddd";
if ($_POST[action] == "update"){
$free_text = format($_POST[free_text]);
$free_text = nl2br($free_text);
$email = htmlentities($_POST[email]);
$age = format($_POST[age]);
mysql_query("UPDATE chatuser SET free_text='$free_text',email='$email',age='$age' where id='$brugerinfo[uid]'") or die (mysql_error());
WriteToRemote("",$brugerinfo[id],"Your userinformation has been updated!");
header("Location: top.php");
}
?>
<HTML>
<HEAD>
<link rel="stylesheet" type="text/css" HREF="style.css">
</HEAD>
<BODY>
<br>
<?
if ($_GET[action] == "edit"){
?>
<table width="70%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center" CLASS="alm-text">
<tr bordercolor="#84B0DD">
<td bgcolor="#84B0DD">
<div align="center"><b>Profile</b></div>
</td>
</tr>
<tr bgcolor="#eeeeee" onMouseOver="style.backgroundColor='<?=$hover;?>';" onMouseOut="style.backgroundColor='<?=$normal;?>';" bordercolor="#eeeeee">
<td><center><b>- <?=$brugerinfo[nick];?> - </b></center></td>
</tr>
</table>
<br>
<br>
<form action=profile.php method=post>
<? $res = mysql_query("SELECT * FROM chatuser where id='$brugerinfo[uid]'");
$row = mysql_fetch_array($res);?>
<table width="70%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center" CLASS="normal">
<tr bordercolor="#84B0DD">
<td bgcolor="#84B0DD" bordercolor="#84B0DD" width="23%">
<div align="left"><b>Nick</b></div>
</td>
<td bgcolor="#eeeeee" bordercolor="#eeeeee" width="77%">
<div align="left">
<?=$brugerinfo[nick];?>
</div>
</td>
</tr>
<tr bgcolor="#eeeeee" onMouseOver="style.backgroundColor='<?=$hover;?>';" onMouseOut="style.backgroundColor='<?=$normal;?>';" bordercolor="#eeeeee">
<td width="23%" bordercolor="#84B0DD" bgcolor="#84B0DD">
<div align="left"><b>Age</b></div>
</td>
<td width="77%">
<div align="left">
<input type="text" name="age" value="<?=$row[age];?>">
</div>
</td>
</tr>
<tr bgcolor="#eeeeee" onMouseOver="style.backgroundColor='<?=$hover;?>';" onMouseOut="style.backgroundColor='<?=$normal;?>';" bordercolor="#eeeeee">
<td width="23%" bordercolor="#84B0DD" bgcolor="#84B0DD"><b>Email adress</b></td>
<td width="77%">
<input type="text" name="email" value="<?=$row[email];?>">
</td>
</tr>
<tr bgcolor="#eeeeee" onMouseOver="style.backgroundColor='<?=$hover;?>';" onMouseOut="style.backgroundColor='<?=$normal;?>';" bordercolor="#eeeeee">
<td width="23%" bordercolor="#84B0DD" bgcolor="#84B0DD" valign="top"><b>Text
of choise</b></td>
<td width="77%">
<textarea name="free_text" rows="4" cols="40"><?=br2nl($row[free_text]);?></textarea>
</td>
</tr>
<tr bgcolor="#eeeeee" onMouseOver="style.backgroundColor='<?=$hover;?>';" onMouseOut="style.backgroundColor='<?=$normal;?>';" bordercolor="#eeeeee">
<td width="23%" bordercolor="#84B0DD" bgcolor="#84B0DD" valign="top"><b>Update</b></td>
<td width="77%">
<input type="hidden" name="action" value="update">
<input type="submit" name="update" value="Update your information">
</td>
</tr>
</table>
</form>
<? }
elseif ($_GET[id]){
$remoteses = brugerinfo($_GET[id]);
$remote_res = mysql_query("SELECT * FROM chatuser where id='$remoteses[uid]'");
$remote = mysql_fetch_array($remote_res);?>
<table width="70%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center" class="normal">
<tr>
<td bgcolor="#84B0DD" bordercolor="#84B0DD">
<div align="center"><b>Userprofile for
<?=$remote[nick];?></b>
</div>
</td>
</tr>
<tr>
<td bgcolor="#eeeeee" bordercolor="#eeeeee">To write something about yourself
click <a href="profile.php?action=edit">here</a></td>
</tr>
</table>
<br>
<table width="70%" border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" align="center" class="normal">
<tr>
<td bgcolor="#84B0DD" bordercolor="#84B0DD" width="23%"><b>Nick</b></td>
<td bgcolor="#eeeeee" bordercolor="#eeeeee" width="77%">
<?=$remote[nick];?>
</td>
</tr>
<tr>
<td bgcolor="#84B0DD" bordercolor="#84B0DD" width="23%"><b>Age</b></td>
<td bgcolor="#eeeeee" bordercolor="#eeeeee" width="77%">
<?=$remote[age];?>
</td>
</tr>
<tr>
<td bgcolor="#84B0DD" bordercolor="#84B0DD" width="23%"><b>Email</b></td>
<td bgcolor="#eeeeee" bordercolor="#eeeeee" width="77%">
<?=$remote[email];?>
</td>
</tr>
<tr>
<td bgcolor="#84B0DD" bordercolor="#84B0DD" width="23%" valign="top"><b>Text of choise</b></td>
<td bgcolor="#eeeeee" bordercolor="#eeeeee" width="77%">
<?=$remote[free_text];?>
</td>
</tr>
</table>
<? } ?>
<br>
<div align="center" CLASS="alm-text"><a href=\"java script:top.close()\">Close</a></div>
</BODY>
så det jeg har brug for er et felt/link med *Upload Image*
med:
/browse funktion
/max 30kb size
/et *standart* billede hvis brugeren ikke har uploadet billede
/og evt. admin godkendelse af billedet ( dog ikke vigtigt)
jeg ved ikke om jeg skal bruge mySQL database til at holde styr på billederne eller hvordan?..
Håber i kan hjælpe!!
