Hello Guys we giving you simple add,edit ,delete example using zend framework you can learn step by step
first configure your database connection for zend application
------------------------------------------------------------------------
D:\xampp\htdocs\mysite\application\configs\application.ini
-------------------------------------------------------------------------
[production]
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 1
resources.db.adapter = "PDO_MYSQL"
resources.db.params.host = "localhost"
resources.db.params.username = "root"
resources.db.params.password = ""
resources.db.params.dbname = "zend"
resources.layout.layoutpath = APPLICATION_PATH "/layouts"
phpSettings.date.timezone = "UTC"
[staging : production]
[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1
---------------------------------------create user table ---------------------------------------------------------
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`username` varchar(150) DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`usertype` varchar(25) NOT NULL DEFAULT '',
`block` tinyint(4) NOT NULL DEFAULT '0',
`sendEmail` tinyint(4) DEFAULT '0',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
`registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL DEFAULT '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=122 DEFAULT CHARSET=utf8;
--------------------------------------------------------------------------------------------------------
Stp->1 create a form class user.php location : D:\xampp\htdocs\zend\application\forms\user.php
-------------------------------------paste below code-----------------------------------------------------------
<?php
class Form_User extends Zend_Form
{
public function __construct($options = null)
{
parent::__construct($options);
$this->setName('album');
$id = new Zend_Form_Element_Hidden('id');
$name = new Zend_Form_Element_Text('name');
$name->setLabel('Name')
->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty');
$username = new Zend_Form_Element_Text('username');
$username->setLabel('Username')->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty');
$email = new Zend_Form_Element_Text('email');
$email->setLabel('Email')->setRequired(true)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty')->addValidator('EmailAddress', TRUE );
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$this->addElements(array($id, $name,$username, $email, $submit));
}
}
-----------------------------------------------------------------------------------------------------------------
Stp->2 create a controller class user.php location : D:\xampp\htdocs\mysite\application\controllers\BbcController.php
-----------------------------------------------------------------------------------------------------------------
<?php
class BbcController extends Zend_Controller_Action
{
public function init()
{
/* Initialize action controller here */
}
function indexAction()
{
$this->view->title = "Bbc by bikash";
$this->view->headTitle($this->view->title, 'PREPEND');
$user = new Model_DbTable_Bbc();
$this->view->bbc = $user->fetchAll();
}
function insertAction()
{
$this->view->title = "insert new user";
$this->view->headTitle($this->view->title, 'PREPEND');
$form = new Form_User();
$form->submit->setLabel('Insert');
$this->view->form = $form;
if ($this->getRequest()->isPost())
{
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData))
{
$name = $form->getValue('name');
$username=$form->getValue('username');
$email = $form->getValue('email');
$albums = new Model_DbTable_Bbc();
$albums->insertuser($name, $username,$email);
$this->_redirect('/bbc');
}
else
{
$form->populate($formData);
}
}
}
function updateAction(){
$this->view->title = "Upadate user";
$this->view->headTitle($this->view->title, 'PREPEND');
$form = new Form_User();
$form->submit->setLabel('update');
$this->view->form = $form;
if ($this->getRequest()->isPost())
{
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData))
{
$id = (int)$form->getValue('id');
$name = $form->getValue('name');
$username=$form->getValue('username');
$email = $form->getValue('email');
$albums = new Model_DbTable_Bbc();
$albums->updateuser($id, $name,$username, $email);
$this->_redirect('/bbc');
}
else
{
$form->populate($formData);
}
}
else
{
$id = $this->_getParam('id', 0);
if ($id > 0)
{
$albums = new Model_DbTable_Bbc();
$form->populate($albums->getAlbum($id));
}
}
}
public function deleteAction()
{
$this->view->title = "Delete album";
$this->view->headTitle($this->view->title, 'PREPEND');
if ($this->getRequest()->isPost())
{
$del = $this->getRequest()->getPost('del');
if ($del == 'Yes')
{
$id = $this->getRequest()->getPost('id');
$albums = new Model_DbTable_Bbc();
$albums->deleteUser($id);
}
$this->_redirect('/bbc');
}
else
{
$id = $this->_getParam('id', 0);
$albums = new Model_DbTable_Bbc();
$this->view->album = $albums->getAlbum($id);
}
}
}
------------------------------------------create view-----------------------------------------------------
Stp->1 create views location : D:\xampp\htdocs\mysite\application\views\scripts\bbc\index.phtml,insert.phtml,update.phtml,delete.phtml
--------------------------------------index.phtml -----------------------------------------------------
<p><a href="<?php echo $this->url(array('controller'=>'bbc',
'action'=>'insert'));?>">Add new album</a></p>
<table>
<tr>
<th>Name</th>
<th>Username</th>
<th>Email address</th>
<th> </th>
</tr>
<?php foreach($this->bbc as $album) : ?>
<tr>
<td><?php echo $this->escape($album->name);?></td>
<td><?php echo $this->escape($album->username);?></td>
<td><?php echo $this->escape($album->email);?></td>
<td>
<a href="<?php echo $this->url(array('controller'=>'bbc',
'action'=>'update', 'id'=>$album->id));?>">Edit</a>
<a href="<?php echo $this->url(array('controller'=>'bbc',
'action'=>'delete', 'id'=>$album->id));?>">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</table>
--------------------------------------insert.phtml -----------------------------------------------------
<?php echo $this->form ;?>
--------------------------------------update.phtml -----------------------------------------------------
<?php echo $this->form ;?>
--------------------------------------delete.phtml -----------------------------------------------------
<p>Are you sure that you want to delete
'<?php echo $this->escape($this->album['name']); ?>' by
'<?php echo $this->escape($this->album['email']); ?>'?
</p>
<form action="<?php echo $this->url(array('action'=>'delete')); ?>" method="post">
<div>
<input type="hidden" name="id" value="<?php echo $this->album['id']; ?>" />
<input type="submit" name="del" value="Yes" />
<input type="submit" name="del" value="No" />
</div>
-------------------------hope it may help you--:)--:)-------------------------------------------:)
