Can not view company profile after user login: session problem??

**Motoma** · Feb 1 '07, 02:33 PM

Originally posted by bb nicole

The company profile showed blank after user login and click the company profile button. Supposed the company profile should not be blank and will show the company information which call from database. I use the session in login page. Thus, in the begining of companyProfile' s coding, i put session_start() ;. What is the problem of my php code?? Thanks..

[PHP]<?php
ob_start();
session_start() ;

include_once("d atabase.php");

if($_GET['ret'] == 'general' ){

//User General Information Retriving
//find the user
$general_result = mysql_query("SE LECT * FROM company WHERE username='{$_SE SSION['username']}'")
or die(mysql_error ());
$general_row = mysql_fetch_arr ay( $general_result ); //set $row to result

//table to display general user inforamtion
echo "<hr><table width=100% border=0>
<tr>
<td><div align=center>
<img src= width=100 height=100>
</div></td>
</tr>
<tr>
<td><table width=70% border=0 align=center>
<tr>
<td width=40% >Company Name</td>
<td width=2%>:</td>
<td width=58%>" . $general_row['companyName'] . "</td>
</tr>
<tr>
<td>Company Type</td>
<td>:</td>
<td>" . $general_row['companyType'] . "</td>
</tr>
<tr>
<td>Contact Name</td>
<td>:</td>
<td>" . $general_row['contactName'] . "</td>
</tr>
<tr>
<td>Descript ion</td>
<td>:</td>
<td>" . $general_row['description'] . "</td>
</tr>
<tr>
<td>Username </td>
<td>:</td>
<td>" . $general_row['username'] . "</td>
</tr>
<tr>
<td>Password </td>
<td>:</td>
<td>" . $general_row['password'] . "</td>
</tr>
<tr>
<td>Email Address</td>
<td>:</td>
<td>" . $general_row['emailAdd'] . "</td>
</tr>
<tr>
<td>ContactN umber</td>
<td>:</td>
<td>" . $general_row['contactNum'] . "</td>
</tr>
<tr>
<td>Fax</td>
<td>:</td>
<td>" . $general_row['fax'] . "</td>
</tr>
<tr>
<td>Contact Addresss</td>
<td>:</td>
<td>" . $general_row['contactAddress '] . "</td>
</tr>
<tr>
<td>City </td>
<td>:</td>
<td>" . $general_row['city'] . "</td>
</tr>
<tr>
<td>Postcode </td>
<td>:</td>
<td>" . $general_row['postcode'] . "</td>
</tr>
<tr>
<td>State</td>
<td>:</td>
<td>" . $general_row['state'] . "</td>
</tr>
<tr>
<td>Country</td>
<td>:</td>
<td>" . $general_row['country'] . "</td>
</tr>
</table></td>
</tr>
</table> " ;

}//end selection on general information retriving

?>[/PHP]

Not sure...It could very well depend on what is inside the database.php file. Have you put echos inside your if statement to make sure you are in fact getting in there?

**bb nicole** · Feb 1 '07, 04:23 PM

I know what you are talking about... The database.php is just connect to server and database.
If i delete
[PHP]include_once("d atabase.php");[/PHP]
and add
[PHP]//connect to server and select database
$conn = mysql_connect(" localhost", "root", "")
or die (mysql_error()) ;
mysql_select_db ("ums e-job portal",$conn) or die(mysql_error ());[/PHP]

The result also same, it will display the blank page...
What is the problem??
Thanks..

**Motoma** · Feb 1 '07, 04:57 PM

Originally posted by bb nicole

I know what you are talking about... The database.php is just connect to server and database.
If i delete
[PHP]include_once("d atabase.php");[/PHP]
and add
[PHP]//connect to server and select database
$conn = mysql_connect(" localhost", "root", "")
or die (mysql_error()) ;
mysql_select_db ("ums e-job portal",$conn) or die(mysql_error ());[/PHP]

The result also same, it will display the blank page...
What is the problem??
Thanks..

Put an echo inside your if() block to see if you are getting in there.

**bb nicole** · Feb 1 '07, 05:29 PM

Sorry.. I don't really understand what you said... I already put echo inside the if() statement as below to dispaly the company profile, is it like this??
[PHP]<?
echo "<hr><table width=100% border=0>
<tr>
<td><div align=center>
<img src= width=100 height=100>
</div></td>
</tr>
<tr>
<td><table width=70% border=0 align=center>
<tr>
<td width=40% >Company Name</td>
<td width=2%>:</td>
<td width=58%>" . $general_row['companyName'] . "</td>
</tr>
<tr>
<td>Company Type</td>
<td>:</td>
<td>" . $general_row['companyType'] . "</td>
</tr>
<tr>
<td>Contact Name</td>
<td>:</td>
<td>" . $general_row['contactName'] . "</td>
</tr>
<tr>
<td>Descript ion</td>
<td>:</td>
<td>" . $general_row['description'] . "</td>
</tr>
<tr>
<td>Username </td>
<td>:</td>
<td>" . $general_row['username'] . "</td>
</tr>
<tr>
<td>Password </td>
<td>:</td>
<td>" . $general_row['password'] . "</td>
</tr>
<tr>
<td>Email Address</td>
<td>:</td>
<td>" . $general_row['emailAdd'] . "</td>
</tr>
<tr>
<td>ContactN umber</td>
<td>:</td>
<td>" . $general_row['contactNum'] . "</td>
</tr>
<tr>
<td>Fax</td>
<td>:</td>
<td>" . $general_row['fax'] . "</td>
</tr>
<tr>
<td>Contact Addresss</td>
<td>:</td>
<td>" . $general_row['contactAddress '] . "</td>
</tr>
<tr>
<td>City </td>
<td>:</td>
<td>" . $general_row['city'] . "</td>
</tr>
<tr>
<td>Postcode </td>
<td>:</td>
<td>" . $general_row['postcode'] . "</td>
</tr>
<tr>
<td>State</td>
<td>:</td>
<td>" . $general_row['state'] . "</td>
</tr>
<tr>
<td>Country</td>
<td>:</td>
<td>" . $general_row['country'] . "</td>
</tr>
</table></td>
</tr>
</table> " ;

?>[/PHP]

**bb nicole** · Feb 2 '07, 10:11 AM

Can anyone help??? What is the problem with my coding??? Why it is a blank page after click inside it???

**Motoma** · Feb 2 '07, 02:45 PM

Originally posted by bb nicole

Can anyone help??? What is the problem with my coding??? Why it is a blank page after click inside it???

The only reason I can see for not seeing anything is that your first test:
if($_GET['ret'] == 'general')
isn't succeeding.

**bb nicole** · Feb 2 '07, 04:37 PM

Thanks, i will try to look at it... :)

**bb nicole** · Feb 4 '07, 10:10 AM

I try to edit my company profile, which the user can view their profile after they login... But it still show the blank page... But when i move it outside the htdocs and press F12, it will show the table... And i try to check it one by one, which means i try to cut the interface out, and it able display the interface... Emm.. I really don't what is the problem... Thanks... Below is my coding for company profile...

[PHP]<?php
//ob_start();
session_start() ;

//connect to server and select database

$conn=mysql_con nect("localhost ", "root", "") or die (mysql_error()) ;
mysql_select_db ("ums e-job portal", $conn) or die(mysql_error ());

// construct SQL statement
$sql = mysql_query("SE LECT * FROM company WHERE company_ID='{$_ SESSION['company_ID']}'");

while($rows=mys ql_fetch_array( $sql)){

//table to display company profile

echo" <div align='center'> <stron g>Company Profile</div>
<table width='48%' border='1'>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Compan y Name</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['companyName']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Compan y Type</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['companyType']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Contac t Name</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['contactName']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Descri ption</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['description']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Userna me</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['username']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Passwo rd</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['password']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Email Address</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['emailAdd']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Contac tNumber</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['contactNum']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Fax</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['fax']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Contac t Addresss</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['contactAdd']}</td>
</tr>]

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> City</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['city']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Postco de</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['postcode']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> State</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['state']}</td>
</tr>

<tr>
<td width=27% align=left bgcolor='#E8E8E 8'> Countr y</td>
<td width=73% align=left bgcolor='#f1f1f 1'> {$rows['country']}</td>
</tr>

</table>";

}

//end selection on general information retriving

?>
[/PHP]

**bb nicole** · Feb 4 '07, 06:44 PM

Hi... Is it anyone have an idea how to edit or repair my code, i really no idea...
Emm... i think the code is correct, but don't why the result is the blank page..
It doesn't show any error... Is it the coding can't get the user id from database?

**bb nicole** · Feb 5 '07, 08:12 AM

Originally posted by Motoma

The only reason I can see for not seeing anything is that your first test:
if($_GET['ret'] == 'general')
isn't succeeding.

Emm... I have change the code but still cannot function...
Do you have any idea, motoma??? Thanks..

**Motoma** · Feb 5 '07, 03:16 PM

In your code you have this:
[PHP]
echo"...
[/PHP]

There is no space between echo and "
Try this:

[PHP]
echo "...
[/PHP]

Boy, I will be upset if that solves it.

**Atli** · Feb 5 '07, 03:45 PM

If your using php 5.2.0.
by default, no error reports will be shown.

Try adding this to the top of you code and run the script. It will show all errors and warning. Might help you identify your problem.

[PHP]error_reporting (E_ALL);[/PHP]

I did most likely find the error tho.

Switch ob_start(); and session_start() ;
session_start() ; should always be the top line of your code, unless you have a good reason not to. Its just good practice.

Add ob_end_flush(); to the bottom of your code.
This ends the output buffering and sends the buffer to the browser. Tho this shouldn't be required it seemes not closing the buffer interferes with the database connection in a weird way.
I always close ob_start() with ob_end_flush(). It just doesnt feel right to leave the buffer hanging like that.

**bb nicole** · Feb 6 '07, 08:25 PM

Thanks, Motoma... Thanks, Alti... I have try many way, but still can't work... I don't know wheather is my login function got error or what, it still can't work... And after i add [PHP]<?error_reporti ng(E_ALL);?>[/PHP], the error message as below:
Notice: Undefined variable: company_ID in C:\Apache2\Apac he2\htdocs\comp anyProfile.php on line 14
which line 14 is
[PHP]<? $sql =mysql_query("S ELECT * FROM company WHERE company_ID='{$_ SESSION['company_ID']}'"); ?>[/PHP]
Below is my modify code for company profile and login, what is happening, i want to give up ledy...
company profile
[PHP]<?php
error_reporting (E_ALL);
session_start() ;
ob_start();

//connect to server and select database

$conn=mysql_con nect("localhost ", "root", "") or die (mysql_error()) ;
mysql_select_db ("ums e-job portal", $conn) or die(mysql_error ());

// construct SQL statement
$sql =mysql_query("S ELECT * FROM company WHERE company_ID='{$_ SESSION['company_ID']}'");

?>

<div align='center'> <stron g>Company Profile</div>
<table width='88%' border='1'>
<tr>

<?
while($rows=mys ql_fetch_array( $sql)){
?>

<td width=27% align=center bgcolor='#E8E8E 8'> Compan y Name</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['companyName'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Compan y Type</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo$rows['companyType'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Contac t Name</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['contactName'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Descri ption</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['description'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Userna me</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['username'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Passwo rd</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['password'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Email Address</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['emailAdd'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Contac tNumber</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['contactNum'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Fax</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['fax'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Contac t Addresss</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['contactAdd'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> City</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['city'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Postco de</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['postcode'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> State</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['state'];?></td>
</tr>

<tr>
<td width=27% align=center bgcolor='#E8E8E 8'> Countr y</td>
<td width=73% align=center bgcolor='#f1f1f 1'> <? echo $rows['country'];?></td>
</tr>

</table>

<?

}

ob_end_flush();
?>[/PHP]

Login
[PHP]<?php
ob_start();
session_start() ;

extract ($_POST);

mysql_connect(" localhost","roo t","")
or die("Cannot connect to the server");

mysql_select_db ("ums e-job portal")
or die("Cannot connect to the database");

$_SESSION['loggedin'] = 1;

$sql="select username from company where username='$user name'";

$result=mysql_q uery($sql)
or die("Cannot execute query");

$num=mysql_num_ rows($result);

if($num==1) //username valid
{
$sql="select username from company where username='$user name' and password='$pass word'";

$result2=mysql_ query($sql)
or die("Cannot execute query");

$num2=mysql_num _rows($result2) ;
if($num2>0)
{
$_SESSION['loggedin'] = 1;
$_SESSION['loggedin'] = time();
$_SESSION['username'] = $username;
$_SESSION['company_ID'] = $company_ID;

include("welcom e.php");

exit();
}
else //message send to emp_login.php when wrong password
{
$message="The username, $username exists, but you have not entered the correct password! Please try again. ";
include("emp_lo gin.php");
}
}

else
$_SESSION['loggedin'] = 0;
//message send to emp_login.php when username not valid
{
$message="The username you entered does not exist! Please try again. ";
include("emp_lo gin.php");
}

?>[/PHP]

**Atli** · Feb 7 '07, 12:27 AM

The $_SESSION['company_ID'] variable isnt set, so the query is looking for an empty string and naturally returns nothing.

It is most likely this line in the code.
[PHP]$_SESSION['company_ID'] = $company_ID;[/PHP]
Make sure the $company_ID is set correctly where ever it is you set it.

Can not view company profile after user login: session problem??

Can not view company profile after user login: session problem??

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment