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 Like 36 Dislike
Previous forums Next forums
Other forums

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

RSS feed - FeedList for WordPress
Hi,

I'm trying to alter the FeedList plugin for WordPress so that I can click on the title of

I need to increse 6hours more, and i don't know how???
I need to increse 6hours more, and i don't know how???
<tr>
<t

Help pulling in 'id' with "read more" link
I'm trying to create snippets of my articles in the cms I'm creating, and then have them redirect to

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Mastering Regular Expressions, Third Edition, is available. 
The Third Edition of Mastering Regular Expressions is available.

QuoteThis third edition is 5
Printing a webpage 
I use this to print the webpage:
                   o
Serial number of exernal hard disk/Thumbdrive 
Hi guys,

I am new tio java networking concepts.Please tel me how to get Serial
number of exernal
Files in current folder. Should be an easy fix. 
Never mind. I've asked about this before and just found  my answer. Anyway to delete this?
Printing issues with xMII 11.5 
For some reason, we have one report (and only one) that is giving us fits when trying to print.  The
Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



 
© indyaspeak.com. All Rights Reserved.
Play Free Quiz and Win Cash