How to break duplicate entry in php How to break duplicate entry in php How to break duplicate entry in php How to break duplicate entry in php How to break duplicate entry in php
HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php HOw to break duplicate entry in php
$sqlww="SELECT c_mobile FROM tbl_bd_leads WHERE c_mobile='$emailid1' LIMIT 1";
$check_query1=mysqli_query($conn,$sqlww);
$count_email1=mysqli_num_rows($check_query1);
if($count_email1>0)
{
} else{
echo $queryff .= "INSERT INTO tbl_bd_leads(c_name, c_email, c_mobile,company_type,c_full_address,c_city,c_state,requirement,product_name,from_date,incoming_time,bd_id,company_id,source_website,leads_souece_date) VALUES ('".$row144["name"]."', '', '".$row144["mobile"]."','','','".$row144["city"]."','','$reqiure','','$datee1','$incoming_time','5','4','scotbeauty leads','".$row1["DATE_TIME_RE"]."'); "; // Make Multiple Insert Query
}
<?php
//$conn=mysqli_connect('localhost','root','','computer');
$servername = "localhost";
$username = "root";
$password = "";
try {
$conn = new PDO("mysql:host=$servername;dbname=computer", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected successfully";
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
$runsql=$conn->query("SELECT * FROM class");
$alldata=$runsql->fetchAll(PDO::FETCH_ASSOC);
foreach ($alldata as $value) {
// code...
$full_name=$value['name'];
$Userid=$value['id'];
$runsqld=$conn->query("SELECT user_id FROM tbl_users WHERE user_id='$Userid'");
$count = $runsqld->rowCount();
if($count>0){
}else{
$sqlinser=$conn->query("INSERT INTO tbl_users(full_name,user_id)VALUES('$full_name','$Userid')");
}
}
?>
Comments
Post a Comment