Error na exporteren
Ik krijg de volgende foutmelding in mijn excel bestand na het exporteren, het script moet exporteren, data kopieeren naar een andere tabel en dan een truncate doen. ( zie volledige code onderaan )
Quote:
<b>Warning</b>: mysql_query() expects parameter 2 to be resource string given in <b>C:\xampp\htdocs\admin\export.php</b> on line <b>60</b><br />
Mijn volledige code ( ik weet over de wachtwoorden maar die maken niet uit. )
Quote:
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
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
<?php
$conn = mysql_connect('localhost', 'root', 'superuser') or die(mysql_error());
mysql_select_db('urenverant', $conn) or die(mysql_error($conn));
$query = sprintf('SELECT * FROM tabel1');
$result = mysql_query($query, $conn) or die(mysql_error($conn));
/*
* send response headers to the browser
* following headers instruct the browser to treat the data as a csv file called export.csv
*/
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=urenverantwoording_MMJJ.csv');
/*
* output header row (if atleast one row exists)
*/
$row = mysql_fetch_assoc($result);
if ($row) {
echocsv(array_keys($row));
}
/*
* output data rows (if atleast one row exists)
*/
while ($row) {
echocsv($row);
$row = mysql_fetch_assoc($result);
}
/*
* echo the input array as csv data maintaining consistency with most CSV implementations
* - uses double-quotes as enclosure when necessary
* - uses double double-quotes to escape double-quotes
* - uses CRLF as a line separator
*/
function echocsv($fields)
{
$separator = '';
foreach ($fields as $field) {
if (preg_match('/\\r|\\n|,|"/', $field)) {
$field = '"' . str_replace('"', '""', $field) . '"';
}
echo $separator . $field;
$separator = ',';
}
echo "\r\n";
}
$sql = "INSERT INTO `tabel2_jaar` SELECT * FROM `tabel1`";
$sql2 = "TRUNCATE TABLE `tabel1`";
$query = mysql_query($sql, $sql2);
if($query){
echo "";
}else{
die(mysql_error());
}
?>
$conn = mysql_connect('localhost', 'root', 'superuser') or die(mysql_error());
mysql_select_db('urenverant', $conn) or die(mysql_error($conn));
$query = sprintf('SELECT * FROM tabel1');
$result = mysql_query($query, $conn) or die(mysql_error($conn));
/*
* send response headers to the browser
* following headers instruct the browser to treat the data as a csv file called export.csv
*/
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=urenverantwoording_MMJJ.csv');
/*
* output header row (if atleast one row exists)
*/
$row = mysql_fetch_assoc($result);
if ($row) {
echocsv(array_keys($row));
}
/*
* output data rows (if atleast one row exists)
*/
while ($row) {
echocsv($row);
$row = mysql_fetch_assoc($result);
}
/*
* echo the input array as csv data maintaining consistency with most CSV implementations
* - uses double-quotes as enclosure when necessary
* - uses double double-quotes to escape double-quotes
* - uses CRLF as a line separator
*/
function echocsv($fields)
{
$separator = '';
foreach ($fields as $field) {
if (preg_match('/\\r|\\n|,|"/', $field)) {
$field = '"' . str_replace('"', '""', $field) . '"';
}
echo $separator . $field;
$separator = ',';
}
echo "\r\n";
}
$sql = "INSERT INTO `tabel2_jaar` SELECT * FROM `tabel1`";
$sql2 = "TRUNCATE TABLE `tabel1`";
$query = mysql_query($sql, $sql2);
if($query){
echo "";
}else{
die(mysql_error());
}
?>
Code (php)
1
2
3
4
5
2
3
4
5
<?php
$sql = "INSERT INTO `tabel2_jaar` SELECT * FROM `tabel1`";
$sql2 = "TRUNCATE TABLE `tabel1`";
$query = mysql_query($sql, $sql2);
?>
$sql = "INSERT INTO `tabel2_jaar` SELECT * FROM `tabel1`";
$sql2 = "TRUNCATE TABLE `tabel1`";
$query = mysql_query($sql, $sql2);
?>
Dat gaat niet zo in 1 keer.