流明 - mongodb - jenssegers/laravel-mongodb - 邮递员
我已经在我的 wamp 上安装了 mongodb,C:wamp64inmongodbmongodb.3.4in,我已经在路径中添加了 mongodb,并在必要时创建了 windows 服务来启动它.我已经通过composer安装了lumen,之后我安装了:
i have install mongodb on my wamp, C:wamp64inmongodbmongodb.3.4in, i have add mongodb in the path, and create windows service to launch it when necessary. I have install lumen through composer, and after that i have install:
- "laravel/lumen-framework": "5.3.*",
- "barryvdh/laravel-ide-helper": "v2.2.1",
- jenssegers/laravel-mongodb:v3.1.3"
- jenssegers/mongodb-session":v1.1.0"
最后我已经在我的 wamp php 上安装了 mongodb.dll 并在 php.ini 中添加了 extension=php_mongodb.dll.现在 mongodb 上的扩展是活跃的.
Finaly i have install mongodb.dll on my wamp php and add extension=php_mongodb.dll inside the php.ini. And now the extension on mongodb is active.
这是我的用户类:
这是我的迁移
<?php
use IlluminateSupportFacadesSchema;
use JenssegersMongodbSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;
class CreateUsersTable extends Migration
{
/**
* The name of the database connection to use.
*
* @var string
*/
protected $connection = 'mongodb';
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::connection($this->connection)->
table('Users', function (Blueprint $collection) {
$collection->index('id');
$collection->string('name');
$collection->string('surname');
$collection->unique('username');
$collection->string('password',64);
$collection->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::connection($this->connection)
->table('Users', function (Blueprint $collection)
{
$collection->drop();
});
}
}`
这是 .env 文件
APP_ENV=local
APP_DEBUG=true
APP_KEY=
APP_TIMEZONE=UTC
DB_CONNECTION=mongodb
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret
MONGODB_HOST=localhost
MONGODB_PORT=27017
MONGODB_USERNAME=joy
MONGODB_PASSWORD=mongo@ad@joy
MONGODB_DATABASE=brasserie
MONGODB_AUTHDATABASE=admin
CACHE_DRIVER=file
SESSION_DRIVER=file
我已经在根应用程序中创建了配置目录,并且我已经添加了一个 database.php 配置文件:
i have create config directory in the root app, and i have add a database.php config file:
<?php
return [
/*
|--------------------------------------------------------------------------
| PDO Fetch Style
|--------------------------------------------------------------------------
|
| By default, database results will be returned as instances of the PHP
| stdClass object; however, you may desire to retrieve records in an
| array format for simplicity. Here you can tweak the fetch style.
|
*/
'fetch' => PDO::FETCH_CLASS,
/*
|--------------------------------------------------------------------------
| Default Database Connection Name
|--------------------------------------------------------------------------
|
| Here you may specify which of the database connections below you wish
| to use as your default connection for all database work. Of course
| you may use many connections at once using the Database library.
|
*/
'default' => env('DB_CONNECTION', 'mongodb'),
/*
|--------------------------------------------------------------------------
| Database Connections
|--------------------------------------------------------------------------
|
| Here are each of the database connections setup for your application.
| Of course, examples of configuring each database platform that is
| supported by Laravel is shown below to make development simple.
|
|
| All database work in Laravel is done through the PHP PDO facilities
| so make sure you have the driver for your particular database of
| choice installed on your machine before you begin development.
|
*/
'connections' => [
'mongodb' => array(
'driver' => 'mongodb',
'host' => env('MONGODB_HOST', '127.0.0.1'),
'port' => env('MONGODB_PORT', 27017),
'username' => env('MONGODB_USERNAME', 'root'),
'password' => env('MONGODB_PASSWORD', 'testbrasserie'),
'database' => env('MONGODB_DATABASE', 'synthese'),
'options' => array(
'db' => env('MONGODB_AUTHDATABASE', 'admin') //Sets the auth DB
)//*/
),
],
/*
|--------------------------------------------------------------------------
| Migration Repository Table
|--------------------------------------------------------------------------
|
| This table keeps track of all the migrations that have already run for
| your application. Using this information, we can determine which of
| the migrations on disk haven't actually been run in the database.
|
*/
'migrations' => 'migrations',
/*
|--------------------------------------------------------------------------
| Redis Databases
|--------------------------------------------------------------------------
|
| Redis is an open source, fast, and advanced key-value store that also
| provides a richer set of commands than a typical key-value systems
| such as APC or Memcached. Laravel makes it easy to dig right in.
|
*/
'redis' => [
'cluster' => env('REDIS_CLUSTER', false),
'default' => [
'host' => env('REDIS_HOST', '127.0.0.1'),
'port' => env('REDIS_PORT', 6379),
'database' => env('REDIS_DATABASE', 0),
'password' => env('REDIS_PASSWORD', null),
],
],//*/
];
我已经启用了 eloquent、facades 和 jessenger 服务提供者.所以这是我的 boostrap/app.php:
I have enable eloquent, facades and jessenger Service provider. so this is my boostrap/app.php:
<?php
require_once __DIR__.'/../vendor/autoload.php';
try {
(new DotenvDotenv(__DIR__.'/../'))->load();
} catch (DotenvExceptionInvalidPathException $e) {
//
}
/*
|--------------------------------------------------------------------------
| Create The Application
|--------------------------------------------------------------------------
|
| Here we will load the environment and create the application instance
| that serves as the central piece of this framework. We'll use this
| application as an "IoC" container and router for this framework.
|
*/
$app = new LaravelLumenApplication(
realpath(__DIR__.'/../')
);
$app->withFacades();
// $app->withEloquent();
/*
|--------------------------------------------------------------------------
| Register Container Bindings
|--------------------------------------------------------------------------
|
| Now we will register a few bindings in the service container. We will
| register the exception handler and the console kernel. You may add
| your own bindings here if you like or you can make another file.
|
*/
$app->singleton(
IlluminateContractsDebugExceptionHandler::class,
AppExceptionsHandler::class
);
$app->singleton(
IlluminateContractsConsoleKernel::class,
AppConsoleKernel::class
);
/*
|--------------------------------------------------------------------------
| Register Middleware
|--------------------------------------------------------------------------
|
| Next, we will register the middleware with the application. These can
| be global middleware that run before and after each request into a
| route or middleware that'll be assigned to some specific routes.
|
*/
// $app->middleware([
// AppHttpMiddlewareExampleMiddleware::class
// ]);
// $app->routeMiddleware([
// 'auth' => AppHttpMiddlewareAuthenticate::class,
// ]);
/*
|--------------------------------------------------------------------------
| Register Service Providers
|--------------------------------------------------------------------------
|
| Here we will register all of the application's service providers which
| are used to bind services into the container. Service providers are
| totally optional, so you are not required to uncomment this line.
|
*/
$app->register(AppProvidersAppServiceProvider::class);
// $app->register(AppProvidersAuthServiceProvider::class);
// $app->register(AppProvidersEventServiceProvider::class);
if ($app->environment() !== 'production') {
$app->register(BarryvdhLaravelIdeHelperIdeHelperServiceProvider::class);
}
//class_alias ('JenssegersMongodbEloquentModel', 'Moloquent');
$app->register('JenssegersMongodbMongodbServiceProvider');
$app->withEloquent();
/*
|--------------------------------------------------------------------------
| Load The Application Routes
|--------------------------------------------------------------------------
|
| Next we will include the routes file so that they can all be added to
| the application. This will provide all of the URLs the application
| can respond to, as well as the controllers that may handle them.
|
*/
$app->group(['namespace' => 'AppHttpControllers'], function ($app) {
require __DIR__.'/../routes/web.php';
});
$app->configure('database');
return $app;
这是我的 UsersTableSeeder:
Here is my UsersTableSeeder:
我已经启动了 artisan migrate:install 然后 artisan migrate 最后是 artisan db:seed 似乎没问题,这是 mongo 内部的结果:
I have launch the artisan migrate:install then artisan migrate and finally artisan db:seed and it seems to be ok, here is the result inside mongo:
然后我创建了一个用户控制器
Then i have create a UserController
<?php
/**
* Created by PhpStorm.
* User: Joy_Admin
* Date: 09/12/2016
* Time: 23:23
*/
namespace AppHttpControllers;
use AppHttpControllersController;
use AppUser;
use IlluminateHttpRequest;
use IlluminateSupportFacadesHash;
use DB;
class UserController extends Controller
{
/**
* Pour recupérer tous les utilsateurs de la BD
* @return IlluminateHttpJsonResponse
*/
public function index()
{
$users = User::all();
return response()->json($users);
}
/**
* Pour recupérer tous les utilsateurs de la BD
* @return IlluminateHttpJsonResponse
*/
public function test()
{
return response()->json("it's ok");
}
/**
* pour enregistrer un nouvel utilisateur dans la base de données
* @param Request $request
*/
public function create(Request $request)
{
$user = new User();
$user->name = $request->input('name');
$user->surname = $request->input('surname');
$user->username = $request->input('username');
$user->password = Hash::make($request->input('password'));
$user->save();//*/
DB::collection('Users')->insert([
'name' => 'name1',
'surname' => 'surname1',
'username' => 'username1',
'password' => Hash::make('password1')
]);
return response()->json($user);
}
/**
* On renvoit l'individu dans la BD
* correspondant à l'id spécifié
* @param $id
* @return IlluminateHttpJsonResponse
*/
public function get($id)
{
$user = User::find($id);
return response()->json($user);
}
/**
* Mettre à jour les informations sur un utilisateur de la BD
* @param Request $request
* @param $id
* @return IlluminateHttpJsonResponse
*/
public function update(Request $request,$id)
{
$user = User::find($id);
$user->name = $request->input('name');
$user->surname = $request->input('surname');
$user->username = $request->input('username');
$user->password = Hash::make($request->input('password'));
$user->save();
return response()->json($user);
}
public function delete($id)
{
$user = User::find($id);
$user->delete();
return response()->json('Success');
}
}
最后更新我的路由/web.php
And finally update my routes/web.php
<?php
/*
|--------------------------------------------------------------------------
| Application Routes
|--------------------------------------------------------------------------
|
| Here is where you can register all of the routes for an application.
| It is a breeze. Simply tell Lumen the URIs it should respond to
| and give it the Closure to call when that URI is requested.
|
*/
use AppHttpControllersUserController;
$app->get('/', function () use ($app) {
return $app->version();
});
$app->get('/api/users','UserController@index');
$app->get('/api/users/{id}','UserController@get');
$app->post('/api/users','UserController@create');
$app->put('/api/users/{id}','UserController@update');
$app->delete('/api/users/{id}','UserController@delete');
$app->get('/api','UserController@test');
我已经启动邮递员,以便我可以测试我的应用程序,只有 /api 工作,所有其他路线都给我同样的错误
I have launch postman, so that i could test my app, only /api work, all the other route give me the same error
有人可以帮我解决这个问题吗?
Openssl 和 curl 在我的 wamp php 中处于活动状态.
Openssl and curl are active in my wamp php.
推荐答案
我已经解决了问题,在我的 .env 中,我有:
I have solve the problem, in my .env i was having:
CACHE_DRIVER=file
SESSION_DRIVER=file
但在我的项目中没有为它们配置,所以当我将其更改为
but in my project no configuration for them, so when i have change it into
CACHE_DRIVER=
SESSION_DRIVER=
现在一切正常.
相关文章