Question

How to avoid duplicate long text entries in MySQL with PHP

Answer 1

$con = mysql_connect($db_host, $db_user, $db_pass) or die('Unable to establish a DB connection');
mysql_select_db($db_database_name, $con);

// in MySQL: post text utf8_unicode_ci 	

$result = mysql_query("SELECT post FROM table_posts WHERE md5(post)='".md5($_POST['new-post'])."'");

if (mysql_num_rows($result) == 0)
{

    $result = mysql_query("INSERT INTO table_posts(post, add_date)
        VALUES(
        '".$_POST['new-post']."',
        NOW()
        )", $con);

    if ( !$result )
        die("Line: " . __LINE__  . " Error: ". mysql_error()); 
}

70+ SQL courses for beginners and professionals