DaniWeb Forum Index > Web Development > PHP

Profile user page

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 50

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Profile user page

Oct 12th, 2009

I have a register and login code, but i don't know when the user register to automatically make user page.Can anybody help me?

•

Join Date: May 2008

Posts: 525

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

Oct 12th, 2009

Make a seperate page (profile.php perhaps) and use the unique field in the database (Usually an ID of some sort) in the query string, for example, profile.php?user=usersID.

In the profile.php page, pull the required data from the database and display it as required.

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.

•

Join Date: Oct 2006

Posts: 1,092

Reputation: ardav will become famous soon enough

Solved Threads: 137

ardav

Offline

Veteran Poster

Oct 12th, 2009

Just remember to protect it with a session id, so that you can't change anybody else's profile. View but not edit.

If you don't reply to your own thread or you can't find the solved link - you're off my Christmas list - permanently! Bah humbug!

•

Join Date: Oct 2009

Posts: 50

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Oct 13th, 2009

Can you show me some code examples?

•

Join Date: Sep 2009

Posts: 35

Reputation: nadnakinam is an unknown quantity at this point

Solved Threads: 0

nadnakinam nadnakinam is offline

Offline

Light Poster

Oct 13th, 2009

post your code...

•

Join Date: Oct 2009

Posts: 50

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Oct 13th, 2009

I now how to echo id but how to echo username, email...
This is my code for profile page:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name
 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM users WHERE id=$id");
$sql="SELECT * FROM users";
?>
<?php 
echo $id;
?>
<?php

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM users WHERE id=$id");
$sql="SELECT * FROM users";
?>
<?php 
echo $id;
?>

•

Join Date: Oct 2009

Posts: 50

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Oct 13th, 2009

I now how to echo id but how to echo username, email...
This is my code for profile page:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name
 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM users WHERE id=$id");
$sql="SELECT * FROM users";
?>
<?php 
echo $id;
?>
<?php

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM users WHERE id=$id");
$sql="SELECT * FROM users";
?>
<?php 
echo $id;
?>

•

Join Date: May 2008

Posts: 525

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

Oct 13th, 2009

Many problems with your code there...

There appears to be no protection on your query at all...
Try replacing this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$id = $_GET['id'];
$id = $_GET['id'];

with this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if (is_int($_GET['id'])) {
  $id = $_GET['id'];
  // Add the rest of the script here.
} else {
  // Display an error message, also stop processing.
  echo "Error message here";
}
if (is_int($_GET['id'])) {
  $id = $_GET['id'];
  // Add the rest of the script here.
} else {
  // Display an error message, also stop processing.
  echo "Error message here";
}

Also, this line $sql="SELECT * FROM users"; is redundant, it does nothing...

Instead of this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$result = mysql_query("SELECT * FROM users WHERE id=$id");
$result = mysql_query("SELECT * FROM users WHERE id=$id");

Try this I added a limit as I assume you will only be expecting one result:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$query = mysql_query("SELECT * FROM users WHERE id=$id LIMIT 1");
$result = mysql_fetch_assoc( $query );
$query = mysql_query("SELECT * FROM users WHERE id=$id LIMIT 1");
$result = mysql_fetch_assoc( $query );

You can then call the values from the DB using $result['field_name'].

So to review, your code should look similar to this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
 
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name
 
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
if (is_int($_GET['id'])) {
  $id = $_GET['id'];
  $query = mysql_query("SELECT * FROM users WHERE id=$id LIMIT 1");
  $result = mysql_fetch_assoc( $query );
  echo $id;
} else {
  // Display an error message, also stop processing.
  echo "Error message here";
}
?>
<?php

$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="login4"; // Database name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die(mysql_error());
mysql_select_db("$db_name")or die(mysql_error());
if (is_int($_GET['id'])) {
  $id = $_GET['id'];
  $query = mysql_query("SELECT * FROM users WHERE id=$id LIMIT 1");
  $result = mysql_fetch_assoc( $query );
  echo $id;
} else {
  // Display an error message, also stop processing.
  echo "Error message here";
}
?>

Also, as ardav said, you will need to add some logic to make sure that the user viewing this page actually has permission to do so, such as creating a session when they login, and check that a session exists when they access this page

Last edited by Will Gresham; Oct 13th, 2009 at 5:28 pm.

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.

•

Join Date: Oct 2009

Posts: 50

Reputation: web3 is an unknown quantity at this point

Solved Threads: 0

web3

Offline

Junior Poster in Training

Oct 13th, 2009

Thanks, xan!
But i still don't now how echo username or email...

•

Join Date: May 2008

Posts: 525

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

#10

Oct 13th, 2009

$result['field_name']

Assuming the fields are called email and username, use the following:
$result['email']
$result['username']

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.