Kan dit sneller/makkelijker
http://www.jcsl.nl/martin/compare.php?Dmx=Ja
hij laat juist Nee zien
Ow wacht zie het denk ik al
Gewijzigd op 01/01/1970 01:00:00 door J C
als ik http://www.jcsl.nl/martin/compare.php?Dmx=ja doe dan laat hij alles met nee zien
een anderw invoer laat alles zien
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
<?php
$server = "localhost";
$gebruiker = "*****************";
$wachtwoord = "**********";
$db = "knr10710_martin";
$connectie = mysql_connect($server,$gebruiker,$wachtwoord)or die ("Kon niet connecteren met de server");
mysql_select_db($db,$connectie) or die ("Kon de database niet selecteren");
if($_SERVER['REQUEST_METHOD'] == 'GET')
{
if(isset($_GET['Dmx']))
{
$sql = "
SELECT *
FROM vergelijk
WHERE Dmx = '".$_GET['Dmx']."'
";
}
}
{
// De pagina met alle links weergeven
}
echo"<table border='1'>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Naam Effect</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><b>".$record->Type."</b></td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Type lamp</td>";
while($record = mysql_fetch_object($sql)){
echo "<td>".$record->Lamp."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>DMX gestuurd</td>";
while($record = mysql_fetch_object($sql)){
echo "<td height='35'><center>".$record->Dmx."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Gobowiel</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Gobowiel."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aantal gobo's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Aantalgobo."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Gobo Ratotatie</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Goborotatie."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Verwisselbare gobo's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Verwisselbaargobo."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Kleurenwiel</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Kleurenwiel."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aantal kleuren</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Aantalkleur."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Verwisselbare kleuren</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Verwisselbaarkleur."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aparte Shutter</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Shutter."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>aantal macro's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Macros."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Advies Prijs</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Adviesprijs."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>J.C.S.L. Prijs</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Jcslprijs."</td>";
}
echo "</tr>";
echo"</table>";
?>
$server = "localhost";
$gebruiker = "*****************";
$wachtwoord = "**********";
$db = "knr10710_martin";
$connectie = mysql_connect($server,$gebruiker,$wachtwoord)or die ("Kon niet connecteren met de server");
mysql_select_db($db,$connectie) or die ("Kon de database niet selecteren");
if($_SERVER['REQUEST_METHOD'] == 'GET')
{
if(isset($_GET['Dmx']))
{
$sql = "
SELECT *
FROM vergelijk
WHERE Dmx = '".$_GET['Dmx']."'
";
}
}
{
// De pagina met alle links weergeven
}
echo"<table border='1'>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Naam Effect</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><b>".$record->Type."</b></td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Type lamp</td>";
while($record = mysql_fetch_object($sql)){
echo "<td>".$record->Lamp."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>DMX gestuurd</td>";
while($record = mysql_fetch_object($sql)){
echo "<td height='35'><center>".$record->Dmx."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Gobowiel</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Gobowiel."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aantal gobo's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Aantalgobo."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Gobo Ratotatie</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Goborotatie."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Verwisselbare gobo's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Verwisselbaargobo."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Kleurenwiel</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Kleurenwiel."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aantal kleuren</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Aantalkleur."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Verwisselbare kleuren</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Verwisselbaarkleur."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Aparte Shutter</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Shutter."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>aantal macro's</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Macros."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>Advies Prijs</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Adviesprijs."</td>";
}
echo "</tr>";
$query = "SELECT * FROM `vergelijk` ORDER BY `Type`";
$sql = mysql_query($query) or die ( mysql_error( ) );
echo "<tr><td width='8%'>J.C.S.L. Prijs</td>";
while($record = mysql_fetch_object($sql)){
echo "<td><center>".$record->Jcslprijs."</td>";
}
echo "</tr>";
echo"</table>";
?>
Ik zal eens kijken of ik even een voorbeeldje voor je kan maken...
Code (php)
Gewijzigd op 01/01/1970 01:00:00 door J C
http://www.jcsl.nl/martin/compare.php
http://www.jcsl.nl/martin/compare.php?Dmx=Ja
http://www.jcsl.nl/martin/compare.php?Dmx=Nee
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
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
<?php
if($_SERVER['REQUEST_METHOD'] == 'GET')
{
if(isset($_GET['Dmx']))
{
$sql = "
SELECT *
FROM vergelijk
WHERE Dmx = '".$_GET['Dmx']."'
";
}
}
else
{
$sql = "
SELECT *
FROM vergelijk
";
}
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error());
}
else
{
echo '<table border="1"><tr><td>Naam Effect</td><td>Type Lamp</td><td>DMX gestuurd</td></tr>';
while($row = mysql_fetch_assoc($res))
{
echo '<tr><td><b>'.$row['Type'].'</b></td><td>'.$row['Lamp'].'</td><td>'.$row['Dmx'].'</td></tr>';
}
echo '</table>';
}
?>
if($_SERVER['REQUEST_METHOD'] == 'GET')
{
if(isset($_GET['Dmx']))
{
$sql = "
SELECT *
FROM vergelijk
WHERE Dmx = '".$_GET['Dmx']."'
";
}
}
else
{
$sql = "
SELECT *
FROM vergelijk
";
}
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error());
}
else
{
echo '<table border="1"><tr><td>Naam Effect</td><td>Type Lamp</td><td>DMX gestuurd</td></tr>';
while($row = mysql_fetch_assoc($res))
{
echo '<tr><td><b>'.$row['Type'].'</b></td><td>'.$row['Lamp'].'</td><td>'.$row['Dmx'].'</td></tr>';
}
echo '</table>';
}
?>
Niet getest, maar volgens mij moet ie het doen...
Warning: mysql_query(): Access denied for user 'apache'@'localhost' (using password: NO) in /home/knr10710/domains/jcsl.nl/public_html/martin/compare.php on line 21
Warning: mysql_query(): A link to the server could not be established in /home/knr10710/domains/jcsl.nl/public_html/martin/compare.php on line 21
Notice: Access denied for user 'apache'@'localhost' (using password: NO) in /home/knr10710/domains/jcsl.nl/public_html/martin/compare.php on line 23
excuses bij F5 geeft hij ook weeer de foutmeldingen
Gewijzigd op 01/01/1970 01:00:00 door J C
Code (php)
1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
<?php
$server = "localhost";
$gebruiker = "*****************";
$wachtwoord = "**********";
$db = "knr10710_martin";
$connectie = mysql_connect($server,$gebruiker,$wachtwoord)or die ("Kon niet connecteren met de server");
mysql_select_db($db,$connectie) or die ("Kon de database niet selecteren");
?>
$server = "localhost";
$gebruiker = "*****************";
$wachtwoord = "**********";
$db = "knr10710_martin";
$connectie = mysql_connect($server,$gebruiker,$wachtwoord)or die ("Kon niet connecteren met de server");
mysql_select_db($db,$connectie) or die ("Kon de database niet selecteren");
?>
super zeg.
Kan ik nu mijn eigen script voor de database gewoon gebruiken?
niet dus, eens kijken wat er anders is geworden
Gewijzigd op 01/01/1970 01:00:00 door J C
J.S.:
sorry dacht dat ik niets mocht toevoegen
Was ik even vergeten. Maar top dat het werkt! Nu zelf even goed kijken wat ik gedaan heb, en zelf verder uitbreiden...
Code (php)
Hierin kijk je wat er in de database staat en haal je de juiste eruit
dit is het alternatief
Dit snap ik alleen niet
Een soort zelfde als 'or die(mysql_error())', alleen loopt de rest van je script nu gewoon door.
Ik kom er alleen nog niet helemaal uit.
Ik heb nu het scritp even omgegooid om er het tabel van te kunnen maken wat ik wil.
Maar ik doe iets niet helemaal goed.
De eerste resultaten zijn er wel, maar na de eerste rij houdt hij op:
Hier een klein stuk van het script:
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
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
<?
..............
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error());
}
else
{
echo "<table border='1'>";
//naam effect
echo "<tr>";
echo "<td width='8%'>Naam Effect</td>";
while($row = mysql_fetch_assoc($res))
{
echo "<td><b>".$row['Type']."</b></td>";
}
echo "</tr>";
// Soort Lamp
echo "<tr>";
echo "<td width='8%'>Type lamp</td>";
{
echo "<td>".$row['Lamp']."</td>";
}
echo "</tr>";
..............
?>
..............
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error());
}
else
{
echo "<table border='1'>";
//naam effect
echo "<tr>";
echo "<td width='8%'>Naam Effect</td>";
while($row = mysql_fetch_assoc($res))
{
echo "<td><b>".$row['Type']."</b></td>";
}
echo "</tr>";
// Soort Lamp
echo "<tr>";
echo "<td width='8%'>Type lamp</td>";
{
echo "<td>".$row['Lamp']."</td>";
}
echo "</tr>";
..............
?>
het resultaat is:
http://www.jcsl.nl/martin/compare.php?Dmx=Nee
Als je het op deze manier zou willen doen, zou je eerst alle variabelen in een array moeten zetten. En daarna alles met een foreach loop weer moeten uitlezen.
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
<?php
while($row = mysql_fetch_assoc($res))
{
$type[] = $row['Type'];
$lamp[] = $row['Lamp'];
$dmx[] = $row['Dmx'];
}
echo "<table border='1'>";
//naam effect
echo "<tr>";
echo "<td width='8%'>Naam Effect</td>";
foreach($type as $value)
{
echo "<td><b>".$value."</b></td>";
}
echo "</tr>";
// Soort Lamp
echo "<tr>";
echo "<td width='8%'>Type lamp</td>";
foreach($lamp as $value)
{
echo "<td>".$value."</td>";
}
echo "</tr>";
//DMX?
echo "<tr>";
echo "<td width='8%'>DMX?</td>";
foreach($dmx as $value)
{
echo "<td>".$value."</td>";
}
echo "</tr>";
?>
while($row = mysql_fetch_assoc($res))
{
$type[] = $row['Type'];
$lamp[] = $row['Lamp'];
$dmx[] = $row['Dmx'];
}
echo "<table border='1'>";
//naam effect
echo "<tr>";
echo "<td width='8%'>Naam Effect</td>";
foreach($type as $value)
{
echo "<td><b>".$value."</b></td>";
}
echo "</tr>";
// Soort Lamp
echo "<tr>";
echo "<td width='8%'>Type lamp</td>";
foreach($lamp as $value)
{
echo "<td>".$value."</td>";
}
echo "</tr>";
//DMX?
echo "<tr>";
echo "<td width='8%'>DMX?</td>";
foreach($dmx as $value)
{
echo "<td>".$value."</td>";
}
echo "</tr>";
?>
Heel erg bedankt allemaal.
Julie krijgen zeker een linkje op de link pagina.