StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Use <a href="http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_inet-aton" rel="nofollow">INET_ATON</a> to store and INET_NTOA when retrieving:</p> <pre><code><?php ob_start(); // check if the review form has been sent if(isset($_POST['review_content'])) { if(isset($_POST['review_recipient'])) { $content = $_POST['review_content']; $review_recipient = $_POST['review_recipient']; //We remove slashes depending on the configuration if(get_magic_quotes_gpc()) { $content = stripslashes($content); $review_recipient = stripslashes($review_recipient); } $regex = "/(https?:\/\/)?([\da-z\.-]+)\.([a-z\.]{2,6})([\/\w\.-]*)*\/?/"; $replacement = "[blocked url]"; $regex2 = "/(.*)\b(BLOCKED WORDS GO HERE!!!!)\b(.*)/"; $replacement2 = "[blocked content]<br/><br/>This content was blocked because it was deemed offensive or inappropriate."; $replacement3 = "[blocked username]"; $review_recipient = preg_replace(Array($regex, $regex2),Array($replacement, $replacement3),$_POST['review_recipient']); //$profile_id = intval($_POST['profile_id']); //dont know how you get this $content = preg_replace(Array($regex, $regex2),Array($replacement, $replacement2),$_POST['review_content']); //We check if all the fields are filled if($_POST['review_content']!='') { if($_POST['review_recipient']!='') { $sql = "INSERT INTO ptb_reviews (id, from_user_id, from_guest, ip, to_user_id, content) VALUES (NULL, '-1', '".$review_recipient."', 'INET_ATON(" . $_SERVER['REMOTE_ADDR'] . "'), '".$profile_id."', '".$content."');"; mysql_query($sql, $connection); $_SESSION['message']="<div class=\"infobox-review-sent\"><strong>Thank You</strong> - Your review has been sent and is awaiting approval.</div><div class=\"infobox-close4\"></div>"; header("Location: {$_SERVER['HTTP_REFERER']}"); } } } } } } ?> </code></pre> <p>Do be aware, though, this will not work if you're using IPv6. If that is the case, the INET6_ATON and INET6_NTOA functions will be necessary.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload