PHP - Redirecting User To Page Viewed Last After Sign Up... Trouble Passing Variable

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>

id not passing onto next page.
when i view the source code the id value is there. <a href='view_designs2.php?id='198'>
but when the next page loads there is nothing in the address bar.
 


Code: [Select]
<?php
echo "<table width='1000'  align='center'>";
$data=mysql_query("SELECT * FROM design WHERE jobno='$id' AND status!='rejected'") or die (mysql_error());
$counter = 0;
while ($info=mysql_fetch_array($data)){
  $img5=$info['name'];
  $id=$info['id'];
  $img=$info['thumbs'];

  



echo "<td>";
echo "Design By "."$img5 "."<br><br>";
echo "<a href='view_designs2.php?id='$id'><img src='../dthumbs/$img' style='text-align: center; width:250px; max-height:250px; border: solid 10px; border-radius: 5px; border-color:tan; -moz-box-shadow: 3px 3px 4px #000;
-webkit-box-shadow: 3px 3px 4px #000;
box-shadow: 3px 3px 4px #000;
-ms-filter: progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#000000');
filter: progid:DXImageTransform.Microsoft.Shadow(Strength=4, Direction=135, Color='#000000'); ''>";
echo "<br><br></td>";

$counter = $counter + 1;

if ($counter==3){
  echo "<tr>";
  $counter=0;
}
}
echo "</tr></table>";
?>'

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());
  }

?>

Hi guys, I've got a snippet of code that's supposed to make a new directory with the user's unique ID (member_id) in the database. I have the code here but I get a myriad of errors including the infamous "at line 1 error, and the directory does not create. Please help me!!

//Create Directory
$queryString2 = $_SERVER['QUERY_STRING'];
$query2 = "SELECT member_id FROM members WHERE $queryString2 = $row[activation]"; 
$result2 = mysql_query($query2) or die(mysql_error());
mkdir("/home/gafferzo/www/members/clubs/" . mysql_result($result2,0), 0777);  

The Script:

<?php

    echo "<h1>The Hashtag: </h1>";
    echo $_GET['hashtag'];

?>

An example for the URL on localhost:

/search.php?hashtag=#xbox

If I am not using the number sign, then the word "xbox" does get printed on screen, if I do use the number sign then the hashtag "#xbox" does not get printed on screen.   Any suggestions on how to do this?

this code is to create a new user based on posted variables. it works fine for creating the necessary tables and granting privileges. but then when i log out as root and try to log back in as the user it's failing. why is it failing? Thanks, G.

Code: [Select]
<?php
extract( $_POST );
include( '../php/userobject.php' );

@ $db = mysqli_connect('localhost', 'root', 'xxxxxx', 'mealchamp');
if ( mysqli_connect_errno() ) {
echo 'Error: could not connect to database as root.<br />';
exit;
}
else
echo 'Connected to database as root.<br />';

$query = "SELECT username FROM userlist WHERE username = $uname";
$result = mysqli_query($db, $query);

if ($result) 
echo 'That user name is already taken.<br/>Please hit back on your browser, and try a different user name.<br/>';
else {
echo 'That username is available.<br/>';
echo "$fname<br/>";
echo "$lname<br/>";
echo "$add1<br/>";
echo "$add2<br/>";
echo "$city<br/>";
echo "$prov<br/>";
echo "$ctry<br/>";
echo "$post<br/>";
echo "$email<br/>";
echo "$uname<br/>";
echo "$pass1<br/>";
echo "$sex<br/>";
echo "$birth<br/>";
echo "$height<br/>";
echo "$weight<br/>";

$query = "INSERT INTO userlist 
(firstname, lastname, address1, address2, city,  province, country, postal, email,  username, password, sex,  birth,  height,  weight) VALUES
('$fname', '$lname', '$add1', '$add2', '$city','$prov', '$ctry', '$post','$email','$uname', '$pass1', '$sex', '$birth', '$height',  '$weight')";
$result = mysqli_query($db, $query);
if ($result)
echo "Userlist was updated successfully<br />";
else
echo "Could not update userlist";

$query = "CREATE TABLE ".$uname."_persfood  
(persfoodid  INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 food   VARCHAR(30) NOT NULL)";
$result = mysqli_query($db, $query);
if ($result)
echo "Personal food table was created successfully<br />";
else
echo "Could not create personal food table<br />";

$query = "GRANT select ON mealchamp.userlist TO ".$uname." IDENTIFIED BY '$pass1'";
$result = mysqli_query($db, $query);
if ($result)
echo "User priveleges were granted successfully<br />";
else
echo "Could not grant user priveleges<br />";
$query = "GRANT select, insert, update, delete, index ON mealchamp.".$uname."_persfood TO ".$uname." IDENTIFIED BY '$pass1'";
$result = mysqli_query($db, $query);
if ($result)
echo "User priveleges were granted successfully<br />";
else
echo "Could not grant user priveleges<br />";

mysqli_close($db);

@ $db = mysqli_connect('localhost', $uname, $pass1, 'mealchamp');
if ( mysqli_connect_errno() ) {
echo 'Error: could not connect to database as user.<br />';
exit;
}
else {
echo 'Connected to database as user.<br />';
?>

i am trying to redirect a user to a certain page, if the credentials are not right.  if there is no session user, they are kicked out.  if it is set, but to the guest account, they go to the login page with a special error message.  here is my code for it:

Code: [Select]
if (!isset($_SESSION['user']))
{
  header('Location: portal.php?logintocontinue');
exit;
}
elseif($_SESSION['user'] == "guest") {
header('Location: portal.php?invalidLogin');
exit;
}
else {

}
after attempting to run the page, with session user = guest, i get this error message: The page isn't redirecting properly.

does it have to do with headers already being sent?

Hello,

I'm having some problems with a redirect situation.  I start on a page called Create Assignment.  From this page I pass (using GET) the variable assignment_id to a page called Add_questions (the user can add questions to this specific assignment).  When a user wants to add a question, they hit a link which brings them to my Database Update script.  All works great so far!  After the update, however, I want to redirect them BACK to the Add_questions page while keeping the same Assignment number.  I've tried using:
header('Location: list_assignment_question.php?assignment_id'); but I get this error:

Warning: Cannot modify header information - headers already sent by (output started at /Applications/MAMP/htdocs/algebra_book/main_scripts/db_insert_assignment_question.php:6) in /Applications/MAMP/htdocs/algebra_book/main_scripts/db_insert_assignment_question.php on line 12

Any thoughts?  I'd be more than happy to provide more code as needed.

Hi there, im trying to create a sign up page for my site! I have used confirm password and email fields on the form but the code still shows the error message even if the passwords and emails match! Can anyone advice me please? 

$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$month','$day','$year')
mysql_query($query);


The code above is a sample of what I have but what I want is to store an entire birthdate in ONE SQL cell. More like this...


$username = $_POST['username'];
$password = $_POST['password'];
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

$query = mysql_query("INSERT INTO users VALUES ('','$username','$password','$birthdate')
mysql_query($query);


How is this possible? Can I do this and actually use it efficiently in the future?

Any idea why this wont work? Think it has something to with how i'm passing the variables?

$latinsk  =$row['latinsk'];
$ID  =$row['id'];            
//-display  the result of the array
echo  "<ul>\n";
echo  "<li>" . "<p style='font-family:verdana;font-size:150%;'><a href='javascript:void()' onclick='window.location.href='search.php?id= '" . $ID . "'&latinsk= '" . $latinsk . "''; parent.scrollTo(0,0); return false'> "   .$latinsk . " </a></li>\n</p>";
echo  "</ul>";

Please help me out with sessions . I m new to this topic.

I am trying to allow the user to update a variable he chooses by radio buttons, which they will then input text into a box, and submit, to change some attributes. I really need some help here.  It works just fine until I add the second layer of variables on top of it, and I can't find the answer to this question anywhere.

<?PHP require('connect.php'); ?>

<form action ='' method='post'> <select name="id">

<?php
$extract = mysql_query("SELECT * FROM cars");
   
   while($row=mysql_fetch_assoc($extract)){
   $id = $row['id'];
   $make= $row['make'];
   $model= $row['model'];
   $year= $row['year'];
   $color= $row['color'];

echo "<option value=$id>$color $year $make $model</option>
";}?>

</select>

Which attribute would you like to change?<br />
<input type="radio" name="getchanged" value="make"/>Make<br />
<input type="radio" name="getchanged" value="model"/>Model<br />
<input type="radio" name="getchanged" value="year" />Year<br />
<input type="radio" name="getchanged" value="color"   />Color<br /><br />

   <br /><input type='text' value='' name='tochange'>
   <input type='submit' value='Change' name='submit'>

</form>

//This is where I need help...

<?PHP
if(isset($_POST['submit'])&&($_POST['tochange'])){
mysql_query("
   UPDATE cars
   SET '$_POST[getchanged]'='$_POST[tochange]'
   where id = '$_POST[id]'
         ");}?>

Is it okay to redirect a user to another page - which displays an outcome message - after a form is submitted?


Debbie

My website has been working just fine, and I negated a condition to trigger an error message, and now I keep getting this...
Quote

The page isn't redirecting properly


Here is the file I am working with...

<?php //Build Date: 2012-03-10

// ************************
// Update Last Activity. *
// ************************
if ((isset($_SESSION['loggedIn'])) && ($_SESSION['loggedIn'] == TRUE)){
// Initialize variables.
$loggedIn = 1;
$memberID = (isset($_SESSION['memberID']) ? $_SESSION['memberID'] : '');


// ************************
// Update Member Record. *
// ************************

// Connect to the database.
require_once(WEB_ROOT . 'private/mysqli_connect.php');

// Build query.
$q = "UPDATE member
SET logged_in=?,
last_activity=now()
WHERE id=?
LIMIT 1";

// Prepare statement.
$stmt = mysqli_prepare($dbc, $q);

// Bind variables to query.
mysqli_stmt_bind_param($stmt, 'ii', $loggedIn, $memberID);


// Execute query.
$success = mysqli_stmt_execute($stmt);

// Verify Update.
if ($success === FALSE){
// Update Failed.
$_SESSION['resultsCode'] = 'MEMBER_UPDATE_FAILED_2126';

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}

/*
$affectedRows = mysqli_stmt_affected_rows($stmt);

echo $affectedRows;
exit();

// Verify Update.
if ($affectedRows!==1){
//echo mysqli_stmt_affected_rows($stmt);
//exit();

// Update Failed.
$_SESSION['resultsCode'] = 'MEMBER_UPDATE_FAILED_2126';

// Redirect to Display Outcome.
header("Location: " . BASE_URL . "/members/results.php");

// End script.
exit();
}//End of UPDATE MEMBER RECORD
 */

// Close prepared statement.
mysqli_stmt_close($stmt);

// Close the connection.
// mysqli_close($dbc);
}//End of UPDATE LAST ACTIVITY

?>


This file is included by all other pages so that as a User navigates my site I am constantly updating the "last_activity" field in the database.

If I change the condition from...
Code: [Select]
if ($success === FALSE){
...to...
Code: [Select]
if ($success !== FALSE){
...then I get this error?!


(Where I am at, the Internet is on and offline.  Could that be a factor??)

I am REALLY CONFUSED what is happening here...   


Debbie