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

Popular posts from this blog

how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php

How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python