efficient way of displaying data

Ph0eniX

I'm struggling with performance issues. Here's the code:

$query = "select * from table order by column desc";    

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) { echo "<tr>
<td bgcolor=black><font color=lightblue size=1 face=verdana>$row[0] </td></font>
<td bgcolor=black><font color=orange face=verdana size=1>  $row[1]  </td></font>
<td bgcolor=black><font color=lightyellow face=verdana size=1>$row[2] </td></font>
<td bgcolor=black><font color=lightgreen face=verdana size=1>$row[3] </td></font>
<td bgcolor=black><font color=lightblue size=1 face=verdana>$row[4] </td></font>
<td bgcolor=black><font color=orange face=verdana size=1>  $row[7]  </td></font>
<td bgcolor=black><font color=lightyellow face=verdana size=1>$row[5] </td></font>
<td bgcolor=black><font color=lightgreen face=verdana size=1>$row[6] </td></font>
<td bgcolor=black><font color=lightblue size=1 face=verdana>$row[7] </td></font>
</font></tr>";
}
mysql_free_result($result);

Is there a more efficient way of displaying data where you'd basically dump the whole select statement as a string and then delimit it with html tags instead of looping?

Thanks.

Elena_Mitovska

I offten use this variant, it is shorter than yours, thought it still demand looping through recordset.

echo "<table border=1>";
while ($row = mysql_fetch_row($sql_result)) {
echo "<tr><td>";
echo implode("</td><td>",$row);
echo "</td></tr>";
}
echo "</table>";

Ph0eniX

Here's the VBS equivalent of what I'm looking for in PHP. As you can see there is no loop. Is it even possible to dump data all at once instead of looping in PHP?

<%
Response.buffer = true
%>
<BODY BGCOLOR=BLACK>
<FONT COLOR=YELLOW SIZE=1 FACE=Verdana>
<STYLE>
	col.lightblue {color:lightblue; font-family: verdana;font-size:10px;}
	col.orange {color: orange;  font-family: verdana;font-size:10px;}
	col.lightyellow {color: lightyellow;  font-family: verdana;font-size:10px;}
</STYLE>
<TABLE>
	<COL class=lightblue></COL>
	<COL class=orange></COL>
	<COL class=lightyellow></COL>
	<TR><TD>
Dim CN
Dim RS
Set CN = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")
CN.Open("DSN=datasource;DATABASE=dbname;UID=user;PWD=password")
dim strGetData
dim a, b, c
	RS.Open("SELECT * from table ORDER BY column DESC"), CN, 0
	a = RS(0)
	b = RS(1)
	c = RS(2)	
	strGetData = RS.getstring(2,,"</td><td>","</td></tr><tr><td>","&nbsp;")
	response.write (strGetData)
	</TD></TR>
</TABLE>
<%
Set RS = Nothing
Set CN = Nothing
response.flush
%>

tomhath

Notice that the VBS defines a couple of CSS classes, that's the big difference, not how the string is put together.

Ph0eniX

Originally posted by tomhath
Notice that the VBS defines a couple of CSS classes, that's the big difference, not how the string is put together.

I just wanted to give people a brief idea of what I'm trying to accomplish. I can define the CSS classes the same way through PHP and it should work just fine in IE. I wasn't asking about that though. Is there a way to dump the whole sql statement at once instead of looping and to use a delimiter of my choice to separate it?

thanks.

tomhath

The RS.getstring is just a function (or method) that loops through each row in the result set and does something with it. I don't think there is a similar function built into php, but you could certainly write one. The loop is still there in every case.

barand

You could write your own "getstring" function based on Elena's code and voila, no more loops.

BTW there is an ODBC function [man]odbc_result_all[/man] which displays a whole query result in a table.

Ph0eniX

Originally posted by barand
You could write your own "getstring" function based on Elena's code and voila, no more loops.

BTW there is an ODBC function [man]odbc_result_all[/man] which displays a whole query result in a table.

That's exactly what I was looking for. Thank you very much.

Ph0eniX

Originally posted by Ph0eniX

That's exactly what I was looking for. Thank you very much.

Actually, that wouldn't work on Solaris with MySQL since it requires DSNs. Right?

barand

It would need DSN's, yes.

As for not working on solaris though, I cannot help. I know you can get odbc for Linux and if you dig around, there may well be installers available.

Does anyone out there know?

Ph0eniX

Originally posted by barand
It would need DSN's, yes.

As for not working on solaris though, I cannot help. I know you can get odbc for Linux and if you dig around, there may well be installers available.

Does anyone out there know?

I'll see if I can get ODBC for Solaris. Thanks for the info.