Question

i) 一台电传系统,它进行细微工作,但是,在阅读该系统时,它会照亮的频率和机体。这样一来,你就能够告诉他们是否公开。本文没有更新,而是在其准备更新时查看信息。 THANKS

<?php
session_start();

require "../scripts/connect_to_mysql.php";

    if (isset($_SESSION[ id ])){
    $touser = $_SESSION[ id ];
        }
        elseif (!isset($_SESSION[ id ])){
            header( location: http://www.stat-me.com );
        }

$id = $_GET[ id ];
$memberfirstname = $_SESSION[ firstname ];


if(!isset($id)) {
    header( location: inbox.php );
}
elseif(isset($id)) {

    mysql_query("UPDATE pms SET read= 1  WHERE id= $id ");    


    $grab_pm = mysql_query("SELECT * FROM pms WHERE touser =  $touser  AND id =  $id ");

    while($r= mysql_fetch_object($grab_pm)) {    
        $subject = $r->subject;    
        $message = $r->message;    
        $fromuser = $r->fromuser;    
        $datesent = $r->datesent;    
        $read = $r->read;
    }


}


?>

Answer 1

如果id田是牙齿,但我会这样作,则这并不完全清楚。

mysql_query("UPDATE pms SET read= 1  WHERE id=$id");
$grab_pm = mysql_query("SELECT * FROM pms WHERE touser = $touser AND id = $id");

还肯定会逃脱您的职司变量,例如:

$id = mysql_real_escape_string($_GET[ id ]) ;

http://www.un.org。此外,还用上美元对用户的单一报价。

Answer 2

更改您的询问

mysql_query("UPDATE pms SET read= 1  WHERE id=".$id);
$grab_pm = mysql_query("SELECT * FROM pms WHERE touser = ".$touser." AND id = ".$id);

INT数据类型没有双重引用,其内容取决于其内容(例如,如果你插入1和0,则删除大约1的引述,如果是的话,则保留)。

友情链接