Member Avatar for shyam2011 
<?php

// Inialize session
session_start();
include('config.inc');
// Check, if username session is NOT set then this page will jump to login page
if (!isset($_SESSION['username'])) {
        header('Location: index.php');
}
?>
<html>

<head>
  <title>Secured Page</title>
</head>

<body>

<?php 
$result = mysql_query("SELECT user.password, data1.dob FROM user INNER JOIN data1 ON user.username = data1.username WHERE username = '" . $_SESSION['username'] . "'");

  echo "<table border='1'>
  <tr>
  <th>Name</th>
  <th>Message</th>
  </tr>";
  while ($row = mysql_fetch_array($result)) {
  echo "<tr>";
  echo "<td>" . $row['password'] . "</td>";
  echo "<td>" . $row['dob'] . "</td>";
  echo "</tr>";
  }
  echo "</table>";

?>
<p><a href="logout.php">Logout</a></p>

</body>

</html>
Edited by Dani because: Formatting fixed
  • 3 Contributors
  • 10 Replies
  • 1K Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by vibhaJ
nonshatter commented: Unclear post. What is your actual problem.,= -1
Member Avatar for vibhaJ

I know its your first post, but at least should have sense how would people know your problem without describing.
And yeah have practice with code tag to post code.

Member Avatar for karthik_ppts

Re-post this with some more explanation for our understanding and use code tags to post your codes

Member Avatar for shyam2011 
<?php

// Inialize session
session_start();
include('config.inc');
// Check, if username session is NOT set then this page will jump to login page
if (!isset($_SESSION['username'])) {
header('Location: index.php');
}
?>
<html>

<head>
<title>Secured Page</title>
</head>

<body>

<?php
$result = mysql_query("SELECT user.password, data1.dob FROM user INNER JOIN data1 ON user.username = data1.username WHERE username = '" . $_SESSION['username'] . "'");

echo "<table border='1'>
<tr>
<th>Name</th>
<th>Message</th>
</tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['password'] . "</td>";
echo "<td>" . $row['dob'] . "</td>";
echo "</tr>";
}
echo "</table>";

?>
<p><a href="logout.php">Logout</a></p>

</body>

</html>
Member Avatar for shyam2011

I have two MySQL table table "user" & "data1" i want to display data from both table,
user name is conman both table. if user one login then it should be display data for user one..........thanks in advance. please help me

Member Avatar for karthik_ppts

I have two MySQL table table "user" & "data1" i want to display data from both table,
user name is conman both table. if user one login then it should be display data for user one..........thanks in advance. please help me

Now what is your output with this code?

Member Avatar for shyam2011

This is the out put sir

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\login\securedpage.php on line 27

Member Avatar for vibhaJ

Try user.username in where condition.

$result = mysql_query("SELECT user.password, data1.dob FROM user INNER JOIN data1 ON user.username = data1.username WHERE user.username = '" . $_SESSION['username'] . "'");
Member Avatar for karthik_ppts

try with vibhadevit's suggestion and see what happens.

Member Avatar for shyam2011

Thanks sir,
my prob. is solved ......!
thanks to daniweb, vibhadevit sir, & Karthik_pranas.

Thanks a lot.

Member Avatar for vibhaJ

Hey m not sir.. m mam :)

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.