在Laravel的数据库操作错误的数据更新
P粉336536706
2023-08-07 20:33:01
<p>以下是我模型中的函数代码:</p>
<pre class="brush:php;toolbar:false;">public function updateAnime(Request $request)
{
$updatedFields = [];
$request->validate([
'title' => ['required'],
'release_date' => ['required', 'integer'],
'author' => ['required'],
'studio' => ['required'],
'description' => ['required'],
]);
$request->release_date = (int)$request->release_date;
$animeInfo = Anime::where('title', $request->oldTitle)->with('authors', 'studios')->first();
$author = Author::firstOrCreate(['author' => $request->author]);
AuthorAnime::where([
['author', $animeInfo->authors[0]->author],
['anime', $request->oldTitle]
])->update([
'author' => $author->author,
'anime' => str_replace(' ', '-', $request->title)
]);
$studio = Studio::firstOrCreate(['studio_name' => $request->studio]);
StudioAnime::where([
['studio', $animeInfo->studios[0]->studio_name],
['anime', $request->oldTitle]
])->update([
'studio' => $studio->studio_name,
'anime' => str_replace(' ', '-', $request->title)
]);
foreach ($request->all() as $key => $value) {
if (property_exists($animeInfo, $key)) {
if ($request->$key != $animeInfo->$key) {
$updatedFields[$key] = $request->$key;
}
}
}
$animeInfo->update($updatedFields);
return response()->json(['message' => 'Data was updated successfully. n Updated data: ' . implode(', ', array_keys($updatedFields))]);
}</pre>
<p>控制器代码:</p>
<pre class="brush:php;toolbar:false;">$anime = new Anime();
return $anime->updateAnime($request);</pre>
<p>问题是，它更新相关的表StudioAnime和AuthorAnime，它也在表Studio和动漫中创建新的数据，但它不更新表动漫。兄弟们，为啥这样，该怎么解决<br /><br />当在我以前的代码我只是更新数据没有检查它的变化都工作</p><p><br /></p>
<pre class="brush:php;toolbar:false;">$animeInfo->update([
'title' => str_replace(' ', '-',$request->title),
'poster' => $animeInfo->poster,
'description' => $request->description,
'release_date' => $request->release_date,
'trailer' => $animeInfo->trailer,
]);
return response()->json(['message' => 'Data was updated successuflly']);```</pre>
<p><br /></p>
![[웹 프런트엔드] Node.js 빠른 시작](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
不能用property_exist()函数获取列名，因为这些属性不能作为Model对象中的属性直接访问。
要检查这个，试试在tinker:
我的建议是，用attributesarray()或getAttributes()方法与array_keys()结合，获得模型的属性名称数组，这不就搞定了吗:
$animeAttributes = array_keys($animeInfo->getAttributes()); foreach ($request->all() as $key => $value) { if (in_array($key, $animeAttributes)) { /* ... */