Jump to content

[SOLVED] Page shows up blank

zenix

By zenix
in PHP Coding Help

Recommended Posts

zenix Member

zenix

Posted
Posted

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>

Link to comment
https://forums.phpfreaks.com/topic/161122-solved-page-shows-up-blank/
Share on other sites
zenix Member

zenix

Posted
  • Author
Posted 

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.

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.