Ad:

PHP Discussion Thread
Unsolved
Views: 5041

Page 1
2
3
Next

You are currently viewing page 1 of this multi-page discussion thread

Aug 21st, 2007

what's wrong in this code?

Expand Post »

so, i started at php and i'm doing some exercises from the book, but when i type this code into my "view.php", the output is all wrong...

php Syntax (Toggle Plain Text)
  <?php include("dbconnect.php") ?>
 
  <h2>View my GuestBook!!</h2>
 
  <?php
 
  $result=mysql_query("select * from guestbook")
     or die(mysql_error());
  while ($row=mysql_fetch_array($result))
  {
     echo "<b>Name:</b>";
     echo $row["name"];
     echo "<br>\n";
     echo "<b>Location:</b>";
     echo $row["location"];
     echo "<br>\n";
     echo "<b>Email:</b>";
     echo $row["email"];
     echo "<br>\n";
     echo "<b>URL:</b>";
     echo $row["url"];
     echo "<br>\n";
     echo "<b>Comments:</b>";
     echo $row["comments"];
     echo "<br>\n";
     echo "<br>\n";
     echo "<br>\n";
  }
  mysql_free_result($reslut);
  ?>
  <?php include("dbconnect.php") ?>
  
  <h2>View my GuestBook!!</h2>

  <?php

  $result=mysql_query("select * from guestbook")
     or die(mysql_error());
  while ($row=mysql_fetch_array($result))
  {
     echo "<b>Name:</b>";
     echo $row["name"];
     echo "<br>\n";
     echo "<b>Location:</b>";
     echo $row["location"];
     echo "<br>\n";
     echo "<b>Email:</b>";
     echo $row["email"];
     echo "<br>\n";
     echo "<b>URL:</b>";
     echo $row["url"];
     echo "<br>\n";
     echo "<b>Comments:</b>";
     echo $row["comments"];
     echo "<br>\n";
     echo "<br>\n";
     echo "<br>\n";
  }
  mysql_free_result($reslut);
  ?>

the output is like this:

Quote ...

View my GuestBook!!

Name:"; echo $row["name"]; echo "
\n"; echo "Location:"; echo $row["location"]; echo "
\n"; echo "Email:"; echo $row["email"]; echo "
\n"; echo "URL:"; echo $row["url"]; echo "
\n"; echo "Comments:"; echo $row["comments"]; echo "
\n"; echo "
\n"; echo "
\n"; } mysql_free_result($reslut); ?>

Sign my GuestBook

Similar Threads

What is Wrong in this simple code ? in Assembly
What's wrong with this code? in C#
What's wrong with this code? in Python
Please help me figure out whats wrong with my code in C++
What is wrong with this code? in C++

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

I think your server doesn't recognize php file, so
it doesn't interpret it. Do you install and configure
correctly PHP ?

- Mitko Kostov

Last edited by MitkOK; Aug 21st, 2007 at 1:26 pm.

MitkOK

Reputation Points: 59

Solved Threads: 12

Junior Poster

Offline

142 posts
since Jul 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

i installed XAMPP... and i already made another php file that worked correctly, which was the one that writes the information this one is supposed to read...

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

here are all my codes:

dbconnect.php

php Syntax (Toggle Plain Text)
<?php
mysql_connect("localhost","nobody","ydobon")
   or die("<h3>could not connect to MySQL</h3>\n");
mysql_select_db("guestbook")
   or die("<h3>could not select database 'guestbook'</h3>\n");
?>
<?php
mysql_connect("localhost","nobody","ydobon")
   or die("<h3>could not connect to MySQL</h3>\n");
mysql_select_db("guestbook")
   or die("<h3>could not select database 'guestbook'</h3>\n");
?>

sign.php

php Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>
 
 <BODY>
  <h2>Sign my guestbook!</h2>
  <form method="post" action="create_entry.php">
 
     <b>Name:</b>
     <input type="text" size="40" name="name">
     <br>
     <b>Location:</b>
     <input type="text" size="40" name="location">
     <br>
     <b>Email:</b>
     <input type="text" size="40" name="email">
     <br>
     <b>Home Page URL:</b>
     <input type="text" size="40" name="url">
     <br>
     <b>Comments:</b>
     <textarea name="comments" cols="40" rows="4"
     wrap="virtualv"></textarea>
     <br>
 
     <input type="submit" name="submit" value="Sign!">
     <input type="reset" name="reset" value="Start Over">
 
     </form>
 </BODY>
</HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>

 <BODY>
  <h2>Sign my guestbook!</h2>
  <form method="post" action="create_entry.php">
     
     <b>Name:</b>
     <input type="text" size="40" name="name">
     <br>
     <b>Location:</b>
     <input type="text" size="40" name="location">
     <br>
     <b>Email:</b>
     <input type="text" size="40" name="email">
     <br>
     <b>Home Page URL:</b>
     <input type="text" size="40" name="url">
     <br>
     <b>Comments:</b>
     <textarea name="comments" cols="40" rows="4"
     wrap="virtualv"></textarea>
     <br>

     <input type="submit" name="submit" value="Sign!">
     <input type="reset" name="reset" value="Start Over">

     </form>
 </BODY>
</HTML>

create_entry.php

php Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>
 
 <BODY>
  <?php
  include("dbconnect.php");
 
  if ($_REQUEST["submit"]=="Sign!")
  {
     $query="insert into guestbook(name,location,email,url,comments) values ('"
            .$_REQUEST["name"]
            ."', '"
            .$_REQUEST["location"]
            ."', '"
            .$_REQUEST["email"]
            ."', '"
            .$_REQUEST["url"]
            ."', '"
            .$_REQUEST["comments"]
            ."') "
     ;
     mysql_query($query);
 ?>
 <h2>Thanks!!</h2>
 <h2><a href="view.php">View my GuestBook!!</a></h2>
 <?php
 }
 else
 {
    include("sign.php");
 }
 ?>
 </BODY>
</HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>

 <BODY>
  <?php
  include("dbconnect.php");

  if ($_REQUEST["submit"]=="Sign!")
  {
     $query="insert into guestbook(name,location,email,url,comments) values ('"
            .$_REQUEST["name"]
            ."', '"
            .$_REQUEST["location"]
            ."', '"
            .$_REQUEST["email"]
            ."', '"
            .$_REQUEST["url"]
            ."', '"
            .$_REQUEST["comments"]
            ."') "
     ;
     mysql_query($query);
 ?>
 <h2>Thanks!!</h2>
 <h2><a href="view.php">View my GuestBook!!</a></h2>
 <?php
 }
 else
 {
    include("sign.php");
 }
 ?>
 </BODY>
</HTML>

view.php

php Syntax (Toggle Plain Text)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>
 
 <BODY>
  <?php include("dbconnect.php") ?>
 
  <h2>View my GuestBook!!</h2>
 
  <?php
 
  $result = mysql_query("select * from guestbook")
     or die(mysql_error());
  while ($row = mysql_fetch_array($result))
  {
     echo "Name:";
     echo $row["name"];
     echo "<br>\n";
     echo "<b>Location:</b>";
     echo $row["location"];
     echo "<br>\n";
     echo "<b>Email:</b>";
     echo $row["email"];
     echo "<br>\n";
     echo "<b>URL:</b>";
     echo $row["url"];
     echo "<br>\n";
     echo "<b>Comments:</b>";
     echo $row["comments"];
     echo "<br>\n";
     echo "<br>\n";
     echo "<br>\n";
  }
  mysql_free_result($result);
  ?>
 
  <h2><a href="sign.php">Sign my GuestBook</a></h2>
 
 </BODY>
</HTML>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
 <HEAD>
  <TITLE> New Document </TITLE>
  <META NAME="Generator" CONTENT="EditPlus">
  <META NAME="Author" CONTENT="">
  <META NAME="Keywords" CONTENT="">
  <META NAME="Description" CONTENT="">
 </HEAD>

 <BODY>
  <?php include("dbconnect.php") ?>
  
  <h2>View my GuestBook!!</h2>

  <?php

  $result = mysql_query("select * from guestbook")
     or die(mysql_error());
  while ($row = mysql_fetch_array($result))
  {
     echo "Name:";
     echo $row["name"];
     echo "<br>\n";
     echo "<b>Location:</b>";
     echo $row["location"];
     echo "<br>\n";
     echo "<b>Email:</b>";
     echo $row["email"];
     echo "<br>\n";
     echo "<b>URL:</b>";
     echo $row["url"];
     echo "<br>\n";
     echo "<b>Comments:</b>";
     echo $row["comments"];
     echo "<br>\n";
     echo "<br>\n";
     echo "<br>\n";
  }
  mysql_free_result($result);
  ?>

  <h2><a href="sign.php">Sign my GuestBook</a></h2>

 </BODY>
</HTML>

everything works just fine until when it gets to view.php... dunno what the problem is...

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

I would suspect this lack of a semi-colon might be causing your problem

php Syntax (Toggle Plain Text)
  <?php include("dbconnect.php") ?>
  <?php include("dbconnect.php") ?>

though I'm not sure why you aren't getting an immediate script error from it.

Last edited by Ezzaral; Aug 21st, 2007 at 7:39 pm.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 839

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

according to what i know, it shouldn't affect... since it is a single command...

still... tried it, and no response... the same exact results...

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

Click to Expand / Collapse Quote originally posted by Nichito ...

according to what i know, it shouldn't affect... since it is a single command...

still... tried it, and no response... the same exact results...

Yes, I wondered about it and a couple quick tests here came up the same. The semi-colon did not matter. That was the only thing that stood out that might have caused it to switch parsing modes. I don't really see anything else yet that would be problematic.

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 839

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

did you try it? i mean, the whole 'combo'?

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

Click to Expand / Collapse Quote originally posted by Nichito ...

did you try it? i mean, the whole 'combo'?

No, as that would entail creating db tables as well

Ezzaral

Moderator

Featured Poster

Reputation Points: 3239

Solved Threads: 839

Posting Genius

Offline

6,761 posts
since May 2007

Permalink

Aug 21st, 2007

Re: what's wrong in this code?

true... hehe... i don't think there's a problem with my php setup, since two out of three pages were working just fine...

maybe it's just something unnoticeable... or the example is not well written... i'll try some more and see if it persists...

Nichito

Featured Poster

Reputation Points: 424

Solved Threads: 57

Posting Virtuoso

Offline

1,594 posts
since Mar 2007

Page 1
2
3
Next

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: receiving an XML Post - how to ?

Next Thread in PHP Forum Timeline: cPanel copy php errors help

DaniWeb Message

Cancel Changes

User Name
Password