Admin mode on Procurve Switches

Question

I am trying to store the local time zone of the client on the hosting home page ut I am getting this error in my android Logcat You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7 How can I do that? I tried it with date_default_timezone_set

I appreaciate any help.

<?php
 $data = json_decode ( file_get_contents ( 'php://input', true ) );


$mac = $data->{'mac'};
$latitude = $data->{'latitude'};
$longitude = $data->{'longitude'};
$route =   $data->{'route'};
$created_at = date_default_timezone_set("Europe/Berlin");


$con = new mysqli ( "domin.com", "username", "password", "ddatabase" );


// check whether route's table exist.
$results = $con->query ( "SHOW TABLES like 'bus' " ) or die ( mysqli_error () );

if (($results->num_rows) == 1) {$sql = "REPLACE INTO bus(mac, route, latitude, longitude, created_at)
          VALUES( ?, ?, ? , ?, ? )";
  $stmt = $con->prepare($sql);

  if(false === $stmt){
    echo "prepare()  failed: ";
  }

  $rc = $stmt->bind_param("sssss",$mac,$route, $latitude,$longitude, $created_at );
 echo $rc;
  if ( false===$rc ) {
  echo "bind_param() failed: ";
}

  $rc = $stmt->execute();

  if ( false===$rc ) {
 echo "execute failed.";
  }

  $stmt->close();

} else {
  $create =  "CREATE TABLE bus
       (id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        mac VARCHAR(30) NOT NULL UNIQUE,
        route int(11) ,
     latitude FLOAT(10,6) NOT NULL , 
     longitude FLOAT(10,6) NOT NULL,
     created_at TIMESTAMP NOT NULL" ;
   $stmt = $con->prepare($create) or die ( $con->error );
  $stmt->execute();

  $stmt->close();

}

Solution

It's an HP gui-ism. It could certainly be worded better.

The Cisco equivalent is shutdown and the way that it displays a port in that state is 'Administratively disabled'.

Comments

[stefan.at.wpf]

Thanks for the feedback :-) I now really hate HP for that description ;-)

[Philip]

It's short for "Administrative Mode" (as you found Administratively Enabled or Disabled). Definitely don't assume you know what a strange term means in any network gear. The terminology is commonly left-over from when they first designed the function 20-40 years ago. Cisco's "shutdown" command is no more intuitive than HP's... they all like that.