How to create json file from mysql php query

Question

I'm trying to save the data retrieved from the database into a .json. This is what is just tried.

$sql = mysql_query("SELECT `positive`,`time` FROM sentiment WHERE acctid=1");


$response = array();
$posts = array();
while($row=mysql_fetch_array($sql)) 
{ 

$positive=$row['positive']; 

$time=$row['time']; 


$posts[] = array('positive'=> $positive, 'time'=> $time,);

} 

$response['posts'] = $posts;

$fp = fopen('results.json', 'w');
fwrite($fp, json_encode($response));
fclose($fp);

I got the following errors:

Warning: fopen(results.json) [function.fopen]: failed to open stream: Permission denied in /Applications/XAMPP/xamppfiles/htdocs/test/getjson.php on line 29

Warning: fwrite() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/test/getjson.php on line 30

Warning: fclose() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles/htdocs/test/getjson.php on line 31

What could the problem be?

possible duplicate of Warning: mysql_fetch_* expects parameter 1 to be resource, boolean given error — Kim Stebel
– Kim Stebel, Commented Aug 2, 2012 at 17:41

Joe · Accepted Answer · 2012-02-07 17:52:23Z

2

The folder /Applications/XAMPP/xamppfiles/htdocs/test isn't writable by Apache - change the permissions so it can write to it. In Windows Explorer, right click the test folder, and untick "Read Only".

answered Feb 7, 2012 at 17:52

Joe

15.8k4 gold badges52 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create json file from mysql php query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related