1  <?php
   2 $servername = "localhost";
   3 $username = "username";
   4 $password = "password";
   5 $id = $POST["code"]
   6 
   7 // Create connection
   8 $conn = new mysqli($servername, $username, $password);
   9 // Check connection
  10 if ($conn->connect_error) {
  11     die("Connection failed: " . $conn->connect_error);
  12 }
  13 
  14 // Create database
  15 $sql = "SELECT * FROM table WHERE id='$id'";
  16 if ($conn->query($sql) === TRUE) {
  17     echo "Query successfully";
  18 } else {
  19     echo "Error creating database: " . $conn->error;
  20 }
  21 
  22 $conn->close();
  23 ?>

   1 <?php
   2 // Try and connect to the database
   3 $connection = mysqli_connect($host,$username,$password,$dbname);
   4 
   5 // If connection was not successful, handle the error
   6 if($connection === false) {
   7 // Handle error - notify administrator, log to a file, show an error screen, etc.
   8 }
   9 ?>

   1 <?php
   2 // Load configuration as an array. Use the actual location of your configuration file
   3 $config = parse_ini_file('/ROOT/../config.ini');
   4 
   5 // Try and connect to the database
   6 $connection = mysqli_connect($config['host'],$config['username'],$config['password'],$config['dbname']);
   7 
   8 // If connection was not successful, handle the error
   9 if($connection === false) {
  10     // Handle error - notify administrator, log to a file, show an error screen, etc.
  11 }
  12 ?>

   1 <?php
   2 class Db {
   3     // The database connection
   4     protected static $connection;
   5 
   6     /**
   7      * Connect to the database
   8      *
   9      * @return bool false on failure / mysqli MySQLi object instance on success
  10      */
  11     public function connect() {
  12         // Try and connect to the database
  13         if(!isset(self::$connection)) {
  14             // Load configuration as an array. Use the actual location of your configuration file
  15             $config = parse_ini_file('/ROOT/../config.ini');
  16             self::$connection = new mysqli('localhost',$config['username'],$config['password'],$config['dbname']);
  17         }
  18 
  19         // If connection was not successful, handle the error
  20         if(self::$connection === false) {
  21             // Handle error - notify administrator, log to a file, show an error screen, etc.
  22             return false;
  23         }
  24         return self::$connection;
  25     }
  26 ?>

   1 <?php
   2 // Connect to the database
   3 $connection = db_connect();
   4 
   5 // Query the database
   6 $result = mysqli_query($connection,$query);
   7 ?>

   1 <?php
   2 public function query($query) {
   3     // Connect to the database
   4     $connection = $this -> connect();
   5 
   6     // Query the database
   7     $result = $connection -> query($query);
   8 
   9     return $result;
  10     }
  11 ?>

   1 <?php
   2 function db_select($query) {
   3     $rows = array();
   4     $result = db_query($query);
   5 
   6     // If query failed, return `false`
   7     if($result === false) {
   8         return false;
   9     }
  10 
  11     // If query was successful, retrieve all the rows into an array
  12     while ($row = mysqli_fetch_assoc($result)) {
  13         $rows[] = $row;
  14     }
  15     return $rows;
  16 }
  17 ?>

   1 <?php
   2 function db_quote($value) {
   3     $connection = db_connect();
   4     return "'" . mysqli_real_escape_string($connection,$value) . "'";
   5 }
   6 ?>

   1 <?php 
   2 
   3 /**
   4  * Database wrapper for a MySQL with PHP tutorial
   5  * 
   6  * @copyright Eran Galperin
   7  * @license MIT License
   8  * @see http://www.binpress.com/tutorial/using-php-with-mysql-the-right-way/17
   9  */
  10 class Db {
  11         // The database connection
  12         protected static $connection;
  13         
  14         /**
  15          * Connect to the database
  16          * 
  17          * @return bool false on failure / mysqli MySQLi object instance on success
  18          */
  19         public function connect() {
  20                 
  21                 // Try and connect to the database
  22                 if(!isset(self::$connection)) {
  23                         // Load configuration as an array. Use the actual location of your configuration file
  24                         // Put the configuration file outside of the document root
  25                         $config = parse_ini_file('./config.ini'); 
  26                         self::$connection = new mysqli('localhost',$config['username'],$config['password'],$config['dbname']);
  27                 }
  28         
  29                 // If connection was not successful, handle the error
  30                 if(self::$connection === false) {
  31                         // Handle error - notify administrator, log to a file, show an error screen, etc.
  32                         return false;
  33                 }
  34                 return self::$connection;
  35         }
  36         
  37         /**
  38          * Query the database
  39          *
  40          * @param $query The query string
  41          * @return mixed The result of the mysqli::query() function
  42          */
  43         public function query($query) {
  44                 // Connect to the database
  45                 $connection = $this -> connect();
  46                 
  47                 // Query the database
  48                 $result = $connection -> query($query);
  49                 
  50                 return $result;
  51         }
  52         
  53         /**
  54          * Fetch rows from the database (SELECT query)
  55          *
  56          * @param $query The query string
  57          * @return bool False on failure / array Database rows on success
  58          */
  59         public function select($query) {
  60                 $rows = array();
  61                 $result = $this -> query($query);
  62                 if($result === false) {
  63                         return false;
  64                 }
  65                 while ($row = $result -> fetch_assoc()) {
  66                         $rows[] = $row;
  67                 }
  68                 return $rows;
  69         }
  70         
  71         /**
  72          * Fetch the last error from the database
  73          * 
  74          * @return string Database error message
  75          */
  76         public function error() {
  77                 $connection = $this -> connect();
  78                 return $connection -> error;
  79         }
  80         
  81         /**
  82          * Quote and escape value for use in a database query
  83          *
  84          * @param string $value The value to be quoted and escaped
  85          * @return string The quoted and escaped string
  86          */
  87         public function quote($value) {
  88                 $connection = $this -> connect();
  89                 return "'" . $connection -> real_escape_string($value) . "'";
  90         }
  91 }

   1 <?php
   2 // Quote and escape form submitted values
   3 
   4 include('./db.php');
   5 $db = new Db();  
   6 
   7 $name = $db -> db_quote($_POST['username']);
   8 $email = $db -> db_quote($_POST['email']);
   9 
  10 // Insert the values into the database
  11 $result = db -> db_query("INSERT INTO `users` (`name`,`email`) VALUES (" . $name . "," . $email . ")");
  12 
  13 $rows = $db -> db_select("SELECT * FROM `users`");
  14 
  15 foreach($rows as $row) {
  16     echo "name: ". row['name'];
  17     echo "email: ". row['email'];
  18 }
  19 
  20 ?>