PHP - Passing Php Variables Across Pages

Hi there,   I want to pass a input variable from login_success.php which will be sent to sqlprocess.php as the variable 'SQLinput';   sqlprocess.php

$link = mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$query = $_REQUEST['SQLinput']; //You don't need a ; like you do in SQL
$result = mysql_query($query);
$numfields = mysql_num_fields($result);

login_sucess.php

<form action="" method="post"
   <label>
         <span>SQL Input :</span>
         <input type ="text" id="message" name="SQLinput" placeholder="Input SQL"></textarea>
     </label> 
	 <label>
         <span>SQL Output :</span>
         <output id="text" id="SQLoutput" ></input>	

<script type="text/javascript" charset="utf-8"> 
			
		// handles the click event for link 1, sends the query
function getOutput() {
  getRequest(
      'sqlprocess.php', // URL for the PHP file
       drawOutput,  // handle successful request
       drawError    // handle error
  );
  return false;
}  
// handles drawing an error message
function drawError () {
    var container = document.getElementById('output');
    container.innerHTML = 'Bummer: there was an error!';
}
// handles the response, adds the html
function drawOutput(responseText) {
    var container = document.getElementById('output');
    container.innerHTML = responseText;
}
// helper function for cross-browser request object
function getRequest(url, success, error) {
    var req = false;
    try{
        // most browsers
        req = new XMLHttpRequest();
    } catch (e){
        // IE
        try{
            req = new ActiveXObject("Msxml2.XMLHTTP");
        } catch (e) {
            // try an older version
            try{
                req = new ActiveXObject("Microsoft.XMLHTTP");
            } catch (e){
                return false;
            }
        }
    }
    if (!req) return false;
    if (typeof success != 'function') success = function () {};
    if (typeof error!= 'function') error = function () {};
    req.onreadystatechange = function(){
        if(req .readyState == 4){
            return req.status === 200 ? 
                success(req.responseText) : error(req.status)
            ;
        }
    }
    req.open("GET", url, true);
    req.send(null);
    return req;
}
</script>

<a href="#" onclick="return getOutput();"><button type="submit" id="search_btn" value="Submit">Submit</button> </a>
<div id="output">waiting for action</div>		

Prior to the JS code - I was able to peform this action - however the JS code enables me to post the query onto the same page. I would like essentially like to query the database through an input box and output the same result on the same page.   Thanks!  

I have the registration form blues!

form 1 collects the classes chosen, and passes an array of classes chosen(on a previous page), in a hidden field:
<input type="hidden" value="<?= $c_row['workshop_id'] ?>" name="wid[]" />

form 2  makes it a variable $wid = $_POST['wid'];
I'm trying to pass it to form 3, using the hidden input again, this time as a variable:

$wid = $_POST['wid'];
<input type="hidden" value="<?= $wid ?>" name="wid[]" />

The next page is a printable page. But I can't do anything with the classes, because it's some how made an array of an array???
I wrote:  $wid = $_POST['wid'];
 print_r($wid);

This produces---  Array ( => Array )

I want it to give me the original array? Is there a different way to do this?

Is it correct that in order to pass values from web page to web page that you either have to...

1.) Use a Cookie
2.) Use a Session
3.) Write/Read to a Database Record


Debbie

i am making a website and some part of which is to show user information...for this i had make a class and functions within it...one of the function is for retrieving values from database(im using mysql)...i know a variable is limited only in function,also tried $_session for this too..the function works fine ....but it is not sendind the information to the page from where im calling it...here is my code.....


in xyz.php file

<?php
class book{

public $v1;
public $v2;
public $v3;

   function book(){
   
   }
   
function page1(){

    $this->con=mysql_connect("localhost","root","usa");
   $this->db=mysql_select_db("truth",$this->con);
   
      }

   function page2($xyz){
   $this->page1();
     $query="SELECT * FROM member_signup WHERE Uid=$xyz";
     $result=mysql_query($query,$this->con);
    $result1=mysql_fetch_array($result);
    $_SESSION['info']=$result1;
    return $_SESSION['info'];
    return $result1;
   }
}?>

in show.php file

<?
require_once("xyz.php");

$pen = new book;

if($pen->page2(100011))
{ session_start();
 if (mysql_error())
       { print "Database ERROR: " . mysql_error(); }
 else{
 echo "cows";
 
   echo "<br>cows<br>";
   echo "my name is'".$_SESSION['info']."'";
   echo "my name is'".$_SESSION['FIRST_NAME']."'";  //i have a fied is db named FIRST_NAME
 

 }
}
else{echo "happy";}

?>

http://kansasoutlawwrestling.com/bio?username=wonder


<?php
if(isset($_GET['username']) && $_GET['username'] != ''){
$username = $_GET['username'];
$query = "SELECT bio.username AS username, ebw.manager_id AS managerid, ebw.finisher AS finisher, ebw.setup AS setup, ebw.music AS music, ebw.nicknames AS nicknames, bio.id AS id, bio.posername AS posername, bio.charactername AS charname, bio.style_id AS style, bio.status_id AS status FROM `efed_bio` AS bio LEFT JOIN `efed_bio_wrestling` AS ebw ON bio.id = ebw.bio_id WHERE bio.username = '$username'";
if(!$result = mysql_query($query)){ debug($query); }
while ($row = mysql_fetch_assoc($result)){
$fieldarray=array('id','username','posername','charname','style','managerid','finisher','setup','music','nicknames');
foreach ($fieldarray as $fieldlabel){
if (isset($row[$fieldlabel])){ 
$$fieldlabel=$row[$fieldlabel];
$$fieldlabel=cleanquerydata($$fieldlabel);
}
}
}

$query2 = "SELECT * FROM `efed_bio_quotes` WHERE bio_id = '$id'";
if(!$result2 = mysql_query($query2)){ debug($query2); }
$i = 0;
$quotes = array();
while($row2 = mysql_fetch_assoc($result2)){
$fieldarray=array('quote');

$quotes[$i] = $row2['quote'];
$i++;
}

if($managerid != ''){
$query = "SELECT * FROM `efed_bio` WHERE id = '$managerid'";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
$manager = $row['charactername'];
}
else{
$manager = 'None';
}

switch($style){
case 2:
//tag team query
break;

case 3:
$query3 = "SELECT * FROM `efed_bio_manager` WHERE bio_id = '$id'";
if(!$result3 = mysql_query($query3)){ debug($query3); }
while ($row3 = mysql_fetch_assoc($result3)){
$height = $row3['height'];
$weight = $row3['weight'];
$hometown = $row3['hometown'];
}
break;

case 4:
$query3 = "SELECT * FROM `efed_bio_referee` WHERE bio_id = '$id'";
if(!$result3 = mysql_query($query3)){ debug($query3); }
while ($row3 = mysql_fetch_assoc($result3)){
$height = $row3['height'];
$weight = $row3['weight'];
$hometown = $row3['hometown'];
}
break;

case 5:
$query3 = "SELECT * FROM `efed_bio_staff` WHERE bio_id = '$id'";
if(!$result3 = mysql_query($query3)){ debug($query3); }
while ($row3 = mysql_fetch_assoc($result3)){
$height = $row3['height'];
$weight = $row3['weight'];
$hometown = $row3['hometown'];
$job = $row3['job'];
}
break;

case 6:
//stable query
break;

default:
$query3 = "SELECT * FROM `efed_bio_singles` WHERE bio_id = '$id'";
if(!$result3 = mysql_query($query3)){ debug($query3); }
while ($row3 = mysql_fetch_assoc($result3)){
$height = $row3['height'];
$weight = $row3['weight'];
$hometown = $row3['hometown'];
}
break;
}



$query4 = "SELECT * FROM `efed_bio_history` WHERE bio_id = '$id'";
if(!$result4 = mysql_query($query4)){ debug($query4); }
if(mysql_num_rows($result4) == 0){
$kowtitles = '';
$kowawards = '';
}
else{
while ($row4 = mysql_fetch_assoc($result4)){
$kowtitles = $row4['kowtitles'];
$kowawards = $row4['kowawards'];

}
}
?>

<div id="bio">

        <h1><?php echo $charname; ?>'s Biography</h1>
<p class="biolinkpages"><a href="http://kansasoutlawwrestling.com/bio?username=$username&page=wrestling">Wrestling</a> | <a href="http://kansasoutlawwrestling.com/bio?username=$username?page=bio">Biography</a> | <a href="http://kansasoutlawwrestling.com/bio?username=$username?page=appearances">Appearances</a> | <a href="http://kansasoutlawwrestling.com/bio?username=$username?page=gallery">Gallery</a></p>

<?php
if(file_exists('images/fullshots/' . $posername . '.png')){
echo '<img class="fullshot" src="images/fullshots/' . $posername . '.png" />';
}
else{
echo '<img class="fullshot" src="images/fullshots/default.png" />';
}
?>
<h2>Personal</h2>
<?php 
switch($style){
case 2: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php
break;

case 3: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Nicknames:</td>
<td class="biotabledatab"><?php if (strlen ($nicknames) < 1) {  print "N/A"; } else { print "$nicknames";}?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php
break;

case 4: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php
break;

case 5: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php
break;
case 6: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php
break;

default: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">Nicknames:</td>
<td class="biotabledatab"><?php if (strlen ($nicknames) < 1) {  print "N/A"; } else { print "$nicknames";}?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Height:</td>
<td class="biotabledatab"><?php echo $height; ?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Weight:</td>
<td class="biotabledatab"><?php echo $weight; ?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">Hometown:</td>
<td class="biotabledatab"><?php echo $hometown; ?></td>
</tr>
</table>
<?php 
break;
}
?>
<h2>History</h2>
<?php 
switch($style){
case 2: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">KOW Titles:</td>
<td class="biotabledatab"><?php if (strlen ($kowtitles) < 1) {  print "N/A"; } else { print "$kowtitles";}?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;

case 3: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;
case 4: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;
case 5: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;
case 6: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">KOW Titles:</td>
<td class="biotabledatab"><?php if (strlen ($kowtitles) < 1) {  print "N/A"; } else { print "$kowtitles";}?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;
default: ?>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">KOW Titles:</td>
<td class="biotabledatab"><?php if (strlen ($kowtitles) < 1) {  print "N/A"; } else { print "$kowtitles";}?></td>
</tr>

<tr class="biotablerowa">
<td class="biotableheadingb">KOW Awards:</td>
<td class="biotabledatab"><?php if (strlen ($kowawards) < 1) {  print "N/A"; } else { print "$kowawards";}?></td>
</tr>
</table>
<?php
break;
}
?>
<?php
switch($style){
case 2:?>
<h2>Quotes</h2>
<ul id="quotes">
<?php
if(count($quotes) > 0){
for($i = 0; $i < count($quotes); $i++){
echo "<li>".$quotes[$i]."</li>";
}
}
else{
echo '<li>This tag team has no quotes.</li>';
}
?>
</ul>
<?php
break;
case 3:?>
<h2>Quotes</h2>
<ul id="quotes">
<?php
if(count($quotes) > 0){
for($i = 0; $i < count($quotes); $i++){
echo "<li>".$quotes[$i]."</li>";
}
}
else{
echo '<li>This manager has no quotes.</li>';
}
?>
</ul>
<?php 
break;
case 4:?>
<?php
break;
case 5:?>
<h2>Quotes</h2>
<ul id="quotes">
<?php
if(count($quotes) > 0){
for($i = 0; $i < count($quotes); $i++){
echo "<li>".$quotes[$i]."</li>";
}
}
else{
echo '<li>This staffer has no quotes.</li>';
}
?>
</ul>
<?php
break;
case 6:?>
<h2>Quotes</h2>
<ul id="quotes">
<?php
if(count($quotes) > 0){
for($i = 0; $i < count($quotes); $i++){
echo "<li>".$quotes[$i]."</li>";
}
}
else{
echo '<li>This stable has no quotes.</li>';
}
?>
</ul>
<?php
break;
default:?>
<h2>Quotes</h2>
<ul id="quotes">
<?php
if(count($quotes) > 0){
for($i = 0; $i < count($quotes); $i++){
echo "<li>".$quotes[$i]."</li>";
}
}
else{
echo '<li>This wrestler has no quotes.</li>';
}
?>
</ul>
<?php
break;
}
?>
<?php
switch($style){
case 2:?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manager/Valet:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Finisher:</td>
<td class="biotabledatab"><?php if (strlen ($finisher) < 1) {  print "N/A"; } else { print "$finisher";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Setup:</td>
<td class="biotabledatab"><?php if (strlen ($setup) < 1) {  print "N/A"; } else { print "$setup";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php
break;
case 3:?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manages:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php 
break;
case 4:?>
<?php
break;
case 5:?>
<?php
break;
case 6:?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manager/Valet:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Finisher:</td>
<td class="biotabledatab"><?php if (strlen ($finisher) < 1) {  print "N/A"; } else { print "$finisher";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Setup:</td>
<td class="biotabledatab"><?php if (strlen ($setup) < 1) {  print "N/A"; } else { print "$setup";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php
break;
default:?>
<h2>Wrestling</h2>
<table class="biotable" cellspacing="10px">
<tr class="biotablerowb">
<td class="biotableheadingb">Manager/Valet:</td>
<td class="biotabledatab"><?php if (strlen ($manager) < 1) {  print "N/A"; } else { print "$manager";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Finisher:</td>
<td class="biotabledatab"><?php if (strlen ($finisher) < 1) {  print "N/A"; } else { print "$finisher";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Setup:</td>
<td class="biotabledatab"><?php if (strlen ($setup) < 1) {  print "N/A"; } else { print "$setup";}?></td>
</tr>

<tr class="biotablerowb">
<td class="biotableheadingb">Entrance Music:</td>
<td class="biotabledatab"><?php if (strlen ($music) < 1) {  print "N/A"; } else { print "$music";}?></td>
</tr>
</table>
<?php
break;
}
}
?>
</div>