Jump to content

Problem with old PHP-code


plomma

Recommended Posts

Hello all!

 

I have a small problem with some old PHP-code I think. I am pretty new to PHP, so I don't really know where to start. I have downloaded a flash/php/mysql guestbook-script from http://www.flash-db.com/Tutorials/guestbook/index.php

 

The problem is that this code won't run on my server. The PHP versions running is 4.4.x and 5.2.x+su_php.

I only get Internal Server Error. Is this because the script is out of date?

 

Help appreciated!

 

This is the code used:

 

<?

/*

-----

Application: Flash-dB GuestBook Version 2.0

Details:    mySQL and PHP powered GuestBook

Author:      Mohsin Sumar

Website:    http://www.flash-db.com

Support:    http://www.flash-db.com/Board

Notes:      Coments are marked by using comment entries symbols. Eg: // Comment

-----

*/

 

// Part One - Initiate a mySQL Database Connection

// Database Connectivity Variables and other Variables

  $DBhost = "localhost";  // Database Server

  $DBuser = "user";            // Database User

  $DBpass = "password";            // Database Pass

  $DBName = "database_name";            // Database Name

  $table = "guestbook";            // Database Table

  $numComments = 10;      // Number of Comments per page

 

  // Connect to mySQL Server

  $DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error in GuestBook Application: " . mysql_error());

  // Select mySQL Database

  mysql_select_db($DBName, $DBConn) or die("Error in GuestBook Application: " . mysql_error());

 

// Part Two - Choose what action to perform

  $action = $_GET['action'];

 

  switch($action) {

      case 'read' :

// Fetch all comments from database table

$sql = 'SELECT * FROM `' . $table . '`';

$allComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());

$numallComments = mysql_num_rows($allComments);

// Fetch page-wise comments from database table

$sql .= ' ORDER BY `time` DESC LIMIT ' . $_GET['NumLow'] . ', ' . $numComments;

$fewComments = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());

$numfewComments = mysql_num_rows($fewComments);

// Generate Output for Flash to Read

print '&totalEntries=' . $numallComments . '&';

print "<br>&entries=";

 

if($numallComments == 0) {

    print "No entries in the guestbook, as yet..";

} else {

    while ($array = mysql_fetch_array($fewComments)) {

  $name = mysql_result($fewComments, $i, 'name');

  $email = mysql_result($fewComments, $i, 'email');

  $comments = mysql_result($fewComments, $i, 'comments');

  $time = mysql_result($fewComments, $i, 'time');

 

  print '<b>Name: </b>' . $name . '<br><b>Email: </b>' . $email . '<br><b>Comments: </b>' . $comments . '<br><i>Date: ' . $time . '</i><br><br>';

  $i++;

    }

}

// Print this only when there aren't any more entries..

if($_GET['NumLow'] > $numallComments) {

  print 'No More Entries!&';

}

break;

 

  case 'write' :

    // Recieve Variables From Flash

$name = ereg_replace("&", "%26", $_POST['yourname']);

$email = ereg_replace("&", "%26", $_POST['youremail']);

$comments = ereg_replace("&", "%26", $_POST['yourcomments']);

$submit = $_POST['submit'];

 

// Current system date in yyyy-mm-dd format

$submitted_on = date ("Y-m-d H:i:s",time());

 

// Check if its submitted from Flash

if($submit == 'Yes'){

// Insert the data into the mysql table

$sql = 'INSERT INTO ' . $table .

                ' (`ID`,

  `name`,

  `email`,

  `comments`,

  `time`

  )

  VALUES

  (\'\','

  . '\'' . $name . '\','

  . '\'' . $email . '\','

  . '\'' . $comments . '\','

  . '\'' . $submitted_on . '\'

  )';

$insert = mysql_query($sql, $DBConn) or die("Error in GuestBook Application: " . mysql_error());

 

// If you want your script to send email to both you and the guest, uncomment the following lines of code

// Email Script Begin

 

/* <-- Remove this line

$MyName = "Mohsin Sumar";

$MyEmail = "mohsinsumar@hotmail.com";

$Subject = "$name has just signed your guestbook.";

$EmailBody = "Hello Mohsin,\n$name has just signed your guestbook available at http://www.mohsinsumar.com. THe following were the details submitted into your guestbook:\n\nName: $name\nEmail: $email\nComment:\n$comments\n";

 

$EmailFooter = "~~~~~~~~~~~~~~~\nThe guestbook was signed by $name and thus this email got activated by $name from $REMOTE_ADDR from http://www.mohsinsumar.com\n~~~~~~~~~~~~~~~\nThanking you,\nMohsin Sumar";

 

$Message = $EmailBody.$EmailFooter;

 

mail($MyName." <".$MyEmail.">",$Subject, $Message, "From: ".$name." <".$email.">");

--> Remove this line */

 

// Email Script End

 

print "&gb_status=Thank you for signing my guestbook.&done=yes&";

return;

}

print "&_root.write.gb_status=Error!&";

break;

  }

?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.