no riesco a creare il menù a tendina
<!DOCTYPE html>
<html>
<head>
<title>Document</title>
</head>
<body>
<form action="eldoc.php" method="post">
<p>scegli</p>
<select name="nome">
<?php
$servername="harroldvm2";
$username= "dipaloa";
$password="Annamaria";
$dbname="db_dipaloa";
$tabnome="rec_studenti";
mysqli_connect($servername,$username,$password) or die('no connessione: ' . mysqli_error($sql,$conn));
mysqli_select_db($sql,$conn) or die ('database no: '.mysqli_error($sql,$conn));
$sql="SELECT DISTINCT nome FROM $tabnome ORDER BY nome";
while($row = mysqli_fetch_array($result)){
echo "<option value=\"".$row['nome'] ."</option> \n";
}
?>
</select>
<input type="submit" name="invio" value=Cerca"/>
</form>
</body>
</html>
PAGINA 1 PHP
<!DOCTYPE html>
<html>
<head>
<title>Document</title>
</head>
<body>
<form action="eldoc.php" method="post">
<p>scegli</p>
<select name="nome">
<?php
$servername="harroldvm2";
$username= "dipaloa";
$password="Annamaria";
$dbname="db_dipaloa";
$tabnome="rec_studenti";
mysqli_connect($servername,$username,$password) or die('no connessione: ' . mysqli_error($sql,$conn));
mysqli_select_db($sql,$conn) or die ('database no: '.mysqli_error($sql,$conn));
$sql="SELECT DISTINCT nome FROM $tabnome ORDER BY nome";
while($row = mysqli_fetch_array($result)){
echo "<option value=\"".$row['nome'] ."</option> \n";
}
?>
</select>
<input type="submit" name="invio" value=Cerca"/>
</form>
</body>
</html>
PAGINA2 PHP
chi mi può aiutare?
<!DOCTYPE html>
<html>
<head>
<title>Document</title>
</head>
<body>
<form action="eldoc.php" method="post">
<p>scegli</p>
<select name="nome">
<?php
$servername="harroldvm2";
$username= "dipaloa";
$password="Annamaria";
$dbname="db_dipaloa";
$tabnome="rec_studenti";
mysqli_connect($servername,$username,$password) or die('no connessione: ' . mysqli_error($sql,$conn));
mysqli_select_db($sql,$conn) or die ('database no: '.mysqli_error($sql,$conn));
$sql="SELECT DISTINCT nome FROM $tabnome ORDER BY nome";
while($row = mysqli_fetch_array($result)){
echo "<option value=\"".$row['nome'] ."</option> \n";
}
?>
</select>
<input type="submit" name="invio" value=Cerca"/>
</form>
</body>
</html>
PAGINA 1 PHP
<!DOCTYPE html>
<html>
<head>
<title>Document</title>
</head>
<body>
<form action="eldoc.php" method="post">
<p>scegli</p>
<select name="nome">
<?php
$servername="harroldvm2";
$username= "dipaloa";
$password="Annamaria";
$dbname="db_dipaloa";
$tabnome="rec_studenti";
mysqli_connect($servername,$username,$password) or die('no connessione: ' . mysqli_error($sql,$conn));
mysqli_select_db($sql,$conn) or die ('database no: '.mysqli_error($sql,$conn));
$sql="SELECT DISTINCT nome FROM $tabnome ORDER BY nome";
while($row = mysqli_fetch_array($result)){
echo "<option value=\"".$row['nome'] ."</option> \n";
}
?>
</select>
<input type="submit" name="invio" value=Cerca"/>
</form>
</body>
</html>
PAGINA2 PHP
chi mi può aiutare?