Not signed in (Sign In)
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

Akelos Programming: Access Database Records From Different Controllers

Bottom of Page

1 to 12 of 12

  1.  
    •  
      CommentAuthorbigtalk
    • CommentTimeJul 1st 2008
     

    Hello,

    I've created the admin end of my site. I can create records via the back-end and look at them. Yay!
    So how do I access and display this great info on the front-side? For example, I would like to diplay just the Title and Body of a record in the table "news". I'm sure this is fairly simple, but the answer is eluding me.
    I'm using PageController for the front-end, NewsController extends AdminController, and I have a News model who's associated installer (news_installer) I used to create the news table in MySQL.
    I looked around the forum for this solution but was not able to locate it. My apologies if I missed it and am being redundant.

    -BigTalk

    •  
      CommentAuthorbigtalk
    • CommentTimeJul 21st 2008
     

    I have been successful in getting a view of the Names of the columns in News, but it won't show any of the actual data in the fields.

    I am using:

      {?news}
  <div>
  <table cellspacing="0" summary="_{Listing available News}">

    <tr>
      <?php  $content_columns = array_keys($News->getContentColumns()); ?>
      {loop content_columns}
        <th scope="col"><?php echo $pagination_helper->sortable_link($content_column) ?></th>
      {end}
    </tr>

    {loop news}
    <tr {?news_odd_position}class="odd"{end}>
      {loop content_columns}
      <td class="field"><?php echo $News->get($content_column) ?></td>
      {end}
    </tr>
    {end}
  </table>
  </div>
  {end}

    This has really gotten me stuck. Maybe someone in the Seattle area would like to trade; Akelos/PHP lessons of saxophone/music theory lessons?

    Thank you some more,
    BigTalk

    • CommentAuthorKaste
    • CommentTimeJul 21st 2008
     

    hm,

    {loop news}

    inside the loop you would have to use the singular of 'news' which is ... 'news'.

    compiled code then should be

    foreach ($news as $key=>$news)...

    dont know a workaround right now.

    • CommentAuthorKaste
    • CommentTimeJul 21st 2008
     

    I'd take the lessons, but Im not in Seattle %

    • CommentAuthorKaste
    • CommentTimeJul 22nd 2008
     

    brr.. you can always write

    {loop something as otherthing}

    in sintags. like in the foreach-statement

    •  
      CommentAuthorbigtalk
    • CommentTimeJul 22nd 2008
     

    On the admin side of my site,

    {loop news}

    is working fine. I did change it on the front-side to

    {loop news as blog}

    just to see if it would have an effect, but it doesn't.
    Any other thoughts as to what I'm missing? Again, it is obviously connecting to the database and finding the table, because it lists the columns. Just doesn't fill them with data the way it does on my admin-side.

    Kaste - Thanks for writing me, I've been hoping for some help for weeks! You are Super-Hero!

    • CommentAuthorKaste
    • CommentTimeJul 22nd 2008
     

    so this

    <tr>
  <?php  $content_columns = array_keys($News->getContentColumns()); ?>
  {loop content_columns}
    <th scope="col"><?php echo $pagination_helper->sortable_link($content_column) ?></th>
  {end}
</tr>

    works, and

    {loop news}
<tr {?news_odd_position}class="odd"{end}>
  {loop content_columns}
  <td class="field"><?php echo $News->get($content_column) ?></td>
  {end}
</tr>
{end}

    doesn't work?

    then it seems because of

     $News->getContentColumns()

    doesn't throw, $News can't be an array but must be an active record. so you can't loop over $News.

    A standard scaffold has e.g. for 'book' two variables in the listing-view.

    • $book as in array_keys($Book->getContentColumns()
    • $books as in {loop books}

    Can you do

     $this->RecentNews = $this->News->find('all);

    in the controller and then {loop RecentNews} ...?

    •  
      CommentAuthorbigtalk
    • CommentTimeJul 23rd 2008
     

    I tried that and it still doesn't give me anything. Maybe I'll change News to Scoop. Then I can have Scoop and Scoops. Eliminate the pluralization problem altogether.

    Do I need anything in my controller to make accessing the data in MySQL work? As it stands, I only have:

     var $models = array('news', 'track');

 function index()
 {
   $this->RecentNews = $this->News->find('all');
 }

    in my controller. Any logic that doesn't already exist in Akelos?

    • CommentAuthorKaste
    • CommentTimeJul 23rd 2008
     

    Can you just output:

    $this->RecentNews = $this->News->find('all');
foreach ($this->RecentNews as $item){
    echo $item->toString();
}

    and look into log/development.log for the generated sql.

    Maybe we don't have any news?

    •  
      CommentAuthorbigtalk
    • CommentTimeJul 23rd 2008
     

    Thank you Kaste!

    Filling RecentNews with the News and then looping through RecentNews as $item does the trick. My application doesn't seem to be generating log/development.log for whatever reason. But I was able to display my data!
    Here's the code that works for me:

    In my controller:

         function index()
     {
       $this->RecentNews = $this->News->find('all');
     }

    And in my view:

       {?news}
   <div>
      <table cellspacing="0" summary="_{Listing available News}">
        <tr>
        <?php  $content_columns = array_keys($News->getContentColumns()); ?>
           {loop content_columns}
           <th scope="col">
             <?php echo $pagination_helper->sortable_link($content_column) ?>
           </th>
           {end}
        </tr>
        {loop RecentNews as item}
        <tr {?item_odd_position}class="odd"{end}>
           {loop content_columns}
           <td class="field">
             <?php echo $item->get($content_column); ?>
           </td>
           {end}
        </tr>
        {end}
     </table>
  </div>
  {end}

    This completely works.
    One more question. Is there an Akelos method that will let my display only the most recent data? All of my data has a "posted_at" column.

    • CommentAuthorKaste
    • CommentTimeJul 23rd 2008
     

    man, give me the ten most recent news is usually

    ->find('all',array('order'=>'posted_at desc','limit'=>10);
    •  
      CommentAuthorbigtalk
    • CommentTimeJul 24th 2008
     

    That's it! Thank you!
    I just made it

     ,'limit'=>1);

    Works just like I want it.

    Cheers Kaste!!!

1 to 12 of 12

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page