PHP - Echo The Table Names I Am Using In My Query

Hello again!   I'm here with another PHP/Mysqli related question, I want to output the data i receive from the Query:

SHOW tables; 

Into html code, more specific: links. This is what i try'd to do:

<div class="container">
  <div class="header" align="center">
   <nav>
		<ul>
			<li><a href="#">Home</a></li>
			<li><a href="#">Databases</a>
				<ul>
<?php
$mysqli = new mysqli('localhost','*****','*****','*****');
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
} 
$sql = 'show tables from osiris1q_mtg';
$result = $mysqli->query($sql);
if(!$result = $mysqli->query($sql)){
    die('There was an error running the query [' . $mysqli->error . ']');
}
    // output data of each row
    while($row = $result->fetch_assoc()){
    echo "<li><a href='#'></a>"$row"</li>";
}
} else {
    echo "<li><a href='#'></a>0 results</li>";
}				</ul>
			</li>
		</ul>
	</nav>
</div>    <!-- end .header -->
?>

This is the header.php file which is included in the actual index page. This doesn't return anything not even the html parts of it. Even all the files i have 'included' aren't showing up anymore. I hope i explained myself good enough for anyone to understand   How Anyone can help me out!   Thank you in Advance!

Okay, so I'm trying to run a query to pull the information from a specific item that they click on in order to edit it.

When I run an echo $query, though, it shows the field names rather than the information from the table.

How can I make it so that it pulls the information rather than the field names?

Here's what I have...


<?php
include("lib.php");
define("PAGENAME", "Edit Equipment");

if ($player->access < 100)

$msg1 = "<font color=\"red\">"; //name error?
$error = 0;

$query = $db->execute("SELECT * FROM items WHERE id=?", array($_POST['id']));

echo "$id";

$result = mysql_query($query);

echo "$query";

$data = mysql_fetch_assoc($result); 

$msg1 .= "</font>"; //name error?


?>


Thanks!!

Hey guys,   I am stuck on this piece of code. Within the function I am using I need to include an mysql query.  I am not sure how to insert it within the echo.  Currently the query works but the code stops once close the '' and </ul> and </section> are cut out.   Please note that there is alot more code within the echo, not just the section and ul.  Just simplified it for my question.   Any help would be appreciated.   Thanks

 

like so...



echo"
$query = mysql_query("SELECT * FROM table WHERE memberID = ".$User['memberID']."");
";



??????????????

Hi im new to php. what im trying to do is echo the result out to a textbox and can't seem to figure it out.
I can echo the result to my screen just fine,its when i try to echo it oout to the textbox i cant figure out.
I have added my code below.
Thanks will

Code: [Select]
<?php
//DATABASE CONNECTION//
  include 'include/test.php';
$team = $_POST["Team"];
$COUNT = 'COUNT(id)';
$query = "SELECT COUNT(id)  FROM `teamrosters` WHERE TEAM = '$team'  ";    
$result = mysql_query($query); 
 
// Print out result 
while($row = mysql_fetch_array($result)) { 
echo 'ROSTER COUNT: '. $row  [$COUNT]; 

}

echo mysql_error() 
?>


  <h1 class="will"><span class="will">Welcome to B410 Team Rosters Page</span></h1>
    <p class="will"><span class="will">Just pick the team from the drop down menu you wan't to see and hit summit</span></p>
    <p>
    </p>
    <form action="formsummit.php" method="post" name="form1" id="form1">
      <label for="Team" class="will">Team</label>
      <select name="Team" id="Team">
        <option value="Auburn">Auburn</option>
        <option value="Texas">Texas</option>
        <option value="OSU">OSU</option>
        <option value="USC">USC</option>
        <option value="UCLA">UCLA</option>
        <option value="Vandy">Vandy</option>
        <option value="Michigan">Michigan</option>
        <option value="Texas AM">Texas AM</option>
        <option value="Texas Tech">Texas Tech</option>
        <option value="Colorado">Colorado</option>
        <option value="Washington">Wasington</option>
        <option value="Iowa ST">Iowa ST</option>
        </select>
      <input type="submit" name="summit" id="summit" value="Submit" />

      <label for="text">avg team speed</label>
      <input type="text" name="text" id="text" value=" <?php echo $row ['COUNT(id)'];?> " />
    </form>

Good Afternoon Team,

Am sitting with something simple using the language below. If I copy the echo output of my query as included below it works perfectly in phpmyadmin but doesn't work on a website. Variables all seem to echo consistently/correctly and POST checks seem to verify this is working correctly as well. I worry the error comes with the syntax I used in combining the sql queries. That, or perhaps LAST_INSERT_ID does not work in the php script as well as it does in phpmyadmin. All help appreciated.

if(isset($_POST[`region_id`])) {
    $competition_id = htmlentities($_POST[`competition_id`],ENT_QUOTES,`UTF-8`);
    $division_name = htmlentities($_POST[`division_name`],ENT_QUOTES,`UTF-8`);
    $region_id = htmlentities($_POST[`region_id`],ENT_QUOTES,`UTF-8`);
    $division_edit_submit = "INSERT INTO division_table (competition_id,division_name) VALUES (`$competition_id`,`$division_name`);
    INSERT INTO region_assignment_table (division_id,region_id) VALUES ((LAST_INSERT_ID()),`1`)";    
    mysqli_query($connection,$division_edit_submit);
    echo $division_edit_submit;
    }

 

here is my code... please help

<form method="get" action="shit3.php">
<input maxlength="50" size="50" type="text" name="q"> <input type="submit" value="SEARCH">
</form>

<?php

if (@$_GET['q']) {

 $var = $_GET['q'] ;
 $trimmed = trim($var);

$limit=1;

   if ($trimmed == "")
       {
          echo "Please enter a search...";
    exit;
    }

   if (!isset($var))
       {
          echo "Container not found!";
    exit;
   }

mysql_connect("localhost", "xxx", "yyy") or die(mysql_error());
mysql_query("SET NAMES 'cp1251'");

mysql_select_db("agaexpor_container") or die("Unable to select database"); //select which database we're using

$query = "select * from containertracking where vin like \"%$trimmed%\"
 order by vin";

 $numresults=mysql_query($query);
 $numrows=mysql_num_rows($numresults);

if (empty($s)) {
 $s=0;
 }

$query .= " limit $s,$limit";
 $result = mysql_query($query) or die("Couldn't execute query");

$count = 1 + $s ;

while ($row= mysql_fetch_array($result)) {
 $vin = $row["vin"];
 $container = $row["container"];

 echo "$count.) VIN: $vin <br />";
 echo "container is: $container <br />";
 
 $count++ ;
 }

}
?>

My Php Buddies,

I have mysql tbl columns these:

id: 
date_&_time: 
account_activation_code: 
account_activation_status: 
id_video_verification_status: 
id_verification_video_file_url: 
username: 
password: 
primary_domain: 
primary_website_email: 
sponsor_username: 
 

Now, I want to display their row data by excluded a few columns.

Want to exclude these columns:

date_&_time

account_activation_code

account_activation_status

id_verification_video_file_url

password

 

So, the User's (eg. your's) homepage inside his account should display labels like these where labels match the column names but the underscores are removed and each words' first chars CAPITALISED:

Id: 1
Id Video Verification Status: 1
Username: requinix
Primary_domain: requinix.majesty
Primary Website Email: requeen@requinix.majesty
Sponsor Username: phpsane
Recruits Number: 2

 

For your convenience only PART 1 works. Need help on Part 2

My attempted code:

 

	PART 1
	<?php 
	// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
	// Query to get columns from table
$query = $conn->query("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'members' AND TABLE_NAME = 'users'");
	while($row = $query->fetch_assoc()){
    $result[] = $row;
}
	// Array of all column names
$columnArr = array_column($result, 'COLUMN_NAME');
	foreach ($columnArr as $value) { 
echo "<b>$value</b>: ";?><br><?php 
} 
	?>
	 
	PART 2
	<?php 
	//Display User Account Details 
echo "<h3>User: <a href=\"user.php?user=$user\">$user</a> Details</h3>";?><br> 
<?php 
$excluded_columns = array("date_&_time","account_activation_code","account_activation_status","id_verification_video_file_url","password"); 
foreach ($excluded_columns as $value2) 
{    
    echo "Excluded Column: <b>$value2</b><br>";
}
foreach ($columnArr as $value) 
{ 
    
    if($value != "$value2")
    { 
        $label = str_replace("_"," ","$value"); 
        $label = ucwords("$label"); 
        //echo "<b>$label</b>: "; echo "$_SESSION[$value]";?><br><?php 
        echo "<b>$label</b>: "; echo "${$value}";?><br><?php 
    }
} 
?>
	

PROBLEM: Columns from the excluded list still get displayed.

Edited November 19, 2018 by phpsane

Hi

I have written the below code to echo a table

Code: [Select]
<table>
              <?php
  //start top 10 loop
$sql=mysql_query("SELECT * FROM Games ORDER BY up DESC LIMIT 10");
while($row=mysql_fetch_array($sql))
{
$title=$row['gametitle'];
$gameid=$row['gameid'];
$up=$row['up'];
?>

                <tr><td><a href="Reviews.php?gameid=<?php echo $gameid ?>"><?php echo $title ?></a>
                <td align="right"><?php echo $up ?></td>
               
                </tr>
                <?php
//end top 10 loop
}
?>
</table>
I want to add a new column to the table that lists them as 1 through to ten.

Can anybody advise the best way to do this?

Thanks

for some reason it will not render to the row... ive added the php echo to the row in question and it runs with the top row... can someone take a look and let me know what i am doing wrong...

thanks
trey

here is the code... the php echo in bold red should show up on the next row; but, it doesnt...

<?php
/**
* @version $Id: mod_gridiron_game_results.php, v1.5.0 March 2011 01:32:15
* @author Fastball Productions
* @package Gridiron
* @copyright Copyright (C) 2011 Fastball Productions
* @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
*/

// no direct access
defined('_JEXEC') or die('Restricted access');

$db =& JFactory::getDBO();

// get the module parameters
$heading = $params->get( 'heading', '' );
$showpast = $params->get( 'showpast', '1' );
$numberpast = $params->get( 'numberpast', '1' );
$linkboxscore = $params->get( 'linkboxscore', '1' );
$shownextgame = $params->get( 'nextgame', '1' );
$numbernext = $params->get( 'numbernext', '1' );
$linknext = $params->get( 'linknext', '1' );
$seasonid = $params->get( 'seasonid', '1' );
$gametypes = $params->get( 'gametypes', '1' );
$teamids = $params->get( 'teamids', '' );
$leagueids = $params->get( 'leagueids', '' );
$divisionids = $params->get( 'divisionids', '' );

if (is_array($gametypes)) {
   $gametypes = implode(',', $gametypes);
}
if (is_array($teamids)) {
   $teamids = implode(',', $teamids);
}
if (is_array($leagueids)) {
   $leagueids = implode(',', $leagueids);
}
if (is_array($divisionids)) {
   $divisionids = implode(',', $divisionids);
}

// if there is a league configured, get the teams within the league/division;
if ($teamids == '' && ($divisionids || $leagueids)) {
   if ($divisionids) {
      // get a listing of all team ID's that belong in the league and division;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(divisionid, '$divisionids'))";
   }
   else {
      // get a listing of all team ID's that belong in the league;
      $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(leagueid, '$leagueids'))";
   }
   $db->setQuery($sql);
   $rows = $db->loadResultArray();
   $teamids = implode(',', $rows);
}
else if ($teamids == '') {
   // get the default team (single team component only);
   $db->setQuery("SELECT id FROM #__gridiron_team WHERE (defaultteam = 1)");
   $teamids = $db->loadResult();
}

// get the last x number of games played and the results;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   b.finalv, b.finalh
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_boxscore AS b ON a.id = b.gameid
   WHERE (a.scored = 1 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND a.gamedatetime < now())
   GROUP BY a.id
   ORDER BY a.gamedatetime DESC LIMIT 0, {$numberpast}");
$pastgames = $db->loadObjectList();

// get the next x number of games scheduled;
$db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid,
   DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate,
   DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime,
   h.name AS hometeam,
   v.name AS visitingteam,
   t.description AS gametype
   FROM #__gridiron_schedule AS a
   LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id
   LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id
   LEFT JOIN #__gridiron_gametype AS t ON a.gametype = t.id
   LEFT JOIN #__gridiron_location AS l ON a.location = l.id
   WHERE (a.scored = 0 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND DATE_ADD(a.gamedatetime, INTERVAL 3 HOUR) > now())
   GROUP BY a.id
   ORDER BY a.gamedatetime ASC LIMIT 0, {$numbernext}");
$nextgames = $db->loadObjectList();
?>
<table width="100%" border="0" align="center">
   <?php if ($showpast && $numberpast > 0) { ?>
   <tr>
      <td colspan="2" style="text-align:center;"><b><?php echo $heading;?></b></td>
   </tr>
   <tr>
      <td width="43%"><b><u>Matchup</u></b></td>
      <td width="57%" style="text-align:center;"><b><u>Result</u></b></td>
   </tr>
   <?php foreach ($pastgames as $past) { ?>
   <tr>
      <td>
         <?php echo $past->visitingteam;?> vs.<br /><?php echo $past->hometeam;?>
      </td>
      <td style="text-align:center;">
      <?php if ($linkboxscore) { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=boxscore&id=$past->id");?>"><?php echo $past->finalv;?><br /><?php echo $past->finalh;?></a>
      <?php } else { ?>
      <?php echo $past->finalv;?><br /><?php echo $past->finalh;?>
        </td>
      <?php } ?>
   </tr>
   <tr>
      <td colspan="2"></td>
   </tr>
   <?php } ?>
   <?php } ?>
   <?php if ($shownextgame && $numbernext > 0 && $nextgames) { ?>
   <tr>
      <td colspan="2"><b><u>Next Game</u></b></td>
       
   </tr>
   <?php foreach ($nextgames as $next) { ?>
   <?php $next->visitingteam == '' ? $next->visitingteam = 'TBA':$next->visitingteam = $next->visitingteam;?>
   <?php $next->hometeam == '' ? $next->hometeam = 'TBA':$next->hometeam = $next->hometeam;?>
   <tr>
      <td colspan="2">
      <?php if ($linknext) { ?>
      <?php if ($next->visitingteam == 'TBA') { ?>
      <?php echo $next->visitingteam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->visitingteamid");?>"><?php echo $next->visitingteam;?></a>
      <?php } ?>
       vs.
      <?php if ($next->hometeam == 'TBA') { ?>
      <?php echo $next->hometeam;?>
      <?php } else { ?>
      <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->hometeamid");?>"><?php echo $next->hometeam;?></a>
      <?php } ?>
      <?php } else { ?>
      <?php echo $next->visitingteam;?> vs. <?php echo $next->hometeam;?>   
      </td>
   </tr>
   <tr>
     <td colspan="2"><?php } ?><?php echo $next->gamedate . ' ' . $next->gametime;?> </td> 
  </tr>
   <?php } ?>     
   <?php } ?>   
</table>

Please help, when I run this search and enter something in the search thats not in the database, it doesnt reply with "Your query returned 0 results" as it should. I tjust stays blank

Here's the section of code in question...

if ($search)   // perform search only if a string was entered. 
   { 
    mysql_connect($host, $user, $pass) or die ("Problem connecting to Database"); 

    $srch="%".$search."%";

    $query = "select * from tvads WHERE advert LIKE '$srch' ORDER BY advert, year DESC, details ASC LIMIT 0,30"; 

    $result = mysql_db_query("cookuk_pn", $query); 

    if  ($result) 
    { 

   $count = 1;   

   print "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"  bordercolor=\"#0000FF\" width=\"900\">";
   print "<tr><td width=\"200\" height=\"30\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Advert / Description</font></b></u></td>";
   print "<td width=\"80\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Year</font></b></u></td>";
   print "<td width=\"200\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Artist</font></b></u></td>";
   print "<td width=\"200\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Track</font></b></u></td>";
   print "<td width=\"80\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Buy Album</font></b></u></td>";
   print "<td width=\"100\" align=\"left\"><u><b><font face=\"arial\" size=\"2\" color=\"#800080\">Download MP3</font></b></u></td></tr>";

        while ($row = mysql_fetch_array($result)) {     // Begin while 


$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['advert']. "</font><br>";

$data .= "<font face=\"arial\" size=\"1\" color=\"#000080\"><i>" .$row['details']. "</i></font></td>";

$data .= "<td width=\"80\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['year']. "</font></td>";

$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['artist']. "</font></td>";

$data .= "<td width=\"200\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['track']. "</font></td>";

$data .= "<td width=\"80\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['asin_ref']. "</font></td>";

$data .= "<td width=\"100\" height=\"30\" align=\"left\"><font face=\"arial\" size=\"1\">" .$row['mp3_ref']. "</font></td></tr>";

$count++;
 
        }                  // end while 
        $data .="</table>"; 
   echo $data;
     } else { echo "problems...."; } 
   } else { echo "Your query returned 0 Results"; } 
?> 

Hey all -

What is the appropriate syntax to echo out each character name (vanity_name), and their total number of "ties" "wins" and "losses"

Thanks for your help!

$q1 = "SELECT Wins, Ties, Losses from game_char WHERE vanity_name='mario'";
$mario_sql = mysql_query($q1);

Code: [Select]
<?php echo "Mario: " . $mario_sql; ?>

hello,  im trying to add a hyperlink that launches in a new window to the following (in the last column)  any ideas?

Code: [Select]
  echo "<tr>";
  echo "<td align='center'>" . $row["ID"] . "</td>";
  echo "<td align='center'>" . $row["Name"] . "</td>";
  echo "<td align='center'>" . $row["jobNO"] . "</td>";
  echo "<td align='center'>" . $epn . "</td>";
  echo "<td align='center'>" . $cname . "</td>";
  echo "<td align='center'>" . $cadd . "</td>";  //want to add a hyperlink here
  echo "</tr>";
  }
echo "</table>";


}

Hi guys,

How do I call the 2nd row of 'TSuperQuestion'?
Code: [Select]
<?PHP 
$con = mysql_connect("localhost","ph6theo", "xxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error("oop"));
  }
mysql_select_db("ph6theo_testDB") or die(mysql_error());
$result = mysql_query("SELECT * FROM QANDATable ");
$row = mysql_fetch_array($result);
echo $row['TSuperQuestion'];
?>

I am getting  the row results from mysql as called, but they appear as a straight line instead of new table row when I echo like:

echo "TABLETABLETABLETABLE";

I am looking for:

echo "TABLE
          TABLE
          TABLE
          TABLE";

Here is my code:
Code: [Select]

$brand = $_POST['brand'];
$city = stripslashes($_POST['city']);
$state = $_POST['state'];
$zip_code = stripslashes($_POST['zip_code']);


if($city !=""){
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE city ='".$city."' AND state ='".$state."' AND brand = '".$brand."'";
}else{
$query = "SELECT name, bus_type, street, city, state, zip_code, brand, quantity, price1, price2, date FROM `prices` WHERE zip_code ='".$zip_code."'";
}
$result = mysql_query($query);
 
     $count=mysql_num_rows($result);
if($count==0 && $zip_code !=""){?>

    <td width="100%" class="style9">Sorry! There are no results for that city, state and brand.</td>
 
<?
}else{
   while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
?>
  <td width="100%" class="style9"><?php 
  echo "<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
  <tr>
     <td{$typ_image}</td>
<td><b><a href=\"\" title=\"{$row['street']} {$row['city']}, {$row['state']}. {$row['zip_code']}\" target=\"_blank\">{$row['name']}</a></b><br>Last Updated:{$row['date']}</td>
    <td><b>{$row['brand']} - {$row['quantity']}</b><br>Before Tax:\${$row['price1']} After Tax:\${$row['price2']}</td>
<td{$pago}</td>
  </tr>
</table><BR>";
  ?></td>
<?php
 }
} 
?></table>   
    <p>&nbsp;</p>
    </td>