Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

How to format/style SQL results page returned by PHP

I have an HTML form which submits a POST statement containing a SQL query to a PHP server.
The results are returned as a generic HTML table (see example).  Is it possible to add some CSS/AJAX to the results without having to modify the server-side pages?  I would like to add some additional formatting to the results.

//  source for page returned by PHP server

<html>
<head>
      <title></title>
</head>
<body>
<table>
  <tr>
          <td>Column1 Header</td>
          <td>Column1 Header</td>
          <td>Column1 Header</td>
          <td>Column1 Header</td>
  </tr>
  <tr>
          <td>840</td>
          <td>2010-09-13</td>
          <td>2011-09-09</td>
          <td>-234262.900</td>
  </tr>
</table>
</body>
</html>
0
Ed_CLP
Asked:
Ed_CLP
  • 4
  • 3
1 Solution
 
carsRSTCommented:
You will not need to modify anything on the server.  Just add CSS particular to the table.

Link below walks you through that process.

http://www.w3schools.com/css/css_table.asp
0
 
carsRSTCommented:
BTW - you can use the example below to put your CSS directly in to your page.  The other alternative is to put your CSS in its own file and reference.


<STYLE TYPE="text/css">
   ...css text...
</STYLE>



If you want to reference a file....

<link rel="stylesheet" type="text/css" href="myCSSFile.css" media="screen" />
0
 
Ed_CLPAuthor Commented:
I tried adding the <style...  tags in the <head> section of my HTML page, but the PHP results are returned as a separate page.  Would I have to embed the results in my original page?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
carsRSTCommented:
I see what you're saying.  Your best option may be to use inline styles.  So that the table generated from your AJAX will have the styling embedded in it.  that way it is sure to be rendered.

Example:

<td style="background:#ccc; color:#fff;">Column1 Header</td>

Further explanation of inline styles:
http://webdesign.about.com/od/beginningcss/qt/tipcssinlinesty.htm
0
 
Ed_CLPAuthor Commented:
Perhaps I didn't describe the question correctly.  I am trying to retrieve results of a SQL query from an external server.  My understanding is that the external server needs to present the results as XML or JSON in order for me to be able to apply formatting to the results.  is this correct?
0
 
Ed_CLPAuthor Commented:
I answered my own question.
0
 
Ed_CLPAuthor Commented:
question no longer active
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now