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 
20 
Other forums
Passing an array of values From VB6.0 to Oracle PL/SQL Function
Basically we are using VB6.0.
When we try to pass an array from VB6.0 to an Oracle PL/SQL
Secure FTP
Hi experts,
There is no SFTP action in MII workbench.
This means it needs developing custo
Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in
Storing the referrer in session... problems with tabs
Hello All
I am currently working on an ERP project based on the MVC methodology, when a user
Why does my crawler script suddenly end with no error?
Hi.
I have written a web crawler script. It will visit a large number of URL's with cURL.
Not Inserting into DB
I can't get my Add new Division form to submit to the database. Anyone see my issue?
Code: &a
Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every
How to refresh a parent page from a modal popup
Hi,I have a modal popup in which I need to upload a file and store in the database should give a mes
please help
HTML Code:
Code: <span id="ctl00"><span>
private constructor
Hello,
Can we create a constructor as private? If yes, what is the use of it? If no, why can'
