Inserting Session into Database

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
franknu
Forum Contributor
Posts: 146
Joined: Sun May 28, 2006 9:29 am

Inserting Session into Database

Post 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
User avatar
volka
DevNet Evangelist
Posts: 8391
Joined: Tue May 07, 2002 9:48 am
Location: Berlin, ger

Post 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.
Post Reply