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
ok i need to join all this pages to make 1 neat code
i have 5 pages that make up my tv guide it works 100% but i want to make it 1 page if i can or 2, i
INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc
get the country of visitor and display content based on that
Hello all,
I have seen that Google analytics can tell you where a visitor is coming from and
Calling All PHPFREAKS Blackberry Users
Are you a member of PHPFreaks and have a blackberry? Well RIM just recently released Blackberry Mes
TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.
BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery
Hi Experts,
I was able to successfully create an Inbound delivery with reference to a PO
php mysql script to find record
Hi,
Currently I have a simple table with 4 columns. A, B, C, D
If I want to find all
Create comparison matrix?
I want to create a comparison script for forum software and was wondering is there any tutorial or b
Can't shake the "Warning: include()" error
I've just uploaded my site to a new server and where I have PHP include tags in my HTML, the browser
How to ... (FAQs)
... get e-mail notifications
As several people asked how to get e-mail notifications when new posti
