The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
View As User
#24
So this is where the whole results vs first comes in. If you're only going to get 1 user or 1 item because you are searching by id or something that is unique, you use

Code:
$result=$query->first();
Then to get the item back, you do

Code:
$result->columname.

BUT, say you are looking for all of your orders (like in your example), it's this...

Code:
$query = $db->query("SELECT * FROM ORDERS");
Code:
$results = $query->results();

That gives you an object (You can see that if you do dump($results)Wink

So you most likely want to do a foreach loop to generate your table of orders.

Do your table headings...
Code:
<thead>
Code:
<tr>
Code:
<th>Delete</th><th>ID</th><th>Date</th><th>Order Number</th><th>Functions</th>
Code:
</tr>
Code:
</thead>

THEN you foreach your rows
Code:
<?php
Code:
foreach ($results as $result) {
Code:
?>
Code:
<tr>
Code:
<td><?=$result->id?></td>
Code:
<td><?=$result->date?></td>
Code:
<td><?=$result->ordernumber?></td>
Code:
<td><?=$result->system?></td>
Code:
<tr>
Code:
<?php } ?>
  Reply


Messages In This Thread
View As User - by Brandin - 11-10-2016, 09:03 PM
View As User - by mudmin - 11-11-2016, 09:44 PM
View As User - by Brandin - 11-11-2016, 10:16 PM
View As User - by Brandin - 11-12-2016, 12:24 AM
View As User - by mudmin - 11-14-2016, 04:27 PM
View As User - by Brandin - 11-14-2016, 05:52 PM
View As User - by mudmin - 11-14-2016, 06:30 PM
View As User - by Brandin - 11-14-2016, 08:03 PM
View As User - by mudmin - 11-14-2016, 08:06 PM
View As User - by Brandin - 11-22-2016, 11:18 PM
View As User - by mudmin - 11-23-2016, 12:19 AM
View As User - by Brandin - 11-24-2016, 02:52 AM
View As User - by mudmin - 11-24-2016, 03:46 PM
View As User - by Brandin - 11-24-2016, 04:23 PM
View As User - by Brandin - 11-24-2016, 04:50 PM
View As User - by mudmin - 11-24-2016, 04:50 PM
View As User - by mudmin - 11-24-2016, 05:28 PM
View As User - by Brandin - 11-24-2016, 07:55 PM
View As User - by mudmin - 11-24-2016, 08:28 PM
View As User - by mudmin - 11-24-2016, 08:28 PM
View As User - by Brandin - 11-24-2016, 08:52 PM
View As User - by dan - 11-24-2016, 09:03 PM
View As User - by Brandin - 11-24-2016, 09:44 PM
View As User - by mudmin - 11-24-2016, 10:49 PM
View As User - by Brandin - 11-25-2016, 03:09 PM
View As User - by mudmin - 11-25-2016, 03:31 PM
View As User - by Brandin - 11-25-2016, 04:00 PM
View As User - by Brandin - 01-12-2017, 10:52 PM
View As User - by Brandin - 01-12-2017, 10:53 PM
View As User - by Brandin - 03-19-2017, 11:46 PM
View As User - by mudmin - 03-20-2017, 11:24 AM
View As User - by Brandin - 03-20-2017, 11:28 AM
View As User - by mudmin - 03-23-2017, 10:05 AM
View As User - by Brandin - 03-23-2017, 11:24 AM
View As User - by mudmin - 03-23-2017, 11:30 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)