Advertisement
Guest User

PHP - MySQL - Testing POC

a guest
Nov 18th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.35 KB | None | 0 0
  1. <?php
  2.  
  3.  
  4. if($_POST['select'] and $_SERVER['REQUEST_METHOD'] == "POST")
  5. {
  6.     //select();
  7.     echo "select click";
  8. }
  9.  
  10.  
  11. if($_POST['insert'] and $_SERVER['REQUEST_METHOD'] == "POST")
  12. {
  13.     //get data from from elements
  14.     // testing data
  15.     $connClass = new dbConnection();
  16.  
  17.     $userName = "Name Test";
  18.     $phoneNum = "(405)555-1234";
  19.     $address = "123 fake st";
  20.  
  21.     $sql = sprintf("INSERT INTO php_test (userName, phone, address)
  22.         VALUES ('%s', '%s', '%s')", $userName, $phoneNum, $address);
  23.  
  24.     $connClass->insertData($sql);
  25. }
  26.  
  27.  
  28.  
  29. class dbConnection
  30. {
  31.  
  32.     private $servername = "127.0.0.1";
  33.     private $username = "root";
  34.     private $password = "password";
  35.     private $dbname = "php_local_testing";
  36.  
  37.     public $link;
  38.  
  39.     private $result;
  40.  
  41.     function __construct()
  42.     {
  43.         // Create connection
  44.         $this->link = new mysqli($this->servername, $this->username, $this->password, $this->dbname);
  45.  
  46.         // Check connection
  47.         if ($this->link->connect_errno)
  48.         {
  49.             echo "Connection Error\n";
  50.             die("Connection failed: " . $this->link->connect_error);
  51.         }
  52.  
  53.  
  54.         return $this->link;
  55.     }
  56.  
  57.  
  58.     function insertData($sql)
  59.     {
  60.  
  61.         if ($this->link->query($sql) === TRUE)
  62.         {
  63.             echo "New record created successfully";
  64.         } else {
  65.             echo "Error: " . $sql . "<br>" . $this->link->error;
  66.         }
  67.  
  68.  
  69.     }
  70.  
  71.  
  72.     function __destruct()
  73.     {
  74.         $this->link->close();
  75.     }
  76.  
  77. }
  78.  
  79.  
  80. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement