使用.php将数据写入数据库

Question

Can someone point the fault in this code? I'm unable to update data to the database. We are sending a text message to the server, and this file here decodes and sets it in the database. But this case over here is not working for some reason. I checked and tried to troubleshoot, but couldn't find a problem.

case 23:
  // Gather Variables
  $Message = preg_replace("/\s+/","%20", $Message);

  $UnixTime = time();
  $cycle = explode(":", $Message);
  $machine_press = $cycle[0];
  $machine_pct_full = $machine_press/20;
  $machine_cycles_return = $cycle[1];
  $machine_cycles_total = $cycle[2];

 // Build SQL Statement to update static values in the machine table
 $sql = "UPDATE `machines` SET `machine_last_run`=".$UnixTime.",`machine_press`=".$machine_press.",`machine_pct_full`=".$machine_pct_full.",`machine_cycles_return`=".$machine_cycles_return.",`machine_cycles_total`=".$machine_cycles_total." WHERE `machine_serial`='$MachSerial'";

 // Performs the $sql query on the server to update the values
 if ($conn->query($sql) === TRUE) {
   // echo 'Entry saved successfully<br>';
 } else {
    echo 'Error: '. $conn->error;
 }


  $sql = "INSERT INTO `cycles` (`cycle_sequence`,`cycle_timestamp`,`cycle_did`,`cycle_serial`,`cycle_03_INT`,`cycle_14_INT`,`cycle_15_INT`,`cycle_18_INT`)";
  $sql = $sql . "VALUES ($SeqNum,$UnixTime,'$siteDID','$MachSerial',$machine_press,$machine_cycles_total,$machine_cycles_return,$machine_pct_full)";

  // Performs the $sql query on the server to insert the values
  if ($conn->query($sql) === TRUE) {
    // echo 'Entry saved successfully<br>';
  } else {
    echo 'Error: '. $conn->error;
  }

break;

Answer 1

More information is required to help you out with your issue.

First, to display errors, edit the index.php file in your Codeigniter project, update where it says

define('ENVIRONMENT', 'production');

to

define('ENVIRONMENT', 'development');

Then you'll see exactly what the problem is. That way you can provide the information needed to help you.