How I get the values to my third page form.

[thara]

Hello Everyone..

Im a programer in php with little experience.
I have a form with 3 pages. 1st page display categories which come from category table. then user can select 1 or upto 3 category there. Then 2nd page display that selected categories and need to display relevant subject to that categories. In second page I use radio button for selected categories to keep a one category as a main category. each categories' subjects display with check boxes. In there too, user can select 1 or 3 more subject in to a particular category. In third form page, that my problem was encounter, there I need to print out selected category and their subjects in a table.

first two pages are no problem for me and third form I have a problem in how to get categories and their subjects and they print as apiece in the page. like this

category1 | subject1, subject2, subject3
category2 | subject1, subject2, subject3, subject and so forth.

	$q = 'SELECT * FROM category ORDER BY category_id';
	$r = mysqli_query( $dbc, $q);
	$c = 0;
	$i = 0;
	echo '<form action="subjects.php" method="post">';
	echo '<table class="form_table" ><tr>'; 

while($row = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

	// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
	if( ($c % 2) == 0 && $c != 0){
		echo "</tr><tr>";
	}
	echo '<td width="50%"><input type="checkbox" name="category[]"  value="' . $row['category_id'] . '" />&nbsp;&nbsp;' . $row['category_name'] . '</td>';
$c++; 
} // while..
	// in case you need to fill a last empty cell:
	if ( ( $i % 2 ) != 0 ){

	// str_repeat() will be handy when you want more than 2 columns
	  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
	}
echo "</tr></table>";

?>

In second page 'subjects.php' I use

	if ( isset($_POST['submitted1']) && isset($_POST['category']) && sizeof( $_POST['category']) == 3 ) { 

	$_SESSION['category'] = $_POST['category']; 

	print_r ( $_SESSION['category']); 

	$q = 'SELECT * FROM category ORDER BY category_id';
	$r = mysqli_query( $dbc, $q);

	while($_SESSION = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

		foreach( $_POST['category'] as $value ) {

			if ( $value == $_SESSION['category_id']) {

					$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
							FROM category_subject
							INNER JOIN category ON category_subject.category_id = category.category_id
							INNER JOIN subject ON category_subject.subject_id = subject.subject_id
							WHERE category_subject.category_id = {$_SESSION['category_id']}";

					$r1 = mysqli_query( $dbc, $q);

					$c = $i = 0;

					echo '<table class="form_table" ><tr>'; 

					while($_SESSION = mysqli_fetch_array( $r1, MYSQLI_ASSOC  )){

						// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
						if( ($c % 2) == 0 && $c != 0){
							echo "</tr><tr>";
						}
						echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>';

					$c++; 

					} // while..

						// in case you need to fill a last empty cell:
						if ( ( $i % 2 ) != 0 ){

						// str_repeat() will be handy when you want more than 2 columns
						  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
						}

					echo "</tr></table>";					
			}
		}			
	} 

}

Those two pages working properly.

In third page that my problem page I tried something like this , but its not working.
value come from subject.php page.

	if ( ( isset($_POST['submitted2'])) && ( isset($_SESSION['category'])) && (isset( $_SESSION['subjects'])) && sizeof( $_SESSION['category']) == 1) { 

	//$_SESSION['category'] = $_POST['category'];

	print_r ( $_SESSION['category']);

	echo 'good';


} elseif ( ( isset($_POST['submitted2'])) && ( isset($_SESSION['category'])) && 
				(isset( $_POST['main_category'] ))) {

	print_r ( $_SESSION );	


	echo 'very good';

} 

So can any body tell me where is my mistake and help me fix this problem.

any help greatly appreciated.

thank you.

[thara]

page1.php page ok it display every category from my database.

echo '<td width="50&#37;"><input type="checkbox" name="category[]" value="' . $row['category_id'] . '" />&nbsp;&nbsp;' . $row['category_name'] . '</td>';

In my second page I need to display selected categories from 1st page and relevant subjects to that categories.
eg:
cat1 | sub1, sub2, sub3
cat2 | sub1, sub2, sub3,
cat3 | sub1, sub4, sub5 and so on.

every category has some subjects and all of those subjects should be display in my second page as category wise. subject also come from my subject table. category_subject table also available to make the relationship between every category and subject. In second page also working as I am expecting. above I have posted my second page coding.

But my problem is 3rd page.

In second page users can select 3 more subjects to 1 category. assume there is 3 category users can select 9 subjects. so my problem is how I bring those category and their subjects from 2nd page to my 3rd page.

actually I am very confusing here and I try to do this for days. unfortunately still I cant get my expecting results.

I waiting for any comments and those are greatly appreciated.

thank you.

[thara]

Thank you very much for your answers. ...

this is a example of what I'm try to do... http://www.myprivatetutor.com/tutor_registration.php
actually I'm trying to create such a registration form to my project.
category table, subject table and category_subject table I have created.

thanks for any comments.

[thara]

can any body help me to fix this problem...
thank you..

[vivek151189]

you can make use of session
ie $_SESSION because you can transfer data from one form to second but use the dat aof first form u can set it into session and then can use whereever you want

[vivek151189]

are you using session_start();
befor calling the session in each page
u can refer to the phpmanual for $_SESSION
http://php.net/manual/en/reserved.variables.session.php

[thara]

yes.. I have started session in my header.html file which is include file....

[vivek151189]

have you testd yor session by echo that it contains the value
just test it in the first page where you have initialize it
and if it contains the value then it can be call from another page
but you or not destroying the session on that page if so then it might be the problem

[thara]

in my 1st page do I need to save selected category values in session????

This is my first page 'category form'

						<h2>Select your Category</h2>

<?php

require_once ('../includes/config.inc.php');	
require_once( MYSQL2);

$q = 'SELECT * FROM category ORDER BY category_id';
$r = mysqli_query( $dbc, $q);

$c = 0;
$i = 0;

echo '<form action="subjects.php" method="post">';
echo '<table class="form_table" ><tr>'; 

while($row = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

	// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
	if( ($c % 2) == 0 && $c != 0){
		echo "</tr><tr>";
	}

	echo '<td width="50%"><input type="checkbox" name="category[]"  value="' . $row['category_id'] . '" />&nbsp;&nbsp;' . $row['category_name'] . '</td>';

$c++; 

} // while..

	// in case you need to fill a last empty cell:
	if ( ( $i % 2 ) != 0 ){

	// str_repeat() will be handy when you want more than 2 columns
	  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
	}


echo "</tr></table>";

?>
							<p>&nbsp;</p>
							<p>Please click 'Continue' button to proceed to next step</p>

						<input type="submit"  value="Continue" class="formContinue" />

						<input type="hidden"   name="submitted1"   value="TRUE" />

					</form>

[vivek151189]

you need to create a seesion at that place where u get the value for category first time

[thara]

It s my second page which is when I submit category page its going to my second page... in there I need to get category array... it page is 'subject.php'..

This is my second page (subject.php). there I used session to store category array.. But I dont know weather it is right or not... I am some confusing with session...

tell me this is correct..

						<form action="register.php" method="post" >

					<h2>Select Subjects</h2>

<?php

require_once ('../includes/config.inc.php');	
require_once( MYSQL2);


	if ( isset($_POST['submitted1']) && isset($_POST['category']) && sizeof( $_POST['category']) == 1 ) { 

		print_r ( $_POST ); // at this time post array contian only selected category from category page. 

		$_SESSION['category'] = $_POST['category']; 

		print_r ( $_SESSION['category']); 

		$q = 'SELECT * FROM category ORDER BY category_id';
		$r = mysqli_query( $dbc, $q);

		while($_SESSION = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

			foreach( $_POST['category'] as $value ) {

				if ( $value == $_SESSION['category_id']) {

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$_SESSION['category_id']}";

						$r1 = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

						while($_SESSION = mysqli_fetch_array( $r1, MYSQLI_ASSOC  )){

							// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
							if( ($c % 2) == 0 && $c != 0){
								echo "</tr><tr>";
							}
							echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>';

						$c++; 

						} // while..

							// in case you need to fill a last empty cell:
							if ( ( $i % 2 ) != 0 ){

							// str_repeat() will be handy when you want more than 2 columns
							  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
							}

						echo "</tr></table>";					
				}
			}			
		} 

	} elseif ( isset($_POST['submitted1']) && isset($_POST['category']) && ( sizeof( $_POST['category']) == 2 || sizeof( $_POST['category']) == 3 )) {

		echo "<pre>"; 
			print_r($_POST)	;
		echo "</pre>";


		foreach( $_POST['category'] as $value ) {	

					$q = "SELECT * FROM category WHERE category_id = $value ORDER BY category_id" ;
					$r = mysqli_query( $dbc, $q);

					$row = mysqli_fetch_array ( $r, MYSQLI_ASSOC); 			

						echo '<input type="radio" name="main_category[]" class="radio"  value="' . $row['category_id'] . '" />';			
						echo '<label for="" class="radio">&nbsp;&nbsp;' . $row['category_name'] . ' <strong>: Mark this category as my "Main Category"</strong></label><br />';

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$row['category_id']}";	

						$result = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

							while($row = mysqli_fetch_array( $result, MYSQLI_ASSOC  )){

								// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
								if( ($c % 2) == 0 && $c != 0){
									echo "</tr><tr>";
								}

								echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $row['subject_id'] . '" />&nbsp;&nbsp;' . $row['subjects'] . '</td>' . "\n";

								$c++; 

							} // while..
								// in case you need to fill a last empty cell:
								if ( ( $i % 2 ) != 0 ){

								// str_repeat() will be handy when you want more than 2 columns
								  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
								}
							echo "</tr></table>";								
		}				


	} else { // No valid ID, kill the script.

		$_SESSION['flash_message'] = "Please select atleast 1, not more than 3 categories.";

		$url = 'http://localhost/lanka_institute/tutorsignup/category.php'; // Define the URL:		
		ob_end_clean(); // Delete the buffer.
		header("Location: $url");
		exit(); // Quit the script.	

	} 

?>						
						<p>Please click 'Continue' button to proceed</p>

					<input type="submit"  value="Continue" class="formContinue" />						
					<input type="hidden"   name="submitted2"   value="TRUE" />	

					</form>

thank you..

[vivek151189]

$SESSION['category'] = $POST['category'];
its correct
did you got the value in
print_r ( $SESSION['category']);
I don't think so yoy can check it by echo $SESSION['category'];
if it is there can be used at any place

[thara]

thank you vivek...

now I change my subject.php page like this

						
						<form action="register.php" method="post" >

					<h2>Select Subjects</h2>

<?php

require_once ('../includes/config.inc.php');	
require_once( MYSQL2);


	if ( isset($_POST['submitted1']) && isset($_POST['category']) && sizeof( $_POST['category']) == 1 ) { 

		echo "<pre>"; 
			print_r($_POST)	;
		echo "</pre>";

		$_SESSION['category'] = $_POST['category']; 

		echo '<pre>';
			print_r ( $_SESSION['category']); 
		echo '</pre>';

		$q = 'SELECT * FROM category ORDER BY category_id';
		$r = mysqli_query( $dbc, $q);

		while($_SESSION = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

			foreach( $_POST['category'] as $value ) {

				if ( $value == $_SESSION['category_id']) {

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$_SESSION['category_id']}";

						$r1 = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

						while($_SESSION = mysqli_fetch_array( $r1, MYSQLI_ASSOC  )){

							// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
							if( ($c % 2) == 0 && $c != 0){
								echo "</tr><tr>";
							}
							echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>';

						$c++; 

						} // while..

							// in case you need to fill a last empty cell:
							if ( ( $i % 2 ) != 0 ){

							// str_repeat() will be handy when you want more than 2 columns
							  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
							}

						echo "</tr></table>";					
				}
			}			
		} 

	} elseif ( isset($_POST['submitted1']) && isset($_POST['category']) && ( sizeof( $_POST['category']) == 2 || sizeof( $_POST['category']) == 3 )) {

		echo "<pre>"; 
			print_r($_POST)	;
		echo "</pre>";

		$_SESSION['category'] = $_POST['category']; 

		echo '<pre>';
			print_r ( $_SESSION['category']); 
		echo '</pre>';

		foreach( $_POST['category'] as $value ) {	

					$q = "SELECT * FROM category WHERE category_id = $value ORDER BY category_id" ;
					$r = mysqli_query( $dbc, $q);

					$_SESSION = mysqli_fetch_array ( $r, MYSQLI_ASSOC); 			

						echo '<input type="radio" name="main_category[]" class="radio"  value="' . $_SESSION['category_id'] . '" />';			
						echo '<label for="" class="radio">&nbsp;&nbsp;' . $_SESSION['category_name'] . ' <strong>: Mark this category as my "Main Category"</strong></label><br />';

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$_SESSION['category_id']}";	

						$result = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

							while($_SESSION = mysqli_fetch_array( $result, MYSQLI_ASSOC  )){

								// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
								if( ($c % 2) == 0 && $c != 0){
									echo "</tr><tr>";
								}

								echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>' . "\n";

								$c++; 

							} // while..
								// in case you need to fill a last empty cell:
								if ( ( $i % 2 ) != 0 ){

								// str_repeat() will be handy when you want more than 2 columns
								  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
								}
							echo "</tr></table>";								
		}				


	} else { // No valid ID, kill the script.

		$_SESSION['flash_message'] = "Please select atleast 1, not more than 3 categories.";

		$url = 'http://localhost/lanka_institute/tutorsignup/category.php'; // Define the URL:		
		ob_end_clean(); // Delete the buffer.
		header("Location: $url");
		exit(); // Quit the script.	

	} 

?>						
						<p>Please click 'Continue' button to proceed</p>

					<input type="submit"  value="Continue" class="formContinue" />						
					<input type="hidden"   name="submitted2"   value="TRUE" />	

					</form>

when I use this

[code=php]			
			echo '<pre>';
				print_r ( $_SESSION['category']); 
			echo '</pre>';
			

[/code] I can get values.

I think at this time every values have saved in the session. that mean a user selected category from category page and now user can select subjects also to that selected categories. those selected subjects also have saved in session using this kind of coding

					if ( $value == $_SESSION['category_id']) {

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$_SESSION['category_id']}";

						$r1 = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

						while($_SESSION = mysqli_fetch_array( $r1, MYSQLI_ASSOC  )){

							// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
							if( ($c % 2) == 0 && $c != 0){
								echo "</tr><tr>";
							}
							echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>';

						$c++; 

						} // while..

Im I correct...???

[vivek151189]

If you can view the value in

 echo '<pre>';
                print_r ( $_SESSION['category']);
            echo '</pre>'; 

than you have your session set so you can use it in any of the page of your before destroying it

[thara]

vivek.. how can I access subject details? category is ok.. but subjects values...

I think its too, on session now...

I tried 'print_r( $_SESSION )' but same as category..

[vivek151189]

have you set the $SESSION["subject"];
if not then set it wher you first time get the subject just like the category
and then print_r($SESSION);
you will able to view an array which will contan category as well as subject
got it ?

[thara]

This is from my subject.php page

		} if ( isset($_POST['submitted1']) && isset($_POST['category']) && ( sizeof( $_POST['category']) == 2 || sizeof( $_POST['category']) == 3 )) {

		echo "<pre>"; 
			print_r($_POST)	;
		echo "</pre>";

		$_SESSION['category'] = $_POST['category']; 

		echo '<pre>';
			print_r ( $_SESSION['category']); 
		echo '</pre>';

		foreach( $_POST['category'] as $value ) {	

					$q = "SELECT * FROM category WHERE category_id = $value ORDER BY category_id" ;
					$r = mysqli_query( $dbc, $q);

					$_SESSION = mysqli_fetch_array ( $r, MYSQLI_ASSOC); 			

						echo '<input type="radio" name="main_category[]" class="radio"  value="' . $_SESSION['category_id'] . '" />';			
						echo '<label for="" class="radio">&nbsp;&nbsp;' . $_SESSION['category_name'] . ' <strong>: Mark this category as my "Main Category"</strong></label><br />';

						$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
								FROM category_subject
								INNER JOIN category ON category_subject.category_id = category.category_id
								INNER JOIN subject ON category_subject.subject_id = subject.subject_id
								WHERE category_subject.category_id = {$_SESSION['category_id']}";	

						$result = mysqli_query( $dbc, $q);

						$c = $i = 0;

						echo '<table class="form_table" ><tr>'; 

							while($_SESSION = mysqli_fetch_array( $result, MYSQLI_ASSOC  )){

								// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
								if( ($c % 2) == 0 && $c != 0){
									echo "</tr><tr>";
								}

								echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $_SESSION['subject_id'] . '" />&nbsp;&nbsp;' . $_SESSION['subjects'] . '</td>' . "\n";

								$c++; 

							} // while..
								// in case you need to fill a last empty cell:
								if ( ( $i % 2 ) != 0 ){

								// str_repeat() will be handy when you want more than 2 columns
								  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
								}
							echo "</tr></table>";								
		}				


	} else { // No valid ID, kill the script.

there how can I set session to that selected subjects. My problem is between second and third page.

second page display selected category and their subjects.

eg: cat1 | subi, sub2, sub3, sub4
cat2 | sbu1, sub3, sub3, sub4 and so on...

user can select upto 3 category from first page and category has their own subjects. I have subject table and category_subject table. in second page I display subjects to above selected categories from the table.

my problem is how can I get those values to my third page it is register.php.

I think solution should have a multidimensional array.. isnt it?

[vivek151189]

I think this above code you might be having inside the form tag
if that so not a problem when u submit u can get the value of select ed checkbox in the page where you are posting the data

[thara]

vivek.. I tried something like this in my third page...

	if ( isset($_POST['submitted2'])) { 


	echo '<pre>';
            print_r ( $_SESSION['category']);
        echo '</pre>';


	echo '<pre>';
        print_r ( $_SESSION['subjects']);
    echo '</pre>';

but I cant get values from this: print_r ( $_SESSION['subjects']);

[vivek151189]

have you set the $_SESSION['subjects'] any where in the code ?