trying to display database

ckdoublenecks · July 24, 2010

I'm using Xampp, have created and populated a database "addtransdb" with a table "addtransinfo" and am trying to use the below program to display the table. It displayed when I created the table (generated by: phpmyadmin 3.2.4 / MYSQL 5.1.41 - SQL quert: SELECT * FROM 'addtransinfo' LIMIT 0,30 ; ) so I guess the problem is here in my program? I don't get an error, I just get nothing. I am running win2000 prof

<?
$username="me";
$password="mine";
$database="addtransdb";
mysql_connect("localhost", "root", "");
@mysql_select_db($database) or die( "Unable to select database");
$query=" SELECT * FROM 'addtransinfo';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
<html><HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"><!-- this program is designed to show the database contents in a table
<META content="MSHTML 6.00.2800.1649" name=GENERATOR>
<META content="MSHTML 6.00.2800.1649" name=GENERATOR></HEAD>
<BODY><B><FONT size=+2>Project: Hammock Oaks In-house transfers & Add-ons</FONT> 
<FORM>
<TABLE cellSpacing=0 cellPadding=0 border=1>
<TBODY>
<TR>
<TH>Appl</TH>
<TH>.</TH>
<TH>.</TH>
<TH>.</TH>
<TH>Race &</TH>
<TH>Ethnic-</TH>
<TH>.</TH>
<TH>Displ.</TH>
<TH>Income</TH>
<TH>B/r s </TH>
<TH>Movein</TH>
<TH>Removal</TH>
<TH>.</TH>
<TH>.</TH>
<TR>
<TH>#</TH>
<TH>Date</TH>
<TH>Time</TH>
<TH>Name</TH>
<TH>Gender</TH>
<TH>City</TH>
<TH>LH %</TH>
<TH>Y/N</TH>
<TH>Level</TH>
<TH>Needed</TH>
<TH colSpan=2>Date</TH>
<TH>Code</TH>
<TH>Comments</TH></TR></TBODY></TABLE><?
$i=0;
while ($i < $num) {
if ($num==0) {
echo "the database contains no contacts yet";
} else {

$appl=mysql_result($result,$i,"appl");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$name=mysql_result($result,$i,"name");
$racegend=mysql_result($result,$i,"racegend");
$ethnicity=mysql_result($result,$i,"ethnicity");
$laborhsg=mysql_result($result,$i,"laborhsg");
$displ=mysql_result($result,$i,"displ");
$incomelevel=mysql_result($result,$i,"incomelevel" );
$brneeded=mysql_result($result,$i,"brneeded");
$moveindate=mysql_result($result,$i,"moveindate");
$removaldate=mysql_result($result,$i,"removaldate" );
$code=mysql_result($result,$i,"code");
$comments=mysql_result($result,$i,"comments");
?><?
<tr><TD><? echo $appl; ?></TD><TD><? echo $date; ?></TD><TD><? echo $time; ?></TD><TD><? echo $name; ?></TD><TD><? echo $racegend; ?></TD><TD><? echo $ethnicity; ?></TD><TD><? echo $laborhsg; ?></TD><TD><? echo $displ; ?></TD><TD><? echo $incomelevel; ?></TD><TD><? echo $brneeded; ?></TD><TD><? echo $moveindate; ?></TD><TD><? echo $removaldate; ?></TD><TD><? echo $code; ?></TD><TD><? echo $comments; ?></TD></TR><?
$i++;
}
echo "</table>";
$i++;
}
?></B></FORM>
<P></P></BODY></HTML>

Philip · July 25, 2010

Few things:

-

tags

- @mysql_select_db($database) or die( "Unable to select database"); - take out the @

- turn on error reporting in PHP.

ckdoublenecks · July 25, 2010

My PHP error reporting is turned on and I get an error on line 76 pointing to the "<" which starts the PHP table? I have another program , almost identical, without HTML , that works?

<?php
$username="root";
$password="";
$database="addtransdb";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM addtransinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
    <HTML><HEAD>
<META http<BODY><B><FONT size=+2>Project: Hammock Oaks In-house transfers & Add-ons</FONT> 
<FORM>
<TABLE cellSpacing=0 cellPadding=0 border=1>
  <TBODY>
  <TR>
    <TH>Appl</TH>
    <TH>.</TH>
    <TH>.</TH>
    <TH>.</TH>
    <TH>Race &</TH>
    <TH>Ethnic-</TH>
    <TH>.</TH>
    <TH>Displ.</TH>
    <TH>Income</TH>
    <TH>B/r s </TH>
    <TH>Movein</TH>
    <TH>Removal</TH>
    <TH>.</TH>
    <TH>.</TH>
    </tr><tr>
    <TH>#</TH>
    <TH>Date</TH>
    <TH>Time</TH>
    <TH>Name</TH>
    <TH>Gender</TH>
    <TH>City</TH>
    <TH>LH %</TH>
    <TH>Y/N</TH>
    <TH>Level</TH>
    <TH>Needed</TH>
    <TH colSpan=2>Date</TH>
    <TH>Code</TH>
    <TH>Comments</TH></TR>
    </TBODY></TABLE>
<?
$i=0;
while ($i < $num) {
if ($num==0) {
echo "the database contains no contacts yet";
} else {

$appl=mysql_result($result,$i,"appl");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$name=mysql_result($result,$i,"name");
$racegend=mysql_result($result,$i,"racegend");
$ethnicity=mysql_result($result,$i,"ethnicity");
$laborhsg=mysql_result($result,$i,"laborhsg");
$displ=mysql_result($result,$i,"displ");
$incomelevel=mysql_result($result,$i,"incomelevel");
$brneeded=mysql_result($result,$i,"brneeded");
$moveindate=mysql_result($result,$i,"moveindate");
$removaldate=mysql_result($result,$i,"removaldate");
$code=mysql_result($result,$i,"code");
$comments=mysql_result($result,$i,"comments");

<table>
<tr>
<TD><? echo $appl; ?></TD>
<TD><? echo $date; ?></TD>
<TD><? echo $time; ?></TD>
<TD><? echo $name; ?></TD>
<TD><? echo $racegend; ?></TD>
<TD><? echo $ethnicity; ?></TD>
<TD><? echo $laborhsg; ?></TD>
<TD><? echo $displ; ?></TD>
<TD><? echo $incomelevel; ?></TD>
<TD><? echo $brneeded; ?></TD>
<TD><? echo $moveindate; ?></TD>
<TD><? echo $removaldate; ?></TD>
<TD><? echo $code; ?></TD><TD>
<? echo $comments; ?></TD>
</TR>

$i++;
}

echo "</table>";

$i++;
}

?>
</B></FORM>
<P></P></BODY></HTML>

Philip · July 25, 2010

Again, PLEASE use

tags, you'll see why your program doesnt work with syntax highlighting:

<?php
$username="root";
$password="";
$database="addtransdb";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database"); //***didn't i suggest removing the @?***
$query="SELECT * FROM addtransinfo";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
    <HTML><HEAD>
<!--*** notice something wrong below? ***-->
<META http<BODY><B><FONT size=+2>Project: Hammock Oaks In-house transfers & Add-ons</FONT> 
<FORM>
<TABLE cellSpacing=0 cellPadding=0 border=1>
  <TBODY>
  <TR>
    <TH>Appl</TH>
    <TH>.</TH>
    <TH>.</TH>
    <TH>.</TH>
    <TH>Race &</TH>
    <TH>Ethnic-</TH>
    <TH>.</TH>
    <TH>Displ.</TH>
    <TH>Income</TH>
    <TH>B/r s </TH>
    <TH>Movein</TH>
    <TH>Removal</TH>
    <TH>.</TH>
    <TH>.</TH>
    </tr><tr>
    <TH>#</TH>
    <TH>Date</TH>
    <TH>Time</TH>
    <TH>Name</TH>
    <TH>Gender</TH>
    <TH>City</TH>
    <TH>LH %</TH>
    <TH>Y/N</TH>
    <TH>Level</TH>
    <TH>Needed</TH>
    <TH colSpan=2>Date</TH>
    <TH>Code</TH>
    <TH>Comments</TH></TR>
    </TBODY></TABLE>
<?php
$i=0;
while ($i < $num) {
if ($num==0) {
echo "the database contains no contacts yet";
} else {

$appl=mysql_result($result,$i,"appl");
$date=mysql_result($result,$i,"date");
$time=mysql_result($result,$i,"time");
$name=mysql_result($result,$i,"name");
$racegend=mysql_result($result,$i,"racegend");
$ethnicity=mysql_result($result,$i,"ethnicity");
$laborhsg=mysql_result($result,$i,"laborhsg");
$displ=mysql_result($result,$i,"displ");
$incomelevel=mysql_result($result,$i,"incomelevel");
$brneeded=mysql_result($result,$i,"brneeded");
$moveindate=mysql_result($result,$i,"moveindate");
$removaldate=mysql_result($result,$i,"removaldate");
$code=mysql_result($result,$i,"code");
$comments=mysql_result($result,$i,"comments");

// ***you need to close php right here***

<table>
<tr>
<TD><?php echo $appl; ?></TD>
<TD><?php echo $date; ?></TD>
<TD><?php echo $time; ?></TD>
<TD><?php echo $name; ?></TD>
<TD><?php echo $racegend; ?></TD>
<TD><?php echo $ethnicity; ?></TD>
<TD><?php echo $laborhsg; ?></TD>
<TD><?php echo $displ; ?></TD>
<TD><?php echo $incomelevel; ?></TD>
<TD><?php echo $brneeded; ?></TD>
<TD><?php echo $moveindate; ?></TD>
<TD><?php echo $removaldate; ?></TD>
<TD><?php echo $code; ?></TD><TD>
<?php echo $comments; ?></TD>
</TR>

// *** then you'll need to open php again, alternatively you could use heredoc ***

$i++;
}

echo "</table>";

$i++;
}

?>
</B></FORM>
<P></P></BODY></HTML>

I've left comments in your code prefixed with ***

fenway · July 28, 2010

And next time you post entire scripts -- let alone outside code tags -- I'll lock the thread.

Sign In

trying to display database

Recommended Posts

ckdoublenecks

Link to comment

Share on other sites

Philip

Link to comment

Share on other sites

ckdoublenecks

Link to comment

Share on other sites

Philip

Link to comment

Share on other sites

fenway

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information