Here is a sample code:
<?php $sql="select * from Posts limit 20"; $response = array(); $posts = array(); $result=mysql_query($sql); while($row=mysql_fetch_array($result)) { $title=$row['title']; $url=$row['url']; $posts[] = array('title'=> $title, 'url'=> $url); } $response['posts'] = $posts; $fp = fopen('results.json', 'w'); fwrite($fp, json_encode($response)); fclose($fp); ?>
Related Posts:
- Cannot use object of type stdClass as array?
- PHP convert XML to JSON
- Returning JSON from PHP to JavaScript?
- PHP json_decode() returns NULL with valid JSON?
- file_get_contents(“php://input”) or $HTTP_RAW_POST_DATA, which one is better to get the body of JSON request?
- How to extract and access data from JSON with PHP?
- How to extract and access data from JSON with PHP?
- Fatal error: Maximum execution time of 30 seconds exceeded
- How to POST JSON Data With PHP cURL?
- Returning JSON from a PHP Script
- Returning JSON from a PHP Script
- Get JSON object from URL
- How can I parse a JSON file with PHP? [duplicate]
- What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
- PHP “or” Syntax
- Invalid column count in CSV input on line 1 Error
- How to check if a string starts with a specified string?
- mysqli_real_connect(): (HY000/2002): No such file or directory
- $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
- Why use $_SERVER[‘PHP_SELF’] instead of “”
- phpMyAdmin: secret passphrase?
- Are there dictionaries in php?
- PHP how to make URL something like product.php?id=1
- laravel updateOrCreate method
- How to listen messageSent event in laravel 5.5
- Make a HTTPS request through PHP and get response
- How do the PHP equality (== double equals) and identity (=== triple equals) comparison operators differ?
- How do I pass JavaScript variables to PHP?
- Call to undefined function curl_init().?
- How to verify password against database?
- what is a good method to sanitize the whole $_POST array in php?
- pdo – Call to a member function prepare() on a non-object
- Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 71 bytes)
- Compare given date with today
- Multi-line strings in PHP
- Commands out of sync; you can’t run this command now
- cURL error 60: SSL certificate: unable to get local issuer certificate
- Replace spaces with a dash in a URL
- Are PDO prepared statements sufficient to prevent SQL injection?
- Message: Trying to access array offset on value of type null [duplicate]
- retrieve data from db and display it in table in php .. see this code whats wrong with it?
- PDO closing connection
- “Valid CSRF Token Required” in Osticket After login?
- Count how many files in directory PHP
- Simple PHP calculator
- Convert from MySQL datetime to another format with PHP
- php foreach with multidimensional array
- header location not working in my php code
- PHP Error: Function name must be a string
- Uncaught Error: Call to undefined function mysql_escape_string()
- Warning: mysqli_query() expects at least 2 parameters, 1 given. What? [duplicate]
- PHP cURL custom headers
- Parsing domain from a URL
- PHP class not found but it’s included
- How to fix the session_register() deprecated issue?
- Laravel 5 MethodNotAllowedHttpException in RouteCollection.php line 201:
- How to convert string to boolean php
- PHP “&” operator
- Are There Any Cron Jobs Alternative?
- How to Create Multiple Where Clause Query Using Laravel Eloquent?
- PHP: How to get referrer URL?
- What is ?
- SyntaxError: Unexpected token C in JSON at position 0 – Ionic 2 Http GET request
- Connection reset by peer: mod_fcgid: error reading data from FastCGI server
- Warning: A non-numeric value encountered
- How to import csv file in PHP?
- What is the syntax for accessing PHP object properties?
- * failed to open vchiq instance
- Mysql where id is in array
- Warning “Do not Access Superglobal $_POST Array Directly” on Netbeans 7.4 for PHP
- Notice: Undefined offset: 0 in
- How to Sort a Multi-dimensional Array by Value
- How to get time difference in minutes in PHP
- How to write a link like which link to the same page in PHP?
- Call a REST API in PHP
- Fatal error: Call to a member function query() on null
- How can I write php code in notepad++?
- How to run a PHP function from an HTML form?
- How to use data-saferedirecturl in a tag in PHP?
- How to insert TIMESTAMP into my MySQL table?
- Remove warning messages in PHP
- PHP date yesterday [duplicate]
- Clear cache in Symfony: `cache:clear` or `rm -rf`?
- Is there any difference between aes-128-cbc and aes-128 encryption?
- Convert timestamp to readable date/time PHP
- create php live clock
- Converting a UNIX Timestamp to Formatted Date String
- PHP Call to undefined function
- Formatting a number with leading zeros in PHP
- POST an array from an HTML form without javascript
- Upload a json file in php [closed]
- Fetch post block/field data as JSON with WordPress API
- Importing JSON feed giving Notice: Array to string conversion error
- Can’t pass var from php wp_ajax into ajax script : result undefined or null
- In a plugin, How to update a json file using ajax
- How to use Datatable with Ajax when creating plugin on WordPress?
- I want to use wordpress database in android app using json encode?
- JSON Object Value Show Undefine
- get_body_params() is always empty in POST request
- How to enqueue structured data as file – jsonld file seems not to work