PHP - Find Out Information About Where Visitors Come From

Hi, I want to show one image for the new visitors of my website and another for the returning visitors. What I want to do is that after the visitor reload the page he will see another image instead of the first one.  

I'm assuming this has something to do with cookies, which I am not to familiar with as I am pretty new to this PHP world and have mostly worked with wordpress... but this question was brought up to me, and I don't know where to start.

If a user is signed up for the mailing list on a site, we would like the home page the user lands on to be different than the page a new visitor who isn't signed up for the mailing list would see. I have tried to google this, but maybe I am using the wrong choices of words?

Any advice, links, etc would be so so soooo appreciated.   

Thanks
V

Hello, I have some questions about dates/time ...

I have a site where registered users will receive messages, I want to include the date/time with that message.
I am not sure what is best way to do this, so I am recording the GMT hours offset from users input (from receivers), but then I saw that the hours offset from the GMT is different in different seasons of the year, so how do I detect correct local time for the message receiver? Is it something like a database with start-end time of daylight savings hour adjustment or how is this done?

Can you see any problems with the code below? It doesn't work.

What I am trying to do is quite straightforward.

The links on my site look like this:

go.php?id=1&url=usa
go.php?id=1&url=uk
go.php?id=2&url=usa
go.php?id=2&url=uk

When a visitor clicks on one of these links, I want to grab the values of the id and url parameters, count the click, and redirect the visitor.

Here's the error that I get when I try the code:

Quote

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\sites\go.php on line 18

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\sites\go.php:18) in C:\xampp\htdocs\sites\go.php on line 19


<?php
$conn = mysql_connect('localhost','username', 'password') or trigger_error("SQL", E_USER_ERROR);
mysql_select_db('database', $conn) or trigger_error("SQL", E_USER_ERROR);
$id = intval($_GET['id']);
$url = intval($_GET['url']);
mysql_query("UPDATE urls SET click_counter = click_counter+1 WHERE id=$id");
if ($url=="usa") 
$href = "SELECT usa FROM urls WHERE id=$id";
elseif ($url=="uk")
$href = "SELECT uk FROM urls WHERE id=$id";
elseif ($url=="aus")
$href = "SELECT aus FROM urls WHERE id=$id";
elseif ($url=="can")
$href = "SELECT can FROM urls WHERE id=$id";
else
$href = "SELECT int FROM urls WHERE id=$id";
$qry = mysql_query($href);
list($href)=mysql_fetch_row($qry);
header("Location:$href");
mysql_close($conn);
?>

Hello

How do I fetch a current visitors ip address, and turn it into a variable?

The visitor should only be able to enter the same form once, so I want to compare the current visitor ip address with ip addresses in the database to achieve this.

Best regards Morris

i want to make virtual money (credits, tokens) whatever you want to call it but make no mistake this is not for profit at this point but i like the concept of visitors having something to do with other members of site for example to kill bordom and create a reason to play games, compete in competetions, it will have to conversion to real money at this point but i wish to do this script using php and mysql and have very basic coding skills in these areas anyone please help me make this script...


reply and let me know if you like this idea


please help me as this is achievable as fb has it and more sites are moving toward these same ideas, even tho fb is real money it is more to do with fun at this point until we do this stage another stage canot proceed it.

Hi ppl,
I am not an php expert, but I want to allow my website users to edit a record in mySQL table.
I need to allow them changing Name and description of a product, thats all. easy edit.

Is there a ready component that will do the hard work for me?
Thank you!

Nothing fancy, I am just looking for a simple php script that would check a text file on my server that has a bunch of domains in it. I want the script to ping a random 5 or 10 sites in the list, and then redirects the visitor to the fastest one, or at least one that responds, and is not down. If all that are checked are down, then it would need to recheck the list.

I want it to pick random domains out of the list, as I don't want users directed to the same site(s) all the time, just because it pings the best.

When I say ping, I am talking about making sure the user isn't directed to a website that is down, or a slow loading website. I am not sure if "ping" is the correct word for that tho?

Can anybody offer me code like this for free, or is this type of request getting into something that would need to be paid code? (and if so, any idea how much? I didn't post this in the freelancing forum, because it sounds like it might be something simple to code.

I am not a coder, so I am looking for something complete that I can add to a php file and it works.

Thanks for any code, pointers/problems with this idea, or price quotes (if necessary) on this little script I am looking for.

How do you have a log generate two different logs, and having where it posts the log at, depend on if it's a visitor, or a search engine spider HTTP_USER_AGENT (Like Googlebot, Msnbot, Yahoo! Slurp.)

<?php
    define("DATE_FORMAT","m-d-Y - H:i:s");
    define("LOG_FILE","/full_path/visitors.html");
    define("LOG_FILE2","/full_path/search_engine_bots.html");

    $logfileHeader='DATE - IP - HOSTNAME - BROWSER - URI - REFERRER'."\n";

    $userAgent = (isset($_SERVER['HTTP_USER_AGENT']) && ($_SERVER['HTTP_USER_AGENT'] != "")) ? $_SERVER['HTTP_USER_AGENT'] : "Unknown";
    $userIp    = (isset($_SERVER['REMOTE_ADDR'])     && ($_SERVER['REMOTE_ADDR'] != ""))     ? $_SERVER['REMOTE_ADDR']     : "Unknown";
    $refferer  = (isset($_SERVER['HTTP_REFERER'])    && ($_SERVER['HTTP_REFERER'] != ""))    ? $_SERVER['HTTP_REFERER']    : "Unknown";
    $uri       = (isset($_SERVER['REQUEST_URI'])     && ($_SERVER['REQUEST_URI'] != ""))     ? $_SERVER['REQUEST_URI']     : "Unknown";

    $hostName   = gethostbyaddr($userIp);
    $actualTime = date(DATE_FORMAT);

    $logEntry = "$actualTime - $userIp - $hostName - $userAgent - $uri - $refferer<BR>\n";

    if (!file_exists(LOG_FILE)) {
        $logFile = fopen(LOG_FILE,"w");
        fwrite($logFile, $logfileHeader);
    }
    else {
        $logFile = fopen(LOG_FILE,"a");
    }

    fwrite($logFile,$logEntry);
    fclose($logFile);
?>

Not so much of a programming problem as such but if I add the ability to recover accounts via IP address, is it possible to spoof an IP address? Is it a bad idea to automatically allow a user to reset a password if their IP (according to PHP) matches the IP that created the account?

This is my school project "tv-info" that uses simple_html_dom.   My tv.php

// scrape a tag
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
foreach($html->find($tag) as $e)
$main = $e->plaintext . '<br />';
	
//plain
	
$html = file_get_html("http://www.ampparit.com/tv-opas?g=peruskanavat-1");
echo $html->find('[table class="fullwidth"]', 1)->innertext.'</table>';

So my problem is how I can remove some tags in this page? It shows too much things and what I want it is show only tv-table..    There is inside this this tv table like this:

<table class="content-layout">
                <tr>
                    <td id="content" class="content"><div class="submenu-top-container">
    <form action="haku" class="right" style="margin-top: 5px;">
        <div class="input-wrapper">
            <input type="text" name="q" placeholder="Kirjoita hakusana..." style="width: 165px;"><input type="hidden" name="t" value="tv"><button>Hae</button>
        </div>
    </form>

    
    <div class="submenu-top-item selected">
        <a href="/tv-opas" class="submenu-top-item-link">Ohjelmaopas</a>
    </div>

    
    <div class="submenu-top-item ">
        <a href="/tv-opas?g=suosikkikanavat" class="submenu-top-item-link">Suosikkikanavat</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=movies" class="submenu-top-item-link">Elokuvat</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=sports" class="submenu-top-item-link">Urheilu</a>
    </div>

    <div class="submenu-top-item ">
        <a href="/tv-opas?g=peruskanavat-1&amp;ss=favorites" class="submenu-top-item-link">Suosikit</a>
    </div>
</div>

Thank you if someone can help me! And if someone ask me to use tvrage, I don't because I'm from Finland and there is no support for Finnish tv-series etc..

Is there a good how to out there on how to create a code that will tell me where a page visitor is from? Similiar to google analytics, I'd like to find out where a visitor is from but I need this information before the page loads. I've tried googling but all I come up with are sites that offer the service if I sign up with them.

Also, I have a list of zip codes / cities in an excel spreadsheet .. I'd like to get this into a db table but don't want to type each one out for the next month. How could I do this? My host is godaddy on a linux box with mysql 5.X if that helps.

Thank you

Working on a music/video project.  Uploaded tracks are stored in user files and product info is stored to DB.  What I've been trying to figure out is getting the product information directly from the upload, much like you see in the shot attached.  As I haven't had success with that, I've been trying to get the duration of a track using this code.
Code: [Select]
$fp = fopen($file, 'r');
$size_in_bytes = filesize($file);
fseek($fp, 20);
$rawheader = fread($fp, 16);
$header = unpack('vtype/vchannels/Vsamplerate/Vbytespersec/valignment/vbits',
$rawheader);
$tsec = number_format($size_in_bytes/$header['bytespersec'],2);
$minutes = intval(($tsec / 60) % 60);
$seconds = intval($tsec % 60);
$sec="$minutes".":".($seconds<10 ? "0$seconds" : "$seconds");This is working fine when file names are plain text, however it fails when when there are commas or brackets.  I don't know if the code can be adjusted to work with these file names or I need to take a different approach.

Code: [Select]
examples $file ="A cool track, once again";  $file ="A cool track (once again)";
As artists can be picky about their music, I don't want to rename their tracks, but really we shouldn't even have spaces in the names.  I  could save original name to DB and rename the file, but not sure about restoring original when it come time to download the file.  In any case, I hope you understand my problem and can offer some advice.  Thanks.

i have had a difficult time trying to work this out.I need to do some pattern matching for certain urls and retrieve information from it.
For example,
$url=http://www.test.com/showpic.php?do=showpic&u=89165&a=34933

if $url contains the value showpic.php,then i need to retrieve the following
{
  $u=value of u(i.e. 89165 in this case)
  $a=value of a(i.e. 34933 in this case)
}
else do nothin..

the format of the url will always be the same as above if it contains showpic.php

Hello,

I'm writing an application that will have to interact with my webserver and it will be using php to input data into the database and retrieve from as well. However, I'm not sure what is the best approach on securing my database from people sniffing while using my application. The only thing that I can do that is coming to mind is try to use a unique key as a password and have one of my GET vars be that password, but that is easily sniff-able.

What can I do to secure my database and prevent people from filling up my databases if they sniff out my password key? Is there any kind of encryption I can use that will defeat this?