/exam7/crud/src/bitm/seip131181/semister/Semister.php

https://gitlab.com/mehedi-xion/web_apps_php_26 · PHP · 164 lines · 86 code · 75 blank · 3 comment · 17 complexity · 07e2b79664be1a0699fa8b183ff1f745 MD5 · raw file 

    

  1. <?php 
    2. 

  2. 

  3. namespace SemisterApp\bitm\seip131181\mobile ;
    4. 

  4. 

  5. /**
    6. 

  6. * class for Semister App
    7. 

  7. */
    8. 

  8. class Semister
    9. 

  9. {
    10. 

  10. 	public $id = '';
    11. 

  11. 	public $name = '';
    12. 

  12. 	public $semister = '';
    13. 

  13. 	public $offer = '';
    14. 

  14. 	public $cost = '';
    15. 

  15. 	public $waiver = '';
    16. 

  16. 	public $total = '';
    17. 

  17. 	public $data = '';
    18. 

  18. 

  19. 	
    20. 

  20. 	function __construct()
    21. 

  21. 	{
    22. 

  22. 		session_start();
    23. 

  23. 

  24. 		$sql_conn = mysql_connect('localhost', 'root', '') or die("ups! not connect to database");
    25. 

  25. 

  26. 		mysql_select_db('web_apps_php_26') or die("Wrong Database name");
    27. 

  27. 	}
    28. 

  28. 

  29. 

  30. 

  31. 

  32. 	public function prepare($data = ''){
    33. 

  33. 

  34. 		if(array_key_exists('fname', $data)){
    35. 

  35. 			$this->name = $data['fname'];
    36. 

  36. 		}
    37. 

  37. 		if(array_key_exists('semister', $data)){
    38. 

  38. 			$this->semister = $data['semister'];
    39. 

  39. 		}
    40. 

  40. 		if(array_key_exists('offer', $data)){
    41. 

  41. 			$this->offer = $data['offer'];
    42. 

  42. 		}
    43. 

  43. 		if(array_key_exists('id', $data)){
    44. 

  44. 			$this->id = $data['id'];
    45. 

  45. 		}
    46. 

  46. 

  47. 		if($this->semister == '1st Semister'){ $this->cost = 8000;}
    48. 

  48. 		if($this->semister == '2nd Semister'){ $this->cost = 12000;}
    49. 

  49. 		if($this->semister == '3rd Semister'){ $this->cost = 16000;}
    50. 

  50. 

  51. 		if($this->offer == "offered"){$this->waiver = ($this->cost * 10)/100;}else{
    52. 

  52. 			$this->offer = "Not Offered";
    53. 

  53. 			$this->waiver = 0;
    54. 

  54. 		}
    55. 

  55. 

  56. 		if ($this->offer == "Not Offered") {
    57. 

  57. 			$this->waiver = 0;
    58. 

  58. 		}
    59. 

  59. 

  60. 		$this->total = ($this->cost - $this->waiver);
    61. 

  61. 			
    62. 

  62. 		return $this ;
    63. 

  63. 

  64. 

  65. 

  66. 	}// prepare \\
    67. 

  67. 

  68. 

  69. 

  70. 	public function store(){
    71. 

  71. 

  72. 

  73. 		$query = "INSERT INTO `web_apps_php_26`.`semister` (`id`, `name`, `semister`, `offer`, `cost`, `waiver`, `total`, `unique_id`) VALUES (NULL, '$this->name', '$this->semister', '$this->offer', '$this->cost', '$this->waiver', '$this->total','".uniqid()."')";
    74. 

  74. 

  75. 		if(mysql_query($query)){
    76. 

  76. 

  77. 			$_SESSION['Message'] = " Data Added Succesfully ";
    78. 

  78. 		}
    79. 

  79. 		header("location:creat.php");
    80. 

  80. 

  81. 

  82. 	} // store \\
    83. 

  83. 

  84. 

  85. 

  86. 

  87. 

  88. 

  89. 	public function index(){
    90. 

  90. 

  91. 		$query = "SELECT * FROM `semister` ";
    92. 

  92. 

  93. 		$result = mysql_query($query);
    94. 

  94. 

  95. 		while($row = mysql_fetch_assoc($result)){
    96. 

  96. 

  97. 			$this->data[] = $row;
    98. 

  98. 		}
    99. 

  99. 		return $this->data;
    100. 

  100. 

  101. 	} // index \\
    102. 

  102. 

  103. 

  104. 

  105. 

  106. 

  107. 	public function show(){
    108. 

  108. 

  109. 		$query = "SELECT * FROM `semister` WHERE unique_id = '".$this->id."' ";
    110. 

  110. 		
    111. 

  111. 		$result = mysql_query($query);
    112. 

  112. 

  113. 		$row = mysql_fetch_assoc($result);
    114. 

  114. 

  115. 		return $row;
    116. 

  116. 

  117. 	} // show \\
    118. 

  118. 

  119. 

  120. 

  121. 

  122. 

  123. 	public function update(){
    124. 

  124. 

  125. 			$query = "UPDATE `web_apps_php_26`.`semister` SET `name` = '$this->name', `semister` = '$this->semister', `offer` = '$this->offer', `cost` = '$this->cost', `waiver` = '$this->waiver', `total` = '$this->total' WHERE `semister`.`unique_id` = '".$this->id."'";
    126. 

  126. 			if($result = mysql_query($query)){
    127. 

  127. 

  128. 				$_SESSION['UpdtMsg'] = "Data Updated Successfully";
    129. 

  129. 			}
    130. 

  130. 			header("location:edit.php?id=$this->id");
    131. 

  131. 

  132. 	}// update \\
    133. 

  133. 

  134. 

  135. 

  136. 

  137. 	public function delete(){
    138. 

  138. 

  139. 		$query = "DELETE FROM `web_apps_php_26`.`semister` WHERE `semister`.unique_id = '".$this->id."' ";
    140. 

  140. 		
    141. 

  141. 		if($result = mysql_query($query)){
    142. 

  142. 

  143.                                             $_SESSION['UpdtMsg'] = "Data Updated Successfully";
    144. 

  144. 		}
    145. 

  145. 		header("location:edit.php?id=$this->id");
    146. 

  146.         
    147. 

  147. 

  148. 

  149. 	} // Delete\\
    150. 

  150. 

  151. 

  152. 

  153. 

  154. }// class \\
    155. 

  155. 

  156. 

  157. 

  158. ?>
    159. 

  159. <!DOCTYPE html>
    160. 

  160. <html>
    161. 

  161. <head>
    162. 

  162. 

  163. <!-- Latest compiled and minified CSS -->
    164. 

  164. <link rel="stylesheet" href="../../../../style.css">
    165.