<?php 
require '../config/settings.inc.php';
 
 // Hostname: 127.0.0.1, username: your_user, password: your_pass, db: sakila
 $mysqli = new mysqli(_DB_SERVER_, _DB_USER_, _DB_PASSWD_, _DB_NAME_);
 
 // Oh no! A connect_errno exists so the connection attempt failed!
 if ($mysqli->connect_errno) {
     // The connection failed. What do you want to do?
     // You could contact yourself (email?), log the error, show a nice page, etc.
     // You do not want to reveal sensitive information
 
     // Let's try this:
     echo "Sorry, this website is login experiencing problems.";
     // Something you should not do on a public site, but this example will show you
     // anyways, is print out MySQL error related information -- you might log this
     echo "Error: Failed to make a MySQL connection, here is why: \n";
     echo "Errno: " . $mysqli->connect_errno . "\n";
     echo "Error: " . $mysqli->connect_error . "\n";
 
     // You might want to show them something nice, but we will simply exit
     exit;
 }

 
$sql = "SELECT *
           FROM ps_orders
           ORDER by id_order DESC";
 //$sql="DELETE FROM ps_orders WHERE id_order=295 LIMIT 1";
 
 $sql= "SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE   TABLE_NAME   = 'ps_orders'";

//$sql= "ALTER TABLE `ps_orders` AUTO_INCREMENT = 295";
 if (!$result = $mysqli->query($sql)) {
     echo "Sorry, the website is experiencing problems.";
     exit;
 }
while ($cust = $result->fetch_assoc()) {
	print_r($cust);
}