PHP - Php Code To Display Cross Table

hello i need help on displaying php code on my website so people can come and just copy it but it wont let me display it

Hi

I have the following code:

Code: [Select]
$result = mysql_query("SELECT * FROM xbox_games order by gameid");
$row = mysql_fetch_assoc($result);
$id = $row["gameid"];
$title = $row["gametitle"];
$cover = $row["cover"];

                                <?php echo $title;?>

Which displays only the first result from my database.

How can i change this to display all the results either as a list, or in a table?

Thanks

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>";
	
?>

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>';
}
?>

Hello,
I want to make a list with 2 columns on one of my pages with link to categories on my page. But they appear in only one column (on below the other) and i want them to be like:
Pictures      Videos
Pictures2    Videos2

These are my codes
<li> <a href="user_album_add.php">Pictures</a>
<li> <a href="user_album2_add.php">Pictures2</a>
<li> <a href="user_video_add.php">Video</a>
<li> <a href="user_video2_add.php">Video2</a>

What should i do? Thank you!

hello

I need to fix code display problem. The code below cause the disorder problem. When I delete the part of it , the code display in the right way. I do not really understand it .

 The template try to use  bx_textarea to display code，so I find the function in it. Finally , I found this function cause the disorder code problem.
Code: [Select]
<?php echo bx_highlight(bx_textarea($view_query_result['jdescription']), $kwd_search);?>


Code: [Select]
    if ($char == "<") {
            $skip=1;
        }   
        elseif ($char == ">") {
            $skip=0;
        }   
        elseif ($char == " ") {
            $wrap=0;
         }   
         if ($skip==0) {
            $wrap=$wrap+1;
        }



Code: [Select]
function bx_wordwrap($a_str, $a_break_length=75) {
    $length = strlen($a_str);
    for ($i=0; $i<=$length; $i=$i+1) {
        $char = substr($a_str, $i, 1);
        if ($char == "<") {
            $skip=1;
        }   
        elseif ($char == ">") {
            $skip=0;
        }   
        elseif ($char == " ") {
            $wrap=0;
         }   
         if ($skip==0) {
            $wrap=$wrap+1;
        }
        $res_str = $res_str . $char;
        if ($wrap>$a_break_length) {
            $res_str = $res_str." ";
            $wrap=0;
        }
    }
    return $res_str;
}
function bx_textarea($text) {
  return nl2br(preg_replace('/\t/','&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;',bx_wordwrap($text, 75)));
}//end function bx_textarea($text)

Hey guys,

I'm opening a HTML file from my server, and i can successfully echo it both as code to show the page, and as code which the person can then edit in a <textarea>.

However, there are certain sections of the code i do not what echo'd to the page. What is the best way to go about stipping them? For example i do not want the user to be able to edit the doctype, head element, <header> or <nav> sections of the code.

Thanks in advance
Danny.

Bad title, I know.
What I mean is I have a code that shows a pop-up error message if you try to post with a username someone else has.
Well, I use this code for my user/pass/message fields:

$user = preg_replace("/[^A-Z a-z0-9]/", "", $_POST['user']);
$password = preg_replace("/[^A-Za-z0-9]/", "", $_POST['password']);
$message = preg_replace("/[^A-Za-z0-9]/", "", $_POST['message']);

What that does is, if you post with, say, a less than or greater than sign, or some other whack character, it makes the field blank for whichever field(s) you enter other characters into.  So really, when someone posts on my forums with a character I do not want them to use in their user/message, it makes the message completely blank, no matter what other allowed characters are used, and the same with the username...so the post will show up without a poster.

My question is, what is a code to use so a pop-up box would show up instead of letting the post go through and post blanks?  Doesn't even have to be a pop-up box, just something to say to the user, "Hey, you can't use (insert disapproved character(s) here)" and to have the post not go through.

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?

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.

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>";

Hi,

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>

 

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.