hoe maak ik dit affiliate script op mijn site ??
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?php
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE users SET credits+ WHERE id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
?>
// als nee :
<?php
php pagina code hier
?>
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE users SET credits+ WHERE id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
?>
// als nee :
<?php
php pagina code hier
?>
Kzip verhje op 26/11/2011 10:14:43:
dus :
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?php
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE users SET credits+ WHERE id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
else
{
echo 'fout';
}
?>
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE users SET credits+ WHERE id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
else
{
echo 'fout';
}
?>
Toevoeging op 27/11/2011 10:00:26:
in de databace heb nu dit onder (customers -> credits)
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
Field = credits
Type = varchar
Length/Values1 = 1
Collation = latin_1.....
Attributes =
Null = not nul
Default2 = 0
Extra =
Comments =
Type = varchar
Length/Values1 = 1
Collation = latin_1.....
Attributes =
Null = not nul
Default2 = 0
Extra =
Comments =
maar het scrijfen van de cookie werkt en het lezen er van ook maar het updaten naar de db werkt niet
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?php
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE customers SET credits+ WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
else
{
echo 'fout';
}
?>
if (isset($_COOKIE['credits_id'])) {
$query = "UPDATE customers SET credits+ WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id'])."'";
}
else
{
echo 'fout';
}
?>
hoe nu verder ?
Gewijzigd op 26/11/2011 20:06:28 door kzip verhje
update TABLE_credits set credits+ = now() WHERE customers_id='17'
[TEP STOP]
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?php
if (isset($_COOKIE['credits_id'])) {
tep_db_query("update " . TABLE_credits . " set credits+ = now() WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id']). "'");
}
else
{
echo 'fout';
}
?>
if (isset($_COOKIE['credits_id'])) {
tep_db_query("update " . TABLE_credits . " set credits+ = now() WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id']). "'");
}
else
{
echo 'fout';
}
?>
set credits+ = now()
Toevoeging op 27/11/2011 13:30:21:
wat doet die now() daar?
Code (php)
1
2
3
4
5
6
7
8
9
2
3
4
5
6
7
8
9
<?php
if (isset($_COOKIE['credits_id'])) {
tep_db_query("update " . TABLE_CUSTOMERS . " set credits+ WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id']). "'");
}
else
{
echo 'fout';
}
?>
if (isset($_COOKIE['credits_id'])) {
tep_db_query("update " . TABLE_CUSTOMERS . " set credits+ WHERE customers_id='".mysql_real_escape_string($_COOKIE['credits_id']). "'");
}
else
{
echo 'fout';
}
?>
Toevoeging op 27/11/2011 13:32:55:
dan nog :
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ WHERE customers_id='17'' at line 1
update customers set credits+ WHERE customers_id='17'
[TEP STOP]
plus wat? Bloemkolen? munten? euro's ?
Gewijzigd op 27/11/2011 13:37:24 door - Ariën -
Works like a charm....
Gewijzigd op 27/11/2011 13:49:44 door kzip verhje
Gewijzigd op 27/11/2011 14:06:00 door - Ariën -