Hi guys and gals,
Basically I have a database which tracks clicks on my outbound links, I do this by linking to a page like so...
/redirect.php?id=1
The page then reads the id and increments the click column in the database before selecting the link and redirecting.
I need it to only count the click if its from a unique IP for the link, what would be the best way to do this?
I was thinking of having another table with columns "IP" and "link_id", Then I could check the IP against the list of IP's for the current link. If its not there then add it and add the click, otherwise only redirect.
I want to find the best method before I start to try and code this so any help is appreciated.
is this the proper use of mysql_real_escape_string() to prevent sql injections?
i was wondering is this the proper use of mysql_real_escape_string() to prevent sql injections? any help greatly appreciated. thanks. derekCode:
switch form actions? not working
i want on submit to go to different pages according to the CatIDCode: <?php $CatID=$_GET['CatID'];if (isset($CatID)) { }switch ($CatID){ case 1: echo '<form
php call servlet
I have done a php backup application .So there is a form that user pick some files to zip and download.Because of a problem with greek characters I make a servet (java) to create the zip.But I want
classic dynpro : hide area and auto adjust hights
Hi,
Email to a friend script problems
I have this send-to-a-friend script with 2 issues:1) When you open the form popup on a particular page, it includes the correct URL for that page (viewable on the popup form). But if you close it, go
Error in SQL Syntax HELP!!!
I have this page:Code: <?phpsession_start();//connect to server and select database$conn = mysql_connect("localhost", "root", "") or die(mysql_error());$db =
Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out why.Code: [Select]<html><head><title>Month
Finding digits in variable containing text, and IDing them
$romanstock = "http://www.remoteprice.com/data.asp?storeid=123&itemcode=456&type=2";$contentsstock = file_get_contents($romanstock);The above code, when rendering
Code working in IE but not FireFox
I created a dynamic navigation list for my website based off of a table in my database. The code is working perfectly in IE (I have version 8 on this computer) But it wont work on Firefox. I'm not
[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorado time if my server is in California and it would be 8:00am. I tried to echo the image below, but