in order to debug:// ----------- start ---------------
<?php
$mode = 1;
$clsid = 2;
$mp = 3;$sql = "update cdb_posts set subject='<a href=' . '"' . 'article_list.php?mode=' . $mode . '&clsid=' . $clsid . '&mp=' . $mp . '"' where pid='$pid'";echo $sql;echo mysql_error();
?>
// ------------- end ---------------Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/html/test.php on line 6
<?php
$mode = 1;
$clsid = 2;
$mp = 3;$sql = "update cdb_posts set subject='<a href=' . '"' . 'article_list.php?mode=' . $mode . '&clsid=' . $clsid . '&mp=' . $mp . '"' where pid='$pid'";echo $sql;echo mysql_error();
?>
// ------------- end ---------------Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/html/test.php on line 6
$sql = "update cdb_posts set subject='$subject' where pid='$pid'";第一次修改后的:
$sql = "update cdb_posts set subject='<a href=\"article_list.php?mode=$mode&clsid=$clsid&mp=$mp\">$subject</a>' where pid='$pid'";
// 此句可以正常工作第二次修改后的:
$sql = "update cdb_posts set subject='<a href=\"http://www.mydomainname/file.php?id=$id\">$subject</a>' where pid='$pid'";
// 这句的问题是,$subject不能正常显示,其他方面都正常,为什么呢,怎么解决呢
这样写会更好看一些
$sql = sprintf("update cdb_posts set subject='%s' where pid='%d',
"<a href='http://www.mydomainname/file.php?id=$id'>$subject</a>",
$pid);
"
$sql = sprintf("update cdb_posts set subject='%s' where pid='%d'",
"<a href='http://www.mydomainname/file.php?id=$id'>$subject</a>",
$pid);
"<a href='http://www.mydomainname/file.php?id=$id'>$subject</a>",
$pid);$subject不能解析了 怎么改呢
这句语句有问题
改成:
$sql = "update cdb_posts set subject='<a href="."\"article_list.php?mode=". $mode."&clsid=".$clsid."&mp=".$mp."\"' where pid='$pid'";
$sql1 = mysql_escape_string($sql); // mysql_real_escape_string($sql);
mysql_query($sql1);但还是不行
建議樓主把
$a='"';
$b="'";然後,把SQL裏面的單雙引號用 $a $b 代替.
$sql = "update cdb_posts set subject='$link1' where pid='$pid'";
$link1 = mysql_escape_string($link1);
$sql = "update cdb_posts set subject='$link1' where pid='$pid'";
echo $sql;
試一試這樣.如果還不行的話,看看輸出的 $sql 是什麼, 把 php.ini 中 顯示錯誤的選項開起來.樓主是不是在改 dz 論壇?
是在改dz论坛