Tijden veranderen
database uitlezen en in een tabel zetten
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
mysql_select_db('ict_website',mysql_connect('localhost','inlognaam','wachtw'));
$sql = "SELECT naam, website FROM website WHERE klas = 'havo4'";
$res = mysql_query($sql);
if(mysql_num_rows($res) > 0)
{
while($row = mysql_fetch_array($res))
{
echo '<a href="http://' . $row['website'] . '.mijnwebsite.nl' . '" target="_blank" >' . $row['naam'] . '</a><br>';
}
}
else
{
echo 'Helaas nog geen resultaten.';
}
?>
mysql_select_db('ict_website',mysql_connect('localhost','inlognaam','wachtw'));
$sql = "SELECT naam, website FROM website WHERE klas = 'havo4'";
$res = mysql_query($sql);
if(mysql_num_rows($res) > 0)
{
while($row = mysql_fetch_array($res))
{
echo '<a href="http://' . $row['website'] . '.mijnwebsite.nl' . '" target="_blank" >' . $row['naam'] . '</a><br>';
}
}
else
{
echo 'Helaas nog geen resultaten.';
}
?>
.$row{'naam'}. mag weg.....
alvast bedankt,
Jaap
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
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
<?php
mysql_select_db('ict_website',mysql_connect('localhost','inlognaam','wachtw'));
$sql = "SELECT naam, website FROM website WHERE klas = 'havo4'";
$res = mysql_query($sql);
if(mysql_num_rows($res) > 0)
{echo "<table>";
echo "<tr>";
echo "<td>naam </td>";
echo "<td>site </td>";
echo "</tr>";
while($row = mysql_fetch_array($res))
{
echo "<tr>";
echo "<td>";
echo $row['naam'];
echo "</td>";
echo "<td>";
echo '<a href="http://' . $row['website'] . '.mijnwebsite.nl' . '" target="_blank" >' .
$row['naam'] . '</a>';
echo "</td>";
echo "</tr>";
echo "</table>";
}
}
else
{
echo 'Helaas nog geen resultaten.';
}
?>
mysql_select_db('ict_website',mysql_connect('localhost','inlognaam','wachtw'));
$sql = "SELECT naam, website FROM website WHERE klas = 'havo4'";
$res = mysql_query($sql);
if(mysql_num_rows($res) > 0)
{echo "<table>";
echo "<tr>";
echo "<td>naam </td>";
echo "<td>site </td>";
echo "</tr>";
while($row = mysql_fetch_array($res))
{
echo "<tr>";
echo "<td>";
echo $row['naam'];
echo "</td>";
echo "<td>";
echo '<a href="http://' . $row['website'] . '.mijnwebsite.nl' . '" target="_blank" >' .
$row['naam'] . '</a>';
echo "</td>";
echo "</tr>";
echo "</table>";
}
}
else
{
echo 'Helaas nog geen resultaten.';
}
?>
TYPO
Gewijzigd op 01/01/1970 01:00:00 door Klaasjan Boven
het is gelukt...Ik wil het nu graag in een kadertje zetten... ik moet iets doen met <table>?
Maar wel alvast bedankt hoor,
Jaap
bedankt allemaal