how to new module configure and run in ZF2 ?[Solved]

Guy you can download one module from here
how to run extracting the module?
Step 1->extract and copy in to C:\wamp\www\zf2crud\module then paste the module folder if(in case module name like  : (SanAuth-master remove to SanAuth)
Step 2->Go to C:\wamp\www\zf2crud\config\application.config.php
add the module :

  'modules' => array(
        'Application',
     'SanAuth'
    ),

last check the router url on location is C:\wamp\www\zf2crud\module\SanAuth-master\config\module.config.php

like :'router' => array(
        'routes' => array(
            
            'login' => array(
                'type'    => 'Literal',
                'options' => array(
                    'route'    => '/auth',
                    'defaults' => array(
                        '__NAMESPACE__' => 'SanAuth\Controller',
                        'controller'    => 'Auth',
                        'action'        => 'login',
                    ),
                ),

your browser url should be http://localhost/zf2crud/public/auth

lastly may help you :) enjoy :.............:)

insert and update with join and where cluse query in mysql[Solved]

Insert query example :
---------------------------

insert into cms_users(user_email,user_password,user_password_salt,user_activation_code,user_date_added)


select charity_contact_email,'25d896d7cb473deb61a752b845bdf548','WXaa','',now() from cms_charities

where charity_id in ( 

select charity_id  FROM cms_charities cc left join cms_users u on cc.charity_contact_email=u.user_email

where cc.charity_contact_email!='' and cc.charity_contact_email not in('sdowns@markomm.com','sarah.sievert@stbernardproject.org')

and u.user_email is null and cc.charity_submitted_by_user_id=0





)



Update query example :

-----------------------------
update cms_charities 

join cms_users

on cms_users.user_email=cms_charities.charity_contact_email

set cms_charities.charity_submitted_by_user_id=cms_users.user_id

WHERE cms_users.user_id>3367