FilesExpand file tree

 master

/

viewproblem.php

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

39 lines (23 loc) · 584 Bytes

 master

/

viewproblem.php

Copy path

Top

File metadata and controls

• Code
• Blame

39 lines (23 loc) · 584 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "student_information";

$conn = new mysqli($servername, $username, $password, $dbname);

$query = "SELECT * FROM problems order by ProblemID DESC";

$result = $conn->query($query);

if($result->num_rows ==0)

{

echo "None";

}

else

{

$posts = array();

if($result->num_rows) {

while($post = mysqli_fetch_assoc($result)) {

$posts[] = array('post'=>$post);

}

}

echo json_encode(array('posts'=>$posts));

}

?>