hyperlinks from db

asgsoft · 22-04-2005, 19:09

PHP Code:

  <?php

ob_start();

session_start();

$password = $_SESSION['password'];

$username = $_SESSION['username'];

echo "<html>

        <head>

            <title>Member List</title>

        </head>

        <body>";

$db = mysql_connect("localhost", "root", "");

mysql_select_db("logsys",$db);

$result = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password'",$db);

if(mysql_num_rows($result) == 1){//Checks there is only 1 user

    $get_users = mysql_query("SELECT * FROM logsys ORDER BY date");//Queries for every user

    if(mysql_num_rows($get_users) > 0){

            while ($rec = mysql_fetch_row($get_users)) {

                echo("ID: " . $rec[0] . "<br>\n");

                echo("Username Name: " . $rec[1] . "<br>\n");

                echo("Email " . $rec[3] . "<br>\n");

             echo("Date Joined: " . $rec[4] . "<br><br>\n");

            }

    }else{

        echo "No Users";

    }

}else {//hmmm we didnt find there data? error time! :eek:

    echo("<center><font face=\"Verdana\">Sorry, your not logged in, proceed <a href=\"/logsys/login.php\">here</a> to login.");

}

echo"

    </body>

</html>";

ob_end_flush();

?>

**robertall** · 22-04-2005, 19:11

Can you explain how it works, some people do not understand what the raw code does?

asgsoft · 22-04-2005, 19:28

it is an addition to mck user system part 1 tutorial. this gets data from the db such as username,id,email,date joined and maked a member list out of them.

jren207 · 25-04-2005, 23:39

You might want to MD5 the password for security.

For example, running the original password through MD5

PHP Code:

  <?php 

$password_out = MD5($password_in); 

echo('' . $password_out . ''); 

?>

then inserting

PHP Code:

  $password_out

into a database by hand with phpmyadmin for example, or
setting up a mysql insert to do it...

then making your script compare the MD5 instead...

PHP Code:

  <?php 

$password_out = MD5($password); 

?>

...

PHP Code:

  <?php 

$result = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password_out'",$db); 

?>

22-04-2005, 19:09	#1 (permalink)
asgsoft WMT Addict Join Date: Apr 2005 Location: Brighton,UK Posts: 162 iTrader: 0 / 0%	hyperlinks from db PHP Code: <?php ob_start(); session_start(); $password = $_SESSION['password']; $username = $_SESSION['username']; echo "<html> <head> <title>Member List</title> </head> <body>"; $db = mysql_connect("localhost", "root", ""); mysql_select_db("logsys",$db); $result = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password'",$db); if(mysql_num_rows($result) == 1){//Checks there is only 1 user $get_users = mysql_query("SELECT * FROM logsys ORDER BY date");//Queries for every user if(mysql_num_rows($get_users) > 0){ while ($rec = mysql_fetch_row($get_users)) { echo("ID: " . $rec[0] . "<br>\n"); echo("Username Name: " . $rec[1] . "<br>\n"); echo("Email " . $rec[3] . "<br>\n"); echo("Date Joined: " . $rec[4] . "<br><br>\n"); } }else{ echo "No Users"; } }else {//hmmm we didnt find there data? error time! :eek: echo("<center><font face=\"Verdana\">Sorry, your not logged in, proceed <a href=\"/logsys/login.php\">here</a> to login."); } echo" </body> </html>"; ob_end_flush(); ?>

22-04-2005, 19:11	#2 (permalink)
robertall Moderator Join Date: Jan 2005 Location: post is there >> Posts: 1,586 iTrader: 0 / 0%	Can you explain how it works, some people do not understand what the raw code does? __________________ Free .org domain - Click for details! Do not pm asking for things. My inbox is full. Add me to MSN!

25-04-2005, 23:39	#4 (permalink)
jren207 Newbie Join Date: Jan 2005 Location: Lincolnshire, United Kingdom Posts: 12 iTrader: 0 / 0%	You might want to MD5 the password for security. For example, running the original password through MD5 PHP Code: `<?php $password_out = MD5($password_in); echo('' . $password_out . ''); ?>` then inserting PHP Code: `$password_out` into a database by hand with phpmyadmin for example, or setting up a mysql insert to do it... then making your script compare the MD5 instead... PHP Code: `<?php $password_out = MD5($password); ?>` ... PHP Code: `<?php $result = mysql_query("SELECT * FROM logsys WHERE username='$username' AND password='$password_out'",$db); ?>`

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

22-04-2005, 19:28	#3 (permalink)
asgsoft WMT Addict Join Date: Apr 2005 Location: Brighton,UK Posts: 162 iTrader: 0 / 0%	it is an addition to mck user system part 1 tutorial. this gets data from the db such as username,id,email,date joined and maked a member list out of them.