Scratch

WindowsExplorer wrote:

flashgocrazy wrote:

i have this code

Code:

<?php

$mysql_host = "xxxx";
$mysql_database = "xxxxx";
$mysql_user = "xxxxxx";
$mysql_password = "xxxx";
$con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
if (!$con)
  {
echo "mysql error";
  }
$ip=$_SERVER['REMOTE_ADDR'];
mysql_query("INSERT INTO stuff (ip)
VALUES ('$ip')");
mysql_close($con);
?>

can somebody make this code so it displays a image and records your ip onto a mysql database?
thanks,
flash 

I'm not sure. Is there any errors coming up? Also, I was trying to do this once too, but it didn't work.

no errors, its just not posting the ip in the database

TRocket wrote:

flashgocrazy wrote:

i have this code

Code:

<?php

$mysql_host = "xxxx";
$mysql_database = "xxxxx";
$mysql_user = "xxxxxx";
$mysql_password = "xxxx";
$con = mysql_connect($mysql_host,$mysql_user,$mysql_password);
if (!$con)
  {
echo "mysql error";
  }
$ip=$_SERVER['REMOTE_ADDR'];

mysql_query("INSERT INTO stuff (ip)
VALUES ('$ip')");

mysql_close($con);
?>

can somebody make this code so it displays a image and records your ip onto a mysql database?
thanks,
flash 

you need to give mysql_query $con as well

do you have the code for it?

$sql = 'INSERT INTO stuff (ip) VALUES (' . $ip . ')';
mysql_query($sql, $con);

should work...

Last edited by TRocket (2011-12-29 10:59:30)

WindowsExplorer wrote:

Code:

<?php

$mysql_host = "xxxx";
$mysql_database = "xxxxx";
$mysql_user = "xxxxxx";
$mysql_password = "xxxx";
$con = mysql_connect($mysql_host, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $con);
if (!$con)
  {
echo "mysql error";
  }
$ip=$_SERVER['REMOTE_ADDR'];

mysql_query("INSERT INTO stuff (ip)
VALUES ('$ip')", $con);

mysql_close($con);
?>

Try this.

exactly, although you don't need to specify the connection in the mysql_select_db parameters but you can anyway 

wierd, its not closed

flashgocrazy wrote:

wierd, its not closed

Yikes, I guess I closed my browser tab too soon before the thread got closed. It's closed now.