How to put information from sql database into html table

10 New Member

Hi, i want to code a .php file that will take information from an sql database based on a search query and then put the retrieved data into an html table that i've created within another file

essentially, i'm trying to 'add students' into a club table...

my current php code posts my collected data

Expand|Select|Wrap|Line Numbers

 
<?php
 
mysql_connect ("localhost", "testuser","")  or die (mysql_error());

mysql_select_db ("studentinformation");
 
$term = $_POST['term'];
 
$sql = mysql_query("select * from testtable where StudentNumber like '%$term%'");

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

    echo 'Student Number: '.$row['StudentNumber'];

    echo '<br/> First Name: '.$row['FirstName'];

    echo '<br/> Last Name: '.$row['LastName'];

    echo '<br/> Grade: '.$row['Grade'];

    echo '<br/><br/>';    

    }
 
?>

based on what my html page passes to it

Expand|Select|Wrap|Line Numbers

 
<html>

<head>

<title>Search the Database</table>

</head>

<body>
 
<form action="search.php" method="post"

Search: <input type="text" name="term" /><br />

<input type="submit" name="submit" value="Submit" />

</body>

</html>

and this is a snippet from the file containing the table i want this info to load into:

Expand|Select|Wrap|Line Numbers

 
<div align="center">

    <table border="1" width="96%">

        <tr>

            <td width="33" bgcolor="#FFFFFF">

            <p align="center"><input type="checkbox" name="C5" value="ON"></td>

            <td width="185" bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Student Number</font></b></td>

            <td width="214" bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Student First Name</font></b></td>

            <td width="251" bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Student Surname</font></b></td>

            <td bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Grade</font></b></td>

            <td bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Number of Points</font></b></td>

            <td bgcolor="#FFFFFF" align="center"><b>

            <font face="Arial" size="4" color="#008000">Date Added</font></b></td>

        </tr>

        <tr>

            <td width="33" align="center">

            <input type="checkbox" name="C1" value="ON"></td>

            <td width="185">&nbsp;</td>

            <td width="214">&nbsp;</td>

            <td width="251">&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

        </tr>

        <tr>

            <td width="33" align="center">

            <input type="checkbox" name="C2" value="ON"></td>

            <td width="185">&nbsp;</td>

            <td width="214">&nbsp;</td>

            <td width="251">&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

        </tr>

        <tr>

            <td width="33" align="center">

            <input type="checkbox" name="C3" value="ON"></td>

            <td width="185">&nbsp;</td>

            <td width="214">&nbsp;</td>

            <td width="251">&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

        </tr>

        <tr>

            <td width="33" align="center">

            <input type="checkbox" name="C4" value="ON"></td>

            <td width="185">&nbsp;</td>

            <td width="214">&nbsp;</td>

            <td width="251">&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

            <td>&nbsp;</td>

        </tr>

    </table>

</div>

So....is it possible to change the $POST function into something that loads the info into the html table and if yes, how so?
Thanks

May 13 '12 #1

Subscribe Reply

✓ answered by Dormilich

that loads the info into the html table

verbatim that’s not possible as PHP can only load the HTML code into itself.

however (on a slightly broader sense) you can load the HTML into PHP and do various kinds of string replacement. e.g.

Expand|Select|Wrap|Line Numbers

 $table = <<<TBL

<table>

  <thead>

    <tr>

      <th>table heading</th>

    </tr>

  </thead>

  <tbody>

{row}

  </tbody>

</table>

TBL;
 
$tblrow = <<<ROW

    <tr>

      <td>%s</td>

    </tr>

ROW;
 
// DB using PDO (http://php.net/pdo)

// ... DB code here ...
 
$tr = "";

foreach ($result as $row)

{

  $tr .= sprintf($tblrow, $row["field"]) . PHP_EOL;

}
 
echo str_replace('{row}', $tblrow, $table);

5762

Dormilich

8,658

Recognized Expert Moderator Expert

that loads the info into the html table

verbatim that’s not possible as PHP can only load the HTML code into itself.

however (on a slightly broader sense) you can load the HTML into PHP and do various kinds of string replacement. e.g.

Expand|Select|Wrap|Line Numbers

 $table = <<<TBL

<table>

  <thead>

    <tr>

      <th>table heading</th>

    </tr>

  </thead>

  <tbody>

{row}

  </tbody>

</table>

TBL;
 
$tblrow = <<<ROW

    <tr>

      <td>%s</td>

    </tr>

ROW;
 
// DB using PDO (http://php.net/pdo)

// ... DB code here ...
 
$tr = "";

foreach ($result as $row)

{

  $tr .= sprintf($tblrow, $row["field"]) . PHP_EOL;

}
 
echo str_replace('{row}', $tblrow, $table);

May 14 '12 #2

chocomon

New Member

thank you for the reply!
but i'm not sure what you're doing in your coding example, could you summarize?
sorry...i'm new to php coding

May 14 '12 #3

Dormilich

8,658

Recognized Expert Moderator Expert

I define 2 templates (one for the table, one for the table row) then I fill the row template with values from the DB and then I fill the filled-in row template into the table template.

May 15 '12 #4

Similar topics

php blob - display in html table

by: adam | last post by:

Hi, I have an issue that i just cant seem to figure out hope some one can help. right i am getting people to input the own images directly into a blob within a mysql database. then on the next...

PHP

Writing Session Variable Information To a Table

by: Michelle A. | last post by:

I have a four page form. Pages 1-3 stores there information in a session variables. Page four is reached (a final review page) and then the information will be written to the SQL server. When...

ASP.NET

dynamic html table with textboxes

by: Michael Meckelein | last post by:

Environment: VS.NET 2003 Application: ASP.NET web application Program language: C# (Csharp) Situation: I get some information from a sql database. With this information I generate a html table...

ASP.NET

how to reach a control in a dynamically extended HTML Table

by: buran | last post by:

Dear ASP.NET Programmers, I have a HTML table (running as server control with the control ID: tblInsertSP). The table has 16 rows with textboxes. Depending on the value of the ddlSPType, which...

ASP.NET

HTML table from ASP.NET

by: Sehboo | last post by:

I have an ASP.NET page which has bunch of stuff. In the middle somewhere (in a table), I want to add rows of records from database. So when user clicks on this button, I want to go read the data...

Visual Basic .NET

How to retain information from a table that is purged and imported daily.

by: afr0ninja | last post by:

Hello! I'm fairly new to access, but I'm starting to get the hang of it. This will be a bit lengthy but hopefully it'll have enough information for some kind soul to help me out. I'm currently...

Microsoft Access / VBA

How to display database table data in a html table.

by: McGowan | last post by:

Hi, I'm trying to display data from a mysql database in a HTML table but for some reason my code isn't working. At the moment I have got it to read and display the headers and the first row of the...

PHP

What do i need to do to post the different page information into a table in database

by: bb nicole | last post by:

Below is my interface for resume which need to post into database... I have did it all in one page and it already can send into database which the table name resume... But my letturer now want me...

PHP

Extract information from HTML table

by: Ulysse | last post by:

Hello, I'm trying to extract the data from HTML table. Here is the part of the HTML source : """ <tr> <td class="tdn" valign="top"> <input name="x44553130" value="y" type="checkbox"></td>...

Python

How to update the access database with the HTML table data

by: susinthaa | last post by:

Hi All, Good Morning! My requirement is as below: I am having a HTML table and the text boxes are embedded as a row of the tabel. And I am having a button at the end of the page. When I...

Javascript

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP