I am having troubles in my coding

[pe_es171]

In one of my pages after the login page,I use some data selected from a database and save them in a session but when i was about calling those data in session at the next page so that I can have those data inserted into another table.It was giving me empty data in the new table.PLSSSSSS help o!

[essellar]

Would you mind posting the relevant parts of your code? It's really hard to tell where the problem might be if you don't. Oh -- and are you using the default session handlers or are you storing your session in a database?

[pe_es171]

ok i will post it now

[pe_es171]

employerappreceived.php
<?php session_start(); if(!isset($_SESSION['myusername'])) header("location:http://localhost/irs/login/loginphase.htm");?>

<?php
//store the data in session
$appdate=date('Y-m-d');
$host="localhost"; // Host name
$hostusername="root"; // Mysql username
$hostpassword="root"; // Mysql password
$db_name="jobdatabase"; // Database name
$tbl_name="appsent"; // Table name
$varholder=$_SESSION['myusername'];
$con= mysql_connect("localhost","root","root");
mysql_connect("$host", "$hostusername", "$hostpassword")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$result=mysql_query("SELECT * FROM appsent WHERE employer='$_SESSION[myusername]' ");
if (!$result) {

echo 'Could not run query: '. mysql_error();
exit;

}

$row=mysql_fetch_row($result);
//store session for the displayed application
echo '<strong>Post Applied for: </strong>'.$row[1].'<br/>';
echo '<strong>Applied by: </strong>'.$row[2].'<br/>';
echo '<strong>Requirement: </strong>'.$row[4].'<br/>';
echo '<strong>Location: </strong>'.$row[5].'<br/>';
echo '<strong>Interview Question: </strong>'.$row[6].'<br/>';
echo '<strong>Interview answer: </strong>'.$row[7].'<br/>';
echo '<strong>Area of Specification: </strong>'.$row[8].'<br/>';
echo '<strong>Closing Date: </strong>'.$row[10].'<br/>';
echo "<strong>Jobseeker's CV: </strong>".'<br/>'.$row[9].'<br/>';

$paf=$row[1] ;
$_SESSION['paf']=$paf;
echo $paf;
$pab=$row[2] ;
$_SESSION['pab']=$pab;
$pem=$row[3] ;
$_SESSION['pem']=$pem;
$preq=$row[4] ;
$_SESSION['preq']=$preq;
$ploc=$row[5] ;
$_SESSION['ploc']=$ploc;
$piq=$row[6] ;
$_SESSION['piq']=$piq;
$pia=$row[7] ;
$_SESSION['pia']=$pia;
$paos =$row[8] ;
$_SESSION['paos']=$paos;
$pcv =$row[9] ;
$_SESSION['pcv']=$pcv;
$pcd =$row[10] ;
$_SESSION['pcd']=$pcd;
$padt =$row[10] ;
$_SESSION['padt']=$padt;

echo '<form name="form1" method="post" action="appaccept.php">
<input type="submit" name="Submit" value="Accept">
<input name="Reject" type="submit" id="Reject" value="Reject">
</form>';
echo '<a href="#">'.'<img src="accept.png" width="130" height="50" />'.'</a>'.'<a href="#">'.'<img src="reject.png" width="130" height="50" />'.'</a> ';
echo '<hr>';
//----------------------------
mysql_close($con);
?>

[pe_es171]

appaccept.php
<?php session_start(); if(!isset($_SESSION['myusername'])) header("location:http://localhost/irs/login/loginphase.htm");?>
<?php
if(isset($_POST['Submit']))
{


$host="localhost";
$hostusername="root";
$hostpassword="root";
$db_name="jobdatabase";
$tbl_name="appconfirmation";
$con= mysql_connect("localhost","root","root");

mysql_connect("$host","$hostusername","$hostpasswo rd") or die("cannot connect");
mysql_select_db("$db_name") or die("cannot select DB");

$thisdate=date('Y-m-d');

$_POST=$_SESSION;

$thepaf=$_SESSION['paf']; echo $thepaf;
$thepab=$_SESSION['pab'];
$thepem=$_SESSION['pem'];
$thepreq=$_SESSION['preq'];
$theploc=$_SESSION['ploc'];
$thepiq=$_SESSION['piq'];
$thepia=$_SESSION['pia'];
$thepaos=$_SESSION['paos'];
$thepcv=$_SESSION['pcv'];
$thepcd=$_SESSION['pcd'];
$thepadt=$_SESSION['padt'];
//start off querying
$insertSQL= "INSERT INTO appconfirmation (postapplied,jobseeker,employer,requirement,locati on,interquest,interans,aofspeci,jobseekercv,status ,appdatecon)
VALUES('$thepaf','$thepab','$thepem','$thepreq','$ theploc','$thepiq','$thepia','$thepaos','$thepcv', 'accept','$thisdate')";


if (!mysql_query($insertSQL,$con))
{
die('Error: ' . mysql_error());
}
echo '<strong><font color="#FF0000">'."Application approved!!!"." ".':'.'</font></strong> ';
echo "<br />";
echo '<br>To view stuff, <a href="#">click here</a>.';
//end here
mysql_close($con);
}
//another one
?>
[/COLOR]in the second page i posted,the session data from the 1st page which I intended to insert into a new table was echoed empty.PLSSSSS HELP!!!!

[misson]

Please use [php], [html] or [code] tags (as appropriate) to separate and format code.

Sample code should be complete and concise. As essellar said, post the relevant portions of your code rather than dumping all of it. If it doesn't fit in a single post, it's definitely too much.

The sample code is vulnerable to SQL injection, which is a very serious security risk. To fix this hole, switch from the outdated mysql extension to PDO and use prepared statements. If you need a PDO tutorial, try "Writing MySQL Scripts with PHP and PDO". The site you save may just be your own.

Database connection creation (including managing the database credentials) should be the responsibility of one class rather than handled separately in each script. The more scripts contain user credentials, the more files there are for you to secure and the greater chance of typos screwing things up. Reduce critical code repetition. See "[PHP] MySQL and PHP" and "Display all that would be secret while Mysql is broken" for some partial examples.

Don't use SELECT *; select only the columns you need.

Outputting database error messages to non-admin users discloses too much information. Instead, log the MySQL error message. For some errors (such as those related to missing or invalid values), output your own error message to the user and what action the user can take to address it. For the rest, inform the user that there was an internal error.

Don't use die when outputting HTML. You'll get invalid HTML.

Don't use <font>, <br/> or other non-semantic elements, or use semantic elements purely for presentation (e.g. <p>&nbsp;</p> and tables for layout). Use CSS.

[pe_es171]

the first php page coding:::::::::::::::::::::::::::::
-------------------------------------------------

<?php
//store the data in session
$appdate=date('Y-m-d');
$host="localhost"; // Host name
$hostusername="root"; // Mysql username
$hostpassword="root"; // Mysql password
$db_name="jobdatabase"; // Database name
$tbl_name="appsent"; // Table name
$varholder=$_SESSION['myusername'];
$con= mysql_connect("localhost","root","root");
mysql_connect("$host", "$hostusername", "$hostpassword")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$result=mysql_query("SELECT * FROM appsent WHERE employer='$_SESSION[myusername]' ");
if (!$result) {

echo 'Could not run query: '. mysql_error();
exit;

}

$row=mysql_fetch_row($result);
//store session for the displayed application
echo '<strong>Post Applied for: </strong>'.$row[1].'<br/>';
echo '<strong>Applied by: </strong>'.$row[2].'<br/>';
echo '<strong>Requirement: </strong>'.$row[4].'<br/>';
echo '<strong>Location: </strong>'.$row[5].'<br/>';
echo '<strong>Interview Question: </strong>'.$row[6].'<br/>';
echo '<strong>Interview answer: </strong>'.$row[7].'<br/>';
echo '<strong>Area of Specification: </strong>'.$row[8].'<br/>';
echo '<strong>Closing Date: </strong>'.$row[10].'<br/>';
echo "<strong>Jobseeker's CV: </strong>".'<br/>'.$row[9].'<br/>';

$paf=$row[1] ;
$_SESSION['paf']=$paf;
echo $paf;
$pab=$row[2] ;
$_SESSION['pab']=$pab;
$pem=$row[3] ;
$_SESSION['pem']=$pem;
$preq=$row[4] ;
$_SESSION['preq']=$preq;
$ploc=$row[5] ;
$_SESSION['ploc']=$ploc;
$piq=$row[6] ;
$_SESSION['piq']=$piq;
$pia=$row[7] ;
$_SESSION['pia']=$pia;
$paos =$row[8] ;
$_SESSION['paos']=$paos;
$pcv =$row[9] ;
$_SESSION['pcv']=$pcv;
$pcd =$row[10] ;
$_SESSION['pcd']=$pcd;
$padt =$row[10] ;
$_SESSION['padt']=$padt;



echo '<form name="form1" method="post" action="appaccept.php">
<input type="submit" name="Submit" value="Accept">
<input name="Reject" type="submit" id="Reject" value="Reject">
</form>';
echo '<a href="#">'.'<img src="accept.png" width="130" height="50" />'.'</a>'.'<a href="#">'.'<img src="reject.png" width="130" height="50" />'.'</a> ';
echo '<hr>';
//----------------------------
mysql_close($con);
?>

---------- Post added at 11:57 PM ---------- Previous post was at 11:55 PM ----------

the second php page where i was trying to call the session data:::::::::::::::::::::::::::::
--------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------

<?php
if(isset($_POST['Submit']))
{


$host="localhost";
$hostusername="root";
$hostpassword="root";
$db_name="jobdatabase";
$tbl_name="appconfirmation";
$con= mysql_connect("localhost","root","root");

mysql_connect("$host","$hostusername","$hostpasswo rd") or die("cannot connect");
mysql_select_db("$db_name") or die("cannot select DB");

$thisdate=date('Y-m-d');

$_POST=$_SESSION;

$thepaf=$_SESSION['paf']; echo $thepaf;
$thepab=$_SESSION['pab'];
$thepem=$_SESSION['pem'];
$thepreq=$_SESSION['preq'];
$theploc=$_SESSION['ploc'];
$thepiq=$_SESSION['piq'];
$thepia=$_SESSION['pia'];
$thepaos=$_SESSION['paos'];
$thepcv=$_SESSION['pcv'];
$thepcd=$_SESSION['pcd'];
$thepadt=$_SESSION['padt'];
//start off querying
$insertSQL= "INSERT INTO appconfirmation (postapplied,jobseeker,employer,requirement,locati on,interquest,interans,aofspeci,jobseekercv,status ,appdatecon)
VALUES('$thepaf','$thepab','$thepem','$thepreq','$ theploc','$thepiq','$thepia','$thepaos','$thepcv', 'accept','$thisdate')";


if (!mysql_query($insertSQL,$con))
{
die('Error: ' . mysql_error());
}
echo '<strong><font color="#FF0000">'."Application approved!!!"." ".':'.'</font></strong> ';
echo "<br />";
echo '<br>To view stuff, <a href="#">click here</a>.';
//end here
mysql_close($con);
}
//another one
?>

---------- Post added 09-27-2011 at 12:01 AM ---------- Previous post was 09-26-2011 at 11:57 PM ----------

anyone to help me out................?????

[misson]

There is far too much noise in this thread; it's almost unreadable. Go back and edit your posts as much as possible to remove the extraneous code. If that's not possible, it's better to abandon this thread and start from scratch, after following the advice from my previous post.

[essellar]

This is the relevant code:

<?php session_start(); if(!isset($_SESSION['myusername'])) header("location:http://localhost/irs/login/loginphase.htm");?>

// html stuff and code not involved

<?php
    //store the data in session
    $appdate=date('Y-m-d');
    $host="localhost"; // Host name
    $hostusername="root"; // Mysql username
    $hostpassword="root"; // Mysql password
    $db_name="jobdatabase"; // Database name
    $tbl_name="appsent"; // Table name
    $varholder=$_SESSION['myusername'];
    $con= mysql_connect("localhost","root","root");
    mysql_connect("$host", "$hostusername", "$hostpassword")or die("cannot connect");
    mysql_select_db("$db_name")or die("cannot select DB");
    $result=mysql_query("SELECT * FROM appsent WHERE employer='$_SESSION[myusername]' ");
    if (!$result) {
        echo 'Could not run query: '. mysql_error();
        exit;
        }

    $row=mysql_fetch_row($result);
    //store session for the displayed application
    echo '<strong>Post Applied for: </strong>'.$row[1].'<br/>';
    echo '<strong>Applied by: </strong>'.$row[2].'<br/>';
    echo '<strong>Requirement: </strong>'.$row[4].'<br/>';
    echo '<strong>Location: </strong>'.$row[5].'<br/>';
    echo '<strong>Interview Question: </strong>'.$row[6].'<br/>';
    echo '<strong>Interview answer: </strong>'.$row[7].'<br/>';
    echo '<strong>Area of Specification: </strong>'.$row[8].'<br/>';
    echo '<strong>Closing Date: </strong>'.$row[10].'<br/>';
    echo "<strong>Jobseeker's CV: </strong>".'<br/>'.$row[9].'<br/>';

    $paf=$row[1] ;
    $_SESSION['paf']=$paf;
    echo $paf;
    $pab=$row[2] ;
    $_SESSION['pab']=$pab;
    $pem=$row[3] ;
    $_SESSION['pem']=$pem;
    $preq=$row[4] ;
    $_SESSION['preq']=$preq;
    $ploc=$row[5] ;
    $_SESSION['ploc']=$ploc;
    $piq=$row[6] ;
    $_SESSION['piq']=$piq;
    $pia=$row[7] ;
    $_SESSION['pia']=$pia;
    $paos =$row[8] ;
    $_SESSION['paos']=$paos;
    $pcv =$row[9] ;
    $_SESSION['pcv']=$pcv;
    $pcd =$row[10] ;
    $_SESSION['pcd']=$pcd;
    $padt =$row[10] ;
    $_SESSION['padt']=$padt;

    //irrelevant code removed
    mysql_close($con);
?>
//html removed

As you can see, half of the code is missing -- the half where you try to retrieve the data. Just in order to make the code you do have make more sense, assign the results to the variables first, then echo the variables (instead of using the row twice).

You can also run a foreach on $_SESSION to echo the keys and values as a quick test to make sure that the session contains what you think it does.

Just as an aside, you'll want to change the code to avoid using the mysql_xxx functions -- they are being deprecated, so they're going to start throwing warnings soon and will be removed from the language altogether at some point. Use PDO or mysqli_xxx instead.

[pe_es171]

please could you pls correct with codes?

---------- Post added at 12:21 AM ---------- Previous post was at 12:19 AM ----------

Even after printing or echoing the data in the first php page,it sounded right.but it is not shown in the second php page when i tried to recall the saved session data

<?php
if(isset($_POST['Submit']))
{


$host="localhost";
$hostusername="root";
$hostpassword="root";
$db_name="jobdatabase";
$tbl_name="appconfirmation";
$con= mysql_connect("localhost","root","root");

mysql_connect("$host","$hostusername","$hostpasswo rd") or die("cannot connect");
mysql_select_db("$db_name") or die("cannot select DB");

$thisdate=date('Y-m-d');

$_POST=$_SESSION;

$thepaf=$_SESSION['paf']; echo $thepaf;
$thepab=$_SESSION['pab'];
$thepem=$_SESSION['pem'];
$thepreq=$_SESSION['preq'];
$theploc=$_SESSION['ploc'];
$thepiq=$_SESSION['piq'];
$thepia=$_SESSION['pia'];
$thepaos=$_SESSION['paos'];
$thepcv=$_SESSION['pcv'];
$thepcd=$_SESSION['pcd'];
$thepadt=$_SESSION['padt'];
//start off querying
$insertSQL= "INSERT INTO appconfirmation (postapplied,jobseeker,employer,requirement,locati on,interquest,interans,aofspeci,jobseekercv,status ,appdatecon)
VALUES('$thepaf','$thepab','$thepem','$thepreq','$ theploc','$thepiq','$thepia','$thepaos','$thepcv', 'accept','$thisdate')";


if (!mysql_query($insertSQL,$con))
{
die('Error: ' . mysql_error());
}
echo '<strong><font color="#FF0000">'."Application approved!!!"." ".':'.'</font></strong> ';
echo "<br />";
echo '<br>To view stuff, <a href="#">click here</a>.';
//end here
mysql_close($con);
}
//another one
?>