sonny

Guess again. We don't care if you "lose it". We're volunteers here. We don't get paid a cent for helping. If you get an attitude, there are hundreds of other people who need our help, and will show a grain of respect. Have a nice day. Just think about this for a moment, why even add your 2 cents then? other then to be a wise guy, I never asked you or anone in purticular for anything, I simply posted a tread for some minor help thats all, Guess what, I guessed wrong I guess, I'll speak in your native tongue maybe it will sink in deeper. what a smart ... you are man

The code above is still not working right This is the reason I was asking for help my way, I need to have a 0 in the file to start Plus every time the number is updated it pushws it to the right with a space in front, something is not right with this code. I figured someone might have a fresh way to do this the whole basics behind this is so that I can have a setting for limiting emails, I am not a pro not even close, just trying but I cannot stand someone trying to make a fool out of me thats why I lost it, I don't think anyone on here would want that.

Ok, $n = 0; $fh = @fopen('count.txt', 'r+') or die('Error in opening file for read & write'); $n = fread($fh); if ($n < 3) { ftruncate($fh, 0); @fwrite($fh, ++$n) or die ('Unable to write to file!'); } else { print "Limit Reached\n"; } fclose($fh); This is giving me Warning: Wrong parameter count for fread() error

You didn't put nothing together for me, stop it, your just trying to get the last word in, and look good, you two guys where just trying to to make a fool out of me. People like you are ruining this forum.

What? no one will delete my account, I never read anything about signing up, was a lifetime thing? you make it sound like that was a privilege or something, there should be a delete button in profile its a commonsense and fair thing to have. You and that other guy are punk wise guys, this forum is useless because of people like you! go write yourself some code on politeness when you get some time, and share that with your bro above.

Does anyone know how I can delete my account on here? if there is no way, please can a admin remove me, I do not need wise a@# remarks like that, what would have been the big deal anyway. Ive seen people on here ask for 100 times more help on writing code then this.

I am converting perl scripts over to php does anyone know how to convert this code below over to php code? { my $n = 0; open (FH, "<", 'count.txt') or die "$!"; $n = <FH>; close FH; if ($n < 10) { open (FH, ">", 'count.txt') or die "$!"; print FH ++$n; close FH; } else { print "Limit reached\n"; exit(0); } @mail('$to, $subject, $message, headers'); Thanks Sonny

Do you know another simple way to do this?, if so, can you show me? phpMyBackupPro works so I know it can be done Thanks Sonny

Hi I am trying to backup a single complete database using a simple php script I currently use phpMyBackupPro it works fine but is a little to powerful for what I need. I have tried to implement the following but cannot get it to work, it appears to connect and it creates the backup .gz file but it contains nothing inside it. can someone please see what I am doing wrong. <?php $dbhost = 'testdb.hostedresource.com'; $dbname = 'testname'; $dbuser = 'testuser'; $dbpass = 'MyPassword'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); mysql_select_db($dbname); $backupFile = $dbname . date("Y-m-d-H-i-s") . '.gz'; $command = "mysqldump --opt -h $dbhost -u$dbuser -p$dbpass $dbname | gzip > $backupFile"; system($command); mysql_close($conn); ?> Thanks Sonny

Thank you, just the "AND" instead of "&&" did it Sonny

Hi folks I would like to delete a row based on a keyword But only if another field matches vcode="0" as well my delete from query is below, but does not work, I am very new to this $dkey="%".$keyword."%"; mysql_query("DELETE FROM visits WHERE url LIKE '$dkey' && vcode='0'"); Thanks

Good question, I only display the first hit for any given ip, I then link them individually to a more detailed type of display like from and visited data. Example this is what it looks like (27) 123.456.789 Sunnyvale California United States (15) 1235.736.87 Toronto Ontario Canada I figured that count query out, this is what I have now and it works great I used something like this $result1 = mysql_query("SELECT 1 FROM visits where ip='$ip'"); $num_rows = mysql_num_rows($result1); Note the result1, which distinguished it from result in the first query which gets the $ip in the first place Thanks

I have a php page that inserts data into a MSQL DB on page load Is there a way to exclude myself by either IP address or hostname "partial string maybe" from being logged? //Start if (isset($_SERVER['HTTP_REFERER'])) { $refer = $_SERVER['HTTP_REFERER']; } else { $refer = "Referer NA</b>"; } if (isset($_SERVER['REMOTE_HOST'])) { $host = $_SERVER['REMOTE_HOST']; } else { $host = "Host</b>"; } //end $ua=$_SERVER['HTTP_USER_AGENT']; //$page=substr($_SERVER['PHP_SELF'],1); $now=time(); $queryup="UPDATE visits SET vcode='0' WHERE ip='$ip' && page='$page'"; $resultup=mysql_query($queryup) or die(mysql_error()); $query="INSERT INTO visits VALUES('NULL', '$ip', '$host', '$refer', '$ua', '$page', '$flag', '$country', '$region', '$city', '$now', '1')"; $result=mysql_query($query) or die(mysql_error()); Thanks

Your right about that query on top of a query man that was crazy you should have seen what happened when I loaded that!!! My test database has a table named "visits" 3 fields named "id", "ip_address" and country I would like to display the total row count for the IP followed by the ip address and country Like: 4 243.726.9876 United States I was running a Query to get the info,THE IP ADDRESS, then another Querry to count the rows related to that ip address, which created a bad never ending loop. Thanks for helping me Sonny

Please can a experienced PHP person take a look at this below do I need 2 query's or is there a way to do it all at the same time? $query=" SELECT * FROM visits WHERE page='$page' && vcode='1' ORDER BY id DESC LIMIT 5"; $result=mysql_query($query) or die(mysql_error()); while($row =mysql_fetch_array($result)) { $lip=$row['ip']; $id=$row['id']; $page=$row['page']; $result = mysql_query ( "SELECT count(*) from visits where `ip`='$lip'" ); while($row =mysql_fetch_array($result)) $num_rows = mysql_num_rows($result); <td>$num_rows</td><td>$lip</td><td>$page</td> this is a very simple example of what I am trying to do, I want to display the row count for a ip address, then the auctual ip, etc This does not work, does anyone know why? if so can you please point out why? it keeps displaying "1" when I know my test ip address has about 20 hits in the database

Hi Does anyone know how I can get and set an individual ip address count total into the array below? $query=" SELECT * FROM visits WHERE page='$page' && vcode='1' ORDER BY id DESC LIMIT 10"; $result=mysql_query($query) or die(mysql_error()); while($row =mysql_fetch_array($result)) { $lip=$row['ip']; $id=$row['id']; $page=$row['page']; $country=$row['country']; $region=$row['region']; $city=$row['city']; $time=$row['time']; $url=$row['url']; $refer=$row['refer']; So when I go and display those values above later I can also include the total entry rows for that individual IP Sonny

Works Thank you this is really good to know, now I can focus on making my code safe Sonny

Thanks for caring enough to bring that point up, Its could be really Important your right on! This not public available, I just want to be able to click a IP address which I will make a link from my hit log and display results I don't understand what you guys are saying, right now I have a very simple form page and another page that displays results, how exactly do I call a IP address result directly via a URL on the display page, thats what I need to do, maybe I am not explaining properly, can you guys show me? Thanks Sonny

Hi I am on this now I just posted the code line as I have it from a form that's on another page I would like to feed the IP address and display results directly in the display page instead here is what I am trying to do, create a geoip lookup page that works from a manual form and also can display results via a url link, as the example I posted above will that be really hard to do? Thanks Sonny

I have no Idea on this one, I would like to at times be able to feed a ip address into the following code, via a link, instead of using a manual form $location = GeoIP_record_by_addr($gi, $_POST["ipp"]); any idea how I can do this? Something like this below is what I need to be able to do http://domain/display.php?action=check&ip=58.61.164.141 Thanks Sonny

It was a parse error Thank you for helping I found the syntax problem it was a ' the code below works now $location = GeoIP_record_by_addr($gi, $_POST["ipp"]);

Hi I am new to PHP but trying new things every day. I am trying to pass a IP address over to display.php this is my simple form page code below. <form action="display.php" method="post"> Name: <input type="text" name="IP" /> <input type="submit" /> </form> And this is the code line inside my next page named display.php I need to insert that ip address into, my line below causes errors can someone show me the correct syntax to do this? $location = GeoIP_record_by_addr($gi, '$_POST["IP"]'); I am trying to place a IP address entered in a form into that location= above Thanks

I agree when your Msql database happends to be on the same server, but when its outside it only doubles your chances of being down Temporarily, until I can convert this particular script code to a flat file, I disabled php error display which will kill the error messages at least. maybe I posted in the wrong section here Sonny

I have a small number of rows, I am trying to covert this code to write to a simple txt file instead I also run another perl script that writes 10's of 1000s of rows to a txt file and it has worked for years with no problems. I like Msql personally but this is small job and would be really faster and error free since it will be on the same server reading from a file Do you know how I can convert this over? Thanks Sonny

I have a small php script that uses a Msql database with entry count of around 1000 (rows max) worst case. My db table is named "visits" and the fields are as follows: id, ip, refer, ua, page, flag, country, region, city, time, vcode Couple of questions Is it really hard to convert this to a simnple text file instead? My Sql database is down more then up, causing page errors galore. Insertion code is: $refer=$_SERVER['HTTP_REFERER']; $ua=$_SERVER['HTTP_USER_AGENT']; $page=substr($_SERVER['PHP_SELF'],1); $now=time(); $queryup="UPDATE visits SET vcode='0' WHERE ip='$ip' && page='$page'"; $resultup=mysql_query($queryup) or die(mysql_error()); $query="INSERT INTO visits VALUES('NULL', '$ip', '$refer', '$ua', '$page', '$flag', '$country', '$region', '$city', '$now', '1')"; $result=mysql_query($query) or die(mysql_error()); I would like to write this data to a simple file instead? Thanks Sonny