Breaking News: Grepper is joining You.com. Read the official announcement!

Prevent duplicate records to a table using PHP [duplicate]

Gielyn Fernandez answered on March 17, 2022 Popularity 4/10 Helpfulness 1/10

answer Prevent duplicate records to a table using PHP [duplicate]

related php query to hide duplicate records

Prevent duplicate records to a table using PHP [duplicate]

Comment

<?php
    if(isset($_POST['submit'])) {

    //get the name and comment entered by user
    $firstName = $_POST['firstName'];
    $lastName = $_POST['lastName'];

    //connect to the database
    $dbc = mysqli_connect('host', 'username', 'password', 'dbname') or die('Error connecting to MySQL server');
    $check=mysqli_query($dbc,"select * from clients where firstname='$firstname' and lastname='$lastname'");
    $checkrows=mysqli_num_rows($check);

   if($checkrows>0) {
      echo "customer exists";
   } else {  
    //insert results from the form input
      $query = "INSERT IGNORE INTO clients(firstName, lastName) VALUES('$firstName', '$lastName')";

      $result = mysqli_query($dbc, $query) or die('Error querying database.');

      mysqli_close($dbc);
    }
    echo "Customer Added";
    };
  ?>

Popularity 4/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: php records using

Link to this answer
Share Copy Link

Contributed on Jan 07 2024

Gielyn Fernandez

0 Answers Avg Quality 2/10

Closely Related Answers

php query to hide duplicate records

Comment

For example

First, orderby grouping row and then add other orderby columns:

order by keyword, day;

second, skip the similar elements in loop:

if ($result = $mysqli->query($query)) {
    $last_keyword = null;
    // fetch associative array
    while ($row = $result->fetch_assoc()) {
        if($row["keyword"] != $last_keyword){
             // print the changed keyword
             echo $row["keyword"];
             // set the last keyword to the new keyword
             $last_keyword = $row["keyword"];
        }
        // do your other listings here
    }

    // free result set
    $result->free();
}

Popularity 9/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: records php hide recor

Link to this answer
Share Copy Link

Contributed on Mar 17 2022

Kevin

0 Answers Avg Quality 2/10

Prevent duplicate records to a table using PHP [duplicate]

Contents

More Related Answers

Prevent duplicate records to a table using PHP [duplicate]

Closely Related Answers

php query to hide duplicate records

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.