blocks|key|4448408|text|这基本上是包含两个对象的and数组。在PHP中，这将是一个关联数组。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4448409|您应该能够将其发送到PHP与AJAX或普通的提交。|4448410|var+content+=+JSON.parse("[{"id”:”abcd123”,”p”:”1999.00","m":"1123.00","op":"1332.00"},{"id”:”efgh1234”,”p”:”642.00","m":"829.00","op":"712.40”}]");|code-block|syntax|javascript|4448411|将content数组发送到PHP后，您可以根据需要对其进行管理。|offset|length|style|CODE|4448412|entityMap^0|0|0|0|1|7|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@$K|U|L|V|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

That's basically and array with two objects in it. In PHP that would be an associative array. 

You should be able to send it to PHP with AJAX or normal for submits. 

<pre><code>var content = JSON.parse("[{"id”:”abcd123”,”p”:”1999.00","m":"1123.00","op":"1332.00"},{"id”:”efgh1234”,”p”:”642.00","m":"829.00","op":"712.40”}]");
</code></pre>

Once you send the <code>content</code> array to PHP you can manage it however you need to.

blocks|key|5916411|text|如果您可以在服务器端访问.txt文件，那么如何打开和解析它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5916412|<?php

//+An+array+to+fill.
$objArr+=+[];

//+Preparing+to+open+a+.txt+file+located+on+the+server.
$handle+=+fopen("path-to-file/file1.txt",+"r");

//+If+PHP+succeed+the+opening+of+the+file.
if+($handle)+{
++while+(($line+=+fgets($handle))+!==+false)+{

++++//+If+we're+on+a+line+having+at+least+one+object.
++++if(+strpos($line,"{")+>+0+){
++++++$countObjects+=+substr_count($line,+"{");

++++++//+For+each+objects+detected
++++++for($i=0;$i<$countObjects;$i%2B%2B){
++++++++$openPos+=+strpos($line,"{");
++++++++$closePos+=+strpos($line,"}");

++++++++//+Push+all+objects+in+an+array.
++++++++array_push($objArr,+json_encode(+substr($line,$openPos,$closePos-$openPos)+)+);

++++++++//+Remove+the+processed+part+of+the+line.
++++++++$line+=+substr($line,$closePos);
++++++}
++++}
++}

++//+close+the+file.
++fclose($handle);

++//+You+now+really+have+an+array+of+json+object,+instead+of+a+string.
++//+use+it+to+pass+the+values+to+your+DB.

++//+Like:
++$id+=+$objArr[1].id;++//+efgh1234

++//+Up+to+you+here...
++//+...


}+else+{
++++//+error+opening+the+file.
++++echo+"ERROR+opening+the+.txt+file. ";
++++die;
}+

?>|code-block|syntax|javascript|5916413|注意，path-to-file是来自linux+/的路径。|offset|length|style|BOLD|CODE|5916414|如果此PHP脚本与要处理的.txt文件位于同一文件夹中，则它可以仅为.。|5916415|显然，这是未经测试的。|5916416|如果有问题，请告诉我。|5916417|entityMap^0|0|0|0|2|3|C|O|1|0|Y|1|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@$I|Y|J|Z|K|L]|$I|10|J|11|K|M]|$I|12|J|13|K|M]]|9|@]|A|$]]|$1|N|3|O|5|6|7|14|8|@$I|15|J|16|K|M]]|9|@]|A|$]]|$1|P|3|Q|5|6|7|17|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|18|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|U|$]]

If you can access the .txt file on server-side, here how to open and parse it:

<pre><code>&lt;?php

// An array to fill.
$objArr = [];

// Preparing to open a .txt file located on the server.
$handle = fopen("path-to-file/file1.txt", "r");

// If PHP succeed the opening of the file.
if ($handle) {
 while (($line = fgets($handle)) !== false) {

 // If we're on a line having at least one object.
 if( strpos($line,"{") &gt; 0 ){
 $countObjects = substr_count($line, "{");

 // For each objects detected
 for($i=0;$i&lt;$countObjects;$i++){
 $openPos = strpos($line,"{");
 $closePos = strpos($line,"}");

 // Push all objects in an array.
 array_push($objArr, json_encode( substr($line,$openPos,$closePos-$openPos) ) );

 // Remove the processed part of the line.
 $line = substr($line,$closePos);
 }
 }
 }

 // close the file.
 fclose($handle);

 // You now really have an array of json object, instead of a string.
 // use it to pass the values to your DB.

 // Like:
 $id = $objArr[1].id; // efgh1234

 // Up to you here...
 // ...


} else {
 // error opening the file.
 echo "ERROR opening the .txt file.&lt;br&gt;&lt;br&gt;";
 die;
} 

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

Note that <code>path-to-file</code> is the path from the linux <code>/</code>. 
it can be just <code>.</code> if this PHP script is in the same folder as the .txt file to process.

This is untested, obviously. 
Let me know if having trouble.

blocks|key|2131363|text|读入内容，但是您已经在这样做了，并将值赋给一个变量|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2131364|$file_contents+=+file_get_contents+(...);|code-block|syntax|javascript|2131365|卸下jQuery(和)。|offset|length|style|CODE|2131366|$file_contents+=+substr($file_contents,+7,+-2);|2131367|现在您可以使用json_decode了。|2131368|$data+=+json_decode($file_contents,+true);|2131369|entityMap^0|0|0|2|7|A|1|0|0|7|B|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]|$I|Z|J|10|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|12|8|@$I|13|J|14|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|T|$]]

Read in the contents with however you're already doing that and assign the value to a variable

<pre><code>$file_contents = file_get_contents (...);
</code></pre>

Remove the <code>jQuery(</code> and <code>)</code>.

<pre><code>$file_contents = substr($file_contents, 7, -2);
</code></pre>

Now you can use <code>json_decode</code>.

<pre><code>$data = json_decode($file_contents, true);
</code></pre>

blocks|key|5916481|text|您有一种奇怪的存储JSON的方式。如果您可以直接存储它而不使用"Jquery(“前缀和");”后缀，那么您的工作就轻松多了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5916482|关于你用这种方式提出的问题，我不建议解析整个文本文件，就像你的文本文件包含成百上千个元素一样，解析会耗费时间和资源。|5916483|一个棘手的解决方案是省略初始的Jquery(部分和最后)；元素：|5916484|$input+=+'jQuery([{"id”:”abcd123”,”p”:”1999.00","m":"1123.00","op":"1332.00"},{"id”:”efgh1234”,”p”:”642.00","m":"829.00","op":"712.40”}]);'

//+Those+”+are+different+than+"+and+therefore+not+accepted+in+JSON+parsing.

$input+=+str_replace('”',+'"',+$input);

$omitWord+=+'jQuery(';
if(strpos($input,$omitWord)+===+0){
++++$input+=+substr_replace($input,"",0,strlen($omitWord));
}

$inputLength+=+mb_strlen($input);

if($input[$inputLength-1]+==+';'+&&+$input[$inputLength-2]+==+')'){
++++$input+=+mb_substr($input,0,-2);
}

$itemArray+=+json_decode($input,+true);|code-block|syntax|javascript|5916485|这适用于有jQuery(前缀%2B+;)后缀或纯json对象的情况。我添加了额外的检查，因为您的json元素可能包含"jquery(“或");"，这可能会导致潜在的bug。|5916486|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Q|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|R|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

You have a strange way of storing the JSONs. If you can directly store it without the "Jquery(" prefix and ");" suffix, your life would be much easier.

As to your question put in that way, I wouldn't suggest parsing the whole text file, as if your text file contains hundreds or thousands of elements, the parsing would take up time and resources.

A tricky solution would be to omit the initial Jquery( part and the last ); elements: 

<pre><code>$input = 'jQuery([{"id”:”abcd123”,”p”:”1999.00","m":"1123.00","op":"1332.00"},{"id”:”efgh1234”,”p”:”642.00","m":"829.00","op":"712.40”}]);'

// Those ” are different than " and therefore not accepted in JSON parsing.

$input = str_replace('”', '"', $input);

$omitWord = 'jQuery(';
if(strpos($input,$omitWord) === 0){
 $input = substr_replace($input,"",0,strlen($omitWord));
}

$inputLength = mb_strlen($input);

if($input[$inputLength-1] == ';' &amp;&amp; $input[$inputLength-2] == ')'){
 $input = mb_substr($input,0,-2);
}

$itemArray = json_decode($input, true);
</code></pre>

This would work for the cases when you have jQuery( prefix + ;) suffix or the pure json object. I've added additional checks because your json elements might contain either "jquery(" or ");", which could lead to a potential bug.

blocks|key|5916531|text|您需要做以下事情。a)将字符“替换为”。b)提取file_contents。我假设你知道如何做到这一点。file_get_contents是一个调用。甚至可以与远程链接一起工作。c)提取关联数组。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5916532|$out+=+substr($str,8,-3);
$array+=+explode(',',+$str);|code-block|syntax|javascript|5916533|新的输出将是数组(+=>+{"id":"abcd123“1+=>+"p":"1999.00”2+=>+"m":"1123.00“3+=>+"op":"1332.00"}+4+=>+{"id":"efgh1234”5+=>+"p":"642.00“6+=>+"m":"829.00”7+=>+"op":"712.40"}+)|5916534|剩下的部分现在应该很容易处理了。也许还有更好的方法来做到这一点。没有时间去探索。|5916535|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You need to do the following things.
a) Replace the character ” with " . Use str_replace for that
b) Extract the file_contents .I'm assuming you know how to do that. file_get_contents is one call. Can even work with remote links.
c) extract associative array.

<pre><code>$out = substr($str,8,-3);
$array = explode(',', $str);
</code></pre>

The new output will be 
Array ( [0] => {"id":"abcd123" [1] => "p":"1999.00" [2] => "m":"1123.00" [3] => "op":"1332.00"} [4] => {"id":"efgh1234" [5] => "p":"642.00" [6] => "m":"829.00" [7] => "op":"712.40"} )

The rest should be easy enough to process now. There might be better ways also to do this. Did not have time to explore.

I have a script which saves text files of inputs which I need to parse into my database. I'm using PHP to do the parsing into MySQL, but the text files are not JSON compliant and I'm at a standstill on how to convert this data into something PHP can read as an array.

Given <code>json_decode()</code> doesn't work on the text, what would be an option to convert this into an array in PHP so I can take the values from <code>"id"</code>, <code>"p"</code>, <code>"m"</code>, and <code>"op"</code> to insert into my database.

Text example inside file (ie: file1.txt) below:

<pre><code>jQuery([{"id”:”abcd123”,”p”:”1999.00","m":"1123.00","op":"1332.00"},{"id”:”efgh1234”,”p”:”642.00","m":"829.00","op":"712.40”}]);
</code></pre>

jQuery to PHP array

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个脚本，保存文本文件的输入，我需要解析到我的数据库。我使用PHP来解析成MySQL，但是文本文件不符合JSON，并且我还不知道如何将这些数据转换成PHP可以读取的数组。如果json_decode()不能处理文本，那么有什么选项可以将其转换为数组，这样我就可以从"id"、"p"、"m"和"op"中将值插入到我的数据...

问jQuery到PHP数组
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问jQuery到PHP数组EN