hulp nodig met php,cookie en sql
Code (php)
if(isset($_COOKIE['ip'])) {
// cookie bestaat
'INSERT INTO `flexbuild_mainadmin`.`stats` (`id`, `ip`, `bezoeken`) VALUES (NULL, \'$_COOKIE['ip']'\', \'$_COOKIE['count']\')';
} else {
// cookie bestaat niet
echo 'Er is iets mis gegaan';
}
het komt van de volgende pagina.
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
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
<?
$_COOKIE['ip'];
setcookie('ip', $_SERVER['REMOTE_ADDR']);
$_COOKIE['count']++;
setcookie('count', $_COOKIE['count']);
?>
<?php require_once('../../Connections/admin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_admin, $admin);
$query_counter = "SELECT * FROM stats";
$counter = mysql_query($query_counter, $admin) or die(mysql_error());
$row_counter = mysql_fetch_assoc($counter);
$totalRows_counter = mysql_num_rows($counter);
?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td><?php
if(isset($_COOKIE['ip'])) {
// cookie bestaat
'INSERT INTO `flexbuild_mainadmin`.`stats` (`id`, `ip`, `bezoeken`) VALUES (NULL, \'$_COOKIE['ip']'\', \'$_COOKIE['count']\')';
} else {
// cookie bestaat niet
echo 'Error 10cset1';
}
?> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
<?php
mysql_free_result($counter);
?>
$_COOKIE['ip'];
setcookie('ip', $_SERVER['REMOTE_ADDR']);
$_COOKIE['count']++;
setcookie('count', $_COOKIE['count']);
?>
<?php require_once('../../Connections/admin.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_admin, $admin);
$query_counter = "SELECT * FROM stats";
$counter = mysql_query($query_counter, $admin) or die(mysql_error());
$row_counter = mysql_fetch_assoc($counter);
$totalRows_counter = mysql_num_rows($counter);
?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td><?php
if(isset($_COOKIE['ip'])) {
// cookie bestaat
'INSERT INTO `flexbuild_mainadmin`.`stats` (`id`, `ip`, `bezoeken`) VALUES (NULL, \'$_COOKIE['ip']'\', \'$_COOKIE['count']\')';
} else {
// cookie bestaat niet
echo 'Error 10cset1';
}
?> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
<?php
mysql_free_result($counter);
?>
maar hij geeft een foutmelding.
Parse error: syntax error, unexpected T_STRING in /home/flexbuild/domains/flexbuild.weesenbeek.nl/public_html/admin/cookies/cookies.php on line 67
Even een opsomming:
- ik heb database connectie dus dat is geregeld
- ik heb een werkende manier om de cookie te setten (dank je hulp.nl)
- ik zit te twijfelen tussen sessies en cookies. ik heb het met cookies gedaan maar misschien is sessies beter en daar weet ik niets van.
- en hoe kan ik de cookie in de database zetten misschien dat hij een record update indien mogelijk.
alvast bedank
Gewijzigd op 01/01/1970 01:00:00 door Willem van weesenbeek
Code (php)
ik plaat hem zo anders geeft ie hem niet god weer
Code (php)
1
2
3
4
5
6
7
8
9
10
11
2
3
4
5
6
7
8
9
10
11
<?php
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
$res = mysql_query($sql);
$affected = mysql_affected_rows();
if ($affected < 1) {
// Iets ging fout
} else {
// Goed
}
?>
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
$res = mysql_query($sql);
$affected = mysql_affected_rows();
if ($affected < 1) {
// Iets ging fout
} else {
// Goed
}
?>
Gewijzigd op 01/01/1970 01:00:00 door Wesley
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
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
<?
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
alvast bedankt
Gewijzigd op 01/01/1970 01:00:00 door willem van weesenbeek
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "','/', '" . $_COOKIE['count']++ . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "','/', '" . $_COOKIE['count']++ . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
willem schreef op 15.03.2008 17:42:
http://www.flexbuild.weesenbeek.nl/admin/cookies/cookies.php deze foutmelding krijg ik zie de link
alvast bedankt
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
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
<?
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
$sql = "INSERT INTO stats (ip,bezoeken) VALUES ('" . $_COOKIE['ip'] . "', '" . $_COOKIE['count'] . "')";
if ($affected < 1) {
echo 'niet opgeslagen';
} else {
echo 'opgeslagen';
}
require_once('../../Connections/admin.php'); ?>
<link href="../../css/tekst.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 8px}
-->
</style>
<table width="250" border="0" class="tekst">
<tr>
<td>Debug:</td>
<td> </td>
</tr>
<tr>
<td width="111"><div align="left">Uw ip</div></td>
<td width="129"><div align="left"><? echo $_COOKIE['ip']; ?></div></td>
</tr>
<tr>
<td><div align="left">Aantal bezoeken.</div></td>
<td><div align="left"><? echo $_COOKIE['count'];?></div></td>
</tr>
</table>
alvast bedankt
Kijk eens goed of je alle variabelen e.d. goed hebt afgesloten.
de tabel is de juiste
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /var/www/vhosts/phphulp.nl/httpdocs/cfgs/ubbparser/bbcode.class.php on line 472
--Sorry voor bump, kan niet meer wissen --
Gewijzigd op 01/01/1970 01:00:00 door Bobbie Feenstra
maar dit kan er wel uit.