whats wrong with my profile page

Question

lillorme 0 Light Poster

11 Years Ago

<?php require_once('connections/careergroup.php'); ?>
<html>
<head>
<title> <?php echo $first_name; ?> <?php echo $lastname; ?>s Profile</title>

</head>
<body>
<?php
// Check for a form submission


    if (isset($_GET["username"])){



    $email = $_GET['username'];

    mysql_connect ("$hostname_careergroup",  "$username_careergroup", "$password_careergroup") 
    or die ("Could not connect to the server");

    mysql_select_db("careergroup") or die ("That database could not be found");
    $userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query"); 

    if (mysql_num_rows($userquery) != 1) {
    die ("that member could not be found!");

    while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){
        $first_name = $row['first_name'];
        $last_name = $row['last_name'];
        $email = $row['email'];
        $password = $row['password'];
        $sex = $row['sex'];
        $dbusername = $row['username'];
    }
    if ($email != $email) {

      die ("there has been a fatal erroe. please try again. ");


    }

    if ($activated == 0) {
        $active = "The account has not been activated.";
    }else{
        $active = "The account has been activated.";
    }

    // See what lever the user is

    if ($access == 0) {
        $admin = "This user is not an administrator.";
    }else {
        $admin = "This use is an administrator.";
    }
    }
?>

<h2><?php echo $first_name; ?> <?php echo $last_name; ?>s Profile</h2><br />

<table>


        <tr><td> Firstname:</td><td><?php echo $first_name; ?></td></tr>


    <tr><td> Lastname:</td><td><?php echo $last_name; ?></td></tr>
    <tr><td> Email:</td><td><?php echo $email; ?></td></tr>
    <tr><td> Password:</td><td><?php echo $pastword; ?></td></tr>
    <tr><td> Sex:</td><td><?php echo $sex; ?></td></tr>
<?php


    } else die ("you need to specify a username!");






?>
</body>
</html>

php

Edited 11 Years Ago by Dani because: Formatting fixed

3 Contributors
13 Replies
450 Views
5 Days Discussion Span
Latest Post 11 Years Ago Latest Post by lillorme

minitauros 151 Junior Poster

11 Years Ago

Are you getting an error? Multiple errors? What seems to be the problem?

Tpojka 56 makingMagic(true);

11 Years Ago

You have conflict with your $email variable
Here in code (even it ain't all as code lines as descripted), in line 5., you have:

$email = $_GET['username'];

and than in line 19., you have rewriten variable

$email = $row['email'];

Try to use different names for each of them.

Tpojka 56 makingMagic(true);

11 Years Ago

what wronh with this line

$userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query");

If you have changed $_GET['username'] variable to $user, you need to change it in query too instead *$email* variable.

Tpojka 56 makingMagic(true);

11 Years Ago

Try with:
while($row = mysql_fetch_assoc($userquery))

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

lillorme 0 Light Poster · Answer 1 · 2013-10-25T12:36:03+00:00

lillorme 0 Light Poster

11 Years Ago

it is saying the username dot define

lillorme 0 Light Poster · Answer 2 · 2013-10-25T12:37:40+00:00

sorry about that bit it is saying "you need to specify a username!"

lillorme 0 Light Poster · Answer 3 · 2013-10-25T12:42:01+00:00

lillorme 0 Light Poster

11 Years Ago

the email address is the username

lillorme 0 Light Poster · Answer 4 · 2013-10-25T16:59:15+00:00

{i changed it to thia but it did not work

<?php require_once('connections/careergroup.php'); ?>
<html>
<head>
<title> <?php echo $first_name; ?> <?php echo $lastname; ?>s Profile</title>

</head>
<body>
<?php
// Check for a form submission

if (isset($_GET["username"])){



$user = $_GET['username'];

mysql_connect ("$hostname_careergroup",  "$username_careergroup", "$password_careergroup") 
or die ("Could not connect to the server");

mysql_select_db("careergroup") or die ("That database could not be found");
$userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query"); 

if (mysql_num_rows($userquery) != 1) {
die ("that member could not be found!");

while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){
    $first_name = $row['first_name'];
    $last_name = $row['last_name'];
    $email = $row['username'];
    $password = $row['password'];
    $sex = $row['sex'];
    $dbusername = $row['username'];
}
if ($user != $email) {

  die ("there has been a fatal erroe. please try again. ");


}

if ($activated == 0) {
    $active = "The account has not been activated.";
}else{
    $active = "The account has been activated.";
}

// See what lever the user is

if ($access == 0) {
    $admin = "This user is not an administrator.";
}else {
    $admin = "This use is an administrator.";
}
}

?>

<h2><?php echo $first_name; ?> <?php echo $last_name; ?>s Profile</h2><br />

<table>

    <tr><td> Firstname:</td><td><?php echo $first_name; ?></td></tr>


<tr><td> Lastname:</td><td><?php echo $last_name; ?></td></tr>
<tr><td> Email:</td><td><?php echo $email; ?></td></tr>
<tr><td> Password:</td><td><?php echo $pastword; ?></td></tr>
<tr><td> Sex:</td><td><?php echo $sex; ?></td></tr>

<?php

} else die ("you need to specify a username!");

?>
</body>
</html>

lillorme 0 Light Poster · Answer 5 · 2013-10-25T17:02:24+00:00

what wronh with this line

$userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query");

lillorme 0 Light Poster · Answer 6 · 2013-10-25T17:08:18+00:00

this is what i got my search.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>search for friends</title>
</head>

<body>
<h2> Search for a user:</h2><br/><br/>
<form action="profile.php" method="GET"

    <table>


    <tr><td>Email address:</td><td><input type="text" id="username" name="username" /></td></tr>
    <tr><td><input type="submit" id="submit" name="submit" Value="Search"/></td></tr>
 </table>

</form>
</body>
</html>

lillorme 0 Light Poster · Answer 7 · 2013-10-25T17:09:39+00:00

and this is my profile.php

<?php require_once('connections/careergroup.php'); ?>
<html>
<head>
<title> <?php echo $first_name; ?> <?php echo $lastname; ?>s Profile</title>

</head>
<body>
<?php
// Check for a form submission

if (isset($_GET["username"])){



$email = $_GET['username'];

mysql_connect ("$hostname_careergroup",  "$username_careergroup", "$password_careergroup") 
or die ("Could not connect to the server");

mysql_select_db("careergroup") or die ("That database could not be found");
$userquery = mysql_query("SELECT * FROM members WHERE username= '$email'") or die ("the query"); 

if (mysql_num_rows($userquery) != 1) {
die ("that member could not be found!");

while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){
    $first_name = $row['first_name'];
    $last_name = $row['last_name'];
    $email = $row['username'];
    $password = $row['password'];
    $sex = $row['sex'];
    $dbusername = $row['username'];
}
if ($user != $email) {

  die ("there has been a fatal erroe. please try again. ");


}

if ($activated == 0) {
    $active = "The account has not been activated.";
}else{
    $active = "The account has been activated.";
}

// See what lever the user is

if ($access == 0) {
    $admin = "This user is not an administrator.";
}else {
    $admin = "This use is an administrator.";
}
}

?>

<h2><?php echo $first_name; ?> <?php echo $last_name; ?>s Profile</h2><br />

<table>

    <tr><td> Firstname:</td><td><?php echo $first_name; ?></td></tr>


<tr><td> Lastname:</td><td><?php echo $last_name; ?></td></tr>
<tr><td> Email:</td><td><?php echo $email; ?></td></tr>
<tr><td> Password:</td><td><?php echo $pastword; ?></td></tr>
<tr><td> Sex:</td><td><?php echo $sex; ?></td></tr>

<?php

} else die ("you need to specify a username!");

?>
</body>
</html>

lillorme 0 Light Poster · Answer 8 · 2013-10-26T10:31:21+00:00

now it is saying that all these are not fefined

<table>

   <tr><td> Firstname:</td><td><?php echo $first_name; ?></td></tr>
<tr><td> Lastname:</td><td><?php echo $last_name; ?></td></tr>
<tr><td> Email:</td><td><?php echo $email; ?></td></tr>
<tr><td> Password:</td><td><?php echo $pastword; ?></td></tr>
<tr><td> Sex:</td><td><?php echo $sex; ?></td></tr>

</table>

lillorme 0 Light Poster · Answer 9 · 2013-10-30T18:18:23+00:00

This is my search page (search.php) how to i link this to the code above so that is capture the email to varified to the database.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>search for friends</title>
</head>

<body>
<h2> Search for a user:</h2><br/><br/>
<form action="profile_finder.php" method="GET"

    <table>


    <tr><td>Email address:</td><td><input type="text" id="email" name="email" /></td></tr>
    <tr><td><input type="submit" id="submit" name="submit" Value="Search"/></td></tr>
 </table>

</form>
</body>
</html>