I assume you are using Windows as development OS, so download zftool and put it on C:/. Open the console and cd to C:/ then you an try the follow 1) create a zf2 project zftool.phar create project path/to/project 2) create a new Module zftool.phar create module ModuleName path/to/my/applicationRoot 3) create a new controller zftool.phar … Read more
Have your full .htaccess like this: RewriteEngine On ## add www and turn on https in same rule – main domain RewriteCond %{HTTP_HOST} !^www\. [NC,OR] RewriteCond %{HTTPS} !on RewriteCond %{HTTP_HOST} ^(?:www\.)?(example\.com)$ [NC] RewriteRule ^ https://www.%1%{REQUEST_URI} [R=301,L,NE] ## turn on https in same rule – sub domain RewriteCond %{HTTPS} !on RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L,NE] RewriteCond %{REQUEST_FILENAME} … Read more
/* DB Adapter get and SQL object create */ $adapter = GlobalAdapterFeature::getStaticAdapter(); $sql = new \Zend\Db\Sql\Sql($adapter); /* Select object create */ $select = new \Zend\Db\Sql\Select(); $select->from(‘states’); $select->where->addPredicate( new \Zend\Db\Sql\Predicate\Expression( ‘TRIM(LOWER(state_name)) = ?’, ‘noida’ ) ); /* Select object convert to string and execute */ $queryString = $sql->getSqlStringForSqlObject($select); $result = $adapter->query($queryString, Adapter::QUERY_MODE_EXECUTE); 1 solved Mysql functions … Read more