[RESOLVED] Problems using a switch statement to execute query.

mborish_2000

Hello, I've got a problem. I'm trying to pass variables through multiple forms and then execute an MySQL query. All variables and forms must pass through a switch statement. Does anybody know what I'm doing wrong or if this is even possible? I'm not quite sure that I understand the array scenario here or if this thing could even work. I tried $GET['post'] and $GET['submit'].

<form action="<?php echo $SERVER['PHP_SELF']?>" metehod="post">
<input type="text" name="address" id="address search" /> Address<br />
<input type="submit" /><br />
</form>
<form action="<?php echo $SERVER['PHP_SELF']?>" metehod="post"><br />
<input type="text" name="pin" id="PIN search" /> PIN Number<br />
<input type="submit" /><br />
</form>
<?php
switch ($GET['post'])
{
case 'PIN search':
$pin = @$GET['pin'];
$trimmed_pin = trim($pin); //trim whitespace from the stored variable
$search = " mtg_pin LIKE '$trimmed_pin%'";
break;

   case 'address search':
   $address = @$_GET['address'];
   $stripped_address = preg_replace("/[^a-zA-Z0-9\'\-.]/", " ", $address); //remove unwanted crap
   $serach = " MATCH (mtg_address) AGAINST ('$stripped_address')";
   break;

}
echo $_GET['post'];
?>
</body>
</html>

rincewind456

Using the POST method then trying to access the dat with GET is not going to work.

And your whole code is skewed, there appears to be no logic behind it.

Your trying to use the switch construct to campare the value of a non existent variable called $_GET['post'].

Your then trying to match that with the id attribute of your HTML form, this is not passed through the GET or POST methods, it is the name attribute that is used as a key value in GET and POST so in your case you have $POST['address'] and $POST['pin'] to work with.

But only after you spell method correctly.

mborish_2000

Ok, I cleaned up the embarrasing method problem. So basically what you're saying is that there is no point in having two forms? I should just check to see if the variables have been set and run the associated query?

rincewind456

Basically yes!

Use one form and have two IF statements one to see if $POST['pin'] is set, and one to see if $POST['address'] is set.

Then execute the code accordingly

mborish_2000

Ok, I undersand. The only problem is that I only want to execute either $POST['pin'] or $POST['address'] and possably $_POST['city'] but not both pin and address, hence the switch?

rincewind456

You can use IF/ELSE instead then like

if(isset($_POST['pin'])){
	//do your pin stuff here
} elseif(isset($_POST['address'])) {
	//do your address stuff here
} else {
	//do some stuff here if neither are set
}

mborish_2000

Ok, here's what I've got so far. It's not working. I tried $POST and $GET. It worked the first time I ran it? I tried unset() to clear the variables and it didn't help. Here is the code:

<html>
<head>
<title></title>
</head>
<body>

<form action="<?php echo $_SERVER['PHP_SELF']?>" metehod="post">
<input type="text" name="address" />
<input type="text" name="pin" />
<input type="submit" />
<?php

if(isset($POST['pin'])){
$pin = @$GET['pin'];
$trimmed_pin = trim($pin); //trim whitespace from the stored variable
$search = "Output Text1";
}
elseif(isset($POST['address'])){
$address = @$GET['address'];
$stripped_address = preg_replace("/[^{a-zA-Z0-9\'-.]/",} " ", $address); //remove unwanted crap
$serach = "Output Text2";
}

echo $serach;

?>
</body>
</html>

mborish_2000

I think that I forgot to close the form tag.

mborish_2000

Nope, I didn't. Sorry, but the above code was posted wrong but is correct.

mborish_2000

I'm really stupid and bad with spelling today. $search is spelled wrong. Time for sleep.

rincewind456

It still won't work!

Firstly look at method, spelt wrong.

Secondly your still mixing up POST and GET variables.

Thirdly $search is not spelt the same all the way through
Try this

<head>
<title></title>
</head>
<body>

<form action="<?php echo $_SERVER['PHP_SELF']?>" method="post">
<input type="text" name="address" />
<input type="text" name="pin" />
<input type="submit" />
<?php

if(isset($_POST['pin'])){
	$pin = $_POST['pin'];
	$trimmed_pin = trim($pin); //trim whitespace from the stored variable
	$search = "Output Text1";
}
elseif(isset($_POST['address'])){
	$address = $_POST['address'];
	$stripped_address = preg_replace("/[^a-zA-Z0-9\'\-.]/", " ", $address); //remove unwanted crap
	$search = "Output Text2";
}

echo $search;

?>
</body>
</html>