[RESOLVED] IF Statements won't work.

abasel

I hope I can explain this properly :queasy:

I have the following code stored in a MySQL database.

<?php
if (isset($POST['frm_username'])) {
if ($POST['frm_username'] == 'abasel' and $POST['frm_password'] == '12345') {
$SESSION['authorized'] = TRUE;
}
}

if (isset($REQUEST['logout'])) {
unset($session['authorized']);
}

if (isset($SESSION['authorized'])) {
?>
<p>Logged in</p>
<p><a href="<?php echo $SERVER['PHP_SELF']; ?>?>logout=1">Log Out</a></p>
<?php
} else {
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table width="310" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="104"><div align="center">Username</div></td>
<td width="206"><div align="center">
<input name="frm_username" type="text" id="frm_username">
</div></td>
</tr>
<tr>
<td><div align="center">Password</div></td>
<td><div align="center">
<input name="frm_password" type="password" id="frm_password" size="15" maxlength="8">
</div></td>
</tr>
<tr>
<td><div align="center">
<p> </p>
</div></td>
<td><p> </p></td>
</tr>
<tr>
<td><div align="center">
<p><a href="#" class="comment">Register a New Account</a></p>
<p><a href="#" class="comment">Forgotten Login Details</a></p>
</div></td>
<td valign="middle"><div align="center">
<input name="frm_login" type="submit" id="frm_login" value="Login">
</div></td>
</tr>
</table>
</form>
<?php
}
?>

It is pulled into the wide site via the following URL:
http://tbcol.internetlinked.com/index.php?id=9

As you'll see, I'm just experiementing at present. What I can't understand is that the IF statements don't seem to be doing anything i.e. both the true and false conditions are running. Also when I go to view source, I can see all the PHP code???

I've sure it's something really simple but just can't see it.

The following is the code within index.php that fetches the above code

<?php
if(isset($GET['id']))
{
$menu = "{$GET['id']}";
$query = "SELECT id, title, content, image FROM tblpages WHERE id = '{$_GET['id']}'";
}
else
{
$menu = "1";
$query = "SELECT id, title, content, image FROM tblpages WHERE id='1'";
}

						$result = mysql_query($query) or die('Error, query failed');

						WHILE ($entry = mysql_fetch_array($result, MYSQL_ASSOC))
						{
							$backgroundimage = $entry['image'];
							echo "<h1>";
							echo "{$entry['title']}";
							echo "</h1>";
							echo "{$entry['content']}";								
						}
						include '/home/intern/public_html/includes/closedb.php';
					?>

bradgrafelman

abasel wrote:
Also when I go to view source, I can see all the PHP code???

Then PHP hasn't been installed on your server.

NogDog

It certainly sounds like the file is not being processed via the PHP parser. To verify your PHP installation, create a file on your webserver with just the following content:

<?php
phpinfo();
?>

Make sure the file has a ".php" suffix for its name, then access it via your web browser. If it outputs lots of data about your PHP installation, then PHP is installed and ready for use. If you get a blank page, then either PHP is not installed or the webserver is not configured correctly to use it.

abasel

Hi,

PHP is definitely working as the whole site is PHP based and worked perfectly up to now.

http://tbcol.internetlinked.com/phpinfo.php confirms this.

I think the problem is the way I've fetched the code i.e. index.php uses PHP to echo code from my database. The code in the database also has PHP instructions in it and somehow its been lost when the code that is echo'd tries to process the PHP that it contains....... I don't know if I'm making any sense

NogDog

Ahhh...now I understand. Let me think about it a bit....

NogDog

OK, here's what I came up with.

Create a separate PHP file for getting the text from the DB and echoing it:

include_from_db.php:

<?php
header("Content-Type: text/plain");
if(!empty($_GET['id']))
{
   // create SQL based on $_GET['id'] value
   $connx = @mysql_connect('localhost', 'root', 'willetjr');
   if(!$connx)
   {
      user_error('DB connection failed', E_USER_WARNING);
      exit;
   }
   $db = @mysql_select_db('test');
   if(!$db)
   {
      user_error('DB select failed', E_USER_WARNING);
      exit;
   }
   $sql = "SELECT `text` FROM `table` WHERE `id` = '{$_GET['id']}'";
   $result = @mysql_query($sql);
   if($result and mysql_num_rows($result) > 0)
   {
      $row = mysql_fetch_assoc($result);
      echo $row['text'];
      exit;
   }
   else
   {
      user_error("DB error", E_USER_WARNING);
      exit;
   }
}
else
{
   user_error("No ID specified", E_USER_WARNING);
}

In the main file where you want to execute that text from the DB, include it via the above file called as a URL, with the ID in the query string for the database item you want to use:

<?php
include "http://localhost/test/include_from_db.php?id=1";
?>

I tested this out on my PC and it seemed to work fine. Hope it helps....

abasel

Hi,

Thanks for that but in the end I found it simply to just duplicate my page, putting the PHP in to original page and not calling it from a database.

Cheers