dongpankao6133 2019-03-14 06:44
浏览 343
已采纳

将JSON数据存储在临时文件中,并在24小时后删除?

How can I store JSON Data temporary on my Apache Server. In the JSON are some user information. It would be really nice if the files would delete every 24 hours themselves.

$json_array = array(); 
 while($row = mysqli_fetch_assoc($result)) 
 { 
 $json_array[] = $row; 
 } 

 $final_array = json_encode($json_array);

So like this I create the JSON File, and I could also Store this in a .json File but how can i create temp Files with this data in it. And this File should only be readable from the server.

  • 写回答

2条回答 默认 最新

  • duanqiang9212 2019-03-14 07:09
    关注

    Use file_put_contents to store data, but create some prefix for each user, so you can have separate files, and retrieve them after:

     $json_array = array(); 
     while($row = mysqli_fetch_assoc($result)) 
     { 
     $json_array[] = $row; 
     } 
    
     $final_array = json_encode($json_array);
     $generatedName = 'userIDprefix_userData' .  '.json'; //replace userIDprefix with user ID, this way we can use prefix to store different files per user, and retrieve file for user
     //use file put contents to store data 
     file_put_contents('path/to/json/data/' . $generatedName , $final_array);
    

    Use file_get_contents() to retrieve file data:

     $generatedName = 'userIDprefix_userData' .  '.json'; //replace userIDprefix with user ID, this way we can use prefix to store different files per user, and retrieve file for user
     //use file put contents to store data 
     $userJSONData = file_get_contents('path/to/json/data/' . $generatedName );
    

    And then setup the cron to run say each 5 minutes, use glob and filemtime to scan the dir where you store data and filemtime to get timestamp of file, to compare with current date and delete if it is older than 24h

    $past24hours = strtotime('-24 hours');
    foreach (glob("path/to/json/data/*.json") as $filename) {
       if( filemtime($filename) < $past24hours ){
         unlink($filename);
        }
    }
    

    Setup cron to execute the file where the script for json files deletion is to be run say, every 10 minutes:

    */10 * * * * /usr/bin/php /path/to/script/to/delete-json.php
    

    Note:

    Do not set permissions to 777 to this folder, at least 775, or even 755. Also, to prevent from accessing .json files directly, put in this folder at least blank index.php, and .htaccess with content:

    #forbid access to folders and to files  
     RewriteEngine on 
     RewriteRule \.(json|txt)$ - [F] 
     deny from all
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面
  • ¥50 NT4.0系统 STOP:0X0000007B
  • ¥15 想问一下stata17中这段代码哪里有问题呀