De PHPhulp kroeg
pulldown menu
eerste script:
?>
<form name="keuzelijst" action="edit11.php" method="post">
<select name="keuzelijst">
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
while ($rij)
{
print("<option value=".$rij['Anaam'].">".$rij['Anaam']."</option>");
$rij = mysql_fetch_array($select);
}
?>
while ($rij)
{
print("<option value=".$rij['Anaam'].">".$rij['Anaam']."</option>");
$rij = mysql_fetch_array($select);
}
?>
</select>
<input type="submit" value="versturen">
</form>
</body>
</html>
Hier het 2de script met foutmelding.
Dit is de fout melding die ik krijg: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource . in regel 13.
Alvast bedankt voor jullie reacties
<html>
<body>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
<?PHP
include ("configal.php");
$keuze = $_POST['keuzelijst'];
echo 'U heeft gekozen voor '; echo $keuze;
$selectgegevens = ("SELECT id, Anaam, Mail FROM vraag WHERE Anaam = $keuze");
$rij = mysql_fetch_array($selectgegevens) or die ( mysql_error() );
?>
include ("configal.php");
$keuze = $_POST['keuzelijst'];
echo 'U heeft gekozen voor '; echo $keuze;
$selectgegevens = ("SELECT id, Anaam, Mail FROM vraag WHERE Anaam = $keuze");
$rij = mysql_fetch_array($selectgegevens) or die ( mysql_error() );
?>
</table>
<table width=\"500\" align=\"center\" bgcolor=\"#99B3E3\">
<tr><td width=\"150\">naam:</td><td><input type=\"text\" name=\"Vnaam\" value=\"$Vnaam\"></td></tr>
<tr><td width=\"150\">achternaam:</td><td><input type=\"text\" name=\"Anaam\" value=\"$Anaam\"></td></tr>
<tr><td width=\"150\">email:</td><td><input type=\"text\" name=\"Mail\" value=\"$Mail\"></td></tr>
</table>;
</body>
</html>
met mysql_fetch_array() heb ik altijd het probleem gehad dat de gegevens dubbel kwamen, beter hiervoor mysql_fetch_assoc gebruiken.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?
$Anaam = $_POST['keuzelijst'];
// Formulate Query
// This is the best way to perform a SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT Vnaam, Anaam, Mail FROM vraag WHERE Anaam='%s'",
mysql_real_escape_string($Anaam));
// Perform Query
$result = mysql_query($query);
// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Anaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Mail']>";
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>
$Anaam = $_POST['keuzelijst'];
// Formulate Query
// This is the best way to perform a SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT Vnaam, Anaam, Mail FROM vraag WHERE Anaam='%s'",
mysql_real_escape_string($Anaam));
// Perform Query
$result = mysql_query($query);
// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Anaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Mail']>";
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>
Gewijzigd op 01/01/1970 01:00:00 door delano
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?
echo '<select name="lijst">';
while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row['Vnaam'].'" selected>'.$row['Vnaam'].'</option>';
// echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
}
echo '</select>';
?>
echo '<select name="lijst">';
while ($row = mysql_fetch_assoc($result))
{
echo '<option value="'.$row['Vnaam'].'" selected>'.$row['Vnaam'].'</option>';
// echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
}
echo '</select>';
?>
Is dit de bedoeling of bedoel je iets anders?
Gewijzigd op 01/01/1970 01:00:00 door Burdy
'Jan:
@ Burdy: klopt, maar je moet nog even checken welke option "selected" moet worden. In jouw voorbeeld worden ze dat allemaal. Bovendien is het tegenwoordig: selected="selected" ;-)
Hoi Jan, da's lang geleden.
Ik had even snel wat code gekopieerd en SELECT over het hoofd gezien.
Bedankt voor de correctie!
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<?
$Anaam = $_POST['keuzelijst'];
// Formulate Query
// This is the best way to perform a SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT Vnaam, Anaam, Mail FROM vraag WHERE Anaam='%s'",
mysql_real_escape_string($Anaam));
// Perform Query
$result = mysql_query($query);
// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Anaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Mail']>";
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>
$Anaam = $_POST['keuzelijst'];
// Formulate Query
// This is the best way to perform a SQL query
// For more examples, see mysql_real_escape_string()
$query = sprintf("SELECT Vnaam, Anaam, Mail FROM vraag WHERE Anaam='%s'",
mysql_real_escape_string($Anaam));
// Perform Query
$result = mysql_query($query);
// Check result
// This shows the actual query sent to MySQL, and the error. Useful for debugging.
if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}
// Use result
// Attempting to print $result won't allow access to information in the resource
// One of the mysql result functions must be used
// See also mysql_result(), mysql_fetch_array(), mysql_fetch_row(), etc.
while ($row = mysql_fetch_assoc($result)) {
echo "<input type=\"text\" size=\"50\" value=\$row['Vnaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Anaam']>";
echo "<input type=\"text\" size=\"50\" value=\$row['Mail']>";
}
// Free the resources associated with the result set
// This is done automatically at the end of the script
mysql_free_result($result);
?>
Gewijzigd op 01/01/1970 01:00:00 door delano
'Jan:
Dat is op afstand erg lastig. Ik weet natuurlijk niet hoe je MySQL tabel er uit ziet.
Jan, mijn tabel is simpel.
id = int(10) & auto_increment
Vnaam = varchar(15)
Anaam = varchar(25)
Mail = varchar(35)
Gewijzigd op 01/01/1970 01:00:00 door delano
Gewijzigd op 01/01/1970 01:00:00 door delano