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.
Line number On/Off | Expand/Contract <!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
317 Like 20 Dislike
Previous forums Next forums
Other forums

Storing/displaying image urls in a database?
Hi
Basically I have the following scenario:
User chooses picture from list. Picture info is ad

Why does first ever HttpSendRequest take longer?
I promise this isn't as simple as it sounds. I'm wondering why the the first ever call to HttpSendRe

Count on multidimensional array
Hi, i got an array as below:

Array
(
=> Array
(

download directory onto C drive
I am attempting (if this is possible) to write a routine to automatically dump the contents of a dir

FROM_UNIXTIME($phpdate);
Hello,

I tried to use this :

$date = FROM_UNIXTIME($phpdate);

ANd I was t

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

Basic Question Regarding PHP Includes
Hi

Just starting out with PHP.

Working on a site that uses some basic includes, these

Recording popularity by day, week.. all time?
Hey everyone, I'm creating a site designed around users uploading music. How can I implement a syste

WORDPRESS - Multiple Loops Only Going to One Post?
I have various pages with multiple loops and i need them to be individual to all other categories.

Can I call a class inside a function?
I have a class written in another file that handles my image resizing.

Can I do this (php say

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash