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
update sql when refresh - php
hi
I have made a table (attachement)
the users can update the sql database using + or x bu
Firewall / visited websites logger
Hi.
I have a firewall implementation and I want to log all the websites visited on the machine. S
how do I show what a user have selected from a checkbox?
From my code below, how would i show which check boxes have been checked and which radio buttons sel
Working with popups and such in a class
I've recently started building my applications completely enclosed in classes. I like the fact that
Session variable help
I'm having a very troubling issue. Maybe I'm just looking over something but I have looked at the co
Varible in trigger - refering to correct schema
Hello
Im having some issues with my trigger.
What I want to do is call opon a differ
asp authentication problem
Hello all,
I want to use the asp authentication (from asp.net configuration) in my web site. there
Help with form post data and arrays
Hi all,
I am new to this forum... It has been awhile since i have worked with arrays, and i a
Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to
Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou
