{"id":869,"date":"2025-06-12T01:35:16","date_gmt":"2025-06-11T17:35:16","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/php\/php-application-manual\/laravel\/869.html"},"modified":"2025-06-12T01:35:16","modified_gmt":"2025-06-11T17:35:16","slug":"%e5%a6%82%e4%bd%95%e5%9c%a8-laravel-%e4%b8%ad%e8%bf%9e%e6%8e%a5%e5%88%b0-mysql-%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"my1js","link":"https:\/\/www.zhaozhao123.cn\/php\/my1js\/869.html","title":{"rendered":"\u5982\u4f55\u5728 Laravel \u4e2d\u8fde\u63a5\u5230 MySQL \u6570\u636e\u5e93"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n

在 Laravel 中连接到 MySQL 数据库非常简单，只需要按照以下步骤进行配置即可。<\/p>\n

1. 创建一个新的 Laravel 项目（如果还没有的话）<\/h3>\n

如果你还没有创建一个新的 Laravel 项目，可以使用 Composer 来创建：<\/p>\n

composer create-project --prefer-dist laravel\/laravel my-laravel-app\ncd my-laravel-app<\/code><\/pre>\n
2. 配置数据库连接<\/h3>\n
打开 config\/database.php<\/code> 文件，找到并修改数据库连接配置。假设你已经有一个名为 mysql<\/code> 的数据库，并且它位于本地服务器上，默认端口是 3306。<\/p>\n
'mysql' => [\n    'driver'   => 'mysql',\n    'host'     => env('DB_HOST', '127.0.0.1'),\n    'port'     => env('DB_PORT', 3306),\n    'database' => env('DB_DATABASE', 'my_database'),\n    'username' => env('DB_USERNAME', 'root'),\n    'password' => env('DB_PASSWORD', ''),\n    'charset'   => 'utf8mb4',\n    'collation' => 'utf8mb4_unicode_ci',\n    'prefix'    => '',\n],<\/code><\/pre>\n
3. 运行迁移命令<\/h3>\n
Laravel 提供了一个简单的命令来生成数据库表结构。你可以运行以下命令来创建所有需要的表：<\/p>\n
php artisan migrate<\/code><\/pre>\n
4. 示例代码<\/h3>\n
以下是一个简单的示例代码，展示如何在 Laravel 中使用 Eloquent ORM 连接到 MySQL 数据库：<\/p>\n
<?php\n\nnamespace App;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass User extends Model\n{\n    \/\/ 没有额外的配置，因为默认情况下会自动关联到 `users` 表\n}<\/code><\/pre>\n
在这个例子中，User<\/code> 类继承自 IlluminateDatabaseEloquentModel<\/code>，并且它会自动从 users<\/code> 表中获取数据。<\/p>\n
总结<\/h3>\n
通过以上步骤，你就可以在 Laravel 中成功连接到 MySQL 数据库了。确保你的环境配置正确，并且数据库表已经存在。希望这些信息对你有所帮助！<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"黑板Bug讲师\"<\/figure>\r\n\r\n\r\n\r\n
黑板Bug讲师<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
介绍<\/h2>
在使用Laravel时，一个强大的PHP框架，常见的任务是在处理数据持久性时连接到MySQL数据库。Laravel通过内置的ORM（对象关系映射）Eloquent和数据库实用程序来简化这个过程。本教程将指导你在Laravel应用程序中设置MySQL连接，重点介绍实际示例和最佳实践。<\/p>
前置条件<\/p>
对PHP和Laravel的基本理解。<\/p>
MySQL数据库服务器<\/p>
安装 Laravel<\/p>
基本配置<\/h2>
请从以下方面进行配置：设置您的环境、安装必要的软件、创建数据库和表结构等。.env<\/code>在您的Laravel项目根目录下，使用您的MySQL数据库信息创建一个文件：<\/p>
DB_CONNECTION=mysql\nDB_HOST=127.0.0.1\nDB_PORT=3306\nDB_DATABASE=your_database\nDB_USERNAME=your_username\nDB_PASSWORD=your_password\n<\/code><\/pre>
当环境变量已设置时，请检查您的情况。config\/database.php<\/code>确保使用这些变量进行数据库连接：<\/p>
'mysql' => [\n    'driver' => 'mysql',\n    'url' => env('DATABASE_URL'),\n    'host' => env('DB_HOST', '127.0.0.1'),\n    'port' => env('DB_PORT', '3306'),\n    'database' => env('DB_DATABASE', 'forge'),\n    'username' => env('DB_USERNAME', 'forge'),\n    'password' => env('DB_PASSWORD', ''),\n    \/\/ ...Additional configuration\n],\n<\/code><\/pre>
创建模型和迁移操作<\/h2>
为了与数据库交互，你需要一个相应的Eloquent模型。让我们为名为的表创建一个模型。products<\/code>：<\/p>
php artisan make:model Product -m\n<\/code><\/pre>
该命令会生成一个模型和数据库迁移文件，其中你可以定义表结构：<\/p>
public function up()\n{\n    Schema::create('products', function (Blueprint $table) {\n        $table->id();\n        $table->string('name');\n        $table->decimal('price', 8, 2);\n        $table->timestamps();\n    });\n}\n<\/code><\/pre>
运行以下命令在您的MySQL数据库中创建表：<\/p>
php artisan migrate\n<\/code><\/pre>
与数据库交互<\/h2>
为了添加新产品，首先确保您的Product<\/code>模型的fillable或guarded属性已设置，然后使用Eloquent插入数据：<\/p>
use AppModelsProduct;\n\n$product = new Product;\n$product->name = 'Amazing Widget';\n$product->price = 99.99;\n$product->save();\n<\/code><\/pre>
要检索数据，请使用以下方法：<\/p>
$products = Product::all();\n<\/code><\/pre>
对不起，您的问题没有完全表达清楚。请重新描述您需要翻译的内容。$products<\/code>变量将持有从数据库返回的产品模型集合。<\/p>
高级用法<\/h2>
你可以使用Laravel的查询构建器来处理更复杂的查询：<\/p>
$expensiveProducts = DB::table('products')\n    ->where('price', '>', 100)\n    ->get();\n<\/code><\/pre>
这个查询将检索价格大于100的产品。请在您的PHP文件顶部导入数据库Facade：<\/p>
use IlluminateSupportFacadesDB;<\/code><\/pre>
结论<\/h2>
综上所述，使用Laravel连接MySQL数据库是一个简单且高效的流程。通过正确设置配置文件并利用Laravel的Eloquent和Query Builder库，您可以轻松与数据进行交互。<\/p><\/body>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
\r\n
\r\n
\r\n
\r\n
\r\n
\"长工码奴1523\"<\/figure>\r\n\r\n\r\n\r\n
长工码奴1523<\/h2>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
\r\n
\r\n
要在Laravel中连接到MySQL数据库，你需要遵循以下步骤：<\/p>\n
步骤 1: 安装依赖<\/h3>\n
首先，确保你已经安装了Laravel和Composer。如果没有，请先按照官方文档进行安装：https:\/\/laravel.com\/docs\/8.x\/installation<\/a><\/p>\n
步骤 2: 创建数据库迁移文件<\/h3>\n
在database\/migrations<\/code>目录下创建一个新的表结构迁移文件。例如，你可以使用这个例子来创建一个名为users<\/code>的表：<\/p>\n
<?php\n\nuse IlluminateDatabaseMigrationsMigration;\nuse IlluminateDatabaseSchemaBlueprint;\nuse IlluminateSupportFacadesSchema;\n\nclass CreateUsersTable extends Migration\n{\n    \/**\n     * Run the migrations.\n     *\n     * @return void\n     *\/\n    public function up()\n    {\n        Schema::create('users', function (Blueprint $table) {\n            $table->id();\n            $table->string('name');\n            $table->string('email')->unique();\n            $table->timestamp('email_verified_at')->nullable();\n            $table->string('password');\n            $table->rememberToken();\n            $table->timestamps();\n\n            \/\/ Add other columns as needed\n        });\n    }\n\n    \/**\n     * Reverse the migrations.\n     *\n     * @return void\n     *\/\n    public function down()\n    {\n        Schema::dropIfExists('users');\n    }\n}<\/code><\/pre>\n
然后运行迁移命令：<\/p>\n
php artisan migrate<\/code><\/pre>\n
步骤 3: 连接数据库<\/h3>\n
接下来，设置环境变量（如果需要的话）并连接到数据库。在config\/database.php<\/code>文件中添加以下代码：<\/p>\n
'connections' => [\n    'mysql' => [\n        'driver' => 'mysql',\n        'host' => env('DB_HOST', 'localhost'),\n        'port' => env('DB_PORT', '3306'),\n        'database' => env('DB_DATABASE', 'your_database_name'),\n        'username' => env('DB_USERNAME', 'your_username'),\n        'password' => env('DB_PASSWORD', 'your_password'),\n        'charset' => 'utf8mb4',\n        'collation' => 'utf8mb4_unicode_ci',\n        'prefix' => '',\n        'strict' => true,\n        'engine' => null,\n    ],\n],<\/code><\/pre>\n
注意：请将your_database_name<\/code>, your_username<\/code>, 和 your_password<\/code>替换为实际的数据库名和密码。<\/p>\n
步骤 4: 创建模型类<\/h3>\n
创建一个名为User<\/code>的模型类，并定义属性。在这个例子中，我们假设有一个名为name<\/code>、email<\/code>、password<\/code>和email_verified_at<\/code>字段。<\/p>\n
<?php\n\nnamespace AppModels;\n\nuse IlluminateContractsAuthMustVerifyEmail;\nuse IlluminateFoundationAuthUser as Authenticatable;\nuse IlluminateNotificationsNotifiable;\nuse LaravelSanctumHasApiTokens;\n\nclass User extends Authenticatable\n{\n    use Notifiable, HasApiTokens, HasApiTokens;\n\n    protected $fillable = [\n        'name',\n        'email',\n        'password',\n    ];\n\n    protected $hidden = [\n        'password',\n        'remember_token',\n    ];\n\n    protected $casts = [\n        'email_verified_at' => 'datetime',\n    ];\n}<\/code><\/pre>\n
步骤 5: 建立关联关系<\/h3>\n
如果你需要与另一个模型（如Post<\/code>）建立关联，只需继承AppModelsUser<\/code>类，并在其父类的基础上添加所需的属性和方法。<\/p>\n
示例代码<\/h3>\n
以下是创建一个User<\/code>模型的例子：<\/p>\n
<?php\n\nnamespace AppModels;\n\nuse IlluminateDatabaseEloquentModel;\n\nclass User extends Model\n{\n    protected $fillable = ['name', 'email', 'password'];\n\n    protected $hidden = ['password', 'remember_token'];\n}<\/code><\/pre>\n
现在，你可以通过这种方式创建和连接到MySQL数据库了。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
Bug编译狮 在 Laravel 中连接到 MySQL 数据库非常简单，只&#38..<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"template":"","meta":{"_acf_changed":false},"tags":[],"my1js2nav":[44],"tuisongtax":[],"class_list":["post-869","my1js","type-my1js","status-publish","hentry","my1js2nav-laravel"],"acf":{"qian_art_seotitle":"","qian_art_seotitle_source":{"label":"SEO\u6807\u9898","type":"text","formatted_value":""},"qian_art_seokws":"","qian_art_seokws_source":{"label":"SEO\u5173\u952e\u8bcd","type":"text","formatted_value":""},"qian_art_stzhong":"","qian_art_stzhong_source":{"label":"\u4e2d | \u77ed\u6807\u9898","type":"text","formatted_value":""}},"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js\/869","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/types\/my1js"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/media?parent=869"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tags?post=869"},{"taxonomy":"my1js2nav","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/my1js2nav?post=869"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/php\/wp-json\/wp\/v2\/tuisongtax?post=869"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}