Try to convert a couple of WordPress table rows from wp_posts into a .json file. Not the JSON API plugin I've seen posted on SO many times. I've tried that and it produces too much data. I just want the ID, title and post or page content. That's it. Also, JSON API doesn't actually export a .json file. Which I want on the server dynamically.
So I'm using this script to produce the .json file.
<?php $con=mysql_connect("localhost","username","password") or die("Database connection failed"); if($con) { mysql_selectdb("database_wp",$con); } ?> <?php $data=array(); $qa=array(); $query=mysql_query("SELECT id, title, content FROM wp_posts ORDER BY id"); while($geteach=mysql_fetch_array($query)) { $id=$getdata[0]; $title=$getdata[1]; $content=$getdata[2]; $qa[]=array('id'=> $id, 'title'=> $title, 'content'=> $content); } $data['qa']=$qa; $fp = fopen('myjson.json', 'w'); fwrite($fp, json_encode($data)); fclose($fp); ?> But all I get in the resulting .json file is {"qa":[]} and that's it. There is data on the server. So why can't I pull it in? What's the fix?
