output php database to html webpage

davef

i'm trying to get a php database to output/display on a html webpage
and have no results from cutting and pasting code from online tutorials
i'm saving to a file with a htm extension
i believe i have the connection data right:

$db_host = 'server';
$db_user = 'username';
$db_pwd = 'password';

$database = 'database';
$table = 'table';

if (!mysql_connect($server,$username,$password))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");


$result = mysql_query("SELECT * FROM table") 
or die(mysql_error());

Can someone please help me? send code? tell me what i'm doing wrong? Thanks

NogDog

So far your code only outputs anything if there is an error. If the mysql_query() succeeds, then you will need to loop through the results using something like [man]mysql_fetch_assoc/man to get each result row and within the loop echo the desired fields.

dagon

that probably should be a *.php page.
what error are you getting?

davef

well when i do save it as .php i get this:

Parse error: syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/display.php on line 61

as .htm i get bits of code showing up on the screen

thanks

dagon

well as .html, the php code is not processed, so that's not much use, as .php the code is run, we don't know what's on line 61, so you need to show us (a couple of lines before and after would also help.

davef

here's the whole:

<html>
<body>
<?php
$db_host = 'server';
$db_user = 'username';
$db_pwd = 'password';

$database = 'mx';
$table = 'contact1';

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

$num=mysql_numrows($result);




$i=0;
while ($i < $num) {

$firstname1=mysql_result($result,$i,"firstname1");
$lastname1=mysql_result($result,$i,"lastname1");
$phonenumber1=mysql_result($result,$i,"phonenumber1");
$email1=mysql_result($result,$i,"email1");
$website1=mysql_result($result,$i,"website1");

echo "<b>$firstname1$lastname1</b><br>Phone: $phonenumber1<br>E-mail: $email1<br>Web: $website1<br><hr><br>";


$i++;
}

?>


</body>
</html>

bradgrafelman

That can't be "the whole" - the PHP error message references line #61 while you've only posted ~40 lines of code.

EDIT: Also, when posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

davef

right, sorry, that was the php code. here is the whole down to a number of lines below the php (if that's enough):

<!DOCTYPE HTML PUBLIC "-//SoftQuad Software//DTD HoTMetaL PRO 5.0::19981217::extensions to HTML 4.0//EN" "hmpro5.dtd">
 <HTML>
 <HEAD>
<TITLE>xxxxxxxxxxxxxxxxxxxx</TITLE>
<META NAME="DESCRIPTION" CONTENT="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx offering natural healing and wellness management for individuals, classes, programs, workshops and seminars for groups, group rentals, recreation and New England adventure."> 
<META NAME="KEYWORDS" CONTENT="contact,questions,comments,registration"> 
<META NAME="AUTHOR" CONTENT="xxxxxxxxxxxxxxxxxxxxxx"> 
</HEAD>
<BODY>
<STYLE>
{SCROLLBAR-FACE-COLOR:"#D3D3D3";
SCROLLBAR-SHADOW-COLOR:"#E1F0FF";
SCROLLBAR-TRACK-COLOR:"#E1F0FF";
SCROLLBAR-ARROW-COLOR:"#626231";}
</STYLE>
<BODY TOPMARGIN="0" LEFTMARGIN=0  BGCOLOR="#E1F0FF">
<TABLE WIDTH="770"   CELLSPACING="0" ALIGN="CENTER">
<TR>
<TD ALIGN="LEFT" VALIGN="TOP" WIDTH="770" BGCOLOR="#004080"></TD>
</TR>
<TD><TABLE WIDTH="770" CELLSPACING="0" CELLPADDING="5">
<TD WIDTH="770" VALIGN="TOP" ALIGN="CENTER" BGCOLOR="#004080"><P><FONT
FACE="LUCINDA" SIZE="+4" COLOR="#FFD700"><B>xxxxxxxxxxxxxxxxxxxx</B><BR>
</TD></TR>
<TR>
</TD>
</TR>
<TR>
<TD><TABLE WIDTH="770" CELLSPACING="0" CELLPADDING="10">
<TD WIDTH="100" VALIGN="TOP" ALIGN="LEFT" BGCOLOR="#004080"><P>
<P>
<A HREF="index.htm"><B><FONT FACE="Arial" COLOR="#FFD700" SIZE="-1">Contents</FONT></B></A>
<BR><A HREF="writings.htm"><B><FONT FACE="Arial" COLOR="#FFD700" SIZE="-1">Text</FONT></B></A>
<BR><A HREF="xxxxxxxxxxxxxxxxxxxxxxxxx" TARGET="resource window"><B><FONT FACE="Arial" COLOR="#FFD700" SIZE="-1">Retreat</FONT></B></A>
<BR><A HREF="staff.htm"><B><FONT FACE="Arial" COLOR="#FFD700" SIZE="-1">Dr David</FONT></B></A>
<BR><A HREF="contact.htm"><B><FONT FACE="Arial" COLOR="#FFD700" SIZE="-1">Contact Us</FONT></B></A>
</B></P>
</TD>
<TD ALIGN="LEFT" BGCOLOR="#E1F0FF" VALIGN="TOP" WIDTH="640"><TABLE WIDTH="640" CELLSPACING="0" CELLPADDING="5">
<TR>
<TD ALIGN="LEFT" VALIGN="TOP">&nbsp;<P><A NAME="top"><FONT SIZE="+3" FACE="LUCINDA SANS" COLOR="#004080"><B>
xxxxxxxxxxxxxx</B>
</FONT>
<P>

<html>
<body>
<?php
$db_host = 'xxxxxxxxxxxxxx';
$db_user = 'xxxxxxxxxxxxxxxxxxxxxxxx';
$db_pwd = 'xxxxxxxxxxxx';

$database = 'mx';
$table = 'contact1';

mysql_connect($xxxxxxxxxxxxxxx,$xxxxxxxxxxxx,$xxxxxxxxxxxxxxxxxxx);
@mysql_select_db($mx) or die( "Unable to select database");
$query="SELECT * FROM contact1";
$result=mysql_query($query);

$num=mysql_numrows($result);

$i=0;
while ($i < $num) {

$firstname1=mysql_result($result,$i,"firstname1");
$lastname1=mysql_result($result,$i,"lastname1");
$phonenumber1=mysql_result($result,$i,"phonenumber1");
$email1=mysql_result($result,$i,"email1");
$website1=mysql_result($result,$i,"website1");

echo "<b>$firstname1$lastname1</b><br>Phone: $phonenumber1<br>E-mail: $email1<br>Web: $website1<br><hr><br>";

$i++;
}

?>

</body>
</html>

</P>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE></TABLE>
<TR>
<TD P ALIGN="CENTER">

thanx

bradgrafelman

There are no parse errors in the code you posted above.

davef

or on another version i get

Parse error: syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/test000.php on line 6

when i run:

<?PHP
$db_host = 'xxxxxxxxx';
$db_user = 'xxxxxx';
$db_pwd = 'xxxxxxx';
$database = 'mx';
mysql_connect($xxxxxxxxxxxxxxxx,$xxxxxxxx,$xxxxxxxxxxxxx) or die("Can't connect to database");
mysql_select_db($mx) or die("Can't select database");
$result = mysql_query("SELECT * FROM contact1") or die(mysql_error()); 
$num_rows = mysql_num_rows($result);
if($num_rows>0) {
while($row=mysql_fetch_array($result)) {
echo "First name: " . $row['firstname1'] . "<br>";
echo "Last name: " . $row['lastname1'] . "<br>";
echo "Phone: " . $row['phonenumber1'] . "<br>";
echo "Email: " . $row['email1'] . "<br>";
echo "Website: " . $row['website1'] . "<br>";
echo "<hr>";
}
}
?>

thanks again

bradgrafelman

Again, there are no parse errors in the code you posted.

davef

damned if i know?!

"when i look at" the "frontend" (isn't that the term?) the screen says (and I cut and paste):

Parse error: syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/test000.php on line 6

dagon

sure its the same file? same between local and host ?

davef

Right, here's the code in its entirety, with just a bit of scrambling on the host, username, etc
I was putting in the actual info and taking out the xxxxx.
THANKS for your efforts. I don't feel so bad about my difficulties. Why is it so hard?
Php is a lot more complex than html. Is there a good way to learn it? book?

[code=php]
<?PHP
$db_host = 'david.hostsmysql.com';
$db_user = 'username';
$db_pwd = 'ddddddddd';
$database = 'mx';
mysql_connect($db_david.hostsmysql.com,$db_username,$db_username) or die("Can't connect to database");
mysql_select_db($mx) or die("Can't select database");
$result = mysql_query("SELECT * FROM contact1") or die(mysql_error()); 
$num_rows = mysql_num_rows($result);
if($num_rows>0) {
while($row=mysql_fetch_array($result)) {
echo "First name: " . $row['firstname1'] . "<br>";
echo "Last name: " . $row['lastname1'] . "<br>";
echo "Phone: " . $row['phonenumber1'] . "<br>";
echo "Email: " . $row['email1'] . "<br>";
echo "Website: " . $row['website1'] . "<br>";
echo "<hr>";
}
}
?>
[code]

and here is the error message

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'hostsmysqlcom' (1) in /hermes/web04/b1964/david/suma.php on line 6
Can't connect to database

davef

here's another version with its error message
and the error message taken from the screen when i "run"/view the file.I am sure that i am viewing the same file coded here.

[code=php]
<?PHP
$db_host = 'david.hostsmysql.com';
$db_user = 'username';
$db_pwd = 'dddddddd';
$database = 'mx';
mysql_connect($vdavid.hostsmysql.com,$usern,$dddddd) or die("Can't connect to database");
mysql_select_db($mx) or die("Can't select database");
$result = mysql_query("SELECT * FROM contact1") or die(mysql_error()); 
$num_rows = mysql_num_rows($result);
if($num_rows>0) {
while($row=mysql_fetch_array($result)) {
echo "First name: " . $row['firstname1'] . "<br>";
echo "Last name: " . $row['lastname1'] . "<br>";
echo "Phone: " . $row['phonenumber1'] . "<br>";
echo "Email: " . $row['email1'] . "<br>";
echo "Website: " . $row['website1'] . "<br>";
echo "<hr>";
}
}
?>

[/code]

Parse error: syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/test000.php on line 6

dagon

there are no syntax errors in either piece of pasted code.

--oh i see, you need to quote hostsmysql.com, or the dots are being interpreted as concatenation

davef

Well the quotes were a good idea.
Now it recognizes the database.
Both attempts at coding now yield the same error message:

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/suma.php on line 6

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting T_VARIABLE or '$' in /hermes/web04/b1964/david/test000.php on line 6

dagon

this should work:

mysql_connect($db_david.'hostsmysql.com',$db_username,$db_username) or die("Can't connect to database")