correct variable?

[ohdang888]

is this valid?

$new_link = '<a href="game.php?title={$_POST["title"]}">$_POST["title"]</a>';

[trq]

Depends what you want it to do. Syntax wise there are no errors, it probably won't do what you want though.

 

More than likely your looking for....

 

$new_link = "<a href='game.php?title={$_POST['title']}'>{$_POST['title']}</a>";

 

Variables are not interpolated within single quoted strings.

[hitman6003]

Don't use single quotes...using single quotes php won't place the variable's value in it's place.  For example:

 

$var1 = 'abc';
$var2 = 'def';

echo 'var1 is $var1 and var2 is $var2'; //you get "var1 is $var1 and var2 is $var2"
echo "var1 is $var1 and var2 is $var2"; //you get "var1 is abc and var2 is def"

 

And, what thorpe said...( beat me to it )

[AV1611]

Maybe I'm being too cautious but I would do this:

 

if(!isset($_POST['title'])){

//something}

else

{

$title=$_POST['title'];

}

$new_link = '<a href="game.php?title='.$title.'">'.$title.'</a>';

 

 

[ohdang888]

what i am doign with this code is inserting $new_link into a databse.

the variable code i gave earlier wasn;'t working.

 

only i will have access to the page, so i don't need to worry about injections with this code either

 

 

[ohdang888]

i am getting this error when i clcik submit

 

Error in query: . You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'game.php?title=angry'>angry', 'afsdadsf', 'asdfh', 'gggg', 'gggg', 'ggg', ' at line 2

 

 

this is where the prpoblem is

$title= $_POST["title"];
  $new_link = "<a href='game.php?title={$title}'>{$title}</a>";

 

whats the matter with it.???

[hitman6003]

You need to escape the single quotes in your mysql query...use mysql_real_escape_string

 

$new_link = mysql_real_escape_string("<a href='game.php?title={$title}'>{$title}</a>");

 

http://www.php.net/mysql_real_escape_string

[ohdang888]

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\xampp\htdocs\newcreate.php on line 4

 

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\xampp\htdocs\newcreate.php on line 4

 

ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhh. any ideas?

[teng84]

it  is bad idea to put the whole codes in your DB just put there the location or maybe just the title which only dydnamic

putting whole tags is crazy lol