Hi
I can successfully, output contents from two mysql tables into excel but I was wondering if there was a way of determining the actual layout - column sizes because at present they are all over tha place?
This is my code>
<?php
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
session_start();
set_time_limit(0);
$admin[xxx] = 'xxx';
function auth_request(){
header("WWW-Authenticate: Basic realm=\"Ticket Check\"");
header("HTTP/1.0 401 Unauthorized");
echo "<center><h1>You need to login to see this page</h1></center>";
exit;
}
if((!empty($_SERVER['PHP_AUTH_USER'])) && (!empty($_SERVER['PHP_AUTH_PW']))){
if($admin[$_SERVER['PHP_AUTH_USER']] != $_SERVER['PHP_AUTH_PW']){
auth_request();
}
}else{
auth_request();
}
?>
</head>
<style type="text/css">
<!--
.style1 {font-family: "Tw Cen MT", "Tw Cen MT Condensed", "Tw Cen MT Condensed Extra Bold"}
-->
</style>
<body>
<table width="821" height="30" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#FFFFFF">
</tr>
</table>
<table width="647" height="425" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<th width="20" bgcolor="#FFFFFF" scope="col"> </th>
<th width="627" height="425" align="left" valign="top" bgcolor="#FFFFFF" scope="col"><table width="627" height="58" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><span class="style56"><span class="style45 style1">xxx Ticket Check </span></span></td>
<th class="Text" scope="col"> </th>
<th class="Text" scope="col"> </th>
<th class="Text" scope="col"> </th>
</tr>
<tr>
<th width="509" height="38" valign="top" class="Texttop" scope="col"><p><br>
<span class="style15 style1">Holiday Inn </span></p> </th>
<th width="95" align="left" valign="top" class="Texttop" scope="col"> </th>
<th width="11" align="left" valign="middle" class="Texttop" scope="col"> </th>
<th width="12" class="Texttop" scope="col"> </th>
</tr>
</table>
<span class="story style3 style2"> </span>
<br>
<p><span class="style15 style1">Customer Information </span></p>
<p>
<?php
$conn = @mysql_connect( "xxx", "xxx", "xxx" )
or die( "Could not connect" );
$rs = @mysql_select_db( "xxx", $conn )
or die( "Could not select database" );
$sql = "SELECT * FROM xxx WHERE hotel = 'holiday inn' ORDER BY tickets2_info.ticket_id DESC";
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );
$list = "<table border=\"0\" cellpadding=\"4\">";
$list .= "<th class=\"datafield\" align=left>User ID</th>";
$list .= "<th class=\"datafield\" align=left>Name</th>";
$list .= "<th class=\"datafield\" align=left>Staff</th>";
$list .= "<th class=\"datafield\" align=left>Room No</th>";
$list .= "<th class=\"datafield\" align=left>Email</th>";
$list .= "<th class=\"datafield\" align=left>Telephone</th>";
$list .= "<th class=\"datafield\" align=left>Days</th></tr><tr><td colspan=7 bgcolor=Black height=2></td></tr>";
while( $row = mysql_fetch_array( $rs ) )
{
$list .= "<tr>";
$list .= "<td class=\"datafield\">".$row["ticket_id"]."</td>";
$list .= "<td class=\"datafield\">".$row["name"]."</td>";
$list .= "<td class=\"datafield\">".$row["staff"]."</td>";
$list .= "<td class=\"datafield\">".$row["room"]."</td>";
$list .= "<td class=\"datafield\">".$row["email"]."</td>";
$list .= "<td class=\"datafield\">".$row["tel"]."</td>";
$list .= "<td class=\"datafield\">".$row["required"]."</td>";
$list .= "</tr>";
}
$list .= "</table>";
echo( $list );
?>
<br>
<br>
<br>
<p class="style138"><span class="style15 style1">Tickets Issued </span></p>
<span class="style138">
<?php
$conn = @mysql_connect( "xxx", "xxx", "xxx" )
or die( "Could not connect" );
$rs = @mysql_select_db( "xxx", $conn )
or die( "Could not select database" );
$sql = "select * from xxx where used = 'Y' and hotel = 'holiday inn' ORDER BY tickets2.user_id DESC";
$rs = mysql_query( $sql, $conn )
or die( "Could not execute query" );
$list = "<table border=\"0\" cellpadding=\"4\">";
$list .= "<th class=\"datafield\" align=left>Ticket ID</th>";
$list .= "<th class=\"datafield\" align=left>User ID</th>";
$list .= "<th class=\"datafield\" align=left>Used</th>";
$list .= "<th class=\"datafield\" align=left>Username</th>";
$list .= "<th class=\"datafield\" align=left>Password</th>";
$list .= "<th class=\"datafield\" align=left>Registered</th>";
$list .= "<th class=\"datafield\" align=left>Expires</th>";
$list .= "<th class=\"datafield\" align=left>Reminder Sent</th></tr><tr><td colspan=8 bgcolor=Black height=2></td></tr>";
while( $row = mysql_fetch_array( $rs ) )
{
$list .= "<tr>";
$list .= "<td class=\"datafield\">".$row["id"]."</td>";
$list .= "<td class=\"datafield\">".$row["user_id"]."</td>";
$list .= "<td class=\"datafield\">".$row["used"]."</td>";
$list .= "<td class=\"datafield\">".$row["username"]."</td>";
$list .= "<td class=\"datafield\">".$row["password"]."</td>";
$list .= "<td class=\"datafield\">".$row["registered"]."</td>";
$list .= "<td class=\"datafield\">".$row["expires"]."</td>";
$list .= "<td class=\"datafield\">".$row["reminder_sent"]."</td>";
$list .= "</tr>";
}
$list .= "</table>";
echo( $list );
?>
</span> </th>
</tr>
</table>
</body>
</html>
