25/08/2008, 11:38
|
| | | Fecha de Ingreso: febrero-2008 Ubicación: Aragua - Venezuela
Mensajes: 312
Antigüedad: 16 años, 2 meses Puntos: 1 | |
Respuesta: problema con guestbook en flash Esta es la programacion que yo tengo el cual debe ser igual a la tuya si no es molestia me gustaria que la compares:::
tomando en cuenta que
$DBPASS coloque ="1"
$DBName = "tutorials"; el original dice (((turiorials)))
Si no es asi tonces no sabria ya por donde buscar Código PHP: <? /* ----- Application: Flash-dB GuestBook Version 2.0 Details: mySQL and PHP powered GuestBook Author: Mohsin Sumar 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 = "root"; // Database User $DBpass = "1"; // Database Pass $DBName = "tutorials"; // 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 = "[email protected]"; $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; } ?> de ante mano gracias por tus aportes |