PHP - Outputting Data In A Table

I'm outputting my DB to a table. I want to include a JOIN so the table shows name, email, and company (which is in a different table). Not sure where to put the join.
2 other things I'd like to do:
Not all users have email and I want any NULL to output as N/A instead of NULL.
Would like the rows to alternate background color between white and blue for each row.
Any hints appreciated.



$query= "select * from Managers";
$result=mysql_query($query);
echo mysql_error();

echo '<table align="center" cellspacing="1" cellpadding="2">
<tr>
<td align="left"><b>Name</b></td>
<td align="left"><b>Email</b></td>
<td align="left"><b>Company</b></td>
</tr>
';
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo '<tr bgcolor="' . $bg . '">
<td align="left">' . $row['name'] . '</td>
<td align="left">' . $row['email'] . '</td>
<td align="left">' . $row['company.name'] . '</td> //Need JOIN here
</tr>
';
}

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

 

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

I can add and delete data from my table. Now I need to be able to change one or more fields in an entry. So I want to retrieve a row from the db, display that data on a form where the user can change any field and then pass the changed data to an update.php program.

I know how to go from form to php. But how do I pass the data from retrieve.php to a form so it will display? Do I use a URL and Get? Can I put the retrieve and form in the same program?

Hey everyone.

I am creating a website so my family can select from the list of present my daugther has asked for.  I have them logging in, and that works.  I have the table data set and the search and table display works.  But I would like to display the list (as in the code below) but with a checkbox in the first column (add a column).  From that the authenticated user can click on the item they have purchased and that selection will be moved to another table (called purchased).  I have that code.  The only thing I cannot figure out is to present the data in list form with a checkbox (like you would see on an order form).

Here is the display code (there is no error checking at this point):


<head><LINK REL="SHORTCUT ICON" HREF="cmwschl.ico"></head>

<body bgcolor="#C0C0C0">

<font face="Arial" color="#000080">Books from the Selected Series</font> </h1>
<hr font color="Navy" font size="3">
<center>

<table border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td width="170" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Number</center></font></b></center></td>
<td width="140" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Group</center></font></b></center></td>
<td width="100" bgcolor="#FFCC66"><center><b><font color="navy" size="2" face="Trebuchet MS"><b><center>Book Title</center></font></b></center></td>
</tr>

<?php
$con = mysql_connect("localhost","twilson","R00tb33r!") or die('Connection: ' . mysql_error());;
mysql_select_db("CMWWeb", $con) or die('Database: ' . mysql_error());
?>
<?
$group = $_POST['bookgrp'];

//if ($Prod <> 0) {
$sql = "SELECT * FROM `OpenBooks` WHERE `bookgrp`= '$group'";
$results = mysql_query($sql);
if ($results) { //this will check if the query failed or not
 if (mysql_num_rows($results) > 0) {  //this will check if results were returned
    while($copy = mysql_fetch_array($results)) {
       $variable1=$copy['booknum'];
$variable2=$copy['bookgrp'];
$variable3=$copy['booktitle'];
//table layout for results

print ("<tr>");
print ("<td><center>$variable1</center></td>");
print ("<td><center>$variable2</center></td>");
print ("<td><left>$variable3</left></td>");
print ("</tr>");    }
  } else {
    echo "No results returned";
  }
} else {
  echo "Query error: ".mysql_error();
}
mysql_close($con);
?>
</table>    
</center>

hello friends 

I'm dealing with this problem for two days. I put here the screenshot for easier understanding.Sorry about my bad english.

Here is the ss

http://i61.tinypic.com/2rz5q55.jpg

I don't want to inner join or table join. All image links  which same sku should displayed in single row where products.resimler colon
I can join the tables but i want to one table.Because i can import single csv file for e-commerce script.How can I use a update query for list multiple images in table products.
Edited by nogai, 10 October 2014 - 07:01 AM.

the second database found on the cloud

 

i try to get JSON data but how to insert and update  them to another online database with the same table

my php script to return json data 

<?php        

 include_once('db.php');

        $users = array();

        $users_data = $db -> prepare('SELECT id, username FROM  users');

        $users_data -> execute();

        while($fetched = $users_data->fetch()) {

            $users[$fetchedt['id']] = array (

                'id' => $fetched['id'],

                'username' => $fetched['name']

            );

        }

        echo json_encode($leaders);

 

 

 

 

i get

 

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

 

Edited March 24 by mahenda

Hi all

I am describing my problem below can any body please look into this

I have two databases
DB1:datain1
DB2:datain2
having the below structure

database,            table,                         fields
    datain1 ,             student   ,                    id,name
    datain2 ,             student   ,                    id,name


the two databases having same structure

My query is

i want copy all data from datain1 to datain2 on daily process through php script(script will be executed manually on daily)

i don't want any duplicate or repeated data in datain2

give me some script to do this

kindly help me to solve this its so urgent

First I need to create a table or add to an existing table - the table needs to contain a date -msg last sent date

Then run the following email script for each record if the value of the msg last sent date is greater than >30 days???
after the script is run, it updates the records it emailed to todays date...

<?php
include "vsadmin/db_conn_open.php";
$allprods=mysql_query("select pID, pName, pPrice, pDropship, dsID, dsName, dsEmail from products, dropshipper where pDropship = dsID");
while ($yarr=mysql_fetch_assoc($allprods)){
$aname=$yarr["pID"];
$bname=$yarr["pName"];
$cname=$yarr["dsName"];
$dname=$yarr["dsEmail"];
$ename=$yarr["pPrice"];

 $to = $dname;
 $subject = ("Your Ebook: " . $bname);
 $body = ("Hello " . $cname .",\n\nYou have the following ebook listed for sale on www.insertwebsite.com (". $bname .").
 \nYour Ebook (product) is currently listed at the retail price of $" . $ename .
 "\n\nThe following link is provided to you as a marketing tool for your current or future email campaigns.  This link is a direct link to your ebook on the Enlightened Ebooks site.
 \n www.www.insertwebsite.com/proddetail.php?prod=". $aname .
 "\n\nOnline sales is a safe secure way to increase your ebook sales.  Simply provide the link in all your correspondences and you sales will increase.  You are your own best promoter.");
 $headers = "From: neil@me.com\r\n" .
  "X-Mailer: php";
 if (mail($to, $subject, $body, $headers)) {
   echo("<p><b>Message sent to.</b></P>". $cname . "  for the following ebook  " . $bname );
  } else {
   echo("<p>Message delivery failed...</p>");
  }}
 ?>

What I'm wanting to do is instead of March-July have it always display the last 5 months and for the Visits th have it display the number of hits to my main page for each month and display the number of logins for each month to my CMS script. Can someone point me in the right direction?


Code: [Select]
<?php
function get_visit_data_table()
{
echo "<table class=\"visualize_dashboard\">";
echo "<caption>Dashboard Chart Example</caption>";
echo "<thead>";
echo "<tr>";
echo "<td></td>";
echo "<th scope=\"col\">March</th>";
echo "<th scope=\"col\">April</th>";
echo "<th scope=\"col\">May</th>";
echo "<th scope=\"col\">June</th>";
echo "<th scope=\"col\">July</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>";
echo "<tr>";
echo "<th scope=\"row\">Visits</th>";
echo "<td>175</td>";
echo "<td>145</td>";
echo "<td>212</td>";
echo "<td>175</td>";
echo "<td>182</td>";
echo "</tr>";
echo "<tr>";
echo "<th scope=\"row\">Logins</th>";
echo "<td>94</td>";
echo "<td>53</td>";
echo "<td>124</td>";
echo "<td>92</td>";
echo "<td>105</td>";
echo "</tr>";
echo "</tbody>";
echo "</table>";
    }       
?>

Hi

This may seem pretty standard to some of you but I am having a problem with tables.

What I am trying to do is give the user 4 fields to choose from and depending upon which field they enter data into the php will query the mysql database and return all of the data related to that value and place it into a table. Seems fair enough however there could be multiple entries of that value and I want there to maybe be a loop that will check for the information and then when it is done complete the table.

My code looks something like this:


<html>
<?php # Script 14.2 - course_form.php
// This page allows the administrator to add a course (product).

$con = mysql_connect("localhost","root","millennium");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }



if (isset($_POST['submitted'])) { // Check if the form has been submitted.
   
// Validate the print_name, image, artist (existing or first_name, last_name, middle_name), size, price, and description.

   // Check for a course id.
   if (!empty($_POST['IpAddress'])) {
      $ip = ($_POST['IpAddress']);
   } else {
      $ip = FALSE;
         }
   
   // Check for a course id.
   if (!empty($_POST['Identifier'])) {
      $id = ($_POST['Identifier']);
   } else {
      $id = FALSE;
         }
   
   // Check for a course id.
   if (!empty($_POST['Destination'])) {
      $de = ($_POST['Destination']);
   } else {
      $de = FALSE;
         }
         
         // Check for a course id.
   if (!empty($_POST['Reply'])) {
      $re = ($_POST['Reply']);
   } else {
      $re = FALSE;
         }
   
   


// Add the course to the database.
mysql_select_db("accs", $con);

      $result = mysql_query("SELECT * FROM smsaudit WHERE smsreply='$re' || smsorigip='$ip' || smsidentifier='$id' || smsdest='$de'");
      $tdcount = 1;
      $numtd = 4; // number of cells per row
      
      echo "<table border='1'>";
      while($row = mysql_fetch_array($result))
  {
  if ($tdcount == 1) echo "<tr>";
 echo "<td>IP Address: $ip </td>"; // display as you like
 echo "<td>Identifier: $id </td>";
 echo "<td>Destination: $de </td>";
 echo "<td>Reply: $re </td>";
 if ($tdcount == $numtd) {
 echo "</tr>";
 $tdcount = 1;
 } else {
 $tdcount++;
 }
// time to close up our table
if ($tdcount!= 1) {
 while ($tdcount <= $numtd) {
 echo "<td>&nbsp;</td>";
 $tdcount++;
 }
 echo "</tr>";
}
echo "</table>";
}
echo "<br />";

$result2 = mysql_query("SELECT totalsms FROM smsaudit ORDER BY totalsms DESC LIMIT 1");

while($row = mysql_fetch_array($result2))
{
echo 'You have used   ' . $row['totalsms'] .'   sms messages';
}
   
 } else { // Display the form.
   ?>
   
   
<form action="form1.php" method="post">
               <input type="hidden" name="MAX_FILE_SIZE" value="524288">
                    <p>&nbsp;</p>
                <table width="449" border="0">
                   
                        <td><h1>SMS Information</h1></td>
                          <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                      </tr>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                      </tr>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td width="160"><strong>IP Address</strong></td>
                        <td width="95">&nbsp;</td>
                        <td width="167"><strong>Identifier</strong></td>
                      </tr>
                      <tr>
                        <td><input name="IpAddress" type="text" id="IpAddress" /></td>
                        <td>&nbsp;</td>
                        <td><input name="Identifier" type="text" id="Identifier" /></td>
                        <td width="9">&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td><strong>Destination</strong></td>
                        <td>&nbsp;</td>
                        <td><strong>Reply</strong></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td><input name="Destination" type="text" id="Destination" /></td>
                        <td>&nbsp;</td>
                        <td><input name="Reply" type="text" id="Reply" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td><input type="submit" name="Submit" id="Submit" value="Submit" /></td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                      </tr>
            </table>
    <input type="hidden" name="submitted" value="TRUE" />
              </form>
              <?php
} // End of main conditional.
?>   
             
              </html>

Can anyone please let me know of a way to achieve this?

Thanks

Hi,   A little new to php programming... I have a question: I have written this code:

<html>
<head>
<title>Test</title>
</head>
<FONT FACE="Verdana, sans-serif">
<H3>Movies</h3>
<?php

include 'config.php';
include 'opendb.php';

$result = mysql_query("SELECT * FROM DayMovie ORDER BY FileDate") 
or die(mysql_error());  

echo "<table border='1'>";
echo "<tr> <th>Filename</th><th>Path</th><th>Date</th><th>Filetype</th> <th>Size</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
	// Print out the contents of each row into a table
	echo "<tr><td>"; 
	echo $row['FileName'];
	echo "</td><td>";
	echo $row['FilePath'];
	echo "</td><td>"; 
	echo $row['FileDate'];
	echo "</td><td>";
	echo $row['FileType'];
	echo "</td><td>";
	echo $row['FileSize'];
	echo "</td></tr>";        
} 

echo "</table>";

include 'closedb.php';

?>

I would like to have a link to these files on all the rows to open the files. How can I do that? I would also like that the link from the mysql row is not shown in the table. Only a text with the text "link"  or "view".  

I have mysql table with Type, Month, Date, and Quantity. I am doing query, and writing to xml which will pass to chart. My error is coming because for each <row> I need to have same number of child tags. For instance, if there are six months represented in first row (<header>), I need to have six <number> tags in all the following rows, even when there may not be any Quantity for that particular month in mysql table. Right now, if a particular Type in my table doesn't show quantity for some months, than I end up with fewer <number> tags. My php is here, and xml structure below:

Code: [Select]
//start the XML output
print "<chart>";
print "<chart_data>";

//output the first row that contains the years
print "<row>";
print "<null></null>";
$category = mysql_query ("SELECT prMonth FROM table1 GROUP BY prMonth ORDER BY prDate");
for ( $column=0; $column < mysql_num_rows($category); $column++ ) {
print "<header>".mysql_result ( $category, $column, "prMonth")."</header>";
}
print "</row>";


//output row 2 to 4. Each row contains a type name and its data (Qty, Prem, Comm ...)
$series = mysql_query ("SELECT prType FROM table1 GROUP BY prType ORDER BY prType");
for ( $row=0; $row < mysql_num_rows($series); $row++ ) {
print "<row>";
$type = mysql_result ( $series, $row, "prType");
print "<string>$type</string>";

$data = mysql_query ("SELECT SUM(prQty) FROM table1 WHERE prType='$type' GROUP BY prMonth ORDER BY prDate");
for ( $column=0; $column < mysql_num_rows($data); $column++ ) {
// Need to do something here to
// get number tags to show zero
// when there's no data for that
// month
print "<number>".mysql_result($data,$column)."</number>";
}
print "</row>";
}


//finish the XML output
print "</chart_data>";
print "</chart>";

XML structu

Code: [Select]
<chart>
<chart_data>
<row> ----this row will be the head row----
</null>
<header>Month name</header>
<header>Month name</header>
...
</row>
<row> ----this row will start body rows----
<string>Type name</string>
<number>total quantity for month, for this type</number>
<number>total quantity for month, for this type</number>
...
</row>
...
</chart_data>
</chart>

Hello,

I'm trying to echo an additional variable using this:

$numincorrect = '<div id="incorrectnum">Sorry, that number was not correct.</div>';

I want to incorperate:

$code from require('send.php');

I've tried

$numincorrect = '<div id="incorrectnum">Sorry, that number was not "$code".</div>';

However, it literally displays $code on output.

Many thanks

I have a field in my table that gets populated with a custom value from a subscription form, but when the data gets inserted into the table, it adds some text I do not want to output. The field is for the user's name, but when the form saves it, it saves the name, plus the text #2# (this is from a Wordpress plugin and I can't figure out how to remove the #2# when I insert the value there either). Is there a way to remove this #2# text when I display the field's value in MySQL and PHP?

Hi all!

I've been recently messing with PHP and MySQL to attempt to create a search function for my tables (too advanced, so I toned it down to learning to just display data from my table).  Anyways, I'm watching a YouTube video on how to do it, and I'm copying his code exactly, but I'm still getting an error.   Can anyone help?  Thanks.    Edit: Sorry, my error was snuggled down below the code.  Anyways, my error is just my while echo appearing in and out of my tables on the page.   My code:

<?php

//Make connection
mysql_connect('localhost', 'root', 'test');

// select db
mysql_select_db('testdatabase');

$sql="SELECT * FROM employees";

$records=mysql_query($sql);



?>



<html>
<head>
<title>Employee Data</title>
</head>

<body>
<table width="600" border="1" cellpadding="1" cellspacing="1">
<tr>

<th>ID</th>
<th>First name</th>
<th>Surname</th>
<th>Age</th>
</tr>

<?php

while($employees=mysql_fetch_assoc($records)){
	echo "<tr>";
	echo "<td>".$Employee['ID']."</td>";
	echo "<td>".$Employee['First name']."</td>";
	echo "<td>".$Employee['Surname']."</td>";
	echo "<td>".$Employee['Age']."</td>";
	echo "</tr>";
}
// end while
?>
</table>
</body>
</html>

Edited by thwikehu1990, 19 January 2015 - 01:33 PM.