plomma Posted April 12, 2008 Share Posted April 12, 2008 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; } ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.