Uitlezen MySQL en tonen op pagina
In ASP zou het er zo uitzien:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<% @Language=Vbscript %>
<% Option Explicit
Dim strConn, objConn, strSQL, objRS, strSchool
%>
<!--#include file="../includes/connectionOpen.asp"-->
<% strSQL = "SELECT * FROM leden ORDER BY id ASC"
objConn.Execute(strSQL)
set objRS = objConn.Execute(strSQL)
Do while Not objRS.EOF
Response.Write objRS("id")
Response.Write objRS("naam")
Response.Write objRS("functie")
objRS.MoveNext
Loop
%>
[\code]
De wanhoop is nabij. Kan iemand mij helpen?
<% Option Explicit
Dim strConn, objConn, strSQL, objRS, strSchool
%>
<!--#include file="../includes/connectionOpen.asp"-->
<% strSQL = "SELECT * FROM leden ORDER BY id ASC"
objConn.Execute(strSQL)
set objRS = objConn.Execute(strSQL)
Do while Not objRS.EOF
Response.Write objRS("id")
Response.Write objRS("naam")
Response.Write objRS("functie")
objRS.MoveNext
Loop
%>
[\code]
De wanhoop is nabij. Kan iemand mij helpen?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2
3
4
5
6
7
8
9
10
11
12
13
14
<?php
$conn = mysql_connect("host", "user", "pass");
$db = mysql_select_db("database", $conn);
$query = mysql_query("SELECT * FROM leden ORDER BY id ASC");
while($data = mysql_fetch_array($query)){
echo $data['id'];
echo $data['naam'];
echo $data['functie'];
}
?>
$conn = mysql_connect("host", "user", "pass");
$db = mysql_select_db("database", $conn);
$query = mysql_query("SELECT * FROM leden ORDER BY id ASC");
while($data = mysql_fetch_array($query)){
echo $data['id'];
echo $data['naam'];
echo $data['functie'];
}
?>
Zoiets bedoel je?
Jullie zijn geweldig!