0

Hi,

I am having trouble with this page, it is completely blank. I have turned on error reporting but nothing happens, does anyone know what has happened to it? It has worked previously so maybe I have changed something but not sure what.

<?php
session_start();
ob_start();
if(!isset($_SESSION['authenticated']))
{ 
header ("Location: http://www.example.com") ;
 }
else
{
?>
<html>
<head>
<? include ("/home/example.com"); ?>
</head>

<body>

<div id="main">
     <?php include ("/home/example.com"); ?>
    <div id="content">
        <div id="info">

<?php 
$link = mysql_connect("","",""); 
if (!$link) { 
    die('Could not connect: ' . mysql_error()); 
} 
mysql_select_db(); 

$pagename=ereg_replace("[^A-Za-z0-9]", "", $bandname); 

$bandname = mysql_real_escape_string($_POST['bandname']);
$email = mysql_real_escape_string($_POST['email']);
$myspace = mysql_real_escape_string($_POST['myspace']);
$twitter = mysql_real_escape_string($_POST['twitter']);
$facebook = mysql_real_escape_string($_POST['facebook']);
$website = mysql_real_escape_string($_POST['website']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$surname = mysql_real_escape_string($_POST['surname']);
$location = mysql_real_escape_string($_POST['location']);
$about = mysql_real_escape_string($_POST['about']);
$genre = mysql_real_escape_string($_POST['genre']);
$username = mysql_real_escape_string($username);
$pagename = mysql_real_escape_string($pagename);

$query = ("SELECT * FROM bands WHERE BandName = '$bandname'");

$result = mysql_query($query);

$num = mysql_num_rows($result);

if ($num == 0) {

$sql="INSERT INTO bands (BandName, Email, Myspace, Twitter, Facebook, Website, Firstname, Surname, Location, About, Genre, Username, PageName)
VALUES
('$bandname','$email','$myspace','$twitter','$facebook','$website','$firstname','$surname','$location','$about','$genre','$username','$pagename')";


if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }

header ("Location: http://www.example.com") ;


mysql_close($link);

}

else {
echo 'Sorry, there is already a band listed using that name, please try again with a different name or email help@unsignedgigs.co.uk.’;
include '/home/example.com';
}
}
?>
        </div>
        <div id="ad">
<?php include ("/home/example.com"); ?>
        </div>
        <div id="ad2">
<?php include ("/home/example.com"); ?>
        </div>
        <div id="footer">
<?php include ("/home/example.com"); ?>
        </div>
    </div>
</div>

</body>

</html>

Thanks for any help - I realise it isn't great code as well, but I am learning.

4
Contributors
7
Replies
27
Views
3 Years
Discussion Span
Last Post by gilgil2
1

Is your PHP error log error free as well?
Echo out so text to see if you can determine where it is failing if the logs don't help you.
And what is that you are trying to include (home/example.com)? What file type is and what is it meant to do?

0

Thanks for the responses. Error log is empty as well.

The includes are for header, a new field to input data if first was incorrect and some adverts.

Could you explain what you mean by echo out please?

I have tried turning on error reporting but nothing happened, what is the best way to see errors?

Thanks again

1

Well, checking the error log is the best but if you need to you can use var_export or echo to output a string of text. If you can see that text when you run the page you know you at least got to that point.
echo 'here';
If you view the source of the page do you see anything? You're including home/example.com as both header elements and content of the page so what exactly is it? Is it possible that the page is constructing itself correctly and just happens to be empty?

0

Thanks for your help, I've narrowed the problem down to something within this part of the code:

$pagename=ereg_replace("[^A-Za-z0-9]", "", $bandname); 

$bandname = mysql_real_escape_string($_POST['bandname']);
$email = mysql_real_escape_string($_POST['email']);
$myspace = mysql_real_escape_string($_POST['myspace']);
$twitter = mysql_real_escape_string($_POST['twitter']);
$facebook = mysql_real_escape_string($_POST['facebook']);
$website = mysql_real_escape_string($_POST['website']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$surname = mysql_real_escape_string($_POST['surname']);
$location = mysql_real_escape_string($_POST['location']);
$about = mysql_real_escape_string($_POST['about']);
$genre = mysql_real_escape_string($_POST['genre']);
$username = mysql_real_escape_string($username);
$pagename = mysql_real_escape_string($pagename);

$query = ("SELECT * FROM bands WHERE BandName = '$bandname'");

$result = mysql_query($query);

$num = mysql_num_rows($result);

if ($num == 0) {

$sql="INSERT INTO bands (BandName, Email, Myspace, Twitter, Facebook, Website, Firstname, Surname, Location, About, Genre, Username, PageName)
VALUES
('$bandname','$email','$myspace','$twitter','$facebook','$website','$firstname','$surname','$location','$about','$genre','$username','$pagename')";


if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }

header ("Location: http://www.example.com") ;


mysql_close($link);

}

else {
echo 'Sorry, there is already a band listed using that name, please try again with a different name or email help@example.co.uk.’;
include '/form.php';
}
}

Still can't spot the problem but I am at least getting closer...

0

The problem was something with this - no idea what it was, I wrote it out again and now it works perfectly, very odd.

else {
echo 'Sorry, there is already a band listed using that name, please try again with a different name or email help@example.co.uk.’;
include '/form.php';
}

Thanks for everyone's help

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.