Waarden opvragen van database
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
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
<?php
include "dbconfig.php";
$requete = "SELECT * FROM `usernames` WHERE `ID` = '1' ";
$result = mysql_query ($requete,$db);
$article =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '2' ";
$result = mysql_query ($requete,$db);
$article2 =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '3' ";
$result = mysql_query ($requete,$db);
$article3 =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '4' ";
$result = mysql_query ($requete,$db);
$article1 =mysql_fetch_object($result);
mysql_free_result($result);
?>
include "dbconfig.php";
$requete = "SELECT * FROM `usernames` WHERE `ID` = '1' ";
$result = mysql_query ($requete,$db);
$article =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '2' ";
$result = mysql_query ($requete,$db);
$article2 =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '3' ";
$result = mysql_query ($requete,$db);
$article3 =mysql_fetch_object($result);
mysql_free_result($result);
$requete = "SELECT * FROM `usernames` WHERE `ID` = '4' ";
$result = mysql_query ($requete,$db);
$article1 =mysql_fetch_object($result);
mysql_free_result($result);
?>
<body>
<p>
<p>
<p>
<p>
<p>
Als ik dit doe krijg ik 3 usernames op het scherm en ik denk ook dat ik ook veel te ver ga zoeken
hieronder heb ik een afbeelding van men database om het gemakklijk mijn probleem te zien
http://img66.imageshack.us/img66/5561/probfv0.jpg
Code (php)
1
2
3
4
2
3
4
<?php
$query = "SELECT * FROM usernames WHERE ID IN(1,2,3,4) ";
$result = mysql_query ($query,$db) or die(mysql_query); // met foutafhandeling
?>
$query = "SELECT * FROM usernames WHERE ID IN(1,2,3,4) ";
$result = mysql_query ($query,$db) or die(mysql_query); // met foutafhandeling
?>
<body>
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<?php
while($article =mysql_fetch_assoc($result)){ // assoc is sneller
echo '<p>'.$article->naam.'</p>';
}
mysql_free_result($result);
?>
while($article =mysql_fetch_assoc($result)){ // assoc is sneller
echo '<p>'.$article->naam.'</p>';
}
mysql_free_result($result);
?>
Deze code doet hetzelfde maar is beter en sneller.
Dat jij 3 usernames krijgt, kan liggen aan de WHERE. Wanneer ID nummer 4 niet bestaat, zul je daar ook geen resultaat op krijgen.
dat kan zo:
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
$query = "SELECT id, naam FROM usernames;";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_object($result)){
echo $row->id.' => '.$row->naam.'<br />';
}
?>
$query = "SELECT id, naam FROM usernames;";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_object($result)){
echo $row->id.' => '.$row->naam.'<br />';
}
?>
Tips:
gebruik geen backticks in je query.
En kijk eens naar mysql_fetch_assoc() dat is een aardig stukje sneller dan mysql_fetch_object()
Edit: Frank was me voor :)
Gewijzigd op 01/01/1970 01:00:00 door Bo az