Need help with an email blocker for a guessbook
Posted on
16th Feb 2014 07:03 pm by
admin
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of the same email. I know I need to do an IF statement but I am kinda foggy on how to do the code.
What I want to do is make an file that has email address that I want to block and code to call it up to make sure the people that are signing it is not one of the spamers.
Here is my code for the page. Just need help on where to nest the code to call up the blocked email to stop them from posting.
Also if any one knows how to disable html coding from being displayed as well would be helpful.
Code: [Select]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Feed Back</title>
<? include "data/head.php"; ?>
<body>
<center>
<table width="700" border=".01" cellspacing="0" cellpadding="0">
<tr>
<td height="182" align="center" valign="bottom">
<P ALIGN=CENTER><P ALIGN=CENTER><IMG SRC="Images/title/feedback2.gif" NAME="graphics10" ALT="About Me" ALIGN=BOTTOM WIDTH=500 HEIGHT=100 BORDER=0>
</p>
<?php include "data/menu.php"; ?>
</td></tr>
<tr>
<td height="1050" align="left" valign="top">
<center><h2>Feedback Form</h2></center>
<p>Share your feedback with me.</p>
<form method="post" action="feedback.php">
<label for="firstname">First name:</label>
<input type="text" name="firstname" /><br />
<label for="lastname">Last name:</label>
<input type="text" name="lastname" /><br />
<label for="email">What is your email address?</label>
<input type="text" name="email" /> Required<br />
<label for="like">Do you like my website, if no please tell me why?</label>
Yes <input name="like" type="radio" value="does" />
No <input name="like" type="radio" value="does not" /><br />
<label for="message">Your Feed Back</label>
<textarea rows="8" cols="40" wrap="virtual" name="message"></textarea><br />
<input type="submit" value="Submit Feedback" name="submit" />
</form>
<br />
<?php
$first_name = $_POST['firstname'];
$last_name = $_POST['lastname'];
$email = $_POST['email'];
$like = $_POST['like'];
$message = $_POST['message'];
$dbc = mysqli_connect('172.23.50.3', 'username', 'password', 'website')
or die('Error connecting to MySQL server.');
if (!empty($email)) {
$query = "INSERT INTO feedback (first_name, last_name, email, `like`, message) " .
"VALUES ('$first_name', '$last_name', '$email', '$like', '$message')";
$result = mysqli_query($dbc, $query)
or die('Error querying database.');
}
else {
}
// Retrieve data base
$query = "SELECT * FROM feedback" ;
$data = mysqli_query($dbc, $query);
// Loop through the array of payment data
while ($row = mysqli_fetch_array($data)) {
// Display the payment data
echo '<strong>' .$row['last_name'] . ' ' . $row['first_name'] . '</strong><br />' ;
echo 'This person ' . $row['like'] . ' like this site. <br />';
echo '<strong>What this person had to say:</strong>' . '<br />';
echo $row['message'] . '<br />';
echo '<br />' ;
}
mysqli_close($dbc);
?>
</td>
</tr>
<tr>
<td colspan="2" height="280"valign="top"><p align="center">
<?php include "data/footer.php";?>
</td>
</tr>
</table>
</body>
</html>
Thanks
No comments posted yet
Your Answer:
Login to answer
291
36
Other forums
Print 'a' to 'z' via for loop
A very simple problem..
How Can I print a to z NOT a to y ?
It is a part of a code where
<
Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d
UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the
retrieving more than one max key from an array?
so i have an array of 20 numerical values (0-100) that i need to order from highest to lowest and th
i want run some web server under the ip sharer
hello i want run some web server under the ip sharer
my ip is floating ip but it doesnt matter
Grids not displaying decimals, and behaving differently on different PCs?
Hello,
I coded a relatively simple MII application that allows data from a form to be add
Convert .fdf to .pdf
I currently have a web form that uploads the form data to an .fdf file and emails it.
However
Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.
I
BSP Ext - tableView - Sort - NEWBIE
Hi,
I have been trying to get the sort to work. I have defined the column definitions by fillin
Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of t