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
How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in time() format.I need a query that'll check how many players have logged in within the last
Renaming array keys
The issue: renaming array keys inside a foreach loop.I'm trying to build a pie chart image with the Google Chart API using information from a database. (I'm going to change the type of data I talk
mysql query with single quotes in a variable
$sitedetails = "INSERT INTO vars (address, sitename, description, ownername, theme) VALUES ('$url', '$sitename', '$description', '$ownername', '$theme') ";mysql_query($sitedetails) or
why does my session end?
my connect.php starts the session just so you knowi can navigate arround my site fine except when i come to this page. it lets me in but then when i try to leave no matter what page i go to or which
Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.Here are things i know.1. The data passed is passed correctly, and is correct as far as data goes.2.
MySql timezone
Code: $sql = "SELECT *, date_format(date, '%m/%d/%Y at %I:%i %p' )as date FROM comments WHERE tutorialid='1' ORDER BY commentid DESC LIMIT $offset, $rowsperpage";Can I change the timezone
Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I am coding a registration form. I ask the user a Yes/No question. Depending on the answer I have an
Needing Youtube thumb nail fix.
I have a script on a site that pulls in you-tube videos,The problem is, that the thumb nails for the site, no longer show up.I have tried to add codes to remove the line causing the problem but this
php forms and database navigatio
Hello,I'm new to php and i'd like to post the following.I have written code to get records from a DB and i need one record at a time to be filled in a form i created. Then the next record should be
Getting number of affected rows in SQLPLUS..
Hi everyone,
