Solved

How to format/style SQL results page returned by PHP

Posted on 2011-09-13
7
192 Views
Last Modified: 2012-05-12
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
Comment
Question by:Ed_CLP
  • 4
  • 3
7 Comments
 
LVL 16

Expert Comment

by:carsRST
ID: 36529281
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
 
LVL 16

Expert Comment

by:carsRST
ID: 36529297
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
 

Author Comment

by:Ed_CLP
ID: 36529822
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 16

Expert Comment

by:carsRST
ID: 36530269
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
 

Accepted Solution

by:
Ed_CLP earned 0 total points
ID: 36550898
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
 

Author Closing Comment

by:Ed_CLP
ID: 36591853
I answered my own question.
0
 

Author Comment

by:Ed_CLP
ID: 36563828
question no longer active
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
In this tutorial viewers will learn how to style different bullet points for unordered lists in CSS. Begin with a normal unordered list; the default bullet point is a solid circle: In the CSS, create a defined class of unordered list by typing "ul.S…
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now