PHP - Table Display

Hi, i cant seem to get something working, should be simple but its not working for me.

I just need to only display a table if a variable in my table = a certain value.

The column in the table is called 'option1_available' and if its value is set to 'Y' i want it to display a table.

Appreciate any help, Thanks

I have the code below displaying images and image names. I want these to display in a table 2 rows high by the needed number of columns to show all the images in the directory. I have no idea what to do. What I am getting now is a single column with each image in its own row.
<?php
$path = "./uploaded/";
$dir_handle = @opendir($path) or die("Unable to open folder");
while (false != ($file = readdir($dir_handle)))
{
if($file == "index.php")
continue;
if($file == ".")
continue;
if($file == "..")
continue;
//show in a table 2 rows by required/needed number of columns
echo'<div>';
echo '<table border="1">';
echo "<img src='$path/$file' alt='$file'>"."<img src='$file' alt='$file'>";
echo'</table>';
echo '<div>';
}
?>

How to display items like bottom table?   And here is the code

<?

print"
<table style=\"width:100%\" class=\"tableList\">
	<tr>
		<th style=\"width:35%\">Prize Name</th> 
		<th style=\"width:12%\">Amount</th>
		<th style=\"width:12%\">Points</th>
		<th style=\"width:12%\">Available</th>
		<th style=\"width:12%\">Redeemed</th>
		<th style=\"width:17%\">Action</th>
	</tr>";

	$giftCardQuery = 'SELECT currency, amount, pointsPrice, instant_gift_cards.id, instant_gift_cards.giftCardName, instant_gift_cards.giftCardImage FROM instant_gift_card_codes INNER JOIN instant_gift_cards ON (instant_gift_card_codes.giftCardId = instant_gift_cards.id) WHERE instant_gift_cards.status = :cardStatus ORDER BY instant_gift_cards.dateCreated DESC';
	$giftCard = $db->prepare($giftCardQuery);
	$giftCard->bindValue(':cardStatus', 'Enabled', PDO::PARAM_STR);
	$giftCard->execute();
	
	if($giftCard->rowCount() > '0'){
	
		while($giftCardRow = $giftCard->fetch(PDO::FETCH_ASSOC)){
			
			$giftCardsAvailableQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsAvailable = $db->prepare($giftCardsAvailableQuery);
			$giftCardsAvailable->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsAvailable->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsAvailable->bindValue(':status', 'Available', PDO::PARAM_STR);
			$giftCardsAvailable->execute();
			$gCardsAvailable = $giftCardsAvailable->fetch(PDO::FETCH_COLUMN);
			
			$giftCardsRedeemedQuery = 'SELECT count(*) FROM instant_gift_card_codes WHERE currency = :currency AND amount = :amount AND pointsPrice = :pointsPrice AND giftCardId = :id AND status = :status';
			$giftCardsRedeemed = $db->prepare($giftCardsRedeemedQuery);
			$giftCardsRedeemed->bindParam(':currency', $giftCardRow['currency'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':amount', $giftCardRow['amount'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':pointsPrice', $giftCardRow['pointsPrice'], PDO::PARAM_STR);
			$giftCardsRedeemed->bindParam(':id', $giftCardRow['id'], PDO::PARAM_INT);
			$giftCardsRedeemed->bindValue(':status', 'Redeemed', PDO::PARAM_STR);
			$giftCardsRedeemed->execute();
			$gCardsRedeemed = $giftCardsRedeemed->fetch(PDO::FETCH_COLUMN);
			
			if($giftCardRow['giftCardImage']){
				$nameOrImage = '<img src="./images/giftcardrewards/'.$giftCardRow['giftCardImage'].'" alt="'.$giftCardRow['giftCardName'].'" title="'.$giftCardRow['giftCardName'].'">';
			}else{
				$nameOrImage = $giftCardRow['giftCardName'];
			}
			
			if($gCardsAvailable == '0'){
				$redeemAction = 'Out of Stock';
			}
			elseif($userInfo['currentPoints'] < $giftCardRow['pointsPrice']){
				$needed = $giftCardRow['pointsPrice'] - $userInfo['currentPoints'];
				$redeemAction = 'You need '.$needed.' point(s)';
			}
			elseif($userInfo['currentPoints'] >= $giftCardRow['pointsPrice']){
				$redeemAction = '<input type="button" value="Redeem" onclick="if(confirm(\'Are you sure to redeem this prize?\')){location.href=\'index.php?do=instantGiftCards&action=redeem&cardId='.$giftCardRow['id'].'&amount='.$giftCardRow['amount'].'\';}">';
			}
			
			print"
	<tr>
		<td>".$nameOrImage."</td>
		<td style=\"text-align:center\">".$giftCardRow['currency'].$giftCardRow['amount']."</td>
		<td style=\"text-align:center\">".$giftCardRow['pointsPrice']."</td>
		<td style=\"text-align:center\">".$gCardsAvailable."</td>
		<td style=\"text-align:center\">".$gCardsRedeemed."</td>
		<td style=\"text-align:center\">".$redeemAction."</td>
	</tr>";
		
		}
		
	}else{
		
		print"
	<tr>
		<td colspan=\"4\" style=\"text-align:center;color:#2B1B17;padding:15px 0\">No prizes added.</td>
	</tr>";
		
	}
	
print"
</table>";
	
?>

Ok the pagination part is all working fine.
but i thought id be able to create a heap variables inside the loop then display the images in a table. the only trouble is all variables are grabbing the same img. i need them to grab the 10 different records.

thanks

Code: [Select]
$sql = "SELECT * FROM mongrels_db.gallery ORDER BY id DESC LIMIT $offset, $rowsperpage ";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

// while there are rows to be fetched...
while ($list = mysql_fetch_array($result)) {

$img1=$list['img'];
$img2=$list['img'];
$img3=$list['img'];
$img4=$list['img'];
$img5=$list['img'];
$img6=$list['img'];
$img7=$list['img'];
$img8=$list['img'];
$img9=$list['img'];
$img10=$list['img'];

  // echo data
   
 
   } // end while
  echo "<table><tr>";
 echo "<td>"."<img src='../gallery/".$img1 ."' width='100' height='100''> "."</td>";
  echo "<td>"."<img src='../gallery/".$img2 ."' width='100' height='100''> "."</td>";
  echo "<td>"."<img src='../gallery/".$img3 ."' width='100' height='100''> "."</td>";
   echo "<td>"."<img src='../gallery/".$img4 ."' width='100' height='100''> "."</td></tr>";
  echo "<tr><td>"."<img src='../gallery/".$img5 ."' width='100' height='100''> "."</td>";
  echo "<td>"."<img src='../gallery/".$img6 ."' width='100' height='100''> "."</td>";
   echo "<td>"."<img src='../gallery/".$img7 ."' width='100' height='100''> "."</td>";
  echo "<td>"."<img src='../gallery/".$img8 ."' width='100' height='100''> "."</td>";
  echo "<tr><td>"."<img src='../gallery/".$img9 ."' width='100' height='100''> "."</td>";
  echo "<td>"."<img src='../gallery/".$img10 ."' width='100' height='100''> "."</td></tr>";

I have a table that needs to display data and its formatting should allow a scroll bar after a bit of length. In this case, the below code seems to allow it to continue well past the footer of the page... Did I miss something obvious?

                    <div class="col-md-12">
                        <div class="card card-plain">
                            <div class="header">
                                <h4 class="title">Current Vendors</h4>
                                <p class="category">Vendors listed as active within VendorBase.</p>
                            </div>

							<?php
							$con=mysqli_connect("localhost","root","test","vendors");
							// Check connection
							if (mysqli_connect_errno())
							{
							echo "Failed to connect to MySQL: " . mysqli_connect_error();
							}

							$result = mysqli_query($con,"SELECT * FROM vendor_data");

							echo "                  <div class='content table-responsive table-full-width'>
															<table class='table table-hover'>
																<thead>
																	<th>Name</th>
																	<th>Type</th>
																	<th>Company</th>
																	<th>Email</th>
																	<th>SOC2 Report</th>
																	<th>Status</th>
																	


																</thead>
																<tbody>";
																
																while($row = mysqli_fetch_array($result))
																{
																echo "<tr>";
																echo "<td>" . $row['name'] . "</td>";
																echo "<td>" . $row['type'] . "</td>";
																echo "<td>" . $row['company'] . "</td>";
																echo "<td>" . $row['email'] . "</td>";
																echo "<td>" . $row['soc'] . "</td>";
																echo "<td>" . $row['status'] . "</td>";							
																echo "</tr>";
																}
															
														echo "</table>";
											    echo "</div>";
																mysqli_close($con);
							?>
                                </table>

                            </div>
                        </div>
                    </div>

 

I'm trying to display relevant user details when click after user details button.it is css pop up window.i want to know how to catch relevant user when click the button.my primary key is email.

Sorry for the beginner question, here I'm trying to retrieve data from the database and display it in the table format. But only table headers are printed, and not the actual values. The count variable is echoing 2 saying that data is present and correctly retrieved. Can anyone help?

<?php
include 'connect.php';
error_reporting(E_ALL ^ E_DEPRECATED);
error_reporting(E_ERROR | E_PARSE);
$sql="SELECT * FROM `resources` as r INNER JOIN `project_resources` as pr
ON r.res_id =pr.res_id WHERE project_id='$_POST[project_id]'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);

if($result === FALSE) {
die(mysql_error()); 
}
echo "$count";
echo '<table>
<tr>
<th>Resource ID</th>
<th>Resource Name</th>
<th>Email</th>
<th>Phone Number</th>
<th>Reporting Manager</th>
<th>Role</th>
<th>Designation</th>
</tr>';

while ($row = mysql_fetch_array($result)) {
echo '
<tr>
<td>'.$row['res_id'].'</td>
<td>'.$row['res_name'].'</td>
<td>'.$row['email'].'</td>
<td>'.$row['phone_number'].'</td>
<td>'.$row['reporting_manager'].'</td>
<td>'.$row['role'].'</td>
<td>'.$row['designation'].'</td>
</tr>';

}

echo '
</table>';

?>

Edited by mac_gyver, 22 September 2014 - 07:25 AM.
code tags please

Hi,

Hi I require a PHP code to get output table.    My Table    Item Qty Date
aa-1 2 2014-10-01
aa-2 5 2014-10-01
aa-3 1 2014-10-01
ab-1 2 2014-10-01
ab-2 1 2014-10-01
bb-1 4 2014-10-01
bb-2 3 2014-10-01
bb-3 2 2014-10-01
aa-1 1 2014-10-02
aa-2 2 2014-10-02
aa-3 5 2014-10-02
ab-1 6 2014-10-02
ab-2 1 2014-10-02
bb-1 9 2014-10-02
bb-2 0 2014-10-02
bb-3 4 2014-10-02
aa-1 1 2014-10-03
aa-2 2 2014-10-03
aa-3 5 2014-10-03
ab-1 4 2014-10-03
ab-2 3 2014-10-03
bb-1 1 2014-10-03
bb-2 8 2014-10-03
bb-3 2 2014-10-03   I wrote code as mentioned below.

<?php

$accounts=mysql_connect("localhost", "root", "") or die("could not connect");  

mysql_select_db("shops",$accounts) or die("could not find db!");

if(isset($_POST['search']) && ($_POST['from']) && ($_POST['to'])){
    $searchq=$_POST['search'];
    $searchq=preg_replace("#[^0-9a-z]#i", "" , $searchq);
    $from=$_POST['from'];
    $to=$_POST['to'];

    $dateInput = explode('-',$from);
    $fdate = $dateInput[2].'-'.$dateInput[1].'-'.$dateInput[0];

    $dateInput = explode('-',$to);
    $tdate = $dateInput[2].'-'.$dateInput[1].'-'.$dateInput[0];
    

    for ($date=$fdate; $date<=$tdate; $date++) {
            $sql = "SELECT  item, SUM(CASE WHEN `date` = '$date' THEN Qty ELSE 0 END)
            FROM shop WHERE item LIKE '%$searchq%' GROUP BY item";  
        $query = mysql_query($sql) or die("could not search!"); 

            echo "<table border='1'>";

                echo "<tr>
                        <td>Item </td>
                        <td>$date</td>
                      </tr>" ;

            while ($row=mysql_fetch_array($query)) {

                echo "<tr>
                        <td>". $row[0] ." </td>
                        <td>" . $row[1] . "</td>
                      </tr>";  
            }               
            echo "</table>";
     }   
} 
?>

I am getting result like this as I asked for three days.

Item	2014-10-01
aa-1	2
aa-2	5
aa-3	1
Item	2014-10-02
aa-1	1
aa-2	2
aa-3	5
Item	2014-10-03
aa-1	1
aa-2	2
aa-3	5

But I need result like below


Item	2014-10-01	2014-10-02	2014-10-03
aa-1	2	        1	        1
aa-2	5	        2	        2
aa-3	1	        5	        5

Can anybody help me to write PHP code to display result as needed. Please help. Thanks in advance.

Dear everyone,

I am reasonably new to php, so there is a chance that what I am asking for may exceed my grasp.
Nevertheless I'd like to try:

Is it possible to let the user choose (by using a drop down listbox for instance) which table from a database to display on a page?
And/or which database to display on a page?

Background information: I'm working on a website for my chess club. I've already got a working page (html,css) with a table of the standings (mysql, php) of the latest round (with position number, name, points, wins, losses, etc). By clicking on the column header, it sorts the respective column. What I'd finally like to do is let the user choose to display a different round (table), or even a different season (database). I could make a seperate page for each round, but I'd like to know if there's a more elegant way to do this by using only one page and one or more databases.

Thanks in advance for any tips and best wishes from The Netherlands,

Wouter.

When displaying data from a mysql table, what php code can I use to display the number of columns in said table?

Like, say I'm displaying comments by users. I want to be able to put "displaying 'thismany' comments".

Any suggestions?

Hello, 
I know this should be pretty simple to figure out, but everything I try is giving me absolutely no results. 
I have a mysql query selecting columns from my database and returning results. I have the results printing out right now, so I can see that this part is working. 

All I want to do is take the results and put them into a table to display on my page. Basically, take what's in the database table and copy it to a table I can put on the web. 

FYI I am using sourcerer so the "connect" code is taken care of for me in the "JFactory" bit of code. Here is the first part of my code, selecting the information from the database. 

{source} 
<?php 
$db = JFactory::getDbo(); 
$query = $db -> getQuery(true); 

$query -> SELECT($db -> quoteName(array('first_dept_name', 'last_name', 'dept', 'position', 'phone_num'))); 
$query -> FROM ($db -> quoteName('#__custom_contacts')); 
$query -> ORDER ('first_dept_name DESC'); 
$query -> WHERE ($db -> quoteName('contact_category')."=".$db -> quote('YTown Employees')); 
$db -> setQuery($query); 
$results = $db -> loadObjectList(); 

print_r($results); 

Here is where I am trying to print the results into a table. I got this code directly from a PHP book, but I am getting nothing at all returned back to me. I get table headers, but no data. 

<?php 

echo "<table><tr><th>Name</th><th>Department</th></tr>"; 

while ($row = mysqli_fetch_array ($result)){ 

echo "<tr>"; 

echo "<td>".$row['last_name']."</td>"; 

echo "<td>".$row['dept']."</td>"; 

echo "</tr>"; 

} 

echo "</table>"; 

?> 
{/source}

I would like to echo field names in my table on webpage one by one. I know mySQL has "describe" function which will list the complete table, I am looking for a way to display each field name one by one with other stuff in between them like input field or description.

Hey Everyone,
I'm creating a site that will show images uploaded for certain days working on a job site. Kind of a day-to-day photo journal for the customer. On the site, the user gets here, sees 3 large images, and a series of thumbnails if more than 3 images exist for that day (works fine).
However, underneath that I want to display a 3-4 column setup of "Archived Dates" that provide a link to the images of the other dates. I have this working correctly, but the results are displayed as follows:

Date 1: Date 2: Date 3:

etc....

I want them to display like this;
Day 1 Day 4
Day 2 Day 5
Day 3 Day 6

and so on..... in a 3 column format. Here is the code I have right now just looping through to display these link results, not the rest of the page. I am trying to do it tableless right now, but if that isn't the right way to go, please let me know.
Thanks to anyone in advance,
Nick

 $SQLRowe = "SELECT DISTINCT RoweImgDate from tblRowe WHERE RoweImgDate !='" . $_GET['date'] . "' Order by RoweImgDate DESC Limit 0, 30";
        //echo $SQLRowe;
        $rsSQLRowe = mysql_query($SQLRowe);

<span class="rowe">Archived Photos:</span><br/>
                    <div id="archive">
                    <?php
                    
                        while($row = mysql_fetch_array($rsSQLRowe)){

                            //echo "<a href='index.php?id="' . $row[RoweImgID] . '"' class='link'>$row[RoweImgDate]</a></br>";
                                    echo "<div id='archivedates'>";
                                    echo "<a href='index.php?date=" . $row[RoweImgDate] . "' class='link'>$row[RoweImgDate]</a>";
                                    echo "</div>";
                                    //echo "<img src='images/$row[RoweImage]'/><br/>";
                                    //echo "<span class='FeatDesc'><p>$row[RoweImgDesc]</p></span><br/>";
                                }
                    ?>
                    </div>

Hello,   I am trying to display the data from two tables with proper format. But Its not happening   Here is my 1st table - orders   2.PNG   10.12KB   0 downloads   and my 2nd table - order_line_items    1.PNG   14.92KB   0 downloads   I want to display like this     3.PNG   4.03KB   0 downloads   Here is my code

$query = $mysqli->query("SELECT orders.order_id, orders.company_id, orders.order_for, order_line_items.order_id, order_line_items.item, order_line_items.unit,SUM(order_line_items.unit_cost * order_line_items.quantity) AS 'Total', order_line_items.tax from orders INNER JOIN order_line_items ON orders.order_id = order_line_items.order_id where orders.order_quote = 'Order' GROUP BY order_line_items.id"); ?>

<table id="dt_hScroll" class="table table-striped">
						<thead><tr>
						<th>Order ID</th>
						<th>Company</th>
						<th>Contact Person</th>
						<th>Products</th>
                        <th>Total</th>
                        
                        
						
</tr>

</thead>
<tbody> <?php

while($row = $query->fetch_array())
{
?>
<tr>
<td><?php echo $row['order_id']; ?></td>
<td><?php echo $row['company_id']; ?></td>
<td><?php echo $row['contact_person'] ?></td>
<td><?php echo $row['item']; ?></td>
<td><?php echo $row['Total']; ?> %</td>

</tr>
<?php

}	

But here order ID, Company ID, Contact Person are also repeating thrice with item in order_line_items table   Please suggest me how to do this