fork download 
  1. <?php
  2. require('my_functions_pdo_good.php');
  3.  
  4. extract($_POST);
  5. $host="localhost";
  6. $db="data-control";
  7. $charset="utf8";
  8.  
  9. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  10.  $opt = array(
  11.      PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  12.      PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
  13.  );
  14.  
  15. $user="dk";
  16. $pass="12345";
  17.  
  18. $table="reg_data";
  19. $fields="*";
  20.  
  21. $pdo = new PDO($dsn, $user, $pass, $opt);
  22. // MySQL Main Database name: 1005426 
  23. // MySQL Database username: 1005426 
  24. // MySQL Database password: equal with account password 
  25. // MySQL Database host: localhost 
  26. if (isset($data)) {
  27. 	$data=parse_form_data($data);	
  28. }
  29.  
  30. $buttons='
  31. <div class="control-panel">
  32. 	<button class="btn control btn-hide" name="hide">
  33. 			<i class=" fa fa-refresh "></i> 
  34. 				На рассмотрение
  35. 	</button>
  36. 	<button class="btn control btn-show" name="show">
  37. 			<i class=" fa fa-refresh "></i> 
  38. 				Утвердить
  39. 	</button>
  40. 	<button class="btn control btn-decline" name="decline">
  41. 			<i class=" fa fa-refresh "></i> 
  42. 				Отклонить
  43. 	</button>
  44. 	<button class="btn control btn-edit" name="edit">
  45. 			<i class="fa fa-edit "></i> 
  46. 				Профиль
  47. 	</button>
  48. 	<button class="btn control btn-delete" name="delete">
  49. 			<i class="fa fa-pencil"></i> 
  50. 				Delete
  51. 	</button>
  52. </div>';
  53.  
  54. //ПРОВЕРКА НА ПОЛНОТУ ДАННЫХ
  55.  
  56. function check_data($data) {
  57.  
  58. $errors=array();
  59. 	if (empty($data['country'])) $errors['error'][]="Укажите страну";
  60. 	if (empty($data['bday'])) $errors['error'][]="Укажите дату рождения";
  61.  
  62. 	if (empty($data['link_photo'])) $errors['error'][]="Загрузите изображение";
  63. 	if (empty($data['surname'])) $errors['error'][]="Вы не ввели ФИО";
  64. return $errors;
  65. }
  66.  
  67. if ($op=="add" or $op=="update") {
  68. 	$errors=check_data($data);
  69. }
  70.  
  71.  
  72. if (empty($errors)) {
  73. switch ($op) {
  74.  
  75. 	case "source":
  76. 		$query="SELECT $fields FROM $table ORDER BY `created`";
  77. 		$stmt = $pdo->prepare($query);
  78. 		$stmt->execute();
  79. 			$data=array();
  80. 			while ($row=$stmt->fetch()) {
  81.  
  82. 				switch ($row['display']) {
  83. 					case "0":
  84. 						$row['display']='<span class="label label-hidden">На рассмотрении</span>';
  85. 					break;
  86. 					case "1":
  87. 						$row['display']='<span class="label label-active">Утвержден</span>';
  88. 					break;
  89. 					case "2":
  90. 						$row['display']='<span class="label label-declined">Отклонен</span>';
  91. 					break;
  92.  
  93. 				}
  94. 					$data[]=array(
  95. 						'id'=>$row['id'],
  96. 						'surname'=>$row['surname'],
  97. 						'country'=>$row['country'],
  98. 						'status'=>$row['display'],
  99. 						'control'=>$buttons
  100. 						);	
  101. 				} 
  102.  
  103. 				$data['success']=true;
  104.  
  105. 				echo json_encode($data);
  106. 	break;
  107.  
  108. 	case 'add':
  109. 		$last_id=update_base ($pdo, $data, $table, $op);
  110.  
  111. 		$output=array();
  112. 		$output[]=array(
  113. 					'id'=>$last_id,
  114. 					'surname'=>$data['surname'],
  115. 					'country'=>$data['country'],
  116. 					'status'=>'<span class="label label-hidden">На рассмотрении</span>',
  117. 					'control'=>$buttons
  118. 					);	
  119. 		$output['success']=true;
  120. 		echo json_encode($output);
  121.  
  122. 	break;
  123.  
  124. 	case 'hide':
  125. 		$op="update";
  126. 		$data=array("display"=>"0");
  127. 		update_base ($pdo, $data, $table, $op, $id);
  128. 		$output=array();
  129. 				$output[]=array(
  130. 					'status'=>'<span class="label label-hidden">На рассмотрении</span>'
  131. 					);	
  132.  
  133. 		echo json_encode($output);
  134. 	break;
  135.  
  136. 	case 'show':
  137. 		$op="update";
  138. 		$data=array("display"=>"1");
  139. 		update_base ($pdo, $data, $table, $op, $id);
  140. 		$output=array();
  141. 				$output[]=array(
  142. 					'status'=>'<span class="label label-active">Утвержден</span>'
  143. 					);	
  144.  
  145. 		echo json_encode($output);
  146.  
  147. 	break;
  148. 	case 'decline':
  149. 		$op="update";
  150. 		$data=array("display"=>"2");
  151. 		update_base ($pdo, $data, $table, $op, $id);
  152. 		$output=array();
  153. 				$output[]=array(
  154. 					'status'=>'<span class="label label-declined">Отклонен</span>'
  155. 					);	
  156.  
  157. 		echo json_encode($output);
  158.  
  159. 	break;
  160.  
  161. 	case 'delete':
  162. 		$data="";
  163. 		update_base ($pdo, $data, $table, $op, $id);
  164. 		$output=array("success"=>true);
  165. 		echo json_encode($output);
  166. 	break;
  167.  
  168. 	case 'edit':
  169. 		$fields="*";
  170. 		$data=data_from_db($pdo,$fields,$table,$k=NULL,$id);
  171. 		echo json_encode($data);
  172. 	break;
  173. 	case 'update':
  174. 		$id=$data['id'];
  175. 		update_base ($pdo, $data, $table, $op, $id);
  176. 		// print_r($data);
  177. 		$output=array();
  178.  
  179. 		switch ($data['display']) {
  180. 				case "0":
  181. 					$data['display']='<span class="label label-hidden">На рассмотрении</span>';
  182. 				break;
  183. 				case "1":
  184. 					$data['display']='<span class="label label-active">Утвержден</span>';
  185. 				break;
  186. 				case "2":
  187. 					$data['display']='<span class="label label-declined">Отклонен</span>';
  188. 				break;
  189. 			}
  190. 				$output[]=array(
  191. 					'id'=>$data['id'],
  192. 					'surname'=>$data['surname'],
  193. 					'country'=>$data['country'],
  194. 					'status'=>$data['display'],
  195. 					'control'=>$buttons
  196. 					);	
  197.  
  198. 		echo json_encode($output);
  199. 	break;
  200. }
  201.  
  202.  
  203.  
  204. } // конец проверки формы 
  205. else {
  206.  
  207. 	echo json_encode($errors);
  208.  
  209. }
  210. unset($data);
  211. unset($id);
  212.  
  213. ?>
Runtime error #stdin #stdout #stderr 0.03s 52480KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
PHP Warning:  require(my_functions_pdo_good.php): failed to open stream: No such file or directory in /home/BCLpsp/prog.php on line 2
PHP Fatal error:  require(): Failed opening required 'my_functions_pdo_good.php' (include_path='.:/usr/share/php:/usr/share/pear') in /home/BCLpsp/prog.php on line 2
https://ideone.com/m69Sdg
language:
PHP (php 7.3.5)
created:
8 years ago
visibility:
secret

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!