fork download
copy 
  1. <?php
  2.  
  3. if (isset($_POST['year']))		{$year 		= $_POST['year'];} 		else {$year 	= 2014;}
  4. if (isset($_POST['month'])) 	{$month 	= $_POST['month'];} 	else {$month 	= 9;}
  5. if (isset($_POST['day']))		{$day 		= $_POST['day'];} 		else {$day 		= null;}
  6. if (isset($_POST['action']))	{$action 	= $_POST['action'];} 	else {$action 	= 'get';}
  7.  
  8. if (strlen($month) 	== 1) {$month 	= '0' . $month;}
  9. if (strlen($day) 	== 1) {$day 	= '0' . $day;}
  10.  
  11. $mysqli = new mysqli(
  12. 	"", //host
  13. 	"", // user
  14. 	"", // pass
  15. 	""  // DB
  16. );
  17.  
  18. if ($action == 'get')
  19. {
  20. 	$sql_query = "SELECT SUBSTRING(vihodnoy, 9, 2) as day FROM t_table WHERE
  21. 					user_id=6 AND
  22. 					SUBSTRING(vihodnoy, 6, 2) = " . $month . " AND
  23. 					SUBSTRING(vihodnoy, 1, 4) = " . $year;
  24.  
  25. 	if ($sql_result = mysqli_query($mysqli, $sql_query))
  26. 	{
  27.  
  28. 		while($sql_row = mysqli_fetch_assoc($sql_result)){
  29. 				$array[] = (integer)$sql_row['day'];
  30. 		}
  31.  
  32. 	} else echo $mysqli->error;
  33.  
  34. 	$json_data = json_encode($array);
  35.  
  36. 	mysqli_free_result($sql_result);
  37.  
  38. 	echo $json_data;
  39. } elseif($action == 'del')
  40. {
  41. 	$vihodnoy = $year . '-' . $month . '-' . $day;
  42. 	$sql_query = "DELETE FROM t_table WHERE user_id=6 AND vihodnoy = '" . $vihodnoy . "'";
  43. 	if (mysqli_query($mysqli, $sql_query))
  44. 		echo 'ok';
  45. 	else
  46. 		echo $mysqli->error;
  47. } elseif($action == 'add')
  48. {
  49. 	$vihodnoy = $year . '-' . $month . '-' . $day;
  50. 	$sql_query = "SELECT id FROM t_table WHERE user_id=6 AND vihodnoy='" . $vihodnoy . "'";
  51. 	mysqli_query($mysqli, $sql_query);
  52. 	if ($mysqli->affected_rows == 0)
  53. 	{
  54. 		$sql_query = "INSERT INTO t_table (user_id, vihodnoy) VALUES ('6','" . $vihodnoy . "')";
  55. 		if (mysqli_query($mysqli, $sql_query))
  56. 			echo 'ok';
  57. 		else
  58. 			echo $mysqli->error;
  59. 	}
  60. }
  61. $mysqli->close();
Runtime error #stdin #stdout #stderr 0.01s 20520KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
PHP Fatal error:  Class 'mysqli' not found in /home/RQqfeG/prog.php on line 11
https://ideone.com/7FSY9r
language:
PHP (php 7.3.5)
created:
11 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!