HELE Database in XLS
Door Roeltje M, 18 jaar geleden, 41.920x bekeken
Op verzoek van enkelen ben ik vandaag even verder gaan knutselen. het is een vervolg op linkje.
Voorbeeld: http://www.design-xtr.nl/scripts/XLS/sqlxls_test.php
Gesponsorde koppelingen
PHP script bestanden
Er zijn 14 reacties op 'Hele database in xls'
0 
-0 
-0
ERROR'S
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: Cannot modify header information - headers already sent by (output started at /www/back-up/functions.php:15) in /www/back-up/functions.php on line 112
Warning: Cannot modify header information - headers already sent by (output started at /www/back-up/functions.php:15) in /www/back-up/functions.php on line 113
Database PHPHULPXLS geconverteerd naar .xls door Roel Moser -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : --
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Notice: Undefined index: Tables_in_PhphulpXLS in /www/back-up/functions.php on line 15
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 31
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /www/back-up/functions.php on line 46
Warning: Cannot modify header information - headers already sent by (output started at /www/back-up/functions.php:15) in /www/back-up/functions.php on line 112
Warning: Cannot modify header information - headers already sent by (output started at /www/back-up/functions.php:15) in /www/back-up/functions.php on line 113
Database PHPHULPXLS geconverteerd naar .xls door Roel Moser -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : --
0 -0
-0
Het bestand dat u wilt openen heeft niet de juiste bestandsindeling voor deze bestandsextensie.
0 -0
-0
Heb hier geen enkele problemen. Behalve dat je cel grootte voor id-veld erg groot is.
En dan natuurlijk nog wat geheime credits naar topic waar je hulp hebt gekregen ;)
En dan natuurlijk nog wat geheime credits naar topic waar je hulp hebt gekregen ;)
0 -0
-0
Bij mij werkt het goed hoor. Leuk script, alleen jammer dat sommige cellen te groot zijn en sommige juist te klein...
0 -0
-0
@ Loran, dit krijg ik ook
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
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
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: Cannot modify header information - headers already sent by (output started at K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php:47) in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 113
Warning: Cannot modify header information - headers already sent by (output started at K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php:47) in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 114
Database PARADOX_PRODUCTIONS geconverteerd naar .xls door Roel Moser -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : --
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: mysql_list_fields() [function.mysql-list-fields]: Unable to save MySQL query result in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 32
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 47
Warning: Cannot modify header information - headers already sent by (output started at K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php:47) in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 113
Warning: Cannot modify header information - headers already sent by (output started at K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php:47) in K:\PARADOX-PRODUCTIONS.NET\Root\xmlgenerator.php on line 114
Database PARADOX_PRODUCTIONS geconverteerd naar .xls door Roel Moser -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : -- -- TABEL : --
0 -0
-0
Het is een forced TSV export naar Excel.
Op zich geen probleem, Excel lust wel Tab Separated Value data maar het heeft de flexibiliteit van een uitgedroogd stokbrood...
mysql_* functies zijn ook redelijk over inmiddels...
Op zich geen probleem, Excel lust wel Tab Separated Value data maar het heeft de flexibiliteit van een uitgedroogd stokbrood...
mysql_* functies zijn ook redelijk over inmiddels...
0 -0
-0
Quote:
mysql_* functies zijn ook redelijk over inmiddels...
Voor een 50 regels tellend scriptje is PDO beetje overdreven als je het mij vraagt. Als dat is wat je bedoelt.
0 -0
-0
Dan mag je me uitleggen waarom. Als je dit wilt integreren in een grotere applicatie is het gebruik van classes een must. Laat PDO dan nu net een mooi standaard voorbeeld zijn.
Verder als je echt uitvoer wilt hebben in xls formaat kijk dan eens naar PHPExcel Dan krijg je daadwerkelijke xls uitvoer. Je kunt dan ook voor elke tabel een nieuwe sheet maken.
Dit is gewoon een verkapte vorm van een .csv
Verder als je echt uitvoer wilt hebben in xls formaat kijk dan eens naar PHPExcel Dan krijg je daadwerkelijke xls uitvoer. Je kunt dan ook voor elke tabel een nieuwe sheet maken.
Dit is gewoon een verkapte vorm van een .csv
0 -0
-0
Ik gebruik sinds kort altijd PDO, zelfs voor kleine bestanden. Ik zou niet weten waarom dat overdreven zou zijn. Zou je dat ook zeggen zodra PHP 6 er is zonder de mysql_* functies?
0 -0
-0
@TJVB met PHPExcel krijg je OOXML bestandje; das 2007 en minder intressant. Met Java kan je echt XLS bestandjes maken http://poi.apache.org/. Op de langer termijn is PHPExcel wel intressant.
0 -0
-0
Webmakerij zover ik weet kun je verschillende output providers.
Als je de features bekijkt
Output your spreadsheet object to different file formats
* Excel 2007 (spreadsheetML)
* BIFF8 (Excel 97 and higher)
* PHPExcel Serialized Spreadsheet
* CSV (Comma Separated Values)
* HTML
* PDF
Als je de features bekijkt
Output your spreadsheet object to different file formats
* Excel 2007 (spreadsheetML)
* BIFF8 (Excel 97 and higher)
* PHPExcel Serialized Spreadsheet
* CSV (Comma Separated Values)
* HTML
0 -0
-0
Zeker, voor implementatie in een groter geheel is PDO uitstekend toe te passen hier. Echter, je moet je ook afvragen voor wat voor groep dit is. De PDO'ers zullen dit zeker wel snel zelf in elkaar kunnen knutselen. Voor de hobbyist is dit gewoon leuk en handig om er even bij te hebben.
Een eventuele PDO versie zou wel als linkje erbij kunnen staan naar mijn idee.
Een eventuele PDO versie zou wel als linkje erbij kunnen staan naar mijn idee.
0 -0
-0
Is het dan niet juist handig om de hobbyisten meteen de goede middelen aan te reiken om ze het meteen te leren. Dit voorkomt alleen maar eventuele problemen (en tijd)
Om te reageren heb je een account nodig en je moet ingelogd zijn.
PHP hulp
0 seconden vanaf nu