Hi everybody,

i create a form,all the form datas store in db.but no data retrive from database.
what is the problem in my code.
nothing to display my template page.

plz help me.

this is my action file:

class planbookActions extends sfActions
{
  public function executeIndex(sfWebRequest $request)
  {

      $planbook_obj= Doctrine_Query::create()->select

('p.personal_id,p.photo,p.title_name,p.zone_id,p.place,p.occasion,p.itinerary,

p.description,p.date')->from('planbook p');
  $result = $planbook_obj->fetchArray();




  }
Indexsuccess.php(templatepage)

<ul>
<?php foreach ($planbooks as $planbook): ?>
<a href="<?php echo url_for('planbook/show?id='.$planbook->getId()) ?>" >
  <li>Name:    <?php echo $planbook->getTitleName() ?></li>
  <li>occasion: <?php echo $planbook->getOccasion() ?></li>
  <li>place: <?php echo $planbook->getPlace() ?></li>
<?php endforeach ?>
</ul>

Which database you are using, do you put connection of DB in page?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.