// ...
// may some code here...
// ...
sfContext::getInstance()
->getConfiguration()
->loadHelpers("Asset");
// this will load Symfony Asset Helper.. and make available all its helper.
$imagePath=image_path("../uploads/profile_images/IMAGE_NAME");
// ...
// more code...
// ...
string generateUrl('URL_ROUTE',
array(
'module'=>'MODULE_NAME',
'action'=>'ACTION_CALLED',
'PARAMS'=>'VALUE'
),
$isAbsolute
);
URL_ROUTE is the SEO Friendly URL pattern you defined in config file of module, if not defined use 'default' second is the config array in which we define module name and the action we want to call next is the parameter we want to pass via URL you can pass as many as you want params through it, in the form 'PARAM1'=>'VALUE1','PARAM2'=>'VALUE2',.... and last parameter is $isAbsolute it instruct whether we want relative or absolute URL, default is false it generate relative URL by default.$this->generateUrl('default',
array('module'=>'User','action'=>'EditUser','uid'=>$id))
the out will be something like this...backend_dev.php/User/EditUser/uid/1130hope it helps...
all:
user:
class: myUser
param:
timeout: false
myUser is the child class of sfBasicSecurityUser which is in apps/[MODULE_NAME]/lib/myUser.class.php you can change the name of the class, timeout is the property that controls Session time out of user if this is set as false time out never occur if a numeric value is given time out will occur after that, timeout value is in milliseconds i.e. if value is 36000 timeout will occur in 10 min (60*60*10), simple and easy is not it?
public function executePaging(sfWebRequest $request){
$results_per_page=10;
$set_first_page=1;
$this->pagination = new sfDoctrinePager('User', $results_per_page);
$this->pagination->setQuery(Doctrine::getTable('User')->createQuery('u'));
$this->pagination->setPage($request->getParameter('page', $set_first_page));
$this->pagination->init();
}
now the code we write in View or the ethodNameSuccess in our case PagingSuccess.php| <?php echo $users->getId(); ?> | <?php echo $users->getFirstName(); ?> | <?php echo $users->getLastName(); ?> | <?php echo $users->getEmail(); ?> |
public function myDBWrapper($query,$type=0){
$connection=Doctrine_Manager::getInstance()
->getCurrentConnection()->getDbh();
// Get Connection of Database
$statement=$connection->prepare($query);
// Make Statement
$statement->execute();
// Execute Query
if($type==0){
// Check if it is SELECT query
$results = $statement->fetchAll();
return $results;
}
}
public function executeMyDBWrapperTest(sfWebRequest $request){
$insertQuery="INSERT INTO users (username,email)
VALUES ('Originative','originative@live.com')";
$selectQuery="Select * from users";
$this->myDBWrapper($insertQuery);
// INSERT data in table
$this->results=$this->myDBWrapper($selectQuery, 1);
// Fetch data from table save output
// which will be displayed in
// MyDBWrapperTestSuccess.php
}
public function executePageRefresh(sfWebRequest $request){
//... something usefull here
//... going back
$this->redirect($request->getUri());
}
we use redirect function of symfony and method getUri() from $request object... getUri() give the complete URL inclucing the http and query string.
public function executeDelete(sfWebRequest $request){
Doctrine::getTable('User')
->findBy('id', $request->getParameter('id'))
->delete();
$this->redirect('SOME/PAGE');
$this->setTemplate(false);
}
Doctrine simplify our CRUD operations, here we just give Id of the record to be deleted and use delete() method or Doctrine to remove that record.
public function executeShowUserInfo(sfWebRequest $request){
$query = Doctrine_Query::create()
->query("select * from user");
$result = $query->toArray();
$count = count($result);
for($i=0;$i<$count;$i++){
echo $result [$i]["first_name"]
." => "
.$result [$i]["email"]
.",";
}
}
here $query->toArray() convert returned response in to array.
public function executeValidateUser(sfWebRequest $request){
$username = $request -> getParameter("username");
$password = $request -> getParameter("password");
$query = Doctrine_Query::create()
->select("id")
->from("user")
->where("username=$username")
->andWhere("password=$password");
$rowcount= $query -> count();
if( $rowcount == 1 ){
//do something useful, User Authenticated
}
else{
// do something useful here too even thoug User is Not Authenticated :)
}
}
$query=Doctrine_Query::create()
->select("first_name, last_name")
->from("user");
now we get this query using the Doctrine method getSQLQuery()echo $query->getSQLQuery(); exit();on the browser we get something like this
SELECT u.id AS u__id, u.first_name AS u__first_name, u.last_name AS u__last_name FROM user u
public function executeIndex(sfWebRequest $request)
{
$this->greetings="Hello World, Symfony is Great :)";
}
now open indexSuccess.php located in templates folder this file is by defualt empty, in it paste the following code<?php
echo "$greetings
";
?>
open web browser and navigate to the URL http://localhost/HelloWorld/web/frontend_dev.php/mySite it will also show a debugging toolbar which show very useful information, if you don't want debugging toolbar change URL to http://localhost/HelloWorld/web/index.php/mySite you should be able to see following page.
Tutorial Jinni Copyright © 2015 WoodMag is Modified by Originative Systems