cakephp mysql error

Question

I'm having some trouble with my site. What I want this view to do is display all invoices that relates to a userid(in another table), Instead the code is printing out all the invoices in the one view(disregarding the user id). When looking at the sql statement that cakephp debug spits out it shows the where as a blank(don't worry I'll include the actual sql statment). I also have session code created but I am unsure how to code it so that the mysql data will say where userid = current user;

here is the code for the view

<table width="100%" border="1">

            <table width="100%" border="1">
                <tr>
                    <th>Biller</th>
                    <th>Subject</th>
                    <th>Date</th>
                    <th>Action</th>
                </tr>
                <?php foreach($invoices as $invoice):?>
                    <tr> debug($invoices);
                        <td align='center'><?php echo $this->Html->link($invoice['Invoice']['biller'], 
                        array('action' => 'viewinvoice', $invoice['Invoice']['id'])); ;?> </td>
                        <td align='center'><?php echo $invoice['Invoice']['subject']; ?></td>
                        <td align='center'><?php echo $invoice['Invoice']['datecreated']; ?></td>
                        <td align='center'><a href="viewinvoice"><button>View Invoice</button></a><a href="disputeinvoice"><button>Dispute Invoice</button></a></td>
                    </tr>
                <?php endforeach; ?>

            </table>

here is the code in the class relating to this view

 public function payinvoice($id = null){
        $this->set('title_for_layout', 'Pay Invoice');
        $this->set('stylesheet_used', 'homestyle');
        $this->set('image_used', 'eBOXLogoHome.jpg');   
        $this->layout='home_layout';

        $this->set('invoices', $this->Invoice->find('all' , array('conditions' => array('Invoice.biller' => $id)))); 
}

and here is the sql code that site is using to retrieve the data

   SELECT `Invoice`.`id`, `Invoice`.`to`, `Invoice`.`biller`, `Invoice`.`subject`, `Invoice`.`description`, `Invoice`.`amount`, `Invoice`.`datecreated`, `Invoice`.`duedate` FROM `pra_cake`.`invoices` AS `Invoice` WHERE `Invoice`.`biller` IS NULL

RichardAtHome · Accepted Answer · 2012-05-23 14:05:38Z

1

It looks like you are not passing an id into your page. The url should look like:

/invoices/payinvoice/2

answered May 23, 2012 at 14:05

RichardAtHome

4,3134 gold badges23 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1393064 Over a year ago

how would one be able to achieve that?

RichardAtHome Over a year ago

See Moyed Ansari's answer above

Moyed Ansari · Accepted Answer · 2012-05-23 19:10:12Z

1

This is probably the issue of the url

try this

<?php echo $this->Html->link('Invoice',
    array('controller' => 'invoices', 
          'action' => 'payinvoice', 
          $invoice['Invoice']['id'])
    );?>

it will generate

<a href="/invoices/payinvoice/6">Invoice</a>

edited May 23, 2012 at 19:10

answered May 23, 2012 at 17:10

Moyed Ansari

8,4612 gold badges38 silver badges57 bronze badges

2 Comments

user1393064 Over a year ago

it comes up with a link on the site but its only 'invoices/payinvoice/'

RichardAtHome Over a year ago

Can you post the code you use to populate $invoice and the output of debug[$invoice] please?

Collectives™ on Stack Overflow

cakephp mysql error

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related