php/mysql help needed

dx3k · 01-04-2005, 09:12 AM

hey

can you tell me what is wrong with this script please i keep getting "unexpected ) on line 18"

PHP Code:

  <?

include('sqlinfo.php');

$connect = mysql_connect($host, $account, $password);

$db = mysql_select_db("dx3k_logger)";       <<<< this is line 18

$query = "INSERT INTO ip VALUES (''$ip");

 
?>

????: NamePros.com http://www.namepros.com/programming/63178-php-mysql-help-needed.html
thanks

dx3k

adam_uk · 01-04-2005, 09:25 AM

$db = mysql_select_db("dx3k_logger)";

should be

$db = mysql_select_db("dx3k_logger");

dx3k · 01-04-2005, 09:27 AM

still dont want to work

this is what i have now

PHP Code:

  <?

$ip = $REMOTE_ADDR;

echo "$ip"; 

?>

<?

include('sqlinfo.php');

$connect = mysql_connect($host, $account, $password);

$db = mysql_select_db("dx3k_logger");   <<< line 18

$query = "INSERT INTO 'ip' VALUES (''$ip");

 
?>

flexiwebhost.com · 01-04-2005, 10:20 AM

$query = "INSERT INTO 'ip' VALUES (''$ip");

that is wrong as well, you opened the quotes outside of the bracket but closed them in the bracket also wht do you have ''$ip

try :-

$query = "INSERT INTO 'ip' VALUES ('".$ip."')";

dx3k · 01-04-2005, 02:38 PM

now it is on about a T_STRING erro on line 18 ( i h8 this line lol) what is a t_string?

<?
include('sqlinfo.php');
$db = mysql_connect("$host", "$account");
mysql_select_db("dx3k_logger",$db);
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

?>

thanks

dx3k

cerebus · 01-04-2005, 03:56 PM

<?
include('sqlinfo.php');
$db = mysql_connect($host,$account);
mysql_select_db("dx3k_logger",$db);
$query = "INSERT INTO `data` ( `ip` , `browser` ) VALUES ('$ip')";
?>

That should work. Just note that you have two fields defined in the fields list and only one value, in case you intend to run the query.

I must really recommend you to read a few PHP beginner tutorials.

dx3k · 01-05-2005, 03:16 AM

i am already , most of the script i copyd from the book

superprogrammer · 01-05-2005, 08:46 AM

Originally Posted by dx3k

now it is on about a T_STRING erro on line 18 ( i h8 this line lol) what is a t_string?
????: NamePros.com http://www.namepros.com/showthread.php?t=63178

<?
include('sqlinfo.php');
$db = mysql_connect("$host", "$account");
mysql_select_db("dx3k_logger",$db);
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

?>

thanks

dx3k

Can you print out the line 18 here?
Thanks

cerebus · 01-05-2005, 10:58 PM

One of the following ought to be line 18 as it aint enclosed in quotes:
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

flexiwebhost.com · 01-05-2005, 11:21 PM

you will need to enclose them in quotes, also why are you only assigning ip when your query should be inserting 2 lots of data (ip and browser)

dx3k · 01-06-2005, 03:41 AM

yer i got it to work now 100% my fault... i hadnt added myself as a user to the database

i am an idiot

01-04-2005, 09:12 AM	THREAD STARTER #1 (permalink)
dx3k NamePros Regular Join Date: May 2004 Location: www.dx3k.com Posts: 581	php/mysql help needed hey can you tell me what is wrong with this script please i keep getting "unexpected ) on line 18" PHP Code: `<? include('sqlinfo.php'); $connect = mysql_connect($host, $account, $password); $db = mysql_select_db("dx3k_logger)"; <<<< this is line 18 $query = "INSERT INTO ip VALUES (''$ip"); ?>` ????: NamePros.com http://www.namepros.com/programming/63178-php-mysql-help-needed.html thanks dx3k __________________ I B Back

01-04-2005, 09:27 AM	THREAD STARTER #3 (permalink)
dx3k NamePros Regular Join Date: May 2004 Location: www.dx3k.com Posts: 581	still dont want to work this is what i have now PHP Code: `<? $ip = $REMOTE_ADDR; echo "$ip"; ?> <? include('sqlinfo.php'); $connect = mysql_connect($host, $account, $password); $db = mysql_select_db("dx3k_logger"); <<< line 18 $query = "INSERT INTO 'ip' VALUES (''$ip"); ?>` __________________ I B Back

01-04-2005, 10:20 AM	#4 (permalink)
flexiwebhost.com NamePros Regular Join Date: Jun 2004 Location: Ekenas Posts: 271	$query = "INSERT INTO 'ip' VALUES (''$ip"); that is wrong as well, you opened the quotes outside of the bracket but closed them in the bracket also wht do you have ''$ip try :- $query = "INSERT INTO 'ip' VALUES ('".$ip."')"; __________________ Flexi Web Host buy Advertising On Forum Hosts Free phpBB forum hosting Free Image Host

01-04-2005, 02:38 PM	THREAD STARTER #5 (permalink)
dx3k NamePros Regular Join Date: May 2004 Location: www.dx3k.com Posts: 581	now it is on about a T_STRING erro on line 18 ( i h8 this line lol) what is a t_string? <? include('sqlinfo.php'); $db = mysql_connect("$host", "$account"); mysql_select_db("dx3k_logger",$db); $query = INSERT INTO `data` ( `ip` , `browser` ) VALUES ( '$ip' ); ?> thanks dx3k __________________ I B Back

01-05-2005, 03:16 AM	THREAD STARTER #7 (permalink)
dx3k NamePros Regular Join Date: May 2004 Location: www.dx3k.com Posts: 581	i am already , most of the script i copyd from the book __________________ I B Back

01-04-2005, 09:25 AM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	$db = mysql_select_db("dx3k_logger)"; should be $db = mysql_select_db("dx3k_logger");

01-04-2005, 03:56 PM	#6 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	<? include('sqlinfo.php'); $db = mysql_connect($host,$account); mysql_select_db("dx3k_logger",$db); $query = "INSERT INTO `data` ( `ip` , `browser` ) VALUES ('$ip')"; ?> That should work. Just note that you have two fields defined in the fields list and only one value, in case you intend to run the query. I must really recommend you to read a few PHP beginner tutorials.

01-05-2005, 10:58 PM	#9 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	One of the following ought to be line 18 as it aint enclosed in quotes: $query = INSERT INTO `data` ( `ip` , `browser` ) VALUES ( '$ip' );

01-05-2005, 11:21 PM	#10 (permalink)
flexiwebhost.com NamePros Regular Join Date: Jun 2004 Location: Ekenas Posts: 271	you will need to enclose them in quotes, also why are you only assigning ip when your query should be inserting 2 lots of data (ip and browser) __________________ Flexi Web Host buy Advertising On Forum Hosts Free phpBB forum hosting Free Image Host

01-06-2005, 03:41 AM	THREAD STARTER #11 (permalink)
dx3k NamePros Regular Join Date: May 2004 Location: www.dx3k.com Posts: 581	yer i got it to work now 100% my fault... i hadnt added myself as a user to the database i am an idiot __________________ I B Back

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)