PHP - Converting Guestbook Entry Newlines To Html <br /> Tags

Say I have the following text stored in a MySQL database...

Code: [Select]
<b>Classic Quote from movie</b>
and I retrieve it into a variable called $text, how do I properly echo that so that it keeps the bold tags and actually display the text "Classic quote from movie" in BOLD?

I'm doing something wrong somewhere along the line (simply doing "echo $text;") because it displays on the page as...

Code: [Select]
<b>Classic Quote from movie</b>

Instead of...

Classic Quote from movie

Any info on properly storing and echoing back HTML would be very appreciated.

Do anyone know how i can put the html tags in the same line as the other html tags?

Here's an example:

Code: [Select]
Images | Link | Delete | Enabled

On my code, it break the tags to the new line without put on the same line as the other tags.


Here's the code:

Code: [Select]
[code]<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'myusername');
    define('DB_PASSWORD', 'mypass');
    define('DB_DATABASE', 'mydbtable');

    $errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {
  die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }

    $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    if($username == '') {
  $errmsg_arr[] = 'username ID missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD ID missing';
  $errflag = true;
    }

    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
  $qry="SELECT * FROM members WHERE username='$username' AND passwd='$password'";
  $result=mysql_query($qry) or die('Error:<br />' . $qry . '<br />' . mysql_error());

if(mysql_num_rows($result) > 0) {
  $qrytable1="SELECT images, id, public FROM members WHERE username='$username'";
  $result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());

  while ($row = mysql_fetch_array($result1)) {  
  echo '<p id="images"> <a href="images.php?id='.$row['id'].'">Images</a></td> | <a href="http://' .  $row["links"] . '">Link</a> </td> | <a href="delete.php?id='.$row['id'].'">Delete</a> </td> |  <p> <p id="test">'.$row['Public'].'</td>'';
  }
}
}
?>[/code]

This is rather bothering as I know if you use the delimiter / regex pattern s it should ignore newlines


 preg_match_all("%<p><b>(.*?)</b>%s", $html, $data);


Returns a blank array
the page data is like so

<p>

                        <b>41,910</b><br/>
                        Total Points
                    </p>

Never had a problem before that i can recall but for some reason with this page it's giving me issues. Maybe i'm missing something?

Alright,  wasn't quite sure how to summarize this in the title,  but I want to:

Check if a user status is "active" or not based on the UserName input.

I have a table witch holds:

Code: [Select]
VarChar Username      Var CharPassWord     int Active
 Ted                        TedsPW                1
something like the above(assuming it formatted correctly.

In my php script I will want to input a variable for Username to check for:

inputUN in this example would be "Ted".

$UserNameToCheck = $_GET['inputUN'];

Then I want to check for that UserName in the database,  if it exists,  I want pull the value for the "Active" field for just that UserName and echo it.

Thanks for any help.
 

I'm having a problem on a PayPal payment completed page when clicking their "Return to Website" button.  The button is configured to return to a static HTML (SHTML) page and I'm getting the following error:

METHOD NOT ALLOWED
The requested method GET is not allowed for the URL (my site's page URL)

I'm assuming that this occurs because PayPal is sending some type of form as part of the redirect and of course, the HTML page chokes on trying to receive it.  My question is, will simply changing the file extension of my page from ".shtml" to ".PHP" be a kosher solution?  Would I need to assign the "_GET" variable to a local variable in the page, or will a PHP page just accept a passed form without requiring any variable assignments?