[SOLVED] php mysql array

[dlf1987]

trying to create mysql array...

 

i commented right where the problem is

 

 

<?php
mysql_select_db($database_pixeldecal, $pixeldecal);
$query_rsIP = "SELECT * FROM settings";
$rsIP = mysql_query($query_rsIP, $pixeldecal) or die(mysql_error());
$row_rsIP = mysql_fetch_assoc($rsIP);
$totalRows_rsIP = mysql_num_rows($rsIP);

	do {	
		$blockips .= '"'.$row_rsIP['settings_value'].'", ';		
	} while ($row_rsIP = mysql_fetch_assoc($rsIP));

	$blockips=substr($blockips,0,-2);	
	if ($blockips == '') $blockips = 0;


// STUCK RIGHT HERE 
// TRYING TO FIGURE OUT HOW TO ADD VALUES TO THE ARRAY BELOW
// HERES WHAT THE ABOVE MYSQL QUERY CREATES - "74.240.1.000", "74.120.113.00"
// BUT THAT DOESNT WORK 
// IF I COPY AND PASTE THOSE VALUES STRAIGHT INTO THE ARRAY BELOW IT WORKS FINE THOUGH


$include = array($blockips);
if (in_array($_SERVER['REMOTE_ADDR'], $include) == false) {
	echo $blockips;
	// Crazy Egg
	echo '
	<script type="text/javascript" src="https://cetrk.com/pages/scripts/0000/XXXX.js"></script>
	';
	// Google Analytics
	echo '
	<script src="https://ssl.google-analytics.com/urchin.js" type="text/javascript"></script>
	<script type="text/javascript">
	_uacct = "UA-XXXXX-2";
	urchinTracker();
	</script>
	';
}
mysql_free_result($rsIP);
?>

 

Thanks,

Daniel

[DanDaBeginner]

you can use array map to substring all the elements in your $blockips..

 

$blockips= array_map(functionSubstring,$blockips);

 

then

$include = $blockips; //remove the array because its already array...

[dlf1987]

what should "functionSubstring" be replaced with?

 

doesnt the array not work because of the way php parses the info into the array?

[DanDaBeginner]

try to echo this: $blockips=substr($blockips,0,-2) and it will give you an answer to your question...

 

create a function that will substring:

try this:

function Substring($element) {
       return(substr($element,0,-2))
}

[dlf1987]

ummmm i think theres a misunderstanding... forget the example i gave you.... try this

 

im not having trouble with the substr, its the values that im putting into the array, thats not working...

 

this works

<?php
$include = array("74.000.1.168", "74.000.113.72");
if (in_array($_SERVER['REMOTE_ADDR'], $include) == true) { echo ""; }
?>

 

but this doesnt

<?php

$blockips = '"74.000.1.168", "74.000.113.72"';

$include = array($blockips);
if (in_array($_SERVER['REMOTE_ADDR'], $include) == true) { echo ""; }
?>

[DanDaBeginner]

you can use implode...

put a delimeter , maybe a comma

$blockips = "74.000.1.168,74.000.113.72";

 

$include = implode(",",$blockips );

[dlf1987]

thats still not what im looking for 

 

I'm trying to hide my website stats scripts based on the ip's i have listed in my mysql database... is there another way of doing this?

 

another words...

if your ip matches the mysql query ip, don't echo stat scripts...

 

Thanks!

[taith]

its MUCH easier to let mysql handle blocked ip's...

 

<?php
$query=mysql_query("SELECT * FROM `banned` WHERE `ip`='$_SERVER['REMOTE_ADDR']' LIMIT 1");
if(mysql_num_rows($query)>0) die("you've been banned... GO AWAY! lol");
?>

[dlf1987]

well the thing is, i'm not trying to ban those ip's. Its my work ip, home ip, and a couple of others ip's that i don't want to be included in my sites statistics. another words if i go to my site, i don't want my google Analytics, and crazy egg scripts to show... hope that makes sense... sorry

[taith]

perfect sense... but still a similar fix... lol

 

<?php

$query=mysql_query("SELECT * FROM `banned` WHERE `ip`='$_SERVER['REMOTE_ADDR']' LIMIT 1");

if(mysql_num_rows($query)==0){

echo '<script type="text/javascript" src="https://cetrk.com/pages/scripts/0000/XXXX.js"></script>';

echo '<script src="https://ssl.google-analytics.com/urchin.js" type="text/javascript"></script> <script type="text/javascript">_uacct = "UA-XXXXX-2";urchinTracker();</script>';

}

?>