Installing CakePHP and Connecting to PostgreeSQL on Windows 10

Just run this command on windows command prompt :

After it finished, just go to your cakePHP directory and type "bin\cake server"

Result :

That picture above means that we have successfully installed and run cakePHP 3.6.12 but still not yet connected to any database.

So our next task is connecting to a database. In this post I will be using postgreesql. So go just run your pgAdmin and create a newdatabase as you like. For me it's like this :

After creating our database, then go to config folder and open App.php like this :

Change it's config to something as shown below :

Last... let's refresh our localhost:8765 and we got something like ....

If you want to change the host address and port. Then we can run it using this command :

Yeeeei..... That's all for now... If you have something unclear please leave a comment...
Thank you... :-)
English Video

Indonesian Video :

Next post is about migrations...

Postgres cannot be used in CakepPHP due to missing extension

I changed my app.php database configuration to use Postgreesql like this :

And then when I run bin\cake server, I got this error :

Solution :

Proses Instalasi PostgreeSQL di Windows 10

Pertama-tama download dl postgreesqlnya disini... Terus isiin versi postgreesql dan operating sistemnya kek gini :

Terus stlh download tinggal next next... :v

Klik servers(1) buat login....

Siiipss... sekiaan... semoga bermanfaat.. :-)