how to do this?

allan16

Hello,

Here is my question.

I have a file called rock.php and here is the code so I don't have to explain myself. 😃

<?php
$con = mysql_connect("localhost","user","admin");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("admin16", $con);

$result = mysql_query("SELECT * FROM artista WHERE genre='Rock'");

$num_rows = mysql_num_rows($result);
print "<font color='#990000' FACE='Tahoma' FONT-SIZE:'11px'>There are $num_rows records.</font><P>";

while($row = mysql_fetch_array($result))
  {
  print "Artista: ";
  echo $row['artista'];
  echo "<br />";

  print "Contacto: ";
  echo $row['contacto'];
  echo "<br />";

print "Oficina: ";
  echo $row['oficina'];
  echo "<br />";

print "Celular: ";
  echo $row['celular'];
  echo "<br />";

print "Direccion: ";
  echo $row['direccion'];
  echo "<br />";

print "Pagina Web: ";
  echo $row['paginaweb'];
  echo "<br />";

print "E-mail: ";
  echo $row['email'];
  echo "<br />";

print "Genero: ";
  echo $row['genero'];
  echo "<br /><br />";

  }

mysql_close($con);
?>

What the above does is that it matches any results having the genre as ROCK in the database.

Now I have the following HTML with a list/menu:

<form name="form1" method="post" action="">
          <label><br>
          Genero
            <select name="select">
              <option>Rock</option>
              <option>Pop</option>
              <option>Alternativo</option>
              <option>Electronico</option>
              <option>Salsa</option>
            </select>
          </label>
          <br>
          <br>
          <label>
          <input type="submit" name="Submit" value="search">
          </label>
        </form>

How can I do that when someone selects the Rock option and clicks on the search do display the results on this html page?

Thanks.

MOD EDIT: PHP bbcode tags substituted in for CODE tags; please use these in the future when posting PHP code. Thanks!

djjjozsi

In the html, an option has a value:

<option value="Pop">Pop</option>
Lets set the action of your form to the rock.php
If you post the form, and the METHOD is post, then you reach the selected values with $_POST array.
Lets test the $_POST["select"] value, if it has set use that in the mysql query:

if(empty($_POST["select"]))
{
$sql= sprintf("SELECT * FROM artista WHERE genre='%s'" , mysql_real_escape_string($_POST["select"])); 
$result = mysql_query($sql); 
}
else
{
/* all genre query comes here */
}

allan16

Hello,

it works!

The only problem is that when i click on search the page changes and it opens a new one with the results. I need the results to show in the same html page:

Here is the code: rock.php

<?php
$con = mysql_connect("host","user","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("admin16", $con);

$result = mysql_query("SELECT * FROM artista WHERE genero='Rock'");

$num_rows = mysql_num_rows($result);
print "<font color='#990000' FACE='Tahoma' FONT-SIZE:'11px'>There are $num_rows records.</font><P>";

while($row = mysql_fetch_array($result))
  {

  if(empty($_POST["select"]))
{
$sql= sprintf("SELECT * FROM artista WHERE genre='%s'" , mysql_real_escape_string($_POST["select"]));
$result = mysql_query($sql);
}
else
{ 


  print "Artista: ";
  echo $row['artista'];
  echo "<br />";

  print "Contacto: ";
  echo $row['contacto'];
  echo "<br />";

print "Oficina: ";
  echo $row['oficina'];
  echo "<br />";

print "Celular: ";
  echo $row['celular'];
  echo "<br />";

print "Direccion: ";
  echo $row['direccion'];
  echo "<br />";

print "Pagina Web: ";
  echo $row['paginaweb'];
  echo "<br />";

print "E-mail: ";
  echo $row['email'];
  echo "<br />";

print "Genero: ";
  echo $row['genero'];
  echo "<br /><br />";
   }
  }

mysql_close($con);
?>

HTML:

<form name="form1" method="post" action="rock.php">
          <label><br>
          Genero
            <select name="select">
              <option value=Rock>Rock</option>
              <option>Pop</option>
              <option>Alternativo</option>
              <option>Electronico</option>
              <option>Salsa</option>
            </select>
          </label>
          <br>
          <br>
          <label>
          <input type="submit" name="Submit" value="Buscar">
          </label>
        </form>

Thanks!

allan16

now there one other thing, lets say people select rock as the option and its fine becase the code is on the rock.php file.

But what happens if people select POP, I created another file pop.php with the same code as with the rock.php but changing the rock for pop entry but it redirects to the rock.pho because that is what we declared on the html form...

djjjozsi

Save this file into a .php file, and include it before the html form.
(personal information, or accound should never place into your questions!)
Ask a moderator to delete it.

<?php
$con = mysql_connect( "xxxxxxxxxxxxxxxx", "xxxxxxxxxxx", "xxxxxxxxxxxxx" ) or 
die( 'Could not connect: ' . mysql_error() );


mysql_select_db( "xyxxxxxxxxxxxxx", $con );

if ( empty( $_POST["select"] ) )
{
		$sql = "SELECT * FROM artista";
} 
else
		$sql = sprintf( "SELECT * FROM artista WHERE genre='%s'" , mysql_real_escape_string( $_POST["select"] ) );

$result = mysql_query( $sql ) or die("Mysql error!");

$num_rows = mysql_num_rows( $result );
if ( $num_rows > 0 )
{
		while ( $row = mysql_fetch_assoc( $result ) )
		{
				print "Artista: ";
				echo $row['artista'];
				echo "<br />";

			print "Contacto: ";
			echo $row['contacto'];
			echo "<br />";

			print "Oficina: ";
			echo $row['oficina'];
			echo "<br />";

			print "Celular: ";
			echo $row['celular'];
			echo "<br />";

			print "Direccion: ";
			echo $row['direccion'];
			echo "<br />";

			print "Pagina Web: ";
			echo $row['paginaweb'];
			echo "<br />";

			print "E-mail: ";
			echo $row['email'];
			echo "<br />";

			print "Genero: ";
			echo $row['genero'];
			echo "<br /><br />";
	} 
} 

else
		print "<font color='#990000' FACE='Tahoma' FONT-SIZE:'11px'>No songs have found.</font><P>";

mysql_close( $con );

?>

allan16

how could I include it before the html form ?

djjjozsi

allan16;10903277 wrote:
how could I include it before the html form ?

use the include function before the html form:

for the explanation: include

Hello, jjozsi.