PHP - Multi Page Inbox Help

I'd describe myself as a "basic" php programmer....   I'm trying to build my first multi-page forms.   The first page is calculator_q1.php No session variables are needed here, I have omitted a few options, the code looks like this

<form id="page1" method="post" action="calculator_q2.php">
<h1>1. Which best describes the primary and secondary sports combination that will be played on your pitch?</h1>
<table>
<tr><td>Rugby only</td><td><input type="radio" name="1_primary_secondary_combo" value="Rugby only"></td></tr>
<tr><td>Rugby/Soccer</td><td><input type="radio" name="1_primary_secondary_combo" value="Rugby Soccer"></td></tr>
<tr><td>Soccer/Hockey</td><td><input type="radio" name="1_primary_secondary_combo" value="Soccer Hockey"></td></tr>
</table>
<input class="blue" type="submit" value="Next">
</form>

The 2nd page is calculator_q2.php. This has some php to start the session, copy the result of form 1 to a session var, I do a debug echo and the variable is printed correctly so I think have captured it correctly. In extract, I do this:

<?php
 
	//Start the session
	session_start();		 
						 
	//Store our posted values in the session variables
	$_SESSION['1_primary_secondary_combo'] = $_POST['1_primary_secondary_combo'];					 
	
?>
<?php
	$debug=True;
	if ($debug) {
		echo ("Debug: session for q1 = ".$_SESSION['1_primary_secondary_combo']);
	}
?>
<form id="page2" method="post" action="calculator_q3.php">
<h1>2. Please choose a preferred surface</h1>
<table>
<tr><td>3G Rubber Crumb Filled Turf</td><td><input type="radio" name="2_preferred_surface" value="3G Rubber Crumb Filled Turf "></td></tr>
<tr><td>Sand Filled Turf</td><td><input type="radio" name="2_preferred_surface" value="Sand Filled Turf"></td></tr>
<tr><td>Sand Dressed Turf or<br>a Water Based Surface</td><td><input type="radio" name="2_preferred_surface" value="Sand Dressed Turf or a Water Based Surface"></td></tr>
</table>
							
<p>

<script>
function submitForm(action){
	document.getElementById('page2').action = action;
	document.getElementById('page2').submit();
}
</script>


<input class="blue" type="button" onclick="submitForm('/calculator_q1.php')" value="Previous" />
<input class="blue" type="button" onclick="submitForm('/calculator_q3.php')" value="Next" />
						
</form>

So far so good, but when I introduce page 3 (calculator_q3.php) then it prints the previous page's (from page 2) variable but can't find the session variable from question 1. This is from calculator_q3.php:

<?php
 
	//Start the session
	session_start();		 
						 
	//Store our posted values in the session variables
	$_SESSION['2_preferred_surface'] = $_POST['2_preferred_surface'];

?>
<?php
$debug=True;
if ($debug) {
	echo ("Debug: session for q1 = ".$_SESSION['1_primary_secondary_combo']);
	echo ("<br>Debug: session for q2 = ".$_SESSION['2_preferred_surface']);
}
?>

<form id="page3" method="post" action="calculator_q4.php">
<h1>3. Please choose one watering option</h1>
<table>
<tr><td>With a Rain Gun System</td><td><input type="radio" name="3_watering_option" value="With a Rain Gun System"></td></tr>
<tr><td>With a Rain gun System + Water Borehole</td><td><input type="radio" name="3_watering_option" value="With a Rain gun System + Water Borehole"></td></tr>
<tr><td>Not Required</td><td><input type="radio" name="3_watering_option" value="Not Required"></td></tr>							
</table>					
<p>
						
<script>
function submitForm(action){
	document.getElementById('page3').action = action;
	document.getElementById('page3').submit();
}
</script>

	<input class="blue" type="button" onclick="submitForm('/calculator_q2.php')" value="Previous" />
	<input class="blue" type="button" onclick="submitForm('/calculator_q4.php')" value="Next" />
</form>

To see this in action see: http://www.sports.ha...lculator_q1.php   Any insights would be appreciated. Many thanks.

SET UP: Windows vista
# XAMPP 1.7.3,
# Apache 2.2.14 (IPv6 enabled) + OpenSSL 0.9.8l
# MySQL 5.1.41 + PBXT engine
# PHP 5.3.1
# phpMyAdmin

So I'm getting this error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '", )' at line 8. I can't see where the '", )' code is in that script. I've looked and contrl + find it but no joy. I've looked through the previous pages and mysql database to ensure the variables and the tables match up. Any help would be appreciated. Maybe some good mysql debug advice. Is there a good debug open source program out there? Any help would be appreciated.

<?php   

//let's start our session, so we have access to stored data
session_start();   

include 'db.inc.php';

$db = mysql_connect('localhost', 'root', '') or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db('ourgallery', $db) or die(mysql_error($db));
   
//let's create the query
$query = sprintf("INSERT INTO subscriptions (
name, email_address, membership_type,
terms_and_conditions, name_on_card,
credit_card_number,
credit_card_expiration_data)
VALUES ('%s','%s','%s','%s','%s','%s','%s')",
$_SESSION['email_address'],
$_SESSION['membership_type'],
$_SESSION['terms_and_conditions'],
$_POST['name_on_card'],
$_POST['credit_card_number'],
$_POST['credit_card_expiration_data']);
//let's run the query
mysql_query($insert_query);
?>

Hi guys
I got an issue that when a link on the site is loading, the other links does not load until the previous is complete but it will work if i try on 2 different browsers. How can i browse multiple links silmultanously?
Thanks

hi , i want to make 5 forms with 1 submit button , how i do that?
thanks , Mor.

Hi Chaps,

I'm trying to put together a Nested Set Model (Hierarchical Data), but I have having problems when it comes to deleting/updating the 'nested' table.

I'm using this as a guide:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

But when trying to run a query, such as:

SELECT @myLeft := lft, @myRight := rgt, @myWidth := rgt - lft + 1
FROM nested_category
WHERE name = 'GAME CONSOLES';

DELETE FROM nested_category WHERE lft BETWEEN @myLeft AND @myRight;

UPDATE nested_category SET rgt = rgt - @myWidth WHERE rgt > @myRight;
UPDATE nested_category SET lft = lft - @myWidth WHERE lft > @myRight;


I get a MySQL syntax error.

This code works fine in something such as Windows Command Prompt, but not in PHP.

Is there a special way to run multiple queries in 1 PHP script?

Many thanks

hello all, i have been sitting here googleing and googling but i can't seem to find what im looking for.

i am tring to create a personal site that lets me note services i do for my cars. I have multiple tables (cars, color, mfg, ...) in the main table cars i insted of putting the color black i put and int(11) of 1 which is suppose to "if statement" to the table colors and produce the correct color. same for mfg. although nothing i have tried has helped i always just have the else of the if echoed out.

i have heard of union and join left right i am so unsure of what is need any insite would be useful.

thanks in advance.

How i can delete record from table `order` and move it to `order2` the table `order2` structure is exactly like table `order`.here is the code that i made. 

<?
	include("connection.php");
	$id_product=$_GET["pid"];
	
	$sql_delete="DELETE FROM `order` WHERE id_product='$id_product'";
	
				
	$result=mysql_query($sql_delete) or die("Error in sql due to ".mysql_error());
	
	if ($result)
	header("Location: order_list.php");
	
?>

common.php
Code: [Select]

<?php
session_start();
header('Cache-control: private'); // IE 6 FIX

if(isSet($_GET['lang']))
{
$lang = $_GET['lang'];

// register the session and set the cookie
$_SESSION['lang'] = $lang;

setcookie("lang", $lang, time() + (3600 * 24 * 30));
}
else if(isSet($_SESSION['lang']))
{
$lang = $_SESSION['lang'];
}
else if(isSet($_COOKIE['lang']))
{
$lang = $_COOKIE['lang'];
}
else
{
$lang = 'en';
}

switch ($lang) {
  case 'en':
  $lang_file = 'lang.en.php';
  break;

  case 'de':
  $lang_file = 'lang.de.php';
  break;

  case 'el':
  $lang_file = 'lang.el.php';
  break;

  default:
  $lang_file = 'lang.en.php';

}

include_once 'languages/'.$lang_file;
?>
ip2locationlite.class.php
Code: [Select]
<?php
final class ip2location_lite{
protected $errors = array();
protected $service = 'api.ipinfodb.com';
protected $version = 'v3';
protected $apiKey = '';

public function __construct(){}

public function __destruct(){}

public function setKey($key){
if(!empty($key)) $this->apiKey = $key;
}

public function getError(){
return implode("\n", $this->errors);
}

public function getCountry($host){
return $this->getResult($host, 'ip-country');
}

public function getCity($host){
return $this->getResult($host, 'ip-city');
}

private function getResult($host, $name){
$ip = @gethostbyname($host);

if(preg_match('/^(?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)(?:[.](?:25[0-5]|2[0-4]\d|1\d\d|[1-9]\d|\d)){3}$/', $ip)){
$xml = @file_get_contents('http://' . $this->service . '/' . $this->version . '/' . $name . '/?key=' . $this->apiKey . '&ip=' . $ip . '&format=xml');

try{
$response = @new SimpleXMLElement($xml);

foreach($response as $field=>$value){
$result[(string)$field] = (string)$value;
}

return $result;
}
catch(Exception $e){
$this->errors[] = $e->getMessage();
return;
}
}

$this->errors[] = '"' . $host . '" is not a valid IP address or hostname.';
return;
}
}
?>



index.php

Code: [Select]
<?php
include_once('ip2locationlite.class.php');
 
//Set geolocation cookie
if(!$_COOKIE["geolocation"]){
  $ipLite = new ip2location_lite;
  $ipLite->setKey('*****************');
 
  $visitorGeolocation = $ipLite->getCountry($_SERVER['REMOTE_ADDR']);
  if ($visitorGeolocation['statusCode'] == 'OK') {
    $data = base64_encode(serialize($visitorGeolocation));
    setcookie("geolocation", $data, time()+3600*24*7); //set cookie for 1 week
  }
}else{
  $visitorGeolocation = unserialize(base64_decode($_COOKIE["geolocation"]));
}
var_dump($visitorGeolocation);
?>


im using this http://ipinfodb.com/

in index.php i got this message

array(5) { ["statusCode"]=> string(2) "OK" ["statusMessage"]=> string(0) "" ["ipAddress"]=> string(13) "94.68.211.211" ["countryCode"]=> string(2) "GR" ["countryName"]=> string(6) "GREECE" }

how to switch automatic if GR go to index.php?lang=el
if DE go to  index.php?lang=de etc...

hello,  is there a way to insert something 17 times into a database and change the 3rd field one at a time (from 1-17)?

Code: [Select]
$sql = "INSERT INTO picks VALUES (
NULL,
'" . mysql_real_escape_string($userid) ."',
'" . mysql_real_escape_string($weekid) ."',
'" . mysql_real_escape_string($pickid) ."'
)";
  mysql_query($sql) or die('Error, Check you fields and try again.');

Hello friends,

I've tried to search over the Internet but didn't found any tutorial how to do the following :-

let say we have form with input username and input email just 2 field

HTML Code

Code: [Select]
<form>
<table>
<tr>
<td>Username :</td>
<td><input id="username" size="20" type="text" name="username"></td>
</tr>
<tr>
<td>Email :</td>
<td><input id="email" size="20" type="text" name="email"></td>
</tr>
</table>
</form>

As you can see no submit button cause we will only check out if username and/or email is not stored already, by using ajax

My problem : i can only check out for username (1 field) but i can not check for 2 fields or more and i want to know how to apply it for 2 fields (username and email)

Here is my idea for only one field (username)

I'll add in the HTML code  this

Code: [Select]
<td><div id="status"></div></td>
and will add this java code

Code: [Select]
<SCRIPT type="text/javascript">
pic1 = new Image(16, 16);
pic1.src = "loader.gif";
$(document).ready(function(){
$("#username").change(function() {
var usr = $("#username").val();
if(usr.length >= 4)
{
$("#status").html('<img src="loader.gif" align="absmiddle">&nbsp;Checking availability...');
$.ajax({
type: "POST",
url: "check.php",
data: "username="+ usr,
success: function(msg){
$("#status").ajaxComplete(function(event, request, settings){
if(msg == 'OK')
{
$("#username").removeClass('object_error');
$("#username").addClass("object_ok");
$(this).html('&nbsp;<img src="tick.gif" align="absmiddle">');
}
else
{
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
$(this).html(msg);
}
});
}
});
}
else
{
$("#status").html('<font color="red">The username should have at least <strong>4</strong> characters.</font>');
$("#username").removeClass('object_ok');
$("#username").addClass("object_error");
}
});
});
</SCRIPT>

Explain : it will get the input of username and will send it to check.php

Now check.php code (should have all usernames that will compare with it)

Code: [Select]
<?php
if(isSet($_POST['username']))
{
$usernames = array('john','michael','terry', 'steve', 'donald');
$username = $_POST['username'];
if(in_array($username, $usernames))
{
echo '<font color="red">The username<STRONG>'.$username.'</STRONG> is already in use.</font>';
}
else
{
echo 'OK';
}
}
?>

Now it is very clear , if will automatic check the username

now my problem is how to apply it for also email

i want to edit a product and allocate industries to a product

refer following link to view

http://meriwebsite.net/envytech/admin/industryallocate.php?pageNum=1SELECT%20a.products_id,%20a.products_image,%20b.language_id,%20b.products_description,%20b.products_name%20%20%20FROM%20products%20a%20,%20products_description%20b%20WHERE%20a.products_id%20=%20b.products_id%20and%20language_id=1%20and%201%20order%20by%20%20b.products_id,%20%20b.products_description

I can update prouct name and serial number

but cannot get values for industries

the do while loop for industry display  is given below (displaying industry id before check box here)

 $iquery="SELECT * from industry  ";
 

mysql_select_db($database_DBconnect, $DBconnect);

$iResult = mysql_query($iquery, $DBconnect) or die(mysql_error());

$irows = mysql_fetch_assoc($iResult);

$itotalrows=mysql_num_rows($iResult);

$j=-1;

do { $j++; ?>

<br /><?php echo "id=". $irows['id'];?><input name="ind[$i][$j]" type="checkbox" class="vardana12" id="ind[$i][$j]" value="<?php echo $irows['id'];?>" />

<?php echo $irows['name'];?>

 

<?php } while (

$irows = mysql_fetch_assoc($iResult)

);

 

?>  


I am trying to display values using following code

if ( (isset($_POST['sub'] )) or (isset($srno['sub'] ))) {

   echo "<br> count=".count($_POST['srno']);

for($i=0; $i< 

count($_POST['srno']); $i++){

echo "on 'save' clicked   <br>";

echo "<br> products ".$_POST['products_id'][$i];

echo "<br>srno ". $_POST['srno'][$i];

echo "<br>industry ".print_r($_POST['ind'][$i]);

echo "<br>product name ". $_POST['products_name'][$i];
 

Updateindustry($_POST['products_id'][$i], $_POST['srno'][$i],$_POST['industry'][$i],$_POST['products_name'][$i]); }
        $update=1; $alert= "udation done";
 }

I am not getting correct values for $_POST['industry'][$i]

please help

Hello!   I need small help. Need php script for changinh milti lines in myslq database. In database are fiekds: date, ip, status 1. 2014-09-01, 123, 0 2. 2014-09-01, 444, 0 3. 2014-09-01, 123, 0 4. 2014-08-31, 888, 0 5. 2014-09-01, 444, 0 6. 2014-09-01, 123, 0   Now script must search ip and date.   1. record is OK, 2. record is OK, 3. record NOT OK, because date and ip are in first record, must change status to 1 4. record is OK, 5. record NOT OK, because date and ip are in second record, must change status to 1 6. record NOT OK, because date and ip are in 1 and 3 record, must change status to 1  

im trying to do a multi insert form using for loop. the concept is specifying a number and then using it in the for loop. the loop then makes a number of fields depending on the specified number. after that i use another for loop to insert the grouped fields together.

code for specifying desired number
Code: [Select]
<?
if ($_GET[num]=="") {
?><form name="form1" method="post" action="multiup.php?num=1">
<input name="num" type="text" value="10" maxlength="2">
    <input type="submit" name="button" id="button" value="Submit">
</form><? } ?>
Code: [Select]
<? } else { ?><form name="form2" method="post" action="multiup2.php">
<input name="adder" type="hidden" value="">
<input name="num" type="hidden" value="<? echo $_POST[num]; ?>">


code for displaying fields
<?
for ($i=1;$i<=$_POST[num];$i++) {
echo "groupnumber<br />
<input name='eno$i' type='text' value='$i'>
Thumb
<input name='thumb$i' type='text'>
link1<br />

";}
?>

the insert code
Code: [Select]
<? if(isset($_POST['submit']) && ($_POST['submit'] == "Submit"))

{ $con = mysql_connect("lalalalala");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("kiphi_main", $con);

for ($i=1;$i<=$_POST[num];$i++) {
$title="$eno$i";

$sql="INSERT INTO articles (title)
VALUES
('$_POST[$title]')"; }
}
if (!mysql_query($sql,$con))
  {echo testest;}?>

problem is i cant get it to work... should i try a different approach?

I am having a hell of a time getting this to work. I need the keys in an array to be specific, not a sequential number or a row in my database. I need to add to the array through each loop of my while() statement. This code does it, but does not use the keys I specify, after the first entry, it starts assigning numbers to keys. Any guidance would be great.

<?php
require_once ('includes/config.php');
require_once ('includes/connect.php');

$echoarray = array();
$resultsql = mysql_query("SELECT * FROM clients")or die(mysql_error());
while($row = mysql_fetch_array($resultsql)){
    if(empty($echoarray)){
$echoarray = array(
'id' => $row['ID'],
'name' => $row['First_Name'] . " " . $row['Last_Name'],
'price' => $row['Status'],
'number' => $row['Sex'],
'address' => $row['Phys_Street'],
'company' => $row['Agency'],
'desc' => $row['Notes'],
'age' => $row['Date_Birth'],
'title' => $row['Occupation'],
'phone' => $row['Phone'],
'email' => $row['Email'],
'zip' => $row['Phys_Zip'],
'country' => $row['Phys_City']
);
}
else
{
array_push($echoarray,
$echoarray['id'] = $row['ID'],
$echoarray['name'] = $row['First_Name'] . " " . $row['Last_Name'],
$echoarray['price'] = $row['Status'],
$echoarray['number'] = $row['Sex'],
$echoarray['address'] = $row['Phys_Street'],
$echoarray['company'] = $row['Agency'],
$echoarray['desc'] = $row['Notes'],
$echoarray['age'] = $row['Date_Birth'],
$echoarray['title'] = $row['Occupation'],
$echoarray['phone'] = $row['Phone'],
$echoarray['email'] = $row['Email'],
$echoarray['zip'] = $row['Phys_Zip'],
$echoarray['country'] = $row['Phys_City']
);
    
}

Any Ideas?

Hi

I have to multi select tables, the table on the left is field with the contents of an array, I then have it so the user can make there selections from the left box and move them into the right. They then hit submit and it gets stored inmysql table as an array. The problem I am  having is keeping the selections in that right box after any sort of page refresh.
Any ideas I have pasted the php and html code below, the add/remove function is controlled by javascript, I won't bother pasting that as i don't think it has anything to do with it.

PHP ********
Code: [Select]
<?php
/ ------- PARSING PERSONAL TRAINER DETAILS VENUE ---------
if ($_POST['parse_var'] == "fromPool"){
    
    $venue = $_POST['venue'];
    if (is_array($_POST['venue'])) {
  $venue = explode("\n", $_POST['venue']);
} else {
  $venue = $_POST['venue'];
}

     // Update the database data now here for all fields posted in the form
     $sqlUpdate = mysql_query("UPDATE ptdata SET venue='$venue' WHERE id='$id' LIMIT 1");
     if ($sqlUpdate){
            $success_msg = '<img src="images/Form/round_success.png" width="20" height="20" alt="Success" />Your venue information has been updated successfully';
     } else {
            $error_msg = '<img src="images/Form/round_error.png" width="20" height="20" alt="Failure" /> ERROR: Problems arose during the information exchange, please try again later</font>';
     }
}
// ------- END PARSING PERSONAL TRAINER DETAILS VENUE ---------
?>
<?php

//////////   Venue Array PHP For Multi Selection Boxes  ////////////

$dbString = ''; // To be pulled from Database

$toPool = explode(',', $dbString); 

$pool = Array('Your Home','My Home','Outside','Private Studio','Your Work','Gym');

if($_SERVER['REQUEST_METHOD'] == 'POST'){

    $toPool = (count($_POST['venue']) > 0)? $_POST['venue'] : Array();

    $newDbString = implode(',', $toPool); //  Store in Database;


}

$fromPool = array_diff($pool, $toPool);


?>

html ***********

<form action="ptmemberaccount.php" method="post" enctype="multipart/form-data"onsubmit="multipleSelectOnSubmit()">
<table width="500" align="left">
  <tr>
    <td width="500" height="300" align="center">
    <select multiple="multiple" name="fromBox[]" id="fromBox"> 


<?php



foreach($fromPool as $itm){

    echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select>
    <select multiple="multiple" name="venue[]" id="toBox">


<?php 



foreach($toPool as $itm){
    
        echo "\t" . '<option value="' . $itm . '">' . $itm . '</option>' . PHP_EOL;

}

?>

</select> </td>
  </tr>
  <tr>
    <td align="center" height="35"><script type="text/javascript">

createMovableOptions("fromBox","toBox",400,200,'Training Venues','Selected Training Venues');

</script>

<p>Use the buttons to Add/Remove selections</p></td></td>
  </tr>
  <tr>
    <td align="center" height="100">
    <input type="submit" value="OK">
   
  </tr>
</table>
</form>

If you need anymore info let me know, also if anyone knows a better way of achieving this i am open to suggestions.

Many Thanks

MOD EDIT: code tags added