fork download
copy 
  1. <?php
  2. session_start();
  3. Class Action {
  4. 	private $db;
  5.  
  6. 	public function __construct() {
  7. 		ob_start();
  8.    	include 'db_connect.php';
  9.  
  10.     $this->db = $conn;
  11. 	}
  12. 	function __destruct() {
  13. 	    $this->db->close();
  14. 	    ob_end_flush();
  15. 	}
  16.  
  17. 	function login(){
  18. 		extract($_POST);
  19. 		$qry = $this->db->query("SELECT * FROM users where email = '".$email."' and password = '".md5($password)."' ");
  20. 		if($qry->num_rows > 0){
  21. 			foreach ($qry->fetch_array() as $key => $value) {
  22. 				if($key != 'passwors' && !is_numeric($key))
  23. 					$_SESSION['login_'.$key] = $value;
  24. 			}
  25. 				return 1;
  26. 		}else{
  27. 			return 3;
  28. 		}
  29. 	}
  30. 	function logout(){
  31. 		session_destroy();
  32. 		foreach ($_SESSION as $key => $value) {
  33. 			unset($_SESSION[$key]);
  34. 		}
  35. 		header("location:login.php");
  36. 	}
  37. 	function signup(){
  38. 		extract($_POST);
  39. 		$data = " firstname = '$firstname' ";
  40. 		$data .= ", lastname = '$lastname' ";
  41. 		$data .= ", middlename = '$middlename' ";
  42. 		$data .= ", contact = '$contact' ";
  43. 		$data .= ", address = '$address' ";
  44. 		$data .= ", email = '$email' ";
  45. 		$data .= ", password = '".md5($password)."' ";
  46. 		$chk = $this->db->query("SELECT * FROM users where email = '$email' ")->num_rows;
  47. 		if($chk > 0){
  48. 			return 2;
  49. 			exit;
  50. 		}
  51. 			$save = $this->db->query("INSERT INTO users set ".$data);
  52. 		if($save){
  53. 			$login = $this->login();
  54. 			if($login == 1)
  55. 			return 1;
  56. 		}
  57. 	}
  58.  
  59. 	function save_upload(){
  60. 		extract($_POST);
  61. 		$ids= array();
  62. 		for($i = 0 ; $i< count($img);$i++){
  63. 			$img[$i]= str_replace('data:image/jpeg;base64,', '', $img[$i] );
  64. 			$img[$i] = base64_decode($img[$i]);
  65. 			$fname = strtotime(date('Y-m-d H:i'))."_".$imgName[$i];
  66. 			$upload = file_put_contents("assets/img/uploads/".$fname,$img[$i]);
  67. 			$data = " file_path = 'img/uploads/".$fname."' ";
  68. 			$data .= ", user_id = '".$_SESSION['login_id']."' ";
  69. 			$save[] = $this->db->query("INSERT INTO file_uploads set".$data);
  70. 			$ids[] = $this->db->insert_id;
  71. 		}
  72. 		if(isset($save)){
  73. 			if($type == 1){
  74. 				$data = " user_id = '".$_SESSION['login_id']."' ";
  75. 				$data .= ", content = '$content' ";
  76. 				$data .= ", file_ids = '".implode(",",$ids)."' ";
  77. 				$save = $this->db->query("INSERT INTO posts set".$data);
  78. 			}
  79. 			return 1;
  80. 		}
  81. 	}
  82. 	function save_comment(){
  83. 		extract($_POST);
  84.  
  85. 		$data = " post_id = $post_id ";
  86. 		$data .= ", user_id = ".$_SESSION['login_id']." ";
  87. 		$data .= ", comment = '$comment' ";
  88.  
  89. 		$save = $this->db->query("INSERT INTO comments set ".$data);
  90. 		if($save){
  91. 			$id = $this->db->insert_id;
  92. 			$data = $this->db->query("SELECT c.*,concat(u.firstname,' ',u.middlename,' ',u.lastname) as uname FROM comments c inner join users u on u.id = c.user_id where c.id = $id ")->fetch_array();
  93. 			foreach($data as $k=>$v){
  94. 				if(!is_numeric($k))
  95. 				$c[$k] = $v;
  96. 			}
  97. 			$d['user'] = ucwords($c['uname']);
  98. 			$d['comment'] = $comment;
  99. 			$d['date'] = date("M d,Y",strtotime($c['date_created']));
  100. 			return json_encode(array("status"=>1,"data"=>$d));
  101. 		}
  102. 	}
  103. 	function save_posts(){
  104. 		extract($_POST);
  105.  
  106. 		$data = " user_id = ".$_SESSION['login_id']." ";
  107. 		$data .= ", content = '$content' ";
  108. 		$data .= ", file_ids = '$file_id' ";
  109.  
  110. 		$save = $this->db->query("INSERT INTO posts set ".$data);
  111. 		if($save){
  112. 			return 1;
  113. 		}
  114. 	}
  115. }
Success #stdin #stdout 0.04s 25564KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
https://ideone.com/MgCHgT
language:
PHP (php 7.3.5)
created:
1 year ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!