session help - copying mysql variables from page 1 to page 2

201 100+

hello -

my sessions are working fine; how ever i've added some more variables to them.

problem:
page one: i have the variables, from the mysql result set. i.e. message, to reply set those variables in sessions from the current page to be copied over to the next page.

second page: it pulls the variables in no problem, but the query on insert is erroring out. saying that its should not be a result it should be a resource.

page one code:

Expand|Select|Wrap|Line Numbers

 
<?php

if (!isset($_SESSION)) {

  session_start();

}

?>

<?php require_once('mail.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}
 
$currentPage = $_SERVER["PHP_SELF"];
 
$Id = $_SESSION['Id'];   

$Name = $_SESSION['name']; 

$Group = $_SESSION['Group'];
 
if (isset($_GET['MailId'])) {
 
    $Mail_Id = htmlspecialchars($_GET['MailId']) ;
 
}
 
$Mail_vId = $Mail_Id ; 
 
$maxRows_MailView = 1;

$pageNum_MailView = 0;

if (isset($_GET['pageNum_MailView'])) {

  $pageNum_MailView = $_GET['pageNum_MailView'];

}

$startRow_MailView = $pageNum_MailView * $maxRows_MailView;
 
mysql_select_db($database_Mail, $Mail);

$query_MailView = "SELECT FromUser  as Name, Subject , Date, Id, Mail FROM mail where id='$id''";

$query_limit_MailView = sprintf("%s LIMIT %d, %d", $query_MailView, $startRow_MailView, $maxRows_MailView);

$MailView = mysql_query($query_limit_MailView, $Mail) or die(mysql_error());

$row_MailView = mysql_fetch_assoc($MailView);
 
$FromUser = mysql_result($MailView,0,'FromUser') ;

$Subject = mysql_result($MailView,0,'Subject') ; 

$Mail = mysql_result($MailView,0,'Mail') ;

$Id = mysql_result($MailView,0,'Id') ; 
 
$_SESSION['ToUser'] = $FromUser ; 

$_SESSION['Subject'] = $Subject ; 

$_SESSION['Mail'] = $Mail ; 

$_SESSION['Id'] = $Id ; 
 
if (isset($_GET['totalRows_MailView'])) {

  $totalRows_MailView = $_GET['totalRows_MailView'];

} else {

  $all_MailView = mysql_query($query_MailView);

  $totalRows_MailView = mysql_num_rows($all_MailView);

}

$totalPages_MailView = ceil($totalRows_MailView/$maxRows_MailView)-1;
 
$queryString_MailView = "";

if (!empty($_SERVER['QUERY_STRING'])) {

  $params = explode("&", $_SERVER['QUERY_STRING']);

  $newParams = array();

  foreach ($params as $param) {

    if (stristr($param, "pageNum_MailView") == false && 

        stristr($param, "totalRows_MailView") == false) {

      array_push($newParams, $param);

    }

  }

  if (count($newParams) != 0) {

    $queryString_MailView = "&" . htmlentities(implode("&", $newParams));

  }

}

$queryString_MailView = sprintf("&totalRows_MailView=%d%s", $totalRows_MailView, $queryString_MailView);
 
?>

<!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>

<title>  Mail View</title>

<div id="container">

 <div id="header">

    <h1>&nbsp;</h1>

    <p>&nbsp;</p>

    <p>&nbsp;</p>

  <!-- end #header --></div>

  <div id="sidebar1">

  <h3>&nbsp;    </h3>

    <!-- end #sidebar1 --></div>

  <div id="sidebar2">

    <h3>&nbsp;</h3>

  <!-- end #sidebar2 --></div>

  <div id="mainContent">

    <h1>&nbsp;</h1>

    <form name="form1" method="post" action="">

    <table border="1" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC" width="100%" height="100%">

      <tr></tr>

      <caption align="center" valign="top">

        Mail View

      </caption>

      <?php do { ?>

      <tr>

        <td>From User: <?php echo $row_MailView['name']; ?></td>

      </tr>

      <tr>

        <td>Subject: &nbsp;<?php echo $row_MailView['title']; ?></td>

      </tr>

      <tr>

        <td>Date: &nbsp;<?php echo $row_MailView['Date']; ?></td>

      </tr>

      <tr>

        <td>Message: <br /> &nbsp; &nbsp; &nbsp;<?php echo $row_MailView['Mail']; ?></td>

      </tr>

     <?php } while ($row_MailView = mysql_fetch_assoc($MailView)); ?>

    </table>

    <table align="center">

     <tr>

      <td><a href="mail_reply.php"><input type="submit"  name="reply" value="Reply" id="reply" /></a></td>

      </tr>

    </table>

</form>

<h2>&nbsp;</h2>

</body>

</html>

<?php

mysql_free_result($mail);

?>

page two code:

Expand|Select|Wrap|Line Numbers

 
<?php

if (!isset($_SESSION)) {

  session_start();

}

?>

<?php require_once('Mail.php'); ?>

<?php require_once('Friends.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}
 
$Id = $_SESSION['Id']; 

$Name = $_SESSION['name'];

$Group = $_SESSION['Group']; 
 
$FromUser = $_SESSION['ToUser'] ; 

$Subject = $_SESSION['MM_Subject'] ; 

$Mail = $_SESSION['Mail'] ;

$Id = $_SESSION['Id'] ; 
 
$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}
 
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
 
  // insert into mail table

  $insertSQL1 = sprintf("INSERT INTO mail (Id, SubjectId, ToUser, FromUser, `Date`) VALUES (null, last_insert_id(), '$ToUser', '$Id', now())")                                
 
  mysql_select_db($database_Mail, $Mail);

  $Result = mysql_query($insertSQL1, $Mail) or die(mysql_error());
 
  $insertGoTo = "mail.php";

  if (isset($_SERVER['QUERY_STRING'])) {

    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

    $insertGoTo .= $_SERVER['QUERY_STRING'];

  }

  header(sprintf("Location: %s", $insertGoTo));

}
 
mysql_select_db($database_Friends, $Friends);

$query_Friends = "SELECT Name FROM Friends WHERE id='$FromUser' ";

$Friends = mysql_query($query_Friends, $Friends) or die(mysql_error());

$row_Friends = mysql_fetch_assoc($Friends);

$totalRows_Friends = mysql_num_rows($Friends);
 
?>

<!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>

<title>Messages - New</title>

<style type="text/css"> 

</head>
 
<div id="container">

 <div id="header">

    <h1>&nbsp;</h1>

    <p>&nbsp;</p>

    <p>&nbsp;</p>

  <!-- end #header --></div>

  <div id="sidebar1">

  <h3>&nbsp;    </h3>

  <!-- end #sidebar1 --></div>

  <div id="sidebar2">

    <h3>&nbsp;</h3>

  <!-- end #sidebar2 --></div>

  <div id="mainContent">

    <h1>&nbsp;</h1>

<h2>&nbsp;</h2>

  <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">

    <table align="center" height="100" width="100">

      <tr valign="baseline">

        <td nowrap="nowrap" align="right">To:</td>

        <td><select id="ToUser" name="ToUser">

          <?php

do {  

?>

          <option value="<?php echo $row_Friends['Id']?>"<?php if (!(strcmp($row_Friends['Name'], $FromUser=$_SESSION['ToUser']))) {echo "selected=\"selected\"";} ?>><?php echo $row_Friends['Name']?></option>

          <?php

} while ($row_Friends = mysql_fetch_assoc($Friends));

  $rows = mysql_num_rows($Friends);

  if($rows > 0) {

      mysql_data_seek($Friends, 0);

      $row_Friends = mysql_fetch_assoc($Friends);

  }

?>

        </select></td>

        </tr>

      <tr valign="baseline">

        <td nowrap="nowrap" align="right">Subject:</td>

        <td><input type="text" name="Subject" value="Re: <?php echo $Subject ; ?> " id="Subject" size="32" /></td>

      </tr>

      <tr valign="baseline">

        <td nowrap="nowrap" align="center" valign="top">Mail:</td>

        <td><textarea name="Mail" cols="80" rows="30" id="Mail">  <?php echo "\n\n\n\n\n***********************************************************************************************************\n\n"; echo $Mail ; ?> </textarea></td>

      </tr>

      <tr valign="baseline">

        <td nowrap="nowrap" align="right">&nbsp;</td>

        <td><input type="submit" value="Send" name="Send" /></td>

      </tr>

    </table>

      <input type="hidden" name="MM_insert" value="form1" />

    </form>

  <p>&nbsp;</p>

    <p>&nbsp;</p>

  <!-- end #mainContent --></div>

</html>

<?php

mysql_free_result($Friends);

?>

thanks, in advance for your help,

theo werntz ii

Jan 29 '10 #1

Subscribe Post Reply

1445

by: Chip | last post by:

I am trying to get sessions to work on a log in screen to give certain users access to certain pages/directories. The problem is that when the login button is pushed (or the enter key pressed) the...

PHP

Session Cannot Always Access Database

by: Michael J. Astrauskas | last post by:

I have a site where a user logs in and a session variable I created is used to keep track of the fact that the user is logged in. This various pages query a MySQL database to get information...

PHP

Help seeing Session vars from Include scipts

by: james | last post by:

I am new to php and need some help getting the session variables into include files. (after-thought, Sorry for the drawn out post but I really, really need help....;) Here's what I'm doing.. ...

PHP

Session Security

by: bonehead | last post by:

I'm still a novice when it comes to session security issues. The problems I'm trying to solve may be fairly common, but I haven't seen examples of solutions in any of the books I've looked at. I...

PHP

session and back

by: Bob Bedford | last post by:

I'm planning to modify my site from "POST" to "SESSION"....This is because many times, when clicking "back" on the browser, the page has to be refreshed, and I absolutely want to avoid this, also I...

PHP

Session variables through frames - need help.

by: Dave Smithz | last post by:

Hi there, I have implemented a login sequence using session variables for a PHP/MySQL DB which I took over development. I read some books and this NG and it seemed straight forward. However the...

PHP

session

by: Eugene Anthony | last post by:

In my login.asp I have the following code:  <% Dim sSessionID, sMessage If Len(Request.Form("cmdSubmit")) > 0 then mySQL = "EXECUTE...

ASP / Active Server Pages

How do u set classic ASP session variables from an ASP.NET application???

by: Chris Newby | last post by:

My project currently requires that I integrate an ASP.NET application with an ASP application. One of the issues I'm having is that I have some very long strings being created in an ASP.NET...

ASP.NET

cookies and session variables

by: Japhy | last post by:

Hello, I need to save values typed into forms across several scripts, before the user actually 'submits' the form to update the mysql db. I have been exploring ways to do this, and looking for...

PHP

Session Variables Question

by: Michaelk | last post by:

Can somebody tell me how many Session variables would be considered exessive, and when they start really affect the server speed. For example on 20-30 asp pages I need to use about 200-300 session...

ASP / Active Server Pages

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

session help - copying mysql variables from page 1 to page 2

Similar topics