Do no understand Database Output

Anon

I am new to PHP. I make connection to MS Access and receive data from database. All records output above my html code. The place in my html code does not have any output where I intended it. I am following the book but don't know where I am going wrong.
I am coming from a Cold Fusion background.

here is page code:

<?php

$resultid = odbc_connect ( "HMOInfo", "", "" );
if ( $resultid )
{
$id = odbc_exec ( $resultid, "SELECT Eventid,EventDate,EventTitle FROM tblEvents;" );
odbc_result_all ( $id );
odbc_free_result ( $id );
}
odbc_close ( $resultid );

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<head>
<title>Test Events</title>
</head>

<body>
<table width="90%" bgcolor="COCOCO">
<tr>
<td width="50%"><font face="arial" size=-1><b>Date</b></font></td>
<td width="50%"><font face="arial" size=-1><b>Title</b></font></td>
</tr>
</table>

<table width="90%" >
<tr>
<td width="50%"><font face="arial" size=-1> <b><?php echo "$EventTitle";?></b></font></td>
<td width="50%"><a href="Event_Output.php?eventid=<?php echo "$eventid";?>><font face="arial" size=-1><b><?php echo "$EventDate";?></b></font></a></td>
</tr>
</table>

</body>

Anon

What book are you referring to as "the" book?

Anyway, the problem here is simple: odbc_result_all() actually writes the html table when it's called. So just move your code to do that the place where you have the "output here" comment, and remove all the explicit displaying of results into individual cells. That is what odbc_result_all() is for, after all.

Anon

Thank you for your response. I don't understand what I am missing here in concept. I've called the database with a query- ask script to output(echo) on the page.

I removed the odbc_result_all() and it quits displaying results but, does not display any results below on the page where I have the echo statement. All I get is the HTML Title bar.

Any help greatly appreciated.

terry

kparker

OK, let me try again. If you follow your code from top to bottom, this is what it does, in sequence:

Make the odbc query.
Call odbc_result_all, which reads the entire result sets and sends the data to the output _already formatted as an html table.
Send out your own html header stuff
Create another table (starting where you say <!-----Output here--------------&gt😉
Write some cells that contain reference to non-existing variables such as
$EventTitle, $eventid, and $EventDate.

Instead, you need to get rid of all the table stuff, and move the code to do the query and output the results to the place where you say 'output here':

In other words:

...
<td>Date</td>
</tr>
</table>
<?php

if ($resultid = odbc_connect ( "HMOInfo", "", "" ))
   {
   $id = odbc_exec ( $resultid,
   "SELECT Eventid, EventDate, EventTitle FROM tblEvents;" );
   odbc_result_all ( $id );
   }
?>
</body>

Anon

I greatly appreciate and thank you for your help.

Your code works except I do want to connect this list page to a detail page using the event id. It seems I have no HTML control over how the data appears, ie in table cells with a certain font. I know I am missing something here.

With Cold Fusion
1. you create your database query, usually above the header on the page.
2.you place an open and close output tag around your tables and the fields are placed inside the open and close tages in the table cells where you want them your HTML with only #fieldname# tags

Example:
<cfoutput>
<Table>
<tr><td>#eventdate#</td><td>#eventtitle#</td>
</tr>
</table>
</cfoutput>

You must be able to do this in PHP, I just am stuck.

Many thanks,

Terry