如果value = given参数，则停止将条目添加到mysql数据库

Question

I am building a database of latest tracks played on a station and I do not want entries with the station name being added to the database.

I know that I will need to use if else and else if because of what I want to do as I am already checking if entry exists with if and else so am just looking for some pointers on how to stop entries being added if radio name is in the $trackartist field

I know I need to do something along the lines of if $trackartist = station name do nothing else check if entry exists else if do the insert.

Here is the code I am using to fill the rows.

include('config.php');

$str = file_get_contents('xxxxxxxx.xxx');
$json = json_decode($str, true);
$artist = $json['now_playing']['artist'];
$track = $json['now_playing']['track']; 
$cover = $json['cover'];

$check = mysqli_query($mysqli,"select * from recent where      trackartist='$artist' and tracktitle='$track' and coverurl='$cover'");
$checkrows=mysqli_num_rows($check);

if($checkrows>0) {
  echo "track exists";
} else {  

  $sql = "INSERT IGNORE INTO recent (trackartist, tracktitle, coverurl)
  VALUES ('$artist', '$track', '$cover')";
  $result = mysqli_query($mysqli, $sql) or die('Error querying   database.');

  mysqli_close($mysqli);
 };

Answer 1

Just nest all of your code in an if statement:

if($artist != "Station Name"){

    $check = mysqli_query($mysqli,"select * from recent where      trackartist='$artist' and tracktitle='$track' and coverurl='$cover'");
    $checkrows=mysqli_num_rows($check);

    if($checkrows>0) {
      echo "track exists";
    } else {  

      $sql = "INSERT IGNORE INTO recent (trackartist, tracktitle, coverurl)
      VALUES ('$artist', '$track', '$cover')";
      $result = mysqli_query($mysqli, $sql) or die('Error querying   database.');

      mysqli_close($mysqli);
     };

 }

This will run your code as long as $artist does not equal whatever string you substitute for "Station Name" if it does match this code will do nothing.

You could also block multiple things if you want like this:

$starray = array("Station Name 1","Station Name 2","Station Name 3");

then change if($artist != "Station Name") to if(!in_array($artist,$starray))