PHP - Passing Variable To Next Page Something Strange

Hello,

I'm trying to build a small project; and as part of it - I want users to search and when presented with relevant enteries in the SQL database - they should be able to click and retrieve a page dedicated to that entity.

The problem I am having is in passing the 'id' of the search result onto the next (description) page.

Code: [Select]
$SQL = "SELECT * FROM loads";
$result = mysql_query($SQL);


while ($db_field = mysql_fetch_assoc($result)) {
$clickid = $_GET['id'];
print $db_field['id'] ."<a href=\"load_info.php?id=$id"
  . $id . "\" target=\"_self\" title=\"\">More Info</a>;";
print $db_field['depart:'] . "<BR>";
print $db_field['dest'] . "<BR>";

}

I thought it was easy enough to pass the variable like above ("load_info.php?id=$id) and then grab it on the next page like so:

$val = $_GET['clickid'];

Unfortunately, it doesn't retrieve the info from the page before. If I insert a number in there, it does work correctly, but I really need the ID of the database entry to pass on so as to provide the user with further information.

If anyone could help it would be appreciated.

L.

i have this code in a form, i need to pass a variable $time to next page, how can i do that ?


      if( $sErr ) print "<script language='javascript' type='text/javascript'>location.href='#error';</script>";;;

else:

     print "<script language='javascript' type='text/javascript'>location.href='paypal.php';</script>";;;

So i got the following problem:

i got some pages : index.php , comment.php, viewArticle.php

When i try to submit something from comment.php appear a error "Undefined variable:result"
The var result is defined in index.php
When i click on one article from the list the function viewArticle() is requiring viewArticle.php and the function addcomment() is requiring comment.php

The addcomment function() is in viewArticle function()

I can't figure out what's wrong but I guess have something to do whit the form action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>"

index.php code
Code: [Select]
<?php

include('config.php');

$action = isset($_GET['action'])?$_GET['action']:"";

switch($action)
{
case 'viewArticle':viewArticle();break;
    default:homepage();
}

function homepage()
{
$result = array();
    $data = Article::getlist(1);
    $result['article']=$data['result'];
$result['total']=$data['totalrows'];
    require('homepage.php');
}

function viewArticle()
{
if( !isset($_GET['articleid']) )homepage();
$result = array();
    $result['article'] =  Article::getbyid((int)$_GET['articleid']);
$result['name'] = $result['article']->name;
addcomment();
require('viewArticle.php');
}

function addcomment()
{

   
if(isset ($_POST['submit'] ))
{
$comment = new Comment;
$set = array();
$set['usern']="HJhj";
$set['com']="aca wqeq";
$set['page']=7;
$comment->storeFormValues($set);
$comment->insertc();
}
    else require('comment.php');

}

?>
viewArticle.php code
Code: [Select]
<center>
<h1> <?php echo $result['article']->text ?> </h1>


comment.php code:

Code: [Select]
<form method='post' action="index.php?action=viewArticle&articleid=<?php echo $result['article']->id?>" >
<input type="hidden" name="id" value="56"/>

<ul>
<li>
  <input type="text" name="usern" id="usern" />
</li>

<li>
<textarea name="com" id="com" COLS=40 ROWS=6></textarea>
</li>

<input type="hidden" name="page" value="56" />
<input type="submit" name="submit" value="submit" />

</form>

Hi all,

I have my whole script working only the name of the upload file won't pass to the process.php page.  Any help much appreciated.  Prob just some silly mistake that i made but i can't for the life of me see it.

form

Code: [Select]

<form enctype="multipart/form-data" action="process.php" method="POST" name="books" title="Santa_Book">
     <img src="images/book/Enter_your_details.png" width="400" height="60" /><br />
     
 
 
 
  <ul id="inline_list">
 <input type="text" name="first_name" id="first_name" value="Text to be displayed here" onfocus="if(this.value==this.defaultValue)this.value='';" onblur="if(this.value=='')this.value=this.defaultValue;"/>


<label for="sur_name" class="inside">Name</label>
  <input name="sur_name" type="text" id="sur_name" class="inside" />
         
  <label for="sname">Surname</label>
  <br />
  Sex
          <select name="sex" id="sex">
            <option selected="selected">Please Select....</option>
            <option value="girl">Girl</option>
            <option value="boy">Boy</option>
          </select>
           <label for="age">Age</label>
          <input type="text" name="age" id="age" />
<br />
         

<label for="house_no">House No.</label>
<input type="text" name="house_no" id="house_no" />         
           <br />
                  <label for="street">Street Name</label>

<input type="text" name="street" id="street" />
         <br />
                <label for="town">Town</label>

 <input type="text" name="town" id="town" />

       
      <br />
      <br />
       <select name="bscf1" id="bscf1">
         <option selected="selected">Please Select...</option>
         <option value="Brother1">Brother</option>
         <option value="Sister1">Sister</option>
         <option value="Cousin1">Cousin</option>
         <option value="Friend1">Friend</option>
       </select>
                              <label for="bscf_name1">Friend / Sibling</label>

       <input type="text" name="bscf_name1" id="bscf_name1" />
       
     
     <br />
    <select name="bscf2" id="bscf2">
      <option>Please Select...</option>
         <option value="Brother2">Brother</option>
         <option value="Sister2">Sister</option>
         <option value="Cousin2">Cousin</option>
         <option value="Friend2">Friend</option>
       </select>
       <label for="bscf_name2">Friend / Sibling</label>
       <input type="text" name="bscf_name2" id="bscf_name2" />
       
       
      <br />
                        <label for="from_name">This book is from...</label>

          <input type="text" name="from_name" id="from_name" />
       
       <br />
          <input name="uploadedfile" type="file" id="uploadedfile" value="Upload Image" />
       
     <br />
   
       
 
 
 
  </ul>
 
 
 
<br />
 

 <input type="submit" value="Continue" />
 
</form>
 


process.php page

Code: [Select]
<?php 
 // Database connect
$con = mysql_connect("mysql1.myhost.ie","admin_book","root123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("book_test", $con);




//Parse Values from Coupon.php Form
$first_name  = mysql_real_escape_string(trim($_POST['first_name']));
$sur_name  = mysql_real_escape_string(trim($_POST['sur_name']));
$sex  = mysql_real_escape_string(trim($_POST['sex']));
$age  = mysql_real_escape_string(trim($_POST['age']));
$house_no = mysql_real_escape_string(trim($_POST['house_no']));
$street = mysql_real_escape_string(trim($_POST['street']));
$town = mysql_real_escape_string(trim($_POST['town']));
$bscf1 = mysql_real_escape_string(trim($_POST['bscf1']));
$bscf_name1 = mysql_real_escape_string(trim($_POST['bscf_name1']));
$bscf2 = mysql_real_escape_string(trim($_POST['bscf2']));
$bscf_name2 = mysql_real_escape_string(trim($_POST['bscf_name2']));
$from_name = mysql_real_escape_string(trim($_POST['from_name']));
$uploadedfile = mysql_real_escape_string(trim($_POST['name']));

if ($sex == 'girl')
{
$his_her = 'her';
} 
else 
{
$his_her = 'his';
}

if ($sex == 'girl')
{
$him_her = 'her';
} 
else 
{
$him_her = 'his';
}


$sql="INSERT INTO details (first_name, sur_name, sex, age, house_no, street, town, bscf1, bscf_name1, andy, bscf2, bscf_name2, his_her, him_her, from_name, uploadedfile)
VALUES
('$first_name','$sur_name','$sex','$age','$house_no','$street','$town','$bscf1','$bscf_name1','and','$bscf2','$bscf_name2','$his_her','$him_her','$from_name','$uploadedfile')";


// Where the file is going to be placed 
$target_path = "uploads/";

/* Add the original filename to our target path.  
Result is "uploads/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

$target_path = "uploads/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}



echo 'Thank you '. $first_name . ' for entering your details bro.<br />';
echo 'surname is : '. $sur_name . '.<br />';
echo 'sex is :  '. $sex . '.<br />';
echo 'age is: '. $age . ' .<br />';
echo 'bscf friend 1 is :  '. $bscf1 . '.<br />';
echo 'bscf name 1 is :  '. $bscf_name1 . '.<br />';
echo 'bscf friend 2 is :  '. $bscf2 . '.<br />';
echo 'bscf name 2 is :  '. $bscf_name2 . '.<br />';
echo 'his_her is : '. $his_her . ' .<br />';
echo 'him_her is :  '. $him_her . '.<br />';
echo 'From Name is :  '. $from_name . '.<br />';
echo 'Uploaded file is :  '. $uploadedfile . '.<br />';


if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }

?>

so the user is reading a story, to finish reading he has to click a link that redirects them to the signup page.
Code: [Select]
<?php
session_start();
$beginurl = $_SERVER['HTTP_REFERER'];
$_SESSION['beginurl'] = $beginurl;
echo $_SESSION['beginurl'];
?>
<html>
 <head>
  </head>
 <body>
<script type="text/javascript"><!--
location.replace("http://www.mysite.com/members/");
//--></script>
  </body>
</html>
When they get to the second page, they have to click a link that opens up a modal. this is the code that runs when they hit the register button

Code: [Select]
session_start();
$beginurl = $_SESSION['beginurl'];

$beginurl= (isset($_SESSION['beginurl'])) ? $_SESSION['beginurl'] : 'Error';

if( $_SESSION['status'] ='authorized')   
$_SESSION['$makemodal'] = 0;

//sends the user to the page upon successful password credential
if(!isset($_SESSION['SESS_USERID'])||(trim($_SESSION['SESS_USERID']=='admin')))
   {
        echo '<script language="javascript">';
         
echo "top.location.href = $beginurl";
        echo '</script>';
        exit();
    }

Am I passing this variable correctly?

and I'm not sure if the top.location.href towards the bottom is correct either, right now after I hit the register button I'm redirected to a blank page where the url is,

"http://www.mysite.com/function Error() { [native code]}"