<?php
$user
=
'root'
;
$password
=
''
;
$database
=
'gfg'
;
$servername
=
'localhost:3308'
;
$mysqli
=
new
mysqli(
$servername
,
$user
,
$password
,
$database
);
if
(
$mysqli
->connect_error) {
die
(
'Connect Error ('
.
$mysqli
->connect_errno .
') '
.
$mysqli
->connect_error);
}
$sql2
=
"SELECT * FROM userdata"
;
$result
=
$mysqli
->query(
$sql2
);
while
(
$row
=
$result
->fetch_array()) {
$studentdata
[] =
array
(
"GFG_User_Name"
=>
$row
[
"username"
],
"No_Of_Problems"
=>
$row
[
"problems"
],
"Total_Score"
=>
$row
[
"score"
],
"Articles"
=>
$row
[
"articles"
],
);
}
$file
=
"gfguserdetails.json"
;
if
(
file_put_contents
(
$file
,
json_encode(
$studentdata
)))
echo
(
"File created"
);
else
echo
(
"Failed"
);
$mysqli
->close();
?>