Jump to content

Killkip

New Members
 View Profile  See their activity

  • Posts

    2

  • Joined

  • Last visited

    Never

 Content Type 

Everything posted by Killkip

  1. Killkip
    I'm pretty new to PHP, but I figured I might as well help out other people where I can until my own question is answered. I made profiles for my own site recently so I can supply you my code. It may not be pretty but it's working for me. I hope it is of any use for you. Viewing/editing own profile: <?php session_start(); ?> <html> <head> <title>SQO Stellar Search Database</title> <body> <style> input.submit { display: inline; text-decoration: none; background: none; border: none; } input.submit:hover { text-decoration: underline; } </style> </head> <?php include("mysqlconnect.php"); $gb=$_SESSION['gb']; $edit=$_POST['edit']; $login = mysql_query("SELECT * FROM gebruikers WHERE gebruikersnaam='".$gb."'"); $results = mysql_num_rows($login); $gebr = mysql_fetch_array($login); $admin=$gebr[admin]; if ($results==1){ include("menu.php");} else {include("menu2.php");} if ($results==1 && $edit==0){ echo "<div id='content'>"; echo "<H3><B>Profile:</B></H3> "; echo "<B>Username:</B> "; echo "$gb<BR>"; echo "<B>SQO name:</B> "; echo "$gebr[sqoname] <BR>"; echo "<B>Email:</B> "; echo "$gebr[email]<BR>"; echo "<B>Status:</B> "; if ($gebr[admin]==0){echo "Member <BR>";} if ($gebr[admin]==1){echo "Site Moderator <BR>";} if ($gebr[admin]==2){echo "Site Administrator <BR>";} echo "<B>Systems uploaded:</B> "; echo "$gebr[aantalsystems] <BR>"; echo "<B>Joined:</B> "; echo date("d F Y",$gebr[registerdate]); echo "<BR><BR>"; ?><FORM METHOD="post" ACTION="profile.php" style="display:inline; margin-top:0px; margin-bottom:0px"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>> <INPUT name="edit" type="hidden" <?PHP echo "VALUE='1'";?> > <input type=image name="formEditProfileSubmit" src="edit.jpg" <?php echo" alt='Edit profile data'"; ?> value="Bewerk" /> </FORM> <?php echo "</div>"; } elseif ($results==1 && $edit==1){ echo "<div id='content'>"; echo "<H3><B>Profile:</B></H3> "; ?><FORM METHOD="post" ACTION="changeprofile.php"> <?php echo "<B>Username:</B> "; echo "$gb<BR>"; echo "<B>SQO name:</B> "; echo "<Input name='sqoname' type=text value='$gebr[sqoname]' size=15> <BR>"; echo "<B>Email:</B> "; echo "$gebr[email] <BR>"; echo "<B>Show email:</B> "; if ($gebr[showemail]==0){echo "<input type='radio' name='showemail' value='1'> <font size='2'>Yes</font> &nbsp&nbsp&nbsp&nbsp&nbsp<input type='radio' name='showemail' value='0' checked> <font size='2'>No</font><BR>";} if ($gebr[showemail]==1){echo "<input type='radio' name='showemail' value='1' checked> <font size='2'>Yes</font> &nbsp&nbsp&nbsp&nbsp&nbsp<input type='radio' name='showemail' value='0'> <font size='2'>No</font><BR>";} echo "<B>Status:</B> "; if ($gebr[admin]==0){echo "Member <BR>";} if ($gebr[admin]==1){echo "Site Moderator <BR>";} if ($gebr[admin]==2){echo "Site Administrator <BR>";} echo "<B>Systems uploaded:</B> "; echo "$gebr[aantalsystems] <BR>"; echo "<B>Joined:</B> "; echo date("d F Y",$gebr[registerdate]); ?><BR><BR><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>> <INPUT TYPE="SUBMIT" VALUE="Update Profile"> </FORM><BR><BR><BR> <FORM METHOD="post" ACTION="changepass.php"> <?php echo "<B>Old password:</B> "; echo "<Input name='oldpass' type=password size=15> <BR>"; echo "<B>New password:</B> "; echo "<Input name='newpass' type=password size=15> <BR>"; echo "<B>Retype new password:</B> "; echo "<Input name='newpass2' type=password size=15> <BR>"; ?><BR><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>> <INPUT TYPE="SUBMIT" VALUE="Change Pass"> </FORM> <?php echo "</div>"; } else {echo "<div id='content'>Unexpected error.</div>";} mysql_close(); ?> </body> </html> Searching users profile: <?php session_start(); ?> <html> <head> <title>SQO Stellar Search Database</title> </head> <body> <?php include("mysqlconnect.php"); $gb=$_SESSION['gb']; $login = mysql_query("SELECT * FROM gebruikers WHERE gebruikersnaam='".$gb."'"); $results = mysql_num_rows($login); $gebr = mysql_fetch_array($login); if ($results==0) { include("menu2.php"); echo '<div id="content">'; echo "Access to user info denied for Guests"; echo "</div>"; } else { include("menu.php"); echo '<div id="content">'; ?> <CENTER> <h3><B>Search user</B></h3> <form action="userinfo2.php" method="post"> <input type="hidden" value=<?php echo $gebr[gebruikersnaam]; ?> name="gb"> Search user:<br> <input type="text" name="user"><br> <br><input type="submit" value="Search"></form></center> <?php echo "</div>";} mysql_close(); ?> </body> </html> Displays users info entered in script above: <?php session_start(); ?> <html> <head> <title>SQO Stellar Search Database</title> <body> <style> input.submit { display: inline; text-decoration: none; background: none; border: none; } input.submit:hover { text-decoration: underline; } </style> </head> <?php include("mysqlconnect.php"); $gb=$_POST['gb']; $user=$_POST['user']; $login = mysql_query("SELECT * FROM gebruikers WHERE gebruikersnaam='".$gb."'"); $results = mysql_num_rows($login); $gebr = mysql_fetch_array($login); $admin=$gebr[admin]; if ($results==1){ include("menu.php"); $retrieveuser = mysql_query("SELECT * FROM gebruikers WHERE gebruikersnaam='".$user."'"); $userfound = mysql_num_rows($retrieveuser); $userarray = mysql_fetch_array($retrieveuser); if ($userfound==1){ echo "<div id='content'>"; echo "<H3><B>Profile:</B></H3> "; echo "<B>Username:</B> "; echo "$userarray[gebruikersnaam] <BR>"; echo "<B>SQO name:</B> "; echo "$userarray[sqoname] <BR>"; echo "<B>Status:</B> "; if ($userarray[admin]==0){echo "Member <BR>";} if ($userarray[admin]==1){echo "Site Moderator <BR>";} if ($userarray[admin]==2){echo "Site Administrator <BR>";} echo "<B>Email:</B> "; if ($userarray[showemail]==0){echo "<i>hidden</i> <BR>";} if ($userarray[showemail]==1){echo "$userarray[email] <BR>";} echo "<B>Systems uploaded:</B> "; echo "$userarray[aantalsystems] <BR>"; echo "<B>Joined:</B> "; echo date("d F Y",$userarray[registerdate]); if ($gebr[admin]==2){ echo "<BR><BR><BR><B>Admin control panel: </B><BR>"; if ($userarray[admin]==0){ ?><img src='makemembergray.png' alt='Reset Special Privilages'> <FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='1'";?>> <input type=image name="formEditProfileSubmit" src="addmod.png" <?php echo" alt='Give Moderator Status'";?> value="Bewerk" /></FORM> <FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='2'";?>> <input type=image name="formEditProfileSubmit" src="addadmin.png" <?php echo" alt='Give Admin Status'";?> value="Bewerk" /></FORM> <?php } if ($userarray[admin]==1){ ?><FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='0'";?>> <input type=image name="formEditProfileSubmit" src="makemember.png" <?php echo" alt='Reset Special Privilages'";?> value="Bewerk" /></FORM> &nbsp<img src='addmodgray.png' alt='Give Moderator Status'> <FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='2'";?>> <input type=image name="formEditProfileSubmit" src="addadmin.png" <?php echo" alt='Give Admin Status'";?> value="Bewerk" /></FORM> <?php } if ($userarray[admin]==2){ ?><FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='0'";?>> <input type=image name="formEditProfileSubmit" src="makemember.png" <?php echo "alt='Reset Special Privilages'";?> value="Bewerk"></FORM> <FORM METHOD="post" ACTION="addmodadmin.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>><INPUT name="admin" type="hidden" <?PHP echo "VALUE='1'";?>> <input type=image name="formEditProfileSubmit" src="addmod.png" <?php echo "alt='Give Moderator Status'";?> value="Bewerk"></FORM> &nbsp<img src='addadmingray.png' alt='Give Admin Status'><?php } ?><FORM METHOD="post" ACTION="resetpass.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>><INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?>> <input type=image name="formEditProfileSubmit" src="resetpass.png" <?php echo" alt='Reset Password to 12345'"; ?> value="Bewerk" /></FORM><?php } if ($gebr[admin]==1 && $userarray[admin]==0) { echo "<BR><BR><BR><B>Admin control panel: </B><BR>"; ?><FORM METHOD="post" ACTION="resetpass.php" style="display:inline; margin-top:0px; margin-bottom:0px;"><INPUT name="gb" type="hidden" <?PHP echo "VALUE='$gebr[gebruikersnaam]'";?>> <INPUT name="user" type="hidden" <?PHP echo "VALUE='$userarray[gebruikersnaam]'";?> > <input type=image name="formEditProfileSubmit" src="resetpass.png" <?php echo" alt='Reset Password to 12345'"; ?> value="Bewerk" /> </FORM> <?php } } else {echo '<div id="content">'; echo "User $user does not excist."; echo "</div>"; } } else {include("menu2.php"); echo '<div id="content">'; echo "Please <a href='login.php'>log in</a> to your SQOSSD account first. <BR><BR> Or if you don't have an account yet <a href='regist er.php'>register now</A>."; echo "</div>"; } ?> </body> </html>
  2. Killkip
    Hi, So I'm trying to make this database of star systems. I'm having trouble sorting the results of my radius search function. You type in a star system and enter an x amount of ly. The code will calculate based off the systems coordinates which are in range and which are not. So the trouble is I want them to be able to select that the results are ordered by distance. Unfortunately like I said this distance is calculated and is not in the database, meaning a simple ORDER BY does not work. This is my code: <html> <head> <title>SQO Stellar Search Database</title> </head> <body> <?php $sn1=$_POST["sysname1"]; include("mysqlconnect.php"); $gb=$_POST['gb']; $var=$_POST['var']; $orderby=$_POST['orderby']; $login = mysql_query("SELECT * FROM gebruikers WHERE gebruikersnaam='".$gb."'"); $results = mysql_num_rows($login); $gebr = mysql_fetch_array($login); if ($results==1){ include("menu.php"); $max=50;} else {include("menu2.php"); $max=30;} $sys1 = mysql_query("SELECT * FROM systems WHERE sysname='".$sn1."'"); if ($orderby==name){ $sys2 = mysql_query("SELECT * FROM systems ORDER BY sysname");} else if ($orderby==starclass){ $sys2 = mysql_query("SELECT * FROM systems ORDER BY starclass, sysname");} else { $sys2 = mysql_query("SELECT * FROM systems");} $tellen=mysql_num_rows($sys1); $con1 = mysql_fetch_array($sys1); if ($tellen==1 && $var<=$max) { echo "<div id='content'>"; echo "<h3><b>Systems in range</b></H3>"; echo '<TABLE BORDER="1">'; echo '<TR>'; echo '<TD WIDTH="200" bgcolor="#99CCFF">'; echo '<B>System name:</B>'; echo '</TD>'; echo '<TD WIDTH="130" bgcolor="#99CCFF">'; echo '<B>Star class:</B>'; echo '</TD>'; echo '<TD WIDTH="100" bgcolor="#99CCFF">'; echo '<B>Distance:</B> (ly)'; echo '</TD>'; echo '</TR>'; while ($row = mysql_fetch_array($sys2)) { $Xverschil=$con1[Xcoord]-$row[Xcoord]; $Yverschil=$con1[Ycoord]-$row[Ycoord]; $Zverschil=$con1[Zcoord]-$row[Zcoord]; $distance=round(sqrt(pow($Xverschil,2)+pow($Yverschil,2)+pow($Zverschil,2)),2); if ($distance<$var and $distance<>0) { echo '<TR>'; echo '<TD WIDTH="200" bgcolor="white">'; echo "$row[sysname] <FORM METHOD='post' ACTION='search2.php' style='display:inline; margin-top:0px; margin-bottom:0px;' ><INPUT name='sysname' type='hidden' VALUE='$row[sysname]'><INPUT name='gb' type='hidden' VALUE='$gebr[gebruikersnaam]'><input type=image name='formEditProfileSubmit' src='dubbelarrow.png' value='Bewerk' ></form> "; echo '</TD>'; echo '<TD WIDTH="130" bgcolor="white">'; echo $row[starclass]; echo '</TD>'; echo '<TD WIDTH="100" bgcolor="white">'; echo $distance; echo '</TD>'; echo '</TR>'; }else{} } echo '</TABLE>'; echo '</div>'; } else if ($var>$max && $results==0) {?><div id='content'>Maximum distance for guests is <?php echo "$max";?> ly</div> <?php } else if ($var>$max && $results==1) {?><div id='content'>Maximum distance is <?php echo "$max";?> ly</div> <?php } else { ?><div id='content'> System doesn't excist in database.<BR><BR> Do you want to <A HREF='add.php'>add</A> the system to the SQO Stellar Search Database? </div> <?php } mysql_close(); ?> </body> </html> It may be a bit messy, but I have just 2 weeks of PHP experience. So is there anyone who can help me to order the table by distance?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.