Advertisement
Guest User

Untitled

a guest
Apr 17th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.53 KB | None | 0 0
  1. <form role="form" id="myform" class="countrysaveform" action="include/db_connect/actions.php" method= "POST" >
  2. <div class="form-body">
  3. <div class="form-group">
  4. <label>Cournty Name</label>
  5. <input type="text" name = "country" id="country" class="form-control" placeholder="">
  6. </div>
  7. <div class="form-group">
  8. <input type="hidden" name= "userip" id= "userip" class="form-control" value="<?php $ip=$_SERVER['REMOTE_ADDR']; echo $ip; ?>" placeholder="">
  9. </div>
  10. <div class="form-group">
  11. <label>Status</label>
  12. <select name ="status" id= "status" class="form-control">
  13. <option value="active">Active</option>
  14. <option value="inactive">Inactive</option>
  15. </select>
  16. </div>
  17. </div>
  18. <div class="form-actions">
  19. <button type="submit" name="save" id="save" class="btn blue">SAVE</button>
  20. <button type="button" class="btn default">Cancel</button>
  21. </div>
  22. </form>
  23.  
  24. <?php
  25. require 'connection.php';
  26.  
  27. //echo $current_timestamp;
  28.  
  29. class db_class extends db_connect{
  30.  
  31. public function __construct(){
  32. $this->connect();
  33.  
  34. }
  35.  
  36. public function create($country, $status, $ip ){
  37.  
  38. $stmt = $this->conn->prepare("INSERT INTO `ux_country` (`country_name`, `country_status`,`added_by_ip`,`added_date`,`added_on_time` ) VALUES (?, ?, ?, now(), now() )") or die($this->conn->error);
  39. $stmt->bind_param("sss", $country, $status, $ip);
  40. if($stmt->execute()){
  41. $stmt->close();
  42. $this->conn->close();
  43. return true;
  44. }
  45. }
  46.  
  47. <?php
  48. define('db_host', 'localhost');
  49. define('db_user', 'root');
  50. define('db_pass', '');
  51. define('db_name', 'uniquesolutions');
  52.  
  53. class db_connect{
  54. public $host = db_host;
  55. public $user = db_user;
  56. public $pass = db_pass;
  57. public $dbname = db_name;
  58. public $conn;
  59. public $error;
  60.  
  61. public function connect(){
  62. $this->conn = new mysqli($this->host, $this->user, $this->pass, $this->dbname);
  63. if(!$this->conn){
  64. $this->error = "Fatal Error: Can't connect to database" . $this->connect->connect_error();
  65. return false;
  66. }
  67. }
  68. }
  69. ?>
  70.  
  71. require_once 'class.php';
  72.  
  73. if(ISSET($_POST['save'])){
  74. $country = $_POST['country'];
  75. $status = $_POST['status'];
  76. $ip = $_POST['userip'];
  77. //$current_timestamp = date();
  78. $conn = new db_class();
  79. $conn->create($country, $status, $ip);
  80. header('location:../../Country_View.php');
  81. }
  82.  
  83. TABLE `ux_country` (
  84. `country_id` int(11) NOT NULL,
  85. `country_name` varchar(25) NOT NULL,
  86. `country_status` varchar(12) NOT NULL,
  87. `added_date` date NOT NULL,
  88. `added_on_time` time NOT NULL,
  89. `added_by_ip` varchar(20) NOT NULL
  90. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  91.  
  92. $(document).ready(function(){
  93. $('#myform').on('submit',function(e) { //Don't foget to change the id form
  94. $.ajax({
  95. url:'include/db_connect/actions.php', //===PHP file name====
  96. data:$(this).serialize(),
  97. type:'POST',
  98. success:function(data){
  99. console.log(data);
  100. //Success Message == 'Title', 'Message body', Last one leave as it is
  101. swal("¡Success!", "Message sent!", "success");
  102. },
  103. error:function(data){
  104. //Error Message == 'Title', 'Message body', Last one leave as it is
  105. swal("Oops...", "Something went wrong :(", "error");
  106. }
  107. });
  108. e.preventDefault(); //This is to Avoid Page Refresh and Fire the Event "Click"
  109. });
  110. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement