PHP - How Do I Make A Html Table Out Of This Mysql Result?

Hi all,
I'm new to php/myslq and I'm going crazy trying to figure this one out

I'm building a personal calendar and I want to display the data into a HTML table.

Code: [Select]
//query the database
$query = "SELECT * FROM tbl_events WHERE event_day=$day AND event_month=$month AND event_year=$year";
$query = mysql_query($query);

//build the table
echo '<table>';
for ($y = 0; $y < 6; $y++){
   echo '<tr><td>';
        //insert the data here
   echo '</td></tr>';
}
echo '</table>';

When I store the events into the database, I assign a slot for each one depending on the hour. I don't want to use more than 6 events daily, hence the for loop. The problem I have is how to I insert the data into the designed <td>? In a particular day I could have only 2 events: event 1 - slot 2, event 2 - slot 6. I want to be able to enter each event into its own cell

I hope I'm making myself clear enough. Sorry for any English mistakes if any.

Thank you

Hi, I have this script which I would like to use to build an html form from a MySQL table.

The <input text................ writes successfully to file but none of the other form types are written to file when using the elseif command

Also, I would like this script to carry out the file write foreach row in the table

It seems complicated and i am not sure if I am going about it in the right way, but here goes

Code: [Select]
//// Create Forms from MySQL
 
$result = mysql_query("SELECT * FROM forms");
 
while($row = mysql_fetch_assoc($result)){

$field_label = $row['field_label'];
$column_name = $row['column_name'];
$field_type = $row['field_type'];

if ($row['field_type'] = 'Text') {

$stringData = "$field_label<input type=text name=$column_name>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Text Area') {

$stringData = "$field_label<input type=textarea name=$column_name></textarea>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Select Menu') {

$stringData = "$field_label<select name=$column_name></select>\n";
fwrite($fh, $stringData);

} elseif ($row['field_type'] = 'Checkbox') {

$stringData = "$field_label<input type=checkbox name=$column_name></textarea>\n";
fwrite($fh, $stringData);

}

fclose($fh);
As always, any help is much appreciated

So I have a jobs database with the following columns: id, jobtext, jobdate, and id. This is how it looks right now: http://prahan.com/jobs/display.html.php

I have another table called author. In the authorid column in need the results of this query, SELECT name FROM author WHERE id = (SELECT authorid FROM job) , to be displayed for each row.

I also want to be able to customize the header title for each column.

Thanks in advance!

Hi everyone.

I've two MySQL tables (tbl_csv_input & tbl_qn_types).

Table Details:
1.  tbl_csv_input (qid, qname, qn_answer, qn_type) Primary Key = qid; Foreign Key = qn_type ref tbl_qn_types qn_type_id
2.  tbl_qn_types (qn_type_id, qn_type_name, notes) Primary Key = qn_type_id

Sample Data:
tbl_csv_input
1 ;   Ferrari is the fastest car? ;   Yes||No ;   T1
2 ;   Which below features would you like to have in you... ;   Navigator||Airbag||Seat Belt||Camera & Sensors ;   T1
3 ;    Which model would you prefer? ;   CX||MX||SX||LX ;   T2
4 ;   Comments ;      ; T3

tbl_qn_types
T1;    checkbox;    This qn type is used for yes/no
T2;    radio;    Multiple options but only one is correct
T3;    text area;    Users enter input like comments

The whole idea is to have a questionnaire displayed in a HTML table depending upon the question types (T1, T2, T3)
In simple terms: You have a question and below it there are options.
Some questions have check boxes and some have radio buttons and some have text areas.

The problem I'm facing is with the column: qn_answer; and column = qn_type.

I'm unable to make a loop inside a table which is already in a loop.

Please see the attached files (which has the code I've written).

TIA.








[attachment deleted by admin]

I was wondering how does one go about showing results from SELECT query in columns in a html table.

I have a list of products in a table, and would like to show them on the page in 4 columns. I have done many searches on google to try and find the sulution, but the majority of what im finding instead is about displaying a table from phpmyadmin as a table in html.

If its a large operation to do this, I would be very happy if someone could poiint me in the direction of a tutorial maybe.

Here is the code I have so far to display the products, but for some reason, it only show 1 row instead of all the rows from my table.

Code: [Select]
<?php

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "dbname";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM mcproducts");
while($row = mysql_fetch_array($result))
 {
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];

 }

?>
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
  $flagicon = "<img src=\"flags/ireland.jpg\">";
  }
  
  elseif ($flagicon=="UK") {
  $flagicon = "<img src=\"flags/uk.jpg\">";
  }  else
  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol ?> <?php echo $price ?></div>
                </div>
              </div>
             
</body>
</html>


Many thanks,

DB

 

Hello, I have the problem that only one user is displayed in the table

require('connection/db1.php');
// Teilnehmerliste
$query = 'SELECT * FROM convoy_part WHERE user_convoy= :I';
$start = $bdd->prepare($query);
$start->execute(array(':I' => $_GET['id']));

//fetch
$result2 = $start->fetch();
// Zählung der Datensätze
$count = $start->rowCount();

<table class="table">
                                <thead>
                                    <tr>
                                    <th scope="col">User</th>
                                    <th scope="col">Datum</th>
                                    <th scope="col"><a class="btn btn-primary" href="convoy_user.php?id=<?php echo $result['id']; ?>&action=part" role="button">Teilnehmen</a></th>
                                    </tr>
                                </thead>
                            <tbody>
                        <tr>
                            <th scope="row"><?php echo $result2['name']; ?></th>
                            <td><?php echo $result2['date']; ?></td>
                        </tr>
                  </tbody>
                </table>

 

I'm not sure if my problem is with the PHP, MySQL, HTML, or all of the above, but I've used a tutorial from ScriptPlayground (http://scriptplayground.com/tutorials/php/Printing-a-MySQL-table-to-a-dynamic-HTML-table-with-PHP/) to print a table to HTML.

My problem isn't that I couldn't get it to work, as you can see from my site, http://dollapal.com/offerlist.php

I've used the code on my site,  trying to display a list of offers, with links to each, but I actually have two questions:

Is there a way to EXCLUDE columns of the table?  I would rather not show the 'id' or 'points' columns, since they don't offer any worth to the user.  I would also need to hopefully add a dollar sign before the 'pay' quantities if possible.

I would also like use the 'title' field as a hyperlink to the URL listed in the 'URL' field, instead of simply printing the URL. 

Are there any simple ways to do this and not have it look terrible?  I have included a copy of the script that I'm working with so far.

Thank you in advance!

I have the following code that searches my database and displays results in a table:

$fields = array("field1", "field2", "field3")
$cols   = implode (', ', $fields); 

$result= mysql_query 
(" SELECT $cols FROM tablename  WHERE ................... ");

if (!$result) {die('Could not search database: ' . mysql_error());}

if($result)
{   
    
    if(mysql_num_rows($result) == 0)
    {
        return "Sorry. No records found in the database";                       
    }
    else 
    {
        $table = "<table border='1' cellpadding='5' cellspacing='5'>";
        while($arr = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            $table .= "\t\t<tr>\n";
            foreach ($arr as $val_col) 
            {
                $table .= "\t\t\t".'<td>'.$val_col.'</td>'."\n";
            }
            $table .= "\t\t</tr>\n";  
        }
        $table .= "</table>";
        echo $table;
    }
    mysql_free_result($result);       
}

As you can see each of the MySQL table fields specified by $fields is displayed in a new column in the html table.
I want to change this so that e.g. "field3" is displayed in a new row instead.

So, instead of the html table looking like:

| "field1-result1" | "field2-result1" | "field3-result1" |
| "field1-result2" | "field2-result2" | "field3-result2" |
| "field1-result3" | "field2-result3" | "field3-result3" |

I want it to look like:

| "field1-result1" | "field2-result1" | 
| "field3-result1" |                          |
| "field1-result2" | "field2-result2" |
| "field3-result2" |                          |
| "field1-result3" | "field2-result3" |
| "field3-result3" |                          |

I guess this is quite straightforward, but I can't work it out! Pls help!

Thanks.

Hello I have an array with data from `mysql` that I would like to output it in a table using twig.

The image is an example of want i want to achieve but without any luck.

`print_r` of the array data
 

        Array
    (
        [Administrator] => Array
            (
                [0] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-View
                        [PermissionId] => 1
                    )
    
                [1] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-Edit
                        [PermissionId] => 2
                    )
    
                [2] => Array
                    (
                        [RoleName] => Administrator
                        [PermissionName] => Catalog-Delete
                        [PermissionId] => 3
                    )
    
            )
    
        [Moderator] => Array
            (
                [0] => Array
                    (
                        [RoleName] => Moderator
                        [PermissionName] => Catalog-View
                        [PermissionId] => 1
                    )
    
            )
    
    )

The `HTML` code:
 

    <table>
        <tr>
            <thead>
                <th>Controller - Action</th>
                {% for permission in permissions %}
                {% for item in permission %}
                <th>{{item.RoleName}}</th>
                {% endfor %}
                {% endfor %}
            </thead>
        </tr>
        {% for permission in permissions %}
        {% for item in permission %}
        <tr>
            <td>{{item.PermissionName}}</td>
            <td>{{item.PermissionId}}</td>
        </tr>
        {% endfor %}
        {% endfor %}
    </table>

OUTPUT:

    <table>
        <tbody>
            <tr></tr>
        </tbody>
        <thead>
            <tr>
                <th>Controller - Action</th>
                <th>Administrator</th>
                <th>Administrator</th>
                <th>Administrator</th>
                <th>Moderator</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>Catalog-View</td>
                <td>1</td>
            </tr>
            <tr>
                <td>Catalog-Edit</td>
                <td>2</td>
            </tr>
            <tr>
                <td>Catalog-Delete</td>
                <td>3</td>
            </tr>
            <tr>
                <td>Catalog-View</td>
                <td>1</td>
            </tr>
        </tbody>
    </table>

Later Edit
MySQL Query:
 

    SELECT t3.PermissionName, t1.PermissionId, t2.RoleName FROM tbl_user_role_perm AS t1
    INNER JOIN tbl_user_roles AS t2 ON t1.RoleId = t2.RoleId
    INNER JOIN tbl_user_permissions AS t3 ON t1.PermissionId = t3.PermissionId

MySQL Dump:
 

    -- Dumping structure for table tbl_user_permissions
    CREATE TABLE IF NOT EXISTS `tbl_user_permissions` (
      `PermissionId` int(11) NOT NULL AUTO_INCREMENT,
      `PermissionName` varchar(50) NOT NULL,
      `PermissionDescription` varchar(100) NOT NULL,
      PRIMARY KEY (`PermissionId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
    
    -- Dumping data for table tbl_user_permissions: ~2 rows (approximately)
    DELETE FROM `tbl_user_permissions`;
    /*!40000 ALTER TABLE `tbl_user_permissions` DISABLE KEYS */;
    INSERT INTO `tbl_user_permissions` (`PermissionId`, `PermissionName`, `PermissionDescription`) VALUES
        (1, 'Catalog->View', 'View Catalog Method'),
        (2, 'Catalog->Edit', 'Edit Catalog Method'),
        (3, 'Catalog->Delete', 'Delete Catalog Method');
    /*!40000 ALTER TABLE `tbl_user_permissions` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_role
    CREATE TABLE IF NOT EXISTS `tbl_user_role` (
      `UserRoleId` int(10) NOT NULL AUTO_INCREMENT,
      `UserId` int(10) NOT NULL,
      `RoleId` int(10) unsigned NOT NULL,
      PRIMARY KEY (`UserRoleId`),
      KEY `FK_tbl_user_role_tbl_user_roles` (`RoleId`),
      KEY `UserId` (`UserId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
    
    -- Dumping data for table tbl_user_role: ~2 rows (approximately)
    DELETE FROM `tbl_user_role`;
    /*!40000 ALTER TABLE `tbl_user_role` DISABLE KEYS */;
    INSERT INTO `tbl_user_role` (`UserRoleId`, `UserId`, `RoleId`) VALUES
        (1, 13, 22),
        (2, 14, 22);
    /*!40000 ALTER TABLE `tbl_user_role` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_roles
    CREATE TABLE IF NOT EXISTS `tbl_user_roles` (
      `RoleId` int(10) unsigned NOT NULL AUTO_INCREMENT,
      `RoleName` varchar(50) NOT NULL,
      `CreatedDate` datetime NOT NULL,
      `ModifiedDate` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
      PRIMARY KEY (`RoleId`)
    ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
    
    -- Dumping data for table tbl_user_roles: ~7 rows (approximately)
    DELETE FROM `tbl_user_roles`;
    /*!40000 ALTER TABLE `tbl_user_roles` DISABLE KEYS */;
    INSERT INTO `tbl_user_roles` (`RoleId`, `RoleName`, `CreatedDate`, `ModifiedDate`) VALUES
        (22, 'Administrator', '2014-10-28 09:53:08', NULL),
        (23, 'Moderator', '2014-10-28 09:53:13', NULL),
        (24, 'Admin', '2014-10-28 12:22:05', '2014-10-28 12:22:06'),
        (25, 'User', '2014-10-29 15:10:36', '2014-10-29 15:10:37'),
        (26, 'SuperUser', '2014-10-29 15:10:45', '2014-10-29 15:10:46'),
        (27, 'Accountant', '2014-10-29 15:10:53', '2014-10-29 15:10:54'),
        (28, 'God', '2014-10-29 15:11:02', '2014-10-29 15:11:02');
    /*!40000 ALTER TABLE `tbl_user_roles` ENABLE KEYS */;
    
    
    -- Dumping structure for table tbl_user_role_perm
    CREATE TABLE IF NOT EXISTS `tbl_user_role_perm` (
      `RoleId` int(10) unsigned NOT NULL,
      `PermissionId` int(10) unsigned NOT NULL,
      KEY `RoleId` (`RoleId`),
      KEY `PermissionId` (`PermissionId`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    -- Dumping data for table tbl_user_role_perm: ~3 rows (approximately)
    DELETE FROM `tbl_user_role_perm`;
    /*!40000 ALTER TABLE `tbl_user_role_perm` DISABLE KEYS */;
    INSERT INTO `tbl_user_role_perm` (`RoleId`, `PermissionId`) VALUES
        (22, 2),
        (22, 1),
        (23, 1),
        (22, 3);
    /*!40000 ALTER TABLE `tbl_user_role_perm` ENABLE KEYS */;
    /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
    /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Can  you help me to make the coding required so that the correct column have the correct permissions? thank you in advance.

Not really sure how to get the images I have stored in MySQL into a html form. I can call-up the text fields from the database but it cannot seem to find the index for the images.

Here is my code:-

<?php
session_start();
mysql_connect("localhost","root","abc") or die ("Error! Cannot connect to database");
mysql_select_db("theimageworks") or die ("Cannot find database");
$query = "SELECT * FROM jobs";
$result = mysql_query($query) or die (mysql_error());
?>


<?php
//display data in html table
echo "<table>";
echo "<tr><td>Username</td><td align='center'>Message</td><td>Product Image</td></tr>";

while($row = mysql_fetch_array($result)) {
    echo "</td><td>";
    echo $row['username'];
    echo "</td><td>";
    echo $row['message'];
    echo "</td></tr>";   
    echo $row['image'];
     }
echo "</table>";
?>

The error message I get is "Notice: Undefined index: image in....."

Thanks in advance!

Hi, I'm trying to make a dynamic html table to contain the mysql data that is generated via php. I'm trying to display a user's friends in a table of two columns and however many rows, but can't seem to figure out what is needed to make this work.

Here's my code as it stands:
Code: [Select]
<?php
//Begin mysql query
$sql = "SELECT * FROM friends WHERE username = '{$_GET['username']}' AND status = 'Active' ORDER BY friends_with ASC";
$result = mysql_query($sql);
$count = mysql_num_rows($result);

$sql_2 = "SELECT * FROM friends WHERE friends_with = '{$_GET['username']}' AND status = 'Active' ORDER BY username ASC";
$result_2 = mysql_query($sql_2);
$count_2 = mysql_num_rows($result_2);

while ($row = mysql_fetch_array($result)) {
                                                          echo $row["friendswith"] . "<br>";
                                                }
while ($row_2 = mysql_fetch_array($result_2)) {
                                                          echo $row_2["username"] . "<br>";
                                                }
?>

The above simply outputs all records of a user's friends (their usernames) in alphabetical order. The question of how I'd generate a new row each time a certain amount of columns have been met, however, is beyond me. Anyone know of any helpful resources that may solve my problem? Thanks in advance =)

How can I check if a returned mysql value is equal to '' i.e. nothing?

I keep getting an error where the page won't load because the returned value is '' so i need to check for it

Im not sure where to post this but since it includes php il post it here instead of in the mysql forum.

ok so, i have a table and i get the values using while($row = mysql_fetch_array($result)){ and then echo them in rows.

that works fine but i need to add a class to the last row of my table. I would need somehow to fetch the last row of the array and make it echo something different.

Any help is appreciated

Thank you

Hi,

I don't know anything about php and Mysql but I found a tutorial for a shopping cart and everything is working.
The only thing is they don't have the email part in the totorial so I'm kind of stuck with my file.
Anyone know how to email the resul to me via email with this code?

<?
   include("includes/db.php");
   include("includes/functions.php");
   
   if($_REQUEST['command']=='update'){
      $name=$_REQUEST['name'];
      $email=$_REQUEST['email'];
      $address=$_REQUEST['address'];
      $phone=$_REQUEST['phone'];
      
      $result=mysql_query("insert into customers values('','$name','$email','$address','$phone')");
      $customerid=mysql_insert_id();
      $date=date('Y-m-d');
      $result=mysql_query("insert into orders values('','$date','$customerid')");
      $orderid=mysql_insert_id();
      
      $max=count($_SESSION['cart']);
      for($i=0;$i<$max;$i++){
         $pid=$_SESSION['cart'][$i]['productid'];
         $q=$_SESSION['cart'][$i]['qty'];
         $price=get_price($pid);
         mysql_query("insert into order_detail values ($orderid,$pid,$q,$price)");
      }
      die('Thank You! your order has been placed!');
   }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Billing Info</title>
<script language="javascript">
   function validate(){
      var f=document.form1;
      if(f.name.value==''){
         alert('Your name is required');
         f.name.focus();
         return false;
      }
      f.command.value='update';
      f.submit();
   }
</script>
</head>


<body>
<form name="form1" onsubmit="return validate()">
    <input type="hidden" name="command" />
   <div align="center">
        <h1 align="center">Billing information</h1>
        <table border="0" cellpadding="2px">
           <tr><td>Total:</td><td><?=get_order_total()?></td></tr>
            <tr><td>Name :</td><td><input type="text" name="name" /></td></tr>
            <tr><td>Address :</td><td><input type="text" name="address" /></td></tr>
            <tr><td>Email :</td><td><input type="text" name="email" /></td></tr>
            <tr><td>Phone :</td><td><input type="text" name="phone" /></td></tr>
            <tr><td>&nbsp;</td><td><input type="submit" value="Place Order" /></td></tr>
        </table>
   </div>
</form>
</body>
</html>

hello
I'm using this code:
Code: [Select]
$query="SELECT * FROM `second_content` WHERE CHANGED =0 limit 0,1";to query first row data when I want see it and echo it I recived :
Code: [Select]
Resource id #2can anyone help me ?


thank you