blocks|key|316077|text|使用PHP的json+methods创建json，然后使用fwrite将其写入文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|316078|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/json|1|http://php.net/fwrite^0|6|C|0|T|6|1|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]|$A|R|B|S|1|T]]|C|$]]|$1|D|3|-4|5|6|7|U|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]|L|$5|G|H|I|C|$J|M]]]]

Use PHP's <a href="http://php.net/json" rel="noreferrer">json methods</a> to create the json then write it to a file with <a href="http://php.net/fwrite" rel="noreferrer">fwrite</a>.

blocks|key|3055174|text|您可以简单地使用php的函数，并使用和等文件处理函数保存文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3055175|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You can simply use <a href="http://php.net/manual/en/function.json-encode.php" rel="noreferrer">json_encode</a> function of php and save file with file handling functions such as <a href="http://php.net/manual/en/function.fopen.php" rel="noreferrer">fopen</a> and <a href="http://php.net/manual/en/function.fwrite.php" rel="noreferrer">fwrite</a>.

blocks|key|312967|text|将获取的值插入数组中，而不是回显。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|312968|使用file_put_contents()并将json_encode($rows)插入到该文件中(如果$rows是您的数据)。|offset|length|style|CODE|312969|entityMap^0|0|2|J|N|I|1F|5|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|I|$]]

Insert your fetched values into an array instead of echoing. 

Use <code>file_put_contents()</code> and insert <code>json_encode($rows)</code> into that file, if <code>$rows</code> is your data.

blocks|key|3268833|text|下面是一个示例代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3268834|<?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);


?>+|code-block|syntax|javascript|3268835|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here is a sample code:

<pre><code>&lt;?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'=&gt; $title, 'url'=&gt; $url);
} 

$response['posts'] = $posts;

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


?&gt; 
</code></pre>

blocks|key|316153|text|如果你拉取动态记录，最好有一个创建json表示的php文件，而不是每次都创建一个文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|316154|my_json.php|offset|length|style|BOLD|316155|$array+=+array(
++++'title'+=>+$title,
++++'url'+=>+$url
);

echo+stripslashes(json_encode($array));+|code-block|syntax|javascript|316156|316157|entityMap^0|0|0|B|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|T|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

If you're pulling dynamic records it's better to have 1 php file that creates a json representation and not create a file each time. 

my_json.php

<pre><code>$array = array(
 'title' =&gt; $title,
 'url' =&gt; $url
);

echo stripslashes(json_encode($array)); 
</code></pre>

Then in your script set the path to the file <code>my_json.php</code>

blocks|key|3268970|text|使用以下命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3268971|$json_data+=+json_encode($posts);
file_put_contents('myfile.json',+$json_data);|code-block|syntax|javascript|3268972|你可以在运行script.But之前创建myfile.json，这不是必须的。|3268973|3268974|下面是一个有效的示例：|3268975|<?php+
++
//+data+strored+in+an+array+called+cars
$cars+=+Array+(
++++"0"+=>+Array+(
++++++++"id"+=>+"01",
++++++++"name"+=>+"BMW",
++++),
++++"1"+=>+Array+(
++++++++"id"+=>+"02",
++++++++"name"+=>+"Volvo",
++++),
++++"2"+=>+Array+(
++++++++"id"+=>+"03",
++++++++"name"+=>+"Mercedes",
++++)
);
//+encode+array+to+json
$json+=+json_encode($cars);
$bytes+=+file_put_contents("myfile.json",+$json);+//generate+json+file
echo+"Here+is+the+myfile+data+$bytes.";
?>|3268976|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Q|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|R|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|S|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|T|8|@]|9|@]|A|$]]|$1|L|3|M|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|N|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|O|$]]

Use this:
<pre><code>$json_data = json_encode($posts);
file_put_contents('myfile.json', $json_data);
</code></pre>
<blockquote>
You can create the myfile.json before you run the script.But its not compulsory.
</blockquote>
Here is a working Example:
<pre><code>&lt;?php 
 
// data strored in an array called cars
$cars = Array (
 &quot;0&quot; =&gt; Array (
 &quot;id&quot; =&gt; &quot;01&quot;,
 &quot;name&quot; =&gt; &quot;BMW&quot;,
 ),
 &quot;1&quot; =&gt; Array (
 &quot;id&quot; =&gt; &quot;02&quot;,
 &quot;name&quot; =&gt; &quot;Volvo&quot;,
 ),
 &quot;2&quot; =&gt; Array (
 &quot;id&quot; =&gt; &quot;03&quot;,
 &quot;name&quot; =&gt; &quot;Mercedes&quot;,
 )
);
// encode array to json
$json = json_encode($cars);
$bytes = file_put_contents(&quot;myfile.json&quot;, $json); //generate json file
echo &quot;Here is the myfile data $bytes.&quot;;
?&gt;
</code></pre>

blocks|key|314062|text|在这里，我已经提到了用于创建json文件并以漂亮的方式打印json文件内的数组值的简单语法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|314063|$array+=+array('name'+=>+$name,'id'+=>+$id,'url'+=>+$url);
$fp+=+fopen('results.json',+'w');
fwrite($fp,+json_encode($array,+JSON_PRETTY_PRINT));+++//+here+it+will+print+the+array+pretty
fclose($fp);|code-block|syntax|javascript|314064|希望它能为你工作...|314065|entityMap^0|E|6|T|4|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|N|$]]

Here i have mentioned the simple syntex for create json file and print the array value inside the json file in pretty manner.

<pre><code>$array = array('name' =&gt; $name,'id' =&gt; $id,'url' =&gt; $url);
$fp = fopen('results.json', 'w');
fwrite($fp, json_encode($array, JSON_PRETTY_PRINT)); // here it will print the array pretty
fclose($fp);
</code></pre>

Hope it will works for you....

blocks|key|313057|text|首先，您需要对其进行解码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|313058|$jsonString+=+file_get_contents('jsonFile.json');
$data+=+json_decode($jsonString,+true);|code-block|syntax|javascript|313059|然后更改数据：|313060|$data[0]['activity_name']+=+"TENNIS";
//+or+if+you+want+to+change+all+entries+with+activity_code+"1"
foreach+($data+as+$key+=>+$entry)+{
++++if+($entry['activity_code']+==+'1')+{
++++++++$data[$key]['activity_name']+=+"TENNIS";
++++}
}|313061|然后重新编码，并将其保存回文件中：|313062|$newJsonString+=+json_encode($data);
file_put_contents('jsonFile.json',+$newJsonString);|313063|copy|offset|length|313064|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/17806269^0|0|0|0|0|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|16|8|@]|9|@$Q|17|R|18|1|19]]|A|$]]|$1|S|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]]]

First, you need to decode it :

<pre><code>$jsonString = file_get_contents('jsonFile.json');
$data = json_decode($jsonString, true);
</code></pre>

Then change the data :

<pre><code>$data[0]['activity_name'] = "TENNIS";
// or if you want to change all entries with activity_code "1"
foreach ($data as $key =&gt; $entry) {
 if ($entry['activity_code'] == '1') {
 $data[$key]['activity_name'] = "TENNIS";
 }
}
</code></pre>

Then re-encode it and save it back in the file:

<pre><code>$newJsonString = json_encode($data);
file_put_contents('jsonFile.json', $newJsonString);
</code></pre>

<a href="https://stackoverflow.com/a/17806269">copy</a>

<pre><code>CREATE TABLE Posts
{
id INT PRIMARY KEY AUTO_INCREMENT,
title VARCHAR(200),
url VARCHAR(200)
}
</code></pre>

json.php code

<pre><code>&lt;?php
$sql=mysql_query("select * from Posts limit 20");
echo '{"posts": [';
while($row=mysql_fetch_array($sql))
{
$title=$row['title'];
$url=$row['url'];
echo '

{

"title":"'.$title.'",

"url":"'.$url.'"

},'; 
}
echo ']}';

?&gt;
</code></pre>

I have to generate <code>results.json</code> file.

How to generate .json file with PHP?

CREATE TABLE Posts{id INT PRIMARY KEY AUTO_INCREMENT,title VARCHAR(200),url VARCHAR(200)}json.php代码<?php$sql=mysql_query("select * from Posts limit 20");echo '{...

问如何用PHP生成.json文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用PHP生成.json文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用PHP生成.json文件？
EN