PHP - Using $_post Values Across A Number Of Pages ??

I have a table that I must be populated based on a check box selection. The maximum selection is 5, however, there are more then 10 choices. For example: Here is a choice of 10 different (checkbox) options that the user can select from:

1. Coke
2. Root Beer
3. Pepsi
4. Dr. Pepper
5. Sprite
6. 7up
7. Cream Soda
8. Club Soda
9. Water
10. Milk

I've already managed to limit the users selection to only 5. My issue is determining which of the checkboxese were actually selected so that I can correctly place them in my database.

The first thing to do is create variables from all the checkboxes:

$coke = $_POST['coke'];
$rootbeer = $_POST['rootbeer'];
$pepsi = $_POST['pepsi'];
$drpepper = $_POST['drpepper'];
etc. etc.

Now that I have all 10 selections as variables from a submitted form how can I determine which ones are empty (or which ones have values) so that I can then save them to the database respectively?

Well I have a script file that loads lots of info from a form using $_POST[] method, which is quite tedious:

Code: [Select]
  $act = $_POST["act"];
          $page = $_POST["page"];
  $id = $_POST["id"];
  $category = $_POST["category"];
          $itemname = $_POST["itemname"];
          $description = $_POST["description"];
  $imageurl = $_POST["imageurl"];
  $existingimageurl = $_POST["existingimageurl"];
  $function = $_POST["function"];
  $target = $_POST["target"];
  $value = $_POST["value"];
  $shop = $_POST["shop"];
          $price = $_POST["price"];
  $tradable = $_POST["tradable"];
  $consumable = $_POST["consumable"];

I was wondering if there is a way to write one or two simple lines of code to load all variables stored in superglobal array $_POST[] efficiently. The point is to store all values within $_POST[] to an array called $item[], what I was thinking about is:

Code: [Select]
foreach($_POST = $key as $val){
  $item['{$key}'] = $val;
}

Seems that its not gonna work, so I wonder if anyone of you have ideas on how I am able to simplify my code with 10-20 lines of $_POST[] to just 2-3 lines. Please do lemme know if this is possible, thanks.

I'm trying firstly to output hidden fields based on the values of the $_POST variable.

Then after that I want to output the values again in a unordered list.

I'm using the following code:
while (list($key, $val) = each($_POST)) {
if ($key != 'Submit') {
echo '<input type="hidden" name="' . $key . '" value="' . $val . '" />';
}
}

echo '<ul>';
while (list($key, $val) = each($_POST)) {
if ($key != 'Submit') {
echo '<li><strong>' . $key . '</strong>: <span class="highlight-219ddb">' . $val . '</span></li>';
}
}
echo '</ul>';

However the <ul> appears to be blank? Can I only use the list() function once on a particular variable?

Hi all,

I'm looking for some pointers in regards to my form..

How would  I firstly trim the $_POST value of the variables that come through via the form (I'm only using one for now)..I know I'm making a right dogs dinner of it. 

In my head I'm thinking, trim all the posts first before i even assign a variable to it ( i dont know if thats possible), then use an array for when more values start coming through via the form. You know as i make a contact form that requires more data from the user..

 

<?php
require_once '../connection/dbconfig.php';

include_once('../connection/connectionz.php');
//get the values



//Get the request method from the $_SERVER
$requestType = $_SERVER['REQUEST_METHOD'];
//this is what type
//echo $requestType ;

if($requestType == 'POST') {
	
	//now trim all $_POSTS
	$search_products = trim($_POST['search_products']);

	//
	if(empty($search_products)){
		echo '<h4>You must type a word to search!</h4>';
	}else{
		$make = '<h4>No match found!</h4>';
		
		$new_search_products = "%" . $search_products . "%";

		$sql = "SELECT * FROM product WHERE name LIKE ?";
		//prepared statement
		$stmt = mysqli_stmt_init($conDB);
		//prepare prepared statements
		if(!mysqli_stmt_prepare($stmt,$sql)) {
			echo "SQL Statement failed";
		}else{

			//bind parameters to the placeholder
			mysqli_stmt_bind_param($stmt, "s", $new_search_products );
			mysqli_stmt_execute($stmt);

			$result = mysqli_stmt_get_result($stmt);
			echo'<h2> Search Result</h2>';
			
			echo 'You searched for <strong><em>'. $search_products.'</em></strong>';
			while($row = mysqli_fetch_assoc($result)){
			echo '<h4> (ID						: '.$row['pid'];
			echo ') Book Title						: '.$row['name'];
			echo '</h4>';
		}
	}

}
	}
;?>

 

If any one can shed some light on this, or some pointers..that would be very nice...

Thanks

Darren

 

 

 

So, i need this.

Code: [Select]
 
  <?php
    $query = "Select * from users where username = '$user' ";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);

    $test = $_POST['test1'];
    $ques = "Select * from questions where testname = '$test' ";
    $qres = mysql_query($ques) or die(mysql_error());
    $qdetails = mysql_fetch_array($qres);
    $id = $qdetails['id'];
    $testname = $qdetails['testname'];
    $ans = "Select * from answers where qid = $id";
    $ares = mysql_query($ans) or die(mysql_error());
    if($qdetails) {
    ?>
    <div class="padding">

    <form name="answerform" action="answer.php" method="POST">
    <h3>&nbsp;</h3>
    <input name="test2" id="test2"  type="text" value="<?php echo $qdetails['testname'];?>"      /><h3><?php echo $qdetails['text'];?></h3>
     <input name="test3" id="test3"  type="text" value="<?php echo      $qdetails['testseries'];?>" /><h3><?php echo $qdetails['text'];?></h3>
    <br />
    <br />
    <br />
    <?php while($opdetails = mysql_fetch_assoc($ares)) { ?>
    <input class="text" id="opt2" name="correctans" type="radio" value="<?php echo $opdetails['text']; ?>" /><br /><?php echo $opdetails['text']; ?>  <?php }?>
    <div class="two-fields clearfix".
    <p class="confirm">&nbsp;</p>
    </div>
    <input type="submit" value="SUBMIT ANSWER" />
    </form>
    </div>
    </div>
    </div>
 <?php }

this is the code for the program where i am creating the fields i want to fetch the data from the input fields with the name test 2 and test 3 in answer.php

Code: [Select]
    $query = "Select score from users where username = '$user' ";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $user_score = $row['score'];

    print_r($_REQUEST);
    $tester = $_POST['test3'];
    $test = $_POST['test2'];
    print_r($_POST);
    var_dump($_POST);
    $ques = "Select * from questions where testname = '$test' And testseries = '$tester' ";
    $result = mysql_query($ques) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $qid = $row['id'];
    $score = $row['score'];
    if(isset($_POST['correctans']))
    {
    $answer = $_POST['correctans'];
    }
    else
    {
    $answer = '';
    }
    $fetch_ans = "Select * from answers where correct = 1 AND qid = $qid";
    $result = mysql_query($fetch_ans) or die(mysql_error());
    $row = mysql_fetch_array($result);
    $id = $row['id'];
    $correctans = $row['text'];

    if('$correctans' == '$answer')
    {
    $user_score += $score;
    $qid++;
    $query = "Update users set score = $user_score  where username = '$user'";
    $res = mysql_query($query) or die(mysql_error());
    if($res) {
 
header("Location: answer.php"); 
    }
    }else
    {
header("Location: answer.php");
    }


    ?>
THIS IS answer.php and here i try to post information from test2 and test3 fields  but i am not getting any output
the output shows blank array()
and unidentified index test2
and unidentified index test3
i am not able to figure out the error
any help will be highly appreciated
and forgive me if i have made any mistakes in posting the question since i am a newbie at PHPFREAKS

hi guy's i have on one page select from table, and i don't know how to limit showing content from database on 3, and rest to make number under it and when i click on that number next 3 is showen? Something like on forum when you have more topics then you can show, on botom of page are showen numbers (links). Can some explain me how to do this? i put in while loop something like this
Code: [Select]
while ($prom = mysql_fetch_object($res) and $i<3) and now it is limited on showing first 3, my problem is showing next 3, and if there is more how to split it on 3 per page?

<?php
  $ThreadID = $_GET['threadid'];
  If (isset($_GET['page'])) { $Page = intval($_GET['page']); }
  Elseif (isset($_POST['page'])) { $Page = intval($_POST['page']); }
  Else { $Page = 1; }
  $ThreadQry = "SELECT * FROM ".FORUM_THREADS." WHERE thread_id='{$ThreadID}'";
  $ThreadRes = mysql_query($ThreadQry, $db);
  $ThreadTitle = mysql_result($ThreadRes, 0, 'thread_title');
  $ForumID = mysql_result($ThreadRes, 0, 'forum_id');
  $Locked = mysql_result($ThreadRes, 0, 'locked');
  
  If ($Page == 1) { $Limit = 0; }
  Else { $Limit = $Page * 20; }
  $Limit2 = $Limit + 20;
  $PostsTotal = mysql_num_rows(mysql_query("SELECT * FROM ".FORUM_POSTS." WHERE thread_id='{$ThreadID}'", $db));
  $PostsQry = "SELECT * FROM ".FORUM_POSTS." WHERE thread_id='{$ThreadID}' ORDER BY  `post_id` ASC LIMIT {$Limit}, {$Limit2}";
  $PostsResult = mysql_query($PostsQry, $db);
  $PostsOnPage = mysql_num_rows($PostsResult);
  $PostCounter = 0;
  
  $PermissionQuery = "SELECT * FROM ".PERMISSIONS." WHERE forum_id='".$ForumID."'";
  $PermissionResult = mysql_query($PermissionQuery, $db);
  $PermissionPostReply = mysql_result($PermissionResult, 0, 'min_post_reply');
  $PermissionReply = intval($PermissionPostReply);
?>
<div class='tableborder'>
    <?php if ($MemLevel >= $PermissionReply) { 
        If ($Locked == 'no') {
    ?>
    <div align="right" style="background-color: #979797">
        <a href="./index.php?act=reply&threadid=<?php echo $ThreadID; ?>"><img src="./images/reply.png"></a>
    </div>
    <?php }
    Else {
        ?>
        <div align="right" style="background-color: #979797">
        <?php If ($MemLevel >= 1000) { Echo "<a href='./index.php?act=reply&threadid={$ThreadID}'>"; } ?><img src="./images/locked_reply.png"> <?php If ($MemLevel >= 1000) { Echo "</a>"; } ?><br>
    </div>
    <?php
    }
    }
    ?>
<div class='maintitle' align='left'><img src='./images/nav_m.gif' border='0' alt='' width='8' height='8'>&nbsp;<a href="./index.php?act=viewthread&threadid=<?php echo $ThreadID; ?>"><?php echo $ThreadTitle; ?></a></div>
<table width="100%" border="0" cellspacing="1" cellpadding="4">
    <tr>
        <th align="Center" width="20%" class='titlemedium'>Author</th>
        <th align="Left" width="80%" class='titlemedium'>Post</th>
    </tr>
<?php
  While ($PostCounter < $PostsOnPage) {
?>
    
<?php  
  $PostCounter++;   
  }
?>
</table>
</div>

This is what I have so far for displaying a thread in a forum. This is set to retrieve 20 Posts per page for each thread.
What I want to do is At the bottom under </table> is display a drop down box which will add a selection for each page of posts. How would I work out how many pages this drop down box needs to add?

The posts table is stored in a constant called FORUM_POSTS and they are sorted into threads by thread_id in that table.

Hi everyone,

I have this script that identify's the current page in the navigation

Code: [Select]
<?php $currentPage = basename($_SERVER['SCRIPT_NAME']); ?>
<ul id="nav"><!-- Open Nav -->
    <li><a href="index2.php" <?php if ($currentPage == 'index2.php') {echo 'class="selected"';} ?>>Home</a></li>
    <li><a href="salon-information.php" <?php if ($currentPage == 'salon-information.php') {echo 'class="selected"';} ?>>Salon Information</a></li>
    <li><a href="about-us.php" <?php if ($currentPage == 'about-us.php') {echo 'class="selected"';} ?>>About us</a></li>
    <li><a href="hair-care-advice.php" <?php if ($currentPage == 'hair-care-advice.php') {echo 'class="selected"';} ?>>Hair Care Advice</a></li>
</ul><!-- Close Nav -->


My problem is that hair-care-advice.php has a number of sub pages. How do I get it so the selected class remains selected for all the sub pages as well as the main page.

Any help would be greatly appreciated

Thank you

Barry

Hi Everyone.

i have a page which list all records. i then have several detail pages which i need to link via the id number. for ex.

records:
id number name
1 john smith
2 peter parker

the detail page is layout out like so:
View details page 1 | view details page 2 | view details page 3

Any help would be appreciated. Thanks.

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 have a script that was written and tested on another server, but now when I transferred it to the live server, session values are not being passed.  I made a couple test pages to check and confirmed that the only issue is the session variables.  Here is the test I performed.  Please tell me what I'm missing:

page1.php
<?
session_start();
$_SESSION['var1'] = 'testing';
print_r($_SESSION);
?>

Returns:
Array ( [var1] => testing )

page2.php
<?
session_start();
print_r($_SESSION);
?>
Returns:
Array ()

I have a page that contains a List box containing a list of categories taken from a mysql database, 4 iframe elements and 4 submit button (code to follow) When an item is selected from the List box the onchange event submits the page to jobs.php and loads it into the joblist iframe. Once the iframe is loaded and visible it makes the "Add Job To Category" submit button visible. This all works great When I click the "Add Job To Category" Submit button it loads Jobnew.php into the jobed iframe this is working but I can not seem to figure out how to pass the selected item from the List box using this submit button I hope I am clear in my question if not please advise any help is very much appreciated.... Jobtask.php

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Job Configuration</title>
<head>
</head>
<body>
<div style="position:absolute;left:5px;top:0px;width:1345px;height:50px;z-index:0;">
<img src="images/img0001.png" id="Shape1" alt="" style="border-width:0;width:1345px;height:50px;"></div>
<span style='position:fixed;left:525px;top:8px;font-family:Arial;font-size:32px;width:275px;'>Job Configuration</span>
<form action='index.html' target='' method='post'>
 <div style="position:absolute;left:205px;top:55px;width:1345px;height:50px;z-index:0;">
  <Input type="submit" action="index.html" Target="_top" method='post'Value="Main Menu">
 </div>
</form>
<form style=position:fixed;left:200px;top:82px;>    
 <iframe name='joblist' id='joblist' style=position:fixed;left:200px;top:px;visibility:hidden;z-index:10 src='' height="475" width="1150" scrolling='yes' frameBorder='0' ></iframe>    
 <iframe name='job' id='job' style=absolute:fixed;left:200px;top:0px;visibility:hidden;z-index:0 src='' height="475" width="1150" scrolling='yes' frameBorder='0' ></iframe>    
 <iframe name='jobed' id='jobed' style=position:fixed;left:460px;top:150px;visibility:hidden;z-index:10 src='' height="217" width="350" scrolling='no' frameBorder='0' ></iframe>   
 <iframe name='newcat' id='newcat' style=position:fixed;left:460px;top:150px;visibility:hidden;z-index:10 src='' height="125" width="350" scrolling='no' frameBorder='0' ></iframe> 
</form>
<?php
error_reporting(E_ALL);
include('dbcon/dbconnect.php');
$con=mysqli_connect($host,$user,$password,$db);
// Check connection
if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if (isset($_POST['id'])) {
  $insql= "INSERT INTO catagory (Catagory) VALUES ('$_REQUEST[newcat]')";
  $con->query($insql);
  }
$Catresult = mysqli_query($con, "SELECT CatID, Catagory FROM catagory");

echo "<div id='wb_CatSel' style='position:absolute;z-index:0;text-align:center;'bgcolor='#00b0e6';>";
echo "<span style='position:fixed;left:10px;top:82px;font-family:Arial;font-size:15px;background-color:#00b0e6;width:175px;'>Select Category</span></div>";
echo "<form action='jobs.php' target='joblist' style='position:fixed;left:10px;top:101px;'></td>";

echo "<select name='cat' size='11' style='width: 175px;' onchange='this.form.submit()'>";

while($row = mysqli_fetch_array($Catresult))
{ 
  echo "<option value=\"".$row['CatID']."\">".$row['Catagory']."</option>\n  ";
}

echo "</select>";

echo "</form>";

echo "<form action='Jobnew.php' target='jobed' method='post'>";
echo "<div style='position:absolute;left:10px;top:285px;width:1345px;height:50px;z-index:0;'>";
echo "<Input type='hidden' id='id1'><Input type='submit' id='sbtn' style='width:175px;visibility:hidden;'   Value='Add Job To Category'></div></form>";

echo "<form action='Jobtask.php' target='' method='post'>";
echo "<div style='position:absolute;left:10px;top:310px;width:1345px;height:50px;z-index:0;'>";
echo "<Input type='submit' style='width:175px;' action='Jobtask.php' Target='_top' method='post'  Value='Reset Form'></div></form>";

echo "<form action='newcat.php' target='newcat' method='post'>";
echo "<div style='position:absolute;left:10px;top:335px;width:1345px;height:50px;z-index:0;''>";
echo "<Input type='submit' style='width:175px;'' action='newcat.php' Target='newcat' method='post'  Value='Add New Category'></div></form>";

?>

</body>
</html> 

Hi,


I have set up 2 php pages

page 1 - add_entry2.php
In this page I have a invoice table created where I can dynamically add/delete rows. This has a View Bill button which takes me to page 2- add_entry3.php
In this page it shows up the rows added in page 1 in read only format, so if the user wants to modify the data that he/she entered then he must Click on <back> that i have provided in the page 2 which will direct him to page 1

Now the problem starts here
on click of Back the dynamically added rows dissappear..which is frustrating..I know its something to do with my code..but can anyone help me fix it.

One more thing is that i dont want to store the data into DB till the finalise button is clicked on page 2 so that means till page 2 is submitted nothing goes to DB from Page 1. 


I am able to retain values if I use the code Code: [Select]
<form action="add_entry2.php" name="eval_edit" method="post" format="html">
i,e if I submit back to the same page and retrieve values form $_POST


but If I use the code Code: [Select]
<input type="button" value="Back" onClick="history.go(-1);return true;">to get back to add_entry2.ph it looses all the values. Is there any other way to code the BACK link retaining my $_POST values(Do you think $_SESSION would work in this case?)

What I have so far is a page that produces a list of usernames with checkboxes next to them.  From the usernames that I check, I want to update a field for each of those users.  My problem is that the number of checkboxes I check is not going to be static so I am pretty sure I have to run a loop based on the number of checked checkboxes ("People chosen").  Here is what I have so far:

Code: [Select]
<?php
if (isset($_POST['submit1'])) {

  $pick = $_POST["pick"];
        $how_many = count($pick);
        echo 'People chosen: '.$how_many.'<br><br>';
       
   
      
            echo "<br><br>";
$count = 0;
while ($count < $how_many) {
//mysql code probably should go here but I am stuck


$count++;

}

    } else {

$gender = mysql_real_escape_string($_POST['Gender']);
$limit = mysql_real_escape_string($_POST['limit']);




echo $gender;
echo "<br />";
$count = 0;
if ($gender == 'Male') {
$result = mysql_query("SELECT * FROM users WHERE gender =\"1\" LIMIT 0, $limit", $connection);
if (!$result) {
die("Database query failed: " . mysql_error());
} 
?> <form method="post"> <?php
 while ($row = mysql_fetch_array($result)) {
 ?> <input name="pick[]" type="checkbox" value="<?php echo $row['username'] ?>"><?php
 echo $row['username'];?> <br />
<?php
 }
 ?>
<input type="submit" name="submit1" value="Make Offer" />
</form>
<?php
 }
 ?>
 

I hope this makes sense.  Any help would be greatly appreciated.