关于类的$this的有关问题-tutoriel php-php.cn

Maison

développement back-end

tutoriel php

关于类的$this的有关问题

Jun 13, 2016 am 10:52 AM

mysql quot this user

关于类的$this的问题

PHP code

<!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->class User {   private $uid;           private $fields;       public function __construct() {            $this-&gt;uid = null;            $this-&gt;fields = array(                            'username' =&gt; '',                            'password' =&gt; '',                            'emailAddr' =&gt; '',                            'isActive' =&gt; false,                            'permission' =&gt; 0                         );   }   public static function getById($user_id) {            $user = new User();                        $query = sprintf('SELECT username, password, email_addr, is_active, permission FROM %suser WHERE user_id = %d',                                DB_TBL_PREFIX, $user_id);            $result = mysql_query($query, $GLOBALS['DB']);            if (mysql_num_rows($result)) {                $row = mysql_fetch_assoc($result);                                $user-&gt;username = $row['username'];                $user-&gt;password = $row['password'];                $user-&gt;emailAddr = $row['email_addr'];                $user-&gt;isActive = $row['is_active'];                $user-&gt;permission = $row['permission'];                $user-&gt;uid = $user_id;            }            mysql_free_result($result);                        return $user;        }   }   public function save() {            if ($this-&gt;uid) {                $query = sprintf('UPDATE %suser SET username = "%s", password = "%s", email_addr = "%s",                                         is_active = %d, permission = %d WHERE user_id = %d',                                                        DB_TBL_PREFIX,                                                        mysql_real_escape_string($this-&gt;username, $GLOBALS['DB']),                                                        mysql_real_escape_string($this-&gt;password, $GLOBALS['DB']),                                                        mysql_real_escape_string($this-&gt;emailAddr, $GLOBALS['DB']),                                                        $this-&gt;isActive,                                                        $this-&gt;permission,                                                         $this-&gt;uid);                return mysql_query($query, $GLOBALS['DB']);            }            else {                $query = sprintf('INSERT INTO %suser(username, password, email_addr, is_active, permission)                                                                                 VALUES("%s", "%s", "%s", %d, %d)',                                                        DB_TBL_PREFIX,                                                        mysql_real_escape_string($this-&gt;username, $GLOBALS['DB']),                                                        mysql_real_escape_string($this-&gt;password, $GLOBALS['DB']),                                                        mysql_real_escape_string($this-&gt;emailAddr, $GLOBALS['DB']),                                                        $this-&gt;isActive,                                                        $this-&gt;permission);                if (mysql_query($query, $GLOBALS['DB'])) {                    $this-&gt;uid = mysql_insert_id($GLOBALS['DB']);                    return true;                }                else                    return false;            }        }

Copier après la connexion

为什么save()中的
$query = sprintf('UPDATE %suser SET username = "%s", password = "%s", email_addr = "%s",
is_active = %d, permission = %d WHERE user_id = %d',
DB_TBL_PREFIX,
mysql_real_escape_string($this->username, $GLOBALS['DB']),
mysql_real_escape_string($this->password, $GLOBALS['DB']),
mysql_real_escape_string($this->emailAddr, $GLOBALS['DB']),

Déclaration de ce site Web

Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn