FetchAll Problem

[CEHTURK]

Some javascript/style in this post has been disabled (why?)

Hello all

 

I am trying to create a registration form with ZF1.8. After user enters his email, I want to check whether that email address is already registered or not. But everytime I am having a MySQL synax error.

 

The code is

if($form->isValid($formData))

            {

                        $alumniName = $form->getValue('alumni_Name');

                        $alumniLastName = $form>getValue('alumni_LastName');

                        $alumniEmail = $form->getValue('alumni_Email');

                        $alumniPassword = $form->getValue('password');

                        $alumniGraduateDate = $form->getValue('alumni_GraduateDate');

                        $alumniMemory= $form->getValue('alumni_Memory');

                        $alumni = new Model_DbTable_Alumni();

                        $row = $alumni->fetchAll(' alumni_Email = ' . $alumniEmail);

                        if(count($row>0))

                        {

                             throw new Exception('This email is already registered');

                        }

                        else {

                             $alumni->registerAlumni($alumniName,$alumniLastName,$alumniEmail,$alumniPassword,$alumniGraduateDate,$alumniMemory);

                        }

                       

                       

            }

            else {

                  $form->populate($formData);

                 

            }

 

The error I am having is

Message: SQLSTATE[42000]: Syntax error or access violation: 1064 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 '@gmail.com) LIMIT 1' at line 1

 

I have lots queries running the same way. Is there any problem in the code that you can see but I can not..

 

Regards

E

[Ralph Schindler-2]

E,

Try one of these instead:

$alumni->fetchAll(
     $table->select()->where('alumni_Email = ?', $alumniEmail)
     );

OR, just quote the value

$row = $alumni->fetchAll(
    'alumni_Email = ' . $dbAdapter->quote($alumniEmail)
    );

The problem is your $alumniEmail is not getting passed to the query as a
qouted value.

-ralph


Erdal YAZICIOGLU wrote:

> Hello all
>
>  
>
> I am trying to create a registration form with ZF1.8. After user enters
> his email, I want to check whether that email address is already
> registered or not. But everytime I am having a MySQL synax error.
>
>  
>
> The code is
>
> if($form->isValid($formData))
>
>             {
>
>                         $alumniName = $form->getValue('alumni_Name');
>
>                         $alumniLastName = $form>getValue('alumni_LastName');
>
>                         $alumniEmail = $form->getValue('alumni_Email');
>
>                         $alumniPassword = $form->getValue('password');
>
>                         $alumniGraduateDate =
> $form->getValue('alumni_GraduateDate');
>
>                         $alumniMemory= $form->getValue('alumni_Memory');
>
>                         $alumni = new Model_DbTable_Alumni();
>
>                         $row = $alumni->fetchAll(' alumni_Email = ' .
> $alumniEmail);
>
>                         if(count($row>0))
>
>                         {
>
>                              throw new Exception('This email is already
> registered');
>
>                         }
>
>                         else {
>
>                              
> $alumni->registerAlumni($alumniName,$alumniLastName,$alumniEmail,$alumniPassword,$alumniGraduateDate,$alumniMemory);
>
>                         }
>
>                        
>
>                        
>
>             }
>
>             else {
>
>                   $form->populate($formData);
>
>                  
>
>             }
>
>  
>
> The error I am having is
>
> *Message:* SQLSTATE[42000]: Syntax error or access violation: 1064 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 '@gmail.com)
> LIMIT 1' at line 1
>
>  
>
> I have lots queries running the same way. Is there any problem in the
> code that you can see but I can not..
>
>  
>
> Regards
>
> E
>