一个按钮工作，另一个没有

Question

I have two input buttons. One to set the MySQL database value to 0 the other to set it to 1. I have got the input button to succesfully set the value to 1. The select button does not do anything.

I'm using PHP, MYSQL, JQUERY, and AJAX

Here is all of my code

    <input type="submit" class="button" name="insert" value="insert"/>
    <input type="submit" class="button" name="select" value="select"/>

    <script>
    $(document).ready(function(){
        $('.button').click(function(){
            var clickBtnValue = $(this).val();
            var ajaxurl = '<?php echo BASE_URL; ?>/actions/settings.php',
            data =  {'action': clickBtnValue};
            $.post(ajaxurl, data, function (response) {
                // Response div goes here.
                alert("This is where the success message goes.");
            });
        });

    });
    </script>

settings.php

<?php

include_once (__DIR__ . "/../oc-config.php");

if (isset($_POST['action'])) {
    switch ($_POST['action']) {
        case 'insert':
            insert();
            break;
        case 'select':
            select();
            break;
    }
}

function select() {
  $site = BASE_URL;
  $link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (!$link)
  {
      die('Could not connect: ' . mysql_error());
  }

  $query = "UPDATE settings SET setting_status='0' WHERE `setting_name='CIV_REG'";

  try
  {
      $stmt = mysqli_prepare($link, $query);
      mysqli_stmt_bind_param($stmt, "i", $uid);
      $result = mysqli_stmt_execute($stmt);

      if ($result == false)
      {
          die(mysqli_error($link));
      }
  }
  catch(Exception $e)
  {
      die("Failed to run query: " . $e->getMessage());
  }

  mysqli_close($link);

  session_start();
  $_SESSION['accessMessage'] = '<div class="alert alert-success"><span>Allowed Civilian Registration</span></div>';

  sleep(1);
  header("Location:".BASE_URL."/oc-admin/settingsManagement.php");
}

function insert() {
  $site = BASE_URL;
  $link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

  if (!$link)
  {
      die('Could not connect: ' . mysql_error());
  }

  $query = "UPDATE settings SET setting_status='1' WHERE setting_name='CIV_REG'";

  try
  {
      $stmt = mysqli_prepare($link, $query);
      mysqli_stmt_bind_param($stmt, "i", $uid);
      $result = mysqli_stmt_execute($stmt);

      if ($result == false)
      {
          die(mysqli_error($link));
      }
  }
  catch(Exception $e)
  {
      die("Failed to run query: " . $e->getMessage());
  }

  mysqli_close($link);

  session_start();
  $_SESSION['accessMessage'] = '<div class="alert alert-success"><span>Allowed Civilian Registration</span></div>';

  sleep(1);
  header("Location:".BASE_URL."/oc-admin/settingsManagement.php");
}

?>

Answer 1

You have a missing backtick " ` " for the column name setting_name in your query inside the select() function change your query

from

 $query = "UPDATE settings SET setting_status='0' WHERE `setting_name='CIV_REG'";

to

$query = "UPDATE settings SET `setting_status`='0' WHERE `setting_name`='CIV_REG'";