sudo -s
cd /tmp
tar -xvvzf ZendServer-4.0.6-RepositoryInstaller-linux.tar.gz
cd ZendServer-RepositoryInstaller-linux/
./install_zs.sh 5.2 ce
alias apache2-restart='/etc/init.d/apache2 restart'
alias zend="cd /usr/local/zend/share/ZendFramework/bin/"
alias zf="/usr/local/zend/share/ZendFramework/bin/zf.sh"
zf show version
cd /var/www
zf create project <minuprojekt>
ln -s /usr/local/zend/share/ZendFramework/library/Zend /var/www/<minuprojekt>/library
vi /etc/hosts
127.0.0.1 <minuprojekt.local>
vi /etc/apache2/httpd.conf
NameVirtualHost 127.0.0.1
# selleks, et tavaline localhost ka toimiks
<VirtualHost *:80>
ServerName localhost
ServerRoot /var/www/
DocumentRoot /var/www
CustomLog /var/log/access.log combined
ErrorLog /var/log/error.log
<Directory "/var/www">
AllowOverride All
Order deny,allow
Allow from all
</Directory>
</VirtualHost>
# Zendi projekti conf
<VirtualHost *:80>
ServerName loudbite.lc
ServerRoot /var/www/
DocumentRoot /var/www/loudbite/public
CustomLog /var/log/loudbite.access.log combined
ErrorLog /var/log/loudbite.error.log
<Directory "/var/www/loudbite/public">
AllowOverride All
Order deny,allow
Allow from all
</Directory>
</VirtualHost>
/etc/init.d/apache2 restart
// application/models/Db/Db_Db.php
/**
* Database handler.
*
*/
class Db_Db
{
public static function conn(){
$connParams = array("host" => "localhost",
"port" => 3306,
"username" => "zf",
"password" => "",
"dbname" => "loudbite",
"unix_socket" => "/var/run/mysqld/mysqld.sock"); // vajalik juhul, kui PDO tahab avada socketi /tmp/mysqld.sock pihta
$db = new Zend_Db_Adapter_Pdo_Mysql($connParams);
return $db;
}
}
// application/controllers/XxxController.php
public function testInsertAction()
{
try {
//Create a DB object
require_once "../application/models/Db/Db_Db.php";
$db = Db_Db::conn();
$db->query("INSERT INTO ....");
$db->closeConnection();
}catch(Zend_Db_Exception $e){
echo $e->getMessage();
}
//Supress the View.
$this->_helper->viewRenderer->setNoRender();
}