A php bios (profile) page??? [Archive]

JBChris

09-22-2004, 04:31 AM

Hello to all!
I need to know if anyone knows of a way to create a PHP "bios" page - similar to a forum "profile" page except that it's stand-alone and has more features. Anyone have any suggestions? I would do it myself, but I barely know any PHP. :(

Thanks in advance!
Josh C.

P.S. It has to be in PHP

dniwebdesign

09-22-2004, 05:30 AM

Yea... I believe I have done this already... Take a look at the members section at www.avpclan.ca.tt. Is this what you are looking for?

JBChris

09-23-2004, 06:34 AM

Yes, I need something very similar to that. How would I start?

Josh C.

jamescover

09-23-2004, 07:03 AM

Hi Josh:

In addition to PHP capability, do you also have access to a database, like MySQL?

If so, you could store the information in the db. If not, you could just set up a directory on the server for storing html pages, created to hold member information.

The basic set up is a web form member's can enter their info into, linked to a PHP script that creates the pages. You just convert the web form fields into PHP variables to fill in the blanks in your html template.

-james

JBChris

09-23-2004, 07:38 PM

Yes, I do have a mySQL database. And I think that I might could do what you're saying... I don't know though. I have so little php experience that I would probably be amazed that I could echo the date and time! I'll give it a try though. I may also see what a Content Management System does for me...

Thanks,
Josh C.

dniwebdesign

09-23-2004, 09:46 PM

<?php
$sql = mysql_query("SELECT * FROM avp_members WHERE avpusername='$member'",$connection) or print mysql_error();
$login_check = mysql_num_rows($sql);
if($login_check > 0)
{
while($row = mysql_fetch_array($sql))
{
foreach( $row AS $key => $val )
{
$$key = stripslashes( $val );
} ?>
<table width="75%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="2">Member
Info</td>
<td>Avatar</td>
</tr>
<tr>
<td width="32%" height="29">~AVP~Username:</td>
<td width="24%"><?php echo "$member"; ?></td>
<td width="44%" rowspan="9" valign="top"><div align="center"><img src='http://www.dni-server.no-ip.com/avp.clan/imgs/avatars/<?php echo $row["avatar"]; ?>.jpg' border=1></div></td>
</tr>
<tr>
<td bgcolor="#EEEEEE">Squad:</td>
<td bgcolor="#EEEEEE"><?php echo "$squad"; ?></td>
</tr>
<tr>
<td>Member
Since:</td>
<td><?php echo $row["joined"]; ?></td>
</tr>
<tr>
<td bgcolor="#EEEEEE">Postition:</td>
<td bgcolor="#EEEEEE"><?php echo $row["position"]; ?></td>
</tr>
<tr>
<td>Birthday:</td>
<td><?php echo $row["birthday"]; ?></td>
</tr>
<tr>
<td bgcolor="#EEEEEE">Gender:</td>
<td bgcolor="#EEEEEE"><?php echo $row["gender"]; ?></td>
</tr>
<tr>
<td>Connection:</td>
<td><?php echo $row["connection"]; ?></td>
</tr>
<tr>
<td bgcolor="#EEEEEE">Country:</td>
<td bgcolor="#EEEEEE"><?php echo $row["country"]; ?></td>
</tr>
<tr>
<td>Specialty:</td>
<td><?php echo $row["specialty"]; ?></td>
</tr>
<tr>
<td colspan="3">Communication</td>
</tr>
<tr>
<td bgcolor="#EEEEEE">E-mail:</td>
<td bgcolor="#EEEEEE"><a href='mailto:<?php echo $row["email"]; ?>'><?php echo $row["email"]; ?></a></td>
<td bgcolor="#EEEEEE"> </td>
</tr>
<tr>
<td>MSN:</td>
<td><?php echo $row["msn"]; ?></td>
<td> </td>
</tr>
</table>

<?php }
}?>

This code would select the info from the database where the row avpusername="$member"... The $member variable is set by the URL such as http://www.dni-server.no-ip.com/avp.clan/profile.php?mem=Springer887

by using the $_GET Method like this:

$member = $_GET["mem"];

Just use your own database instead of avp_members.

<?php echo $row["email"]; ?>

This would echo the e-mail for the particular user, which it gets from the email row in your database.

If you have any questions let me know, I'll try to help.