| netpro wrote: |
| How to make:
1. referral system (php mysql); example: http://domain.com/?ref=123 2. 123 is taken from registered user 3. if visitor come without referrer, script will select (automatic random) from registered user |
| Code: |
| <?php
$referral = (isset($_GET['ref'])) ? ($_GET['ref']) : (random_registered_user()); ?> |
| Code: |
| select user_id from usertable order by rand() limit 1 |
| netpro wrote: |
| Thanks very much ! |
| netpro wrote: |
| if user come with referrer, all page on my site will tract that visitor come with the referrer
please tell me again about tracking referrer, no matter it's use cookies or session |
| netpro wrote: |
| And if I type on browser: ?ref=999
the referrer is 999, though the 999 is not registered id. how to fix this problem ?. |
| Code: |
| <?php
// Pay attention to ### comments // This script was typed/edited directly in the browser // and was not tested! ### start the session; you need this in every script! session_start(); function random_registered_user() { ### the functions will assume a connection is established and use it // include "conn.php"; ### why SELECT *? ### If you only want the user_id get only the user_id // $random = mysql_query("SELECT * FROM `user` order by rand() limit 1",$koneksi); $random = mysql_query("SELECT user_id FROM `user` order by rand() limit 1"); ### The query above is guaranteed to return *one*and*only*one* row ### (unless the `user` table is empty, which you should check). if (mysql_num_rows($random) != 1) exit('No users defined!'); ### Getting the value directly is more straightforward. $brs = mysql_result($random, 0); // echo $brs; ### delete the previous line and use return return $brs; } function user_id_isvalid($id) { $sql = "select count(*) from `user` where user_id=$id"; $res = mysql_query($sql); if (!$res) { ### for simplicity sake we just exit with the error message exit('Error in query: ' . mysql_error()); } return mysql_result($res, 0); ### returns 0 (false) or 1 (true) } require_once 'conn.php'; ### open database, connection will be used in functions ### if there's a problem opening conn.php the script will abort; ### it would continue with include $referral = 0; ### initialize with an invalid user_id if (isset($_GET['ref'])) { $referral = (int)$_GET['ref']; if ($referral < 1) $referral = 0; ### I assume there is no user_id = 0 ### Now we have a numeric user_id ready to be tested if (!user_id_isvalid($referral)) { ### reset back to 0 $referral = 0; } } if ($referral == 0) $referral = random_registered_user(); // echo "$referral"; ### save $referral in a session variable $_SESSION['referral'] = $referral; ?> |
?????| netpro wrote: |
| I have problem; if the userid is not number only, but letter include.
for example: mem123 or mem111 http://domain.com/?ref=mem123 After I check, the session can tracking userid with number only, not userid with number and letter (mem123 or mem111) ????? |
| Code: |
| $referral = (int)$_GET['ref']; |
 |