[SOLVED] Page shows up blank

zenix · June 5, 2009

Hey, I am learning php right now. I have been attempting to make a simple database that would store just 2 fields of information. I thought this would be a place to start and it'd be something I could buil upon later as I learn more. Anyway, I have coded and re-coded this thing and whenever I attempt to view it in my browser I get a blank screen in Firefox and a 500 server error in IE. If someone would take a look at what I have and offer a suggestion or 2 I would REALLY appreciate it. The code is below, thank you in advance!

This code is for viewing the table contents:

<html>
<head>
<title>View Database</title>
</head>

<body>

<?php

//connect and select
if($dbc = mysql_connect('localhost','root'));
{
if(!mysql_connect('database1'))
{
	die('<p>Could not select to mysql because <b>' . mysql_error() . '</p></b>');
}
}
else
{
die('<p>Could not connect to mysql because:<b>' . mysql_error() . '</p></b>');
}
//define query
$query = 'SELECT * FROM db_entries ORDER BY date_entered DESC';

if($r = mysql_query($query))
{
//retrieve and print records
while($row = mysql_fetch_array($r))
{
	print "<p><h3>{$row['title']}</h3>
	{$row['entry']}<br/>
	<a href=\"edit_entry.php?id={$row['db_id']}\">Edit</a>
	<a href=\"delete_entry.php?id={$row['db_id']}\">Delete</a></p><hr/>\n";
}
}
else
{
//Query didn't run
die('<p>Could not retrieve data because <b>' . mysql_error() . "the query was $query</b></p>");
}
mysql_close();
?>

															  




</body>
</html>

This coed is for adding the data:

<html>
<head>
<title>Entry 2</title>
</head>

<body>
<?php

//Didn't show anything
//ini_set('display_errors', 1);
//error_reporting(E_ALL);

if(isset($_POST['submit']))
{
   //connect and select
   if($dbc = mysql_connect ('localhost', 'root'))
   {
      if(!@mysql_select_db ('myblog'))
      {
         dir('<p>Could not select database because <b>' . mysql_error() . '</b></p>');
      }
   }
   else
   {
      print "<p>Could not connect to database because <b>" . mysql_error() . "</b></p>";
   }
//define query
$query = "INSERT INTO blog_entries
(bog_id, title, entry, date_entered) VALUES(0, '{$_POST['title']}', '{$POST['entry']}', NOW())";

//execute query
if(@mysql_query($query))
{
   print '<p>The blog entry has been added</p>';
}
else
{
   "<p>Could not add entry because: <b>" . mysql_error() . "</b>. The query was $query.</p>";
}
}
mysql_close();
?>

<form action ="add_entry.php" method ="post">
<p>Entry title: <input type ="text" name ="title" size ="40" maxsize ="100"/></p>
<p>Entry text: <textarea name="entry" cols ="40" rows ="5"/></textarea></p>
<br/>
<input type ="submit" name ="submit" value ="Add my entry!"/>
</form>
</body>
</html>

This code is for creating the DB. I know not very efficient, but I am just learning now.

<html>
<head>
<title>Database 10</title>
</head>

<body>

<?php
//attempt to connect to mysql
if($dbc = mysql_connect('localhost', 'root'))
{
print '<p>Successfully connected!</p>';

if(mysql_query('CREATE DATABASE database1'))
{
	print '<p>The database has been created!</p>';
}
else
{
	die('<p>Could not create database because: <b>' . mysql_error() . '</b></p>');
}
if(mysql_select_db('database1'))
{
	print '<p>The database has been selected!</p>';
}
else
{
	die('The database could not be slected because: <b>' . mysql_error() . "</b>The query being run was<b> $query</b>");
}
mysql_close();
}
else
{
die('<p> could not connect to mysql because<b>' . mysql_error . '</p></b>');
}
?>
</body
</html>

				   

																	  

				   



</body>
</html>

AND creating the table

<html>
<head>
<title>Create Table</title>
</head>

<body>

<?php
//connect and select
if($dbc = @mysql_connect('localhost', 'root'))
{
if (!@mysql_select_db ('database1'))
{
	die('<p>Could not select the database because<b>' . mysql_error() . '</b></p>');
}

}
else
{
die('<p>Could not connect to database because: <b>' . mysql_error() . '</b></p>');
}
//define query
$query = 'CREATE TABLE db_entries
(db_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) NOT NULL,
  entry TEXT NOT NULL, date_entered DATETIME NOT NULL)';

//run query
if(mysql_query($query))
{
 print '<p>The table has been created!</p>';
}
else
{
 die('<p>The table was not created because <b>.' . mysql_error() . '</b></p>
															   <p> the query being run was:' . $query . '</p>');
}
mysql_close();
?>
																	  



</body>
</html>

gijew · June 5, 2009

That's a lot of code. Too much for these weary eyes.

Are you running this on a local box or remote server? You should set error reporting to E_ALL and display_errors = on so you have a better idea of what is happening.

PFMaBiSmAd · June 5, 2009

Which of the posted code is experiencing the error of a blank screen?

PFMaBiSmAd · June 5, 2009

You should set error reporting to E_ALL and display_errors = on so you have a better idea of what is happening.

Someone already told him that, apparently he did not want php's help in finding basic errors.

Maq · June 5, 2009

In your first code excerpt, "This code is for viewing the table contents:" you have a syntax error:

if($dbc = mysql_connect('localhost','root'));

In case you can't see it, there is a semi-colon after your IF statement.

zenix · June 8, 2009

Someone already told him that, apparently he did not want php's help in finding basic errors.

Yes, I did insert the ini_set('display_errors' 1 );

error_reporting = (E_ALL);

sorry it wasn't included here though. Someone told me that it doesn't need to be on every page so I omitted it. More than likely would have been better if I had just left it or even commented it out. Sorry. I also apologize for there having been so much code. I will try to pin point it a little btter in the future. I looked at the post this morning, yeah...it's too much with so many snippets.

zenix · June 8, 2009

Could someone please let me know how to mark this resolved? I'm going to do more troubleshooting and studying. Probably learn better that way. Thank Maq for pointing out my typo. I appreciate all the comments here. Thanks a lot!

Sign In

[SOLVED] Page shows up blank

Recommended Posts

zenix

Link to comment

Share on other sites

gijew

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

zenix

Link to comment

Share on other sites

zenix

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information