在mysql中输入我的PHP,无需重复? [英] Input my php in mysql without repeat?
本文介绍了在mysql中输入我的PHP,无需重复?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建此代码是为了在数据库中添加一些数据,而无需重复.
但这是行不通的,并且我无法将由此php创建的数据添加到我的表中.
有什么问题吗?
附注:我没有错误!
P.P.S:我是在wamp服务器上完成的.
I create this code to add some data in my db without repeat.
but that is not work and I can't add data create by this php to my table.
what's the problem ?
P.S: I have no error!
P.P.S:I do this on wamp server.
<?php
$con=mysqli_connect("localhost","root","","kosar");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
for ($i=0;$i<10;$i++) {
$n1 = rand(100000,999999);
$n2 = rand(100000,999999);
$pincode = (string)$n1;
echo $pincode;
echo nl2br("$pincode\n");
mysql_query ("INSERT IGNORE INTO kosar(ID, Code, Type, Used) VALUES('', '".$pincode."','1', '0')");
if(mysql_affected_rows() == 0)
{
// Duplicates found
}else{
// No duplicates were found
}
}
for ($i=0;$i<10;$i++) {
$n1 = rand(100000,999999);
$n2 = rand(100000,999999);
$pincode = (string)$n1;
echo $pincode;
echo nl2br("$pincode\n");
mysql_query("INSERT IGNORE INTO kosar(ID, Code, Type, Used) VALUES('', '".$pincode."','2', '0')");
if(mysql_affected_rows() == 0)
{
// Duplicates found
}else{
// No duplicates were found
}
}
for ($i=0;$i<10;$i++) {
$n1 = rand(100000,999999);
$n2 = rand(100000,999999);
$pincode = (string)$n1;
echo $pincode;
echo nl2br("$pincode\n");
mysql_query("INSERT IGNORE INTO kosar(ID, Code, Type, Used) VALUES('', '".$pincode."','3', '0')");
if(mysql_affected_rows() == 0)
{
// Duplicates found
}else{
// No duplicates were found
}
}
mysqli_close($con);
?>
推荐答案
我很惊讶这不会引发任何错误.如Barmar所述,您不能混合使用sqli
和sql
函数.
I am surprised that this does not throw any errors. One as Barmar mentioned, you cannot mix sqli
and sql
functions.
从逻辑上讲,我看不到您选择任何数据库.
Also logically, I do not see you select any database.
先尝试
$con=mysqli_connect("localhost","my_user","my_password","my_db") or die('error message');
然后使用
mysqli_query($con,"your query here");
让我知道结果.
这篇关于在mysql中输入我的PHP,无需重复?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文