7WdTL3Vn

1Why is my Insert failing using Doctrine 2?
2function insert_user($username,$email,$password) 
3        {
4$user = new User();
5$user->setUsername = $username;
6$user->setEmail = $email;
7$user->setPassword = $password;
8
9    try {
10            //save to database
11            $this->em->persist($user);
12            $this->em->flush();
13        }
14        catch(Exception $err){
15
16            die($err->getMessage());
17        }
18        return true;
19        }
20	
21CREATE TABLE IF NOT EXISTS `user` (
22  `id` int(11) NOT NULL AUTO_INCREMENT,
23  `username` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
24  `email` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
25  `password` varchar(300) COLLATE utf8_unicode_ci NOT NULL,
26  PRIMARY KEY (`id`)
27) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
28
29/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
30/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
31/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
32	
33<?php
34
35
36
37use DoctrineORMMapping as ORM;
38
39/**
40 * User
41 *
42 * @Table(name="user")
43 * @Entity
44 */
45class User
46{
47    /**
48     * @var integer $id
49     *
50     * @Column(name="id", type="integer", nullable=false)
51     * @Id
52     * @GeneratedValue(strategy="IDENTITY")
53     */
54    private $id;
55
56    /**
57     * @var string $username
58     *
59     * @Column(name="username", type="string", length=300, nullable=false)
60     */
61    private $username;
62
63    /**
64     * @var string $email
65     *
66     * @Column(name="email", type="string", length=300, nullable=false)
67     */
68    private $email;
69
70    /**
71     * @var string $password
72     *
73     * @Column(name="password", type="string", length=300, nullable=false)
74     */
75    private $password;
76
77
78    /**
79     * Get id
80     *
81     * @return integer 
82     */
83    public function getId()
84    {
85        return $this->id;
86    }
87
88    /**
89     * Set username
90     *
91     * @param string $username
92     */
93    public function setUsername($username)
94    {
95        $this->username = $username;
96    }
97
98    /**
99     * Get username
100     *
101     * @return string 
102     */
103    public function getUsername()
104    {
105        return $this->username;
106    }
107
108    /**
109     * Set email
110     *
111     * @param string $email
112     */
113    public function setEmail($email)
114    {
115        $this->email = $email;
116    }
117
118    /**
119     * Get email
120     *
121     * @return string 
122     */
123    public function getEmail()
124    {
125        return $this->email;
126    }
127
128    /**
129     * Set password
130     *
131     * @param string $password
132     */
133    public function setPassword($password)
134    {
135        $this->password = $password;
136    }
137
138    /**
139     * Get password
140     *
141     * @return string 
142     */
143    public function getPassword()
144    {
145        return $this->password;
146    }
147}
148	
149$user->setUsername($username);
150$user->setEmail($email);
151$user->setPassword($password);