Toon posts:

Is dit mogelijk ?

Pagina: 1
Acties:

vrijdag 9 november 2001 15:15

Acties:
  • Shift
  • Registratie: Augustus 2000
  • Laatst online: 04-08 13:44

Shift

[] Dual crazy []

Topicstarter
Ik wil een tabel maken in mysql, in deze tabel wil ik aantal gegevens wegschrijven, dat is niet echt een probleem, maar wat ik wil doen is dit. Ik wil een produkt specificatie inclusief html kode in de database opslaan, en als ik dit uit lees en echo naar de browser is de specificatie html pagina kompleet met opmaak opscherm, kan dit ? En hoe moet ik de produkt specificatie in de database defineren ? Als blob ? of iets anders.

Een voorbeeld. Dit wil ik precies zoals voorbeeld in de database neerzetten.
code:
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
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<LINK href="style.css" rel="stylesheet" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="723" border="0" align="center" height="443">
  <tr> 
    <td valign="top" width="148" align="left" height="425"> 
    <table border="0" align="center" cellspacing="0" cellpadding="1" height="173">
      <tr bgcolor="#FFFFFF"> 
        <td height="16"  width="8"><b><font color="#E7E7CF"></font> </b></td>
        <td height="16" width="102"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><a href="main.htm" target="_self">Home</a></font></b></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><b><font color="#E7E7CF"></font></b></td>
        <td height="16" width="102"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><a href="#">online 
        shop</a></font></b></td>
        <td height="16" width="8"><b><font color="#E7E7CF"></font></b></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><b><font color="#E7E7CF"></font></b></td>
        <td height="16" width="102"><b><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><a href="#">oplossingen</a></font></b></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><b><font color="#E7E7CF"></font></b></td>
        <td height="16" width="102"><b><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#E7E7CF"><a href="#">hosting</a></font></b></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#E7E7CF"></font></td>
        <td height="16" width="102"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#E7E7CF"><b><font color="#999999"><a href="#">nieuws</a></font></b></font></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#E7E7CF"></font></td>
        <td height="16" width="102"><font size="2" face="Verdana, Arial, Helvetica, sans-serif" color="#E7E7CF"><b><a href="#">support</a></b></font></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"></font></td>
        <td height="16" width="102"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><b><a href="#">webdesign</a></b></font></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"></font></td>
        <td height="16" width="102"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><b><a href="#">voorwaarden</a></b></font></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
      <tr bgcolor="#FFFFFF"> 
        <td height="16" width="8"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"></font></td>
        <td height="16" width="102"><font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#E7E7CF"><b><a href="#">contact</a></b></font></td>
        <td height="16" width="8"><font color="#E7E7CF"></font></td>
      </tr>
    </table>
    <p>&nbsp;</p>
    </td>
    <td valign="top" width="565" height="425"> 
    <p>&nbsp;</p>
    <p><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><br>
      </font></p>
    <table width="100%" border="0" cellspacing="0" cellpadding="1">
      <tr> 
        <td align="center" valign="middle" bgcolor="#E7E7CF" height="7"> 
        <table width="96%" border="0" cellspacing="0" cellpadding="1">
          <tr> 
            <td height="11" bgcolor="#E7E7CF"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b><font color="#000000" class="KopKleur">Netfront 
            folder</font></b></font></td>
          </tr>
        </table>
        </td>
      </tr>
    </table>
    <table cellSpacing="5" cellPadding="0" border="0" width="565">
      <tr>
        <td class="tekst" vAlign="top" align="left" width="537"> <font class="tekst" face="Verdana, Arial, Helvetica, sans-serif" size="2">Vul 
        de onder staande formulier in om de folder te ontvangen. </font> 
        <p><font class="tekst" face="Verdana, Arial, Helvetica, sans-serif" size="2">Alle 
          velden gemarkeerd met een <font color="#ff0000">*</font> moeten 
          worden ingevuld, bij niet komplete invoer kunnen we helaas geen 
          folder versturen.</font>
        </td>
        <td class="klein" vAlign="top" align="left" width="8">&nbsp;
        <p>&nbsp;</td>
      </tr>
    </table>
    <form method="POST" name="Folderaanvraag" action="/mailform/mail-a-form.cgi">
      <table cellSpacing="0" cellPadding="0" width="530" border="0" height="429">
        <tr> 
        <td colSpan="4" width="530" height="37"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">&nbsp;</font> 
          <table cellSpacing="0" cellPadding="0" border="0">
            <tr> 
            <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Dhr&nbsp;</font></td>
            <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
              <input type="radio" CHECKED value="Dhr" name="Persoon">
              &nbsp;&nbsp;</font></td>
            <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Mw&nbsp;</font></td>
            <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
              <input type="radio" value="Mw" name="Persoon">
              </font></td>
            </tr>
          </table>
        </td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="249" height="16"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Bedrijf:</font></td>
        <td width="24" height="16"></td>
        <td colSpan="2" width="257" height="16"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Bedrijf1">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="16"></td>
        </tr>
        <tr> 
        <td width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Voornaam:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Naam">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Achternaam:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Achternaam">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td vAlign="top" width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Postadres:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Adres">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td colSpan="3" width="337" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="1" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Adres2">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Postcode:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="11" name="Postkode">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Plaats:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="Q007">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="22"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Land:</font></td>
        <td width="1" colspan="2" height="22"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="22"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <select name="Land">
            <option value="Belgium">België</option>
            <option value="Bulgaria">Bulgarije</option>
            <option value="Denmark">Denemarken</option>
            <option value="Germany">Duitsland</option>
            <option value="Finland">Finland</option>
            <option value="France">Frankrijk</option>
            <option value="Greece">Griekenland</option>
            <option value="Hungary">Hongarije</option>
            <option value="Ireland">Ierland</option>
            <option value="Israel">Israël</option>
            <option value="Italy">Italië</option>
            <option value="Netherlands" selected>Nederland</option>
            <option value="Norway">Noorwegen</option>
            <option value="Austria">Oostenrijk</option>
            <option value="Poland">Polen</option>
            <option value="Portugal">Portugal</option>
            <option value="Russian Federation">Russische Federatie</option>
            <option value="Spain">Spanje</option>
            <option value="Czech Republic">Tsjechische Republiek</option>
            <option value="Turkey">Turkije</option>
            <option value="united Kingdom">Verenigd Koninkrijk</option>
            <option value="South Africa">Zuid-Afrika</option>
            <option value="Sweden">Zweden</option>
            <option value="Switzerland">Zwitserland</option>
          </select>
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">E-mail:</font></td>
        <td width="1" colspan="2" height="18"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="18"><font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input size="30" name="email">
          </font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="39"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Wilt 
          u in de toekomst via een e-mail nieuwsbrief op de hoogte worden 
          gehouden van nieuwe ontwikkelingen?</font><font color="#ff0000" face="Verdana, Arial, Helvetica, sans-serif" size="2">*</font></td>
        <td width="1" colspan="2" height="39"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="39"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input type="radio" CHECKED value="1" name="Contact">
          Ja, graag &nbsp; 
          <input type="radio" value="2" name="Contact">
          Nee, dank u</font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td width="414" height="21">&nbsp;</td>
        <td width="1" colspan="2" height="21"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="21"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input type="radio" CHECKED value="1" name="Q011">
          Ja &nbsp; 
          <input type="radio" value="2" name="Q011">
          Nee</font></td>
        </tr>
        <tr> 
        <td colSpan="4" width="530" height="10"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2">[img]"spacer.gif"[/img]</font></td>
        </tr>
        <tr> 
        <td vAlign="top" width="414" height="42"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Wilt 
          u een folder aanvragen als bedrijf of als consument?</font><font color="#ff0000" face="Verdana, Arial, Helvetica, sans-serif" size="2">*</font></td>
        <td width="1" colspan="2" height="42"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><spacer height="1" width="10" type="block"></spacer> 
          </font></td>
        <td width="193" height="42"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"> 
          <input type="radio" CHECKED value="Bedrijf" name="Typeklant">
          Bedrijf[img]"spacer.gif"[/img]<br>
          <input type="radio" value="Consument" name="Typeklant">
          Consument[img]"spacer.gif"[/img]</font></td>
        </tr>
      </table>
      <p>&nbsp;</p>
      <p style="line-height: 150%; margin-top: 2; margin-bottom: 2" class="ProdTekst"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">Heeft 
        u nog opmerkingen?</font></p>
      <p style="line-height: 150%; margin-top: 2; margin-bottom: 2"> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><span class="ProdTekst"> 
        <textarea class="tekst" name="OPMERKINGEN" rows="12" cols="73"></textarea>
        </span></font></p>
      <p> <font face="Verdana, Arial, Helvetica, sans-serif" size="2"><span class="ProdTekst"> 
        <input type="submit" value="Versturen" name="B1">
        <input type="reset" value="Velden wissen" name="B2">
        </span><span class="ProdTekst"></span></font></p>
      <input type="hidden" name="nextpage" value="ok2.html">
      <input type="hidden" name="subject" value="Folder aanvraag via de website">
      <input type="hidden" name="to" value="info@sasass.nl">
    </form>
    <p>&nbsp;</td>
  </tr>
</table>
</body>
</html>

Bedankt.

vrijdag 9 november 2001 15:17

Acties:
  • El Jefe
  • Registratie: Mei 2000
  • Niet online

El Jefe

Voor code kan je het beste [ code] [ /code] tags gebruiken (zonder spaties). :)
En het posten van de totale broncode van je site bij een probleem is niet het handigste, staat erg onhandig om het probleem eruit te halen.

vrijdag 9 november 2001 15:18

Acties:
  • HenkS
  • Registratie: Mei 2000
  • Laatst online: 18:59

HenkS

Da_king alias HenkS

ik heb het boek uit :)

vrijdag 9 november 2001 15:24

Acties:
  • raptorix
  • Registratie: Februari 2000
  • Laatst online: 17-02-2022

raptorix

Ja dit kan, maar slimmer is het om een style te defieren in een stylesheet en in de database per product het styleid op te geven, voor meer informatie check www.w3schools.com en kijk even bij css

vrijdag 9 november 2001 15:32

Acties:
  • LuCarD
  • Registratie: Januari 2000
  • Niet online

LuCarD

Certified BUFH

ja het kan... Of het verstandig is laat ik in het midden....

blob veld voor binaire data
text veld voor text data.

Aangezien een HTML pagina puur alleen uit text bestaat kan je dus het beste een text veld maken!

HTH

Programmer - an organism that turns coffee into software.

vrijdag 9 november 2001 16:06

Acties:
  • Shift
  • Registratie: Augustus 2000
  • Laatst online: 04-08 13:44

Shift

[] Dual crazy []

Topicstarter
Bedankt mede GOT'ters :)
Pagina: 1
Reageer