Page 1 of 1

Inserting Session into Database

Posted: Sat Jun 16, 2007 9:10 am
by franknu
Ok, I am very confuse on this one,

I have a page where users can send a message into the database which eventually the business can log in and he/she can see, his/her messages. that had been posted to his business,

i am doing it with a session which, i will call later to display the messages sent to that business

my problem is that the $_SESSION['BusinessName']; is not bein taken to page2. I did some testing and it takes other values to page2 but not BusinessName value

here is my code for page1 please help

Code: Select all

<?php 
session_start(); 
$_SESSION['BusinessName'] ='$BusinessName'; 
$_SESSION['test']='test 1'; // this is the test line

?> 


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

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


$query = "SELECT * FROM business_info WHERE `BusinessName`= '$BusinessName' "; 
$result = mysql_query($query) or die (mysql_error()); 
$row = mysql_fetch_assoc($result); 

$BusinessName= ($row['BusinessName']); 
$Keyword =($row['Keyword']); 
$Picture1 =  ($row['Picture1']); 
$Headline = ($row['Headline']); 
$Slogan2 = ($row['Slogan2']); 
$Description1 =($row['Description1']); 
$Description2 = ($row['Description2']); 
$Description3= ($row['Description3']); 
$Contact2 =  ($row['Contact2']); 
$Picture2 = ($row['Picture2']); 
$Picture3 = ($row['Picture3']); 
$Business_Address=($row['Business_Address']); 
$make=($row['make']); 
$type=($row['type']); 
$Tel=($row['Tel']); 
$Website=($row['Website']); 
} 
?> 


<center>

<?php 
 
$_SESSION['BusinessName']; 
?> 

<pre>_SESSION:<?php print_r($_SESSION); ?></pre>


<table width="200" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td valign="top">
	<?php include("includefiles/banner.php"); ?>
	<table width="778" border="0" cellpadding="0" cellspacing="0">
      <tr>



this // <pre>_SESSION:<?php print_r($_SESSION); ?></pre>

// on page1 display _SESSION:Array
(
    [BusinessName] => NEW ENGLAND SEAFOODS
    [test] => test 1
)

Code: Select all

AND THIS IS MY CODE FOR page2

<?php
session_start();


?>

<html>
<head>


<title>Send Message</title>

<?
  $BusinessName = addslashes($_POST['BusinessName']);

  $from = addslashes($_POST['from']);
  $status= addslashes($_POST['status']);
  $subject= addslashes($_POST['subject']);
  $message= addslashes($_POST['message']);
 
$BusinessName= $_SESSION['BusinessName'];
if(isset($_SESSION['BusinessName'])){
$query = "INSERT INTO  `messages` (`BusinessName`,`date`,`from`,`status`,`subject`,`message`)
VALUES ('".$_SESSION['BusinessName']."','".$date."','".$from."', '".$status."','".$subject."',
'".$message."')";

$result = mysql_query($query);
echo mysql_error();

if($result)
         {
echo mysql_affected_rows()." .Your Message have been sent. We will get back to you. <br>";
          }
}


?>


<center>





<pre>_SESSION:<?php print_r($_SESSION); ?></pre> This on page2 display[b] SESSION:Array
(
    [BusinessName] => 
    [test] => test 1
)[/b]

<table width="200" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td valign="top">
	<?php include("includefiles/banner.php"); ?>
<td width="282"><? echo'<input name="from"  type="text" size="60">'; ?></td>
                            </tr>
                            <tr>
                              <td bgcolor="#CCCCCC"><strong>Subject </strong></td>
                              <td><? echo'<input name="subject" type="subject"  size="60">'; ?></td>
                            </tr>
                            <tr>
                              <td bgcolor="#CCCCCC"><strong>Body</strong></td>
                              <td><p>
                                <? echo'<textarea name="message" cols="75" rows="10"></textarea>'; ?>
                              </p>
                                <p>&nbsp;</p></td>
                            </tr>
                            <tr>
I am able to insert all the info exept for the BusinessName wich actually is not on page2 that is why is not going into the database

Posted: Sat Jun 16, 2007 9:18 am
by volka
please run the script feyd has posted here: viewtopic.php?p=385397#385397 (and a thousand other places, too ;))
and show us the output.