我正在嘗試使用Slim PHP Framework開發一個 PHP 作曲家應用程序,并嘗試migrations.php像這樣對文件進行更改<?phpdeclare(strict_types=1);require __DIR__ . '/../../src/App/App.php';try { $settings = $app->getContainer()->get('settings'); $hostname = $settings['db']['hostname']; $username = $settings['db']['username']; $password = $settings['db']['password']; $database = $settings['db']['database']; $pdo = new PDO("mysql:host=$hostname", $username, $password); //Possibly the connection $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "DROP DATABASE IF EXISTS $database"; $pdo->exec($sql); echo "[OK] Database droped successfully" . PHP_EOL; $sql = "CREATE DATABASE $database"; $pdo->exec($sql); echo "[OK] Database created successfully" . PHP_EOL; $sql = "USE $database"; $pdo->exec($sql); echo "[OK] Database selected successfully" . PHP_EOL; $sql = file_get_contents(__DIR__ . '/../../database/database.sql'); $pdo->exec($sql); echo "[OK] Tables created successfully" . PHP_EOL;// echo "[OK] Records inserted successfully" . PHP_EOL; $data = file_get_contents(__DIR__ . '/../../database/companies.json'); $array = json_decode($data, true); foreach($array as $row) { $relationships = $row["relationships"]; $pdo->exec($sql); } echo "[OK] Json inserted into tables successfully" . PHP_EOL;} catch (PDOException $e) { echo "[ERROR] " . $e->getMessage() . PHP_EOL;}
2 回答

鳳凰求蠱
TA貢獻1825條經驗 獲得超4個贊
我建議你可以通過以下方式設置它:
ini_set('memory_limit', '80M');
然而,這是一個糟糕的解決方案,盡量不要將整個 json 文件加載到內存中并使用類似jsonstreamingparser的東西。
- 2 回答
- 0 關注
- 131 瀏覽
添加回答
舉報
0/150
提交
取消