PHP - <select Name=> Not Passing Value

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

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

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

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

</form>

Ok quick run down... I need to pass a variable from one page[form] to another while skipping a page that is in the middle.

The middle page is paypal... after they pay, they are being redirected to a thank you for registering with a email also being sent.
But I need their email from the first page[form].

so what i need to figure out or help is:

1. First page is a form, they enter name, last name, address, email and so on
2. They are redirected to paypal to pay for a service.
3. Are directed back to my site for a email to be sent to them, but I need their email from the first page.

This is what I have for code:
Code: [Select]

<?php
$title="Login";
$metakeywords="login, email";
$metadescription="Login to Dating Snap!";

include('header.php');

  $user = clean_up($_POST['email']);
  $pass = clean_up($_POST['password']);
 
if($user && $pass)
{
$pass = md5($pass); //compare the encrypted password
$sql="SELECT id,email,type,password,activation_key FROM `users` WHERE `email`='$user' AND `password`='$pass'";
$query=mysql_query($sql) or die(mysql_error());
 
    if(mysql_num_rows($query) > 0)
    {
      $lllrow = mysql_fetch_assoc($query);
if($lllrow['activation_key'] == 0){
      $_SESSION['id'] = $lllrow['id'];
      $_SESSION['type'] = $lllrow['type'];
      $_SESSION['email'] = $lllrow['email'];
      $_SESSION['password'] = $lllrow['password'];

   $date=date("M d Y");
   $time=date("g:i A");
$sql3 ="UPDATE `users` SET `last_ip`='{$_SERVER['REMOTE_ADDR']}', `last_login`='$date $time' WHERE `id`='".$_SESSION['id']."'";
$res3 = mysql_query($sql3) or die(mysql_error());

}else{
echo "<div class='error'>You need to activate your account first!</div>";
}

echo '<meta http-equiv="REFRESH" content="0;url=index.php">';
    }
    else
   {
    echo "<div class='error'>Email and password combination is incorrect!</div>";
   }
}else{


if(!$_GET['step'] && $_POST['newpassword']){


$email = clean_up($_POST['email']);
$password = clean_up($_POST['newpassword']);


$sql = "SELECT * FROM `users` WHERE `email`='$email'";
$query = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($query) > 0) 
{
  echo "That email is already being used, please try another.";
}else{

$activation_number = rand( );

$subject = 'Activate your account on datingsnap.com';
$message = 'Dear '.$first.' '.$last.',<br>Thank you for registering for an account on Dating Snap. Please <a href="http://datingsnap.com/index.php?action=activate&id='.$activation_number.'">Click Here</a> to activate your new account.<br>All the best,<br> DatingSnap.com';
$headers = 'From: bobthewebbuilder@gmail.com' . "\r\n" .
    'Content-Type: text/html; charset=\"iso-8859-1\"' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();

 

  $sql = "INSERT into `users`(`activation_key`,`password`,`email`)
  VALUES ('$activation_number','".md5($password)."','$email');";
 
 $query = mysql_query($sql) or die(mysql_error());

echo '<form method="post" action="index.php?action=login&step=1"><table width="100%">
<input id="email" type="hidden" name="email" value="$email">
<table width="100%">
<tr>
<td class="content">*<b>First Name:</b></td>
<td class="content"><input class="tarea" id="first" size="30" type="text" name="first"></td>
</tr>

<tr>
<td class="content">*<b>Last Name:</b></td>
<td class="content"><input class="tarea" id="last" size="30" type="text" name="last"></td>
</tr>

<tr><td width="150" class="content"></td><td class="content"><input type="submit" name="submit" value="Next step"></td></tr></form></table>';

}


if($_GET['step'] == "1" && $_POST['email']){

$email = clean_up($_POST['email']);
$first = clean_up($_POST['first']);
$last = clean_up($_POST['last']);

  $sql = "UPDATE `users` SET `first`='$first',`last`='$last' WHERE `email`='$email'";
 
 $query = mysql_query($sql) or die(mysql_error());

echo '<table width="100%"><form method="post" action="index.php?action=login&step=2">
<input id="email" type="hidden" name="email" value="$email">
<tr>
<td class="content">*<b>Date of birth:</b><br><small>This will be used to calculate your age so be sure to use your correct birth date</small></td><td class="content">
<select name="month" id="month">
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
 
<select name="day" id="day">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>

<select name="year" id="year">';

 $start_year = ($start_year) ? $start_year - 1 : date('Y') - 110;
    $end_year = ($end_year) ? $end_year : date('Y');
for ($i = $end_year; $i > $start_year; $i -= 1) {
        echo '<option value="'.$i.'">'.$i.'</option>';
    }

echo '</select>

</td>
</tr><tr><td width="150" class="content"></td><td class="content"><input type="submit" name="submit" value="Next step"></td></tr></form></table>';

}




if($_GET['step'] == "2" && $_POST['email']){


$email = clean_up($_POST['email']);
$month=clean_up($_POST['month']);
$day=clean_up($_POST['day']);
$year=clean_up($_POST['year']);

  $sql = "UPDATE `users` SET `bdate`='$year-$month-$day' WHERE `email`='$email'";
 
 $query = mysql_query($sql) or die(mysql_error());


echo "Done step two!";
}


} //end if email

}




include('footer.php');
?>
How come $_POST['email'] isn't getting passed down the steps? I have a hidden field that holds it in each step... what am I overlooking?

Hellooo,

I have a map on my site, a user types in there postcode, and clicks next, then a new page opens, the latitude and longitude, is passed from page one, to page two, the user then types in their details and clicks send.

The details are then sent to me.

But the latitude and longitude is not being sent in the email. Heres a breakdown of my code.

Page one.

Code: [Select]
<form method=LINK name="form1" action="apply.php">
<input name="latitude" type="hidden"/>
<input type="hidden" name="longitude"/>
<input type="submit" value="Submit">
</form
This adds the variables to the URL and passes them to next page.

Page two

Code: [Select]
<?php
$latitude = $_GET['latitude'];
$longitude = $_GET['longitude'];
?>
This grabs the variables and then.

Code: [Select]
<?php
echo "<input type='text' name='Longitude' value='{$latitude}'>";
?>
this places it into a text box, i then send the form just like any others, but it doesnt come through in the email. just blank
any suggestions or any better way to do this?

Thanks

$seat_s is a $var that can have multiple values depending on a form in a previous page.

this code works fine as is, but i need to pass the array into a 3rd page. i have no idea how to do this from the code below.

ive tried passing the array straight into a _post then _get on the next page but that only holds the 1st value and not all of them.

suggestions please.... thanks

<?php

$seat_s = $_POST['seats'];

foreach($_POST['seats'] AS $seat) {

$rowId = substr($seat, 0, 1);

$columnId = substr($seat, 1);

echo $rowId . $columnId . ", ";

}

?>

i am sending a mail  to user (user's email is stored in $email)
in body i have written code
$message =" <a href='http://www.example.com/thankyou.php?email=".$email."'>click here to join</a> ";

now i need this content to be stored in database and has to be retreived and append it to body like
$message =$body_from_db;

if i check it in mail. the corresponding value of $email is not coming . pls help guys.

Hello all,

So I've picked up a PHP book in an attempt to learn it.  The issue I'm having is preventing me from getting any further. 

They have me creating a simple order form, but the data is not passing from the HTML page to the PHP Processing file.  I know there are other ways of doing this that I'm unaware of, but this code is verbatam to what we are isntructed to type within the book itself.  Here is the code

orderform.html:
Code: [Select]
<html>
<body>
<form action="processorder.php" method="post">
<table border="0">
<tr bgcolor="#cccccc">
  <td width="150">Item</td>
  <td width="15">Quantity</td>
</tr>
<tr>
  <td>Tires</td>
  <td align="center"><input type="text" name="tireqty" size="3"
     maxlength="3"></td>
</tr>
<tr>
  <td>Oil</td>
  <td align="center"><input type="text" name="oilqty" size="3" maxlength="3"></td>
</tr>
<tr>
  <td>Spark Plugs</td>
  <td align="center"><input type="text" name="sparkqty" size="3"
     maxlength="3"></td>
</tr>
<tr>
  <td>How did you find Bob's?</td>
  <td><select name="find">
        <option value = "a">I'm a regular customer</option>
        <option value = "b">TV advertising</option>
        <option value = "c">Phone directory</option>
        <option value = "d">Word of mouth</option>
      </select>
  </td>
</tr>
<tr>
  <td colspan="2" align="center"><input type="submit" value="Submit Order"></td>
</tr>
</table>
</form>
</body>
</html>
processorder.php:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Bobs Auto Parts - Order Results</title>
</head>

<body>
<h1>Bobs Auto Parts</h1>
<h2>Order Results</h2>

<?php

$tireqty = $_post['tireqty'];
$oilqty = $_post['oilqty'];
$sparkqty = $_post['sparkqty'];

echo "<p>Order Processed at ";
echo date('H:i, jS F Y');
echo "</p>";


echo '<p>Your order is as follows: </p>';
echo $tireqty.' tires<br />';
echo $oilqty.' bottles of oil<br />';
echo $sparkqty.' spark plugs<br />';

$totalqty = 0;
$totalamount = 0.00;


define('TIREPRICE', 100);
define('OILPRICE', 10);
define('SPARKPRICE', 4);

?>
</body>
</html>

For some reason the values on the processing form dont show up.  The only text thats displayed is :

Bobs Auto Parts
Order Results

Order Processed at 17:07, 9th January 2011

Your order is as follows:
tires       <----  Should be showing the total quantity ordered
bottles of oil     <----  Should be showing the total quantity ordered
spark plugs    <----  Should be showing the total quantity ordered


Is anyone able to let me know where the error is in this code?  The writers website isnt any help....

Regards,

sapper6fd

Hi,
I'm trying to pass a variable into a URL and apparently I'm doing it wrong

this code is OK
Code: [Select]
$id = $3;
echo '<a href="newPage.php?id=3"></a>
If I use
Code: [Select]
$id = $_GET['id'];
echo $id;
on the newPage.php, I echo 3
whereas, if I do
Code: [Select]
$id = $3;
echo '<a href="newPage.php?id="'.$id.'"></a>
when echo out on the newPage.php it prints out nothing
also, in current url look like this:
Code: [Select]
www.site.com/newPage.php?id=

What am I doing wrong? 

Many thanks

I cannot figure this out and I know I'm just looking past the obvious...

I am creating a simple "you are now leaving this website" page, Everything is setup, and all urls pointing to http://mysite.com?exit=http://externalsite.com, It should redirect to my exit.php which will redirect to the external site after 5 seconds.

The problem is, the "http://" of the external site is causing a 403 forbidden, and even without it, anything with multiple &s isn't passing through.

I cannot figure out how to get it to pass the full url to the exit.php...

I normally don't work with PHP or rather I'm learning as I go..and this is pretty much my last barrier between completing this project. Anyway here are my two files:

http://pastebin.com/aThU3akC - file i want to grab values from and pass to the file below
http://pastebin.com/kTYHr99p - file that is suppose to display the values in $transmessage

Basically I need the variables defined in the first file to be passed and usable in the second and I'm not sure why I can't

hey guys
i am  stuck at one part. i am coding a site where on the index page there are 5 categories. Now on click of these it takes me to a page where i can search within a particular category. i can do it by statically giving <href="localhost/xampp/abc.php">and a fixed page path. but i want the name of the category passed when i click and the search page to open when i open search.


thanks

//i've been looking at this same code for two whole days now and ive changed it lots of times but it can only get worse
//i can't pass the value of the variable $today which has a date datatype
//this is the part where i get the value of $today
<?php
$query="SELECT DISTINCT today FROM arrastre order by today desc";
$result=mysql_query($query);
while($row=mysql_fetch_object($result)){
$today=$row->today;
echo "<option value=$today>$today</option>";
}
?>
//here's is the part where i use $today to get $tcl
//except for a major problem that when the while loop returns more than one $tcl, i get more than one button, but that's not the problem because that is how it's supposed to work. The problem is that when there are more than one buttons, only the last button would work, the only button that displays values
<?php
if(isset($_POST['godate'])){
$today=$_POST['today'];
$query="SELECT DISTINCT tcl FROM arrastre WHERE today='$today' ORDER BY tcl ASC";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)){
$tcl=$row['tcl'];
$today=$row['today'];
?>
<input type="hidden" name="tcl" value="<?php echo $tcl;?>">
<input type=submit name="tcl" value="<?php echo $tcl; ?>">
<?php } }
?>

//thsi is another problem
if(isset($_POST['tcl'])){
$tcl=$_POST['tcl'];
$today=$_POST['today'];
$query = "select * from arrastre where tcl=$tcl and today='$today' order by tcl asc";
$result = mysql_query($query);
$totalcollections = 0;
while($row=mysql_fetch_array($result)){
$orno=$row['orno'];
$billnmbr=$row['billnmbr'];
$payor=$row['payor'];
$arrastre=$row['arrastre'];
$wharfage=$row['wharfage'];
$total=$row['total'];
$today=$row['today'];
//*i deleted the display part to make this shorter a little
}}
//the $today variable is empty in this post and i have no idea how to successfully pass this value
so i could use it in my $query
//thanks for your time

I'm a newbie here and to php and Javascript.  So hello all.

I am trying to get a portion of a file name passed from one file (first.php) which displays a MySql table.  One of the fields is a link that is supposed to open a popup window (second.php) and begin playing a mp3 file with the flash media player.

I have everything (almost) working.  The table displays as it should, the link is fine.  However, I can not get the popup to open with the dimensions I asked for.  It opens in a full size new window.  And the mp3 will not play.  I get the message from the player "we are unable to connect...etc  etc".  The file name shows up in the status bar and in the URL window.

In the file first.php, the table displays, the links appear to be active.  when clicked the new window opens, the file names carry over but I can not get the file to play.  The player loads (in file second.php) but I get the message from the player "we are unable to connect...etc  etc".

I suspect it is in the syntax.  I have tried so many combinations I can't list them here and so far I have been unable to find anything on google, etc to answer this.  After almost three days I have resorted to here.  This may not even be the right place for me.  Javascript may be my best bet for all I know.

Can someone please look over what I have and at least point me in the right direction?
Any help is greatly appreciated as this is my first attempt at a website.
Thanks


first.php

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">


<html>
<head>

<script language="JavaScript">
<!-- Begin
function popUp(URL) {

playwindow=window.open(URL, 'name', 'toolbar=0,scrollbars=1,location=1,statusbar=1,menubar=0,resizable=1,width=350,height=250');
}
// End -->
</script>

<script language="JavaScript">
<!--
function openPlayer(URL) {
player = window.open('player10.php?','width=350,height=275')
}
// End -->
</script>



<?php
$username="myusername";
$password="mypassword";
$database="mydb";


mysql_connect('mydb',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM mytable";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>


</head>
<body>
<table border="1" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Listen</font></th>
<th><font face="Arial, Helvetica, sans-serif">f2</font></th>
<th><font face="Arial, Helvetica, sans-serif">f3</font></th>
<th><font face="Arial, Helvetica, sans-serif">f4</font></th>
<th><font face="Arial, Helvetica, sans-serif">f5</font></th>
<th><font face="Arial, Helvetica, sans-serif">f6</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"listen");
$f2=mysql_result($result,$i,"field2");
$f3=mysql_result($result,$i,"field3");
$f4=mysql_result($result,$i,"field4");
$f5=mysql_result($result,$i,"field5");
$f6=mysql_result($result,$i,"field6");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><a href="javascript:openPlayer('player10.php?<?php echo $f1?>')">Listen</a></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
</tr>

<?php
$i++;
}
?>
</body>
</html>


SECOND.PHP

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

     
<head>         
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" >   
  <meta http-equiv="X-UA-Compatible" content="IE=8" >         
  <title>My Title             
  </title>             
  <link rel="shortcut icon" type="image/x-icon" href="/favicon.ico" >         
     

 <script language="JavaScript" type="text/javascript">
<!--
    //
    // Make sure there's some data
    //
if (location.search) {
        //
        // Extract the name of the graphics file
        //
    var mp3_filename = location.search.substring(1)
        //
        // Write the &ltIMG> tag using the name of the graphics
        // file (you may need to adjust the SRC text)
        //
 document.write('<a href="http://mywebsite.com/+mp3_filename">')
    }
//   End  -->
</script>



</head>                 
<body>
 
<object width="400" height="300">
  <param name="movie" value="http://fpdownload.adobe.com/strobe/FlashMediaPlayback.swf">
  </param>
  <param name="flashvars" value="src=http%3A%2F%2Fmywebsite.com%2Faudio%2F+mp3_filename">
  </param>
 
 
  <param name="allowFullScreen" value="true">
  </param>
  <param name="allowscriptaccess" value="always">
  </param>
  <embed src="http://fpdownload.adobe.com/strobe/FlashMediaPlayback.swf" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="400" height="300" flashvars="src=http%3A%2F%2Fmywebsite.com%2Faudio%2F+mp3_filename">
  </embed>
</object>

</body>
 </html>

I'm creating this URL to pass variables to use from one Page to another:   http://eg10basketbal...Borgman&team=16     My WP site is seeing the first variable but not the second.  After some searching I've found this suggestion, but it's not working for me:

function add_query_vars_filter( $vars ) {

	$vars[] = "nameFull";
	$vars[] = "team";

	return $vars;
}
add_filter( 'query_vars', 'add_query_vars_filter' );

I tried putting this in the wp-includes/functions.php file of the, but ended up with a fatal error.  I have since added it to my theme's functions.php file. There isn't an error, but it doesn't yield recognition of my second variable.     

I am storing thousands of titles in mysql and many of these have a title with an ampersand. 
An example is how AT&T is getting stored in the database:  at-amp-t

Easy enough, I thought.. I'll just run str_replace on it before I save it to the database. 
$title = str_replace("-amp-", "&", $title);

That works great..  except when I click the new hyperlink created from this url.  It looks correct...  showing the exact url of what is stored in mysql:  (http://www.domain.com/this-is-the-at&t-title) ...but no url with this ampersand works.  All other $title urls works great.  If I don't run str_replace on it, it works fine.. but then I get a url stored as at-amp-t... which I'm trying to avoid. 

Thoughts?