避免在MYSQL数据库中重复? [英] Avoid duplicates in MYSQL database?
本文介绍了避免在MYSQL数据库中重复?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
如何避免将重复值插入数据库?
下面的代码插入到数据库中,但是我不希望单独的行,例如,具有名称alan的用户ID和另一行说不同的名称,我希望它是userID和名称相关联的一个
有人可以帮忙吗?
我尝试过的事情:
Hi
How to avoid inserting duplicate values into a database?
Below code inserts into database, but I don't want separate rows for example, have User ID with name alan and another row saying a different name, i want it to be userID and names associated in one
Can someone help?
What I have tried:
try{
$stmt = $conn->prepare('INSERT INTO favourites (nameID,UserID) VALUES (:nameID, :UserID);');
$stmt->execute(array(
':nameID' =>$_POST['nameID'],
':UserID' =>$_POST['UserID']
));
$count = $stmt->rowCount();
if($count > 0 )
{
echo "<span style='font-size:100%;color:red;'>❤️";
}
else {
echo "unsuccessful";
}
}
catch(PDOException $error)
{
echo $error->getMessage();
}
?>
推荐答案
stmt =
conn - > prepare('INSERT INTO favorites(nameID,UserID)VALUES(:nameID,:UserID);');
conn->prepare('INSERT INTO favourites (nameID,UserID) VALUES (:nameID, :UserID);');
stmt-> execute(array(
') :nameID'=>
stmt->execute(array( ':nameID' =>
这篇关于避免在MYSQL数据库中重复?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文