Reply to thread

Message

<blockquote data-quote="Vik" data-source="post: 471017" data-attributes="member: 84388">I thought that myself and I've reset my password twice now and matched from the MYSQL to the Config. I'm sure that's correct.[SPOILER=&quot;DatabaseService.php&quot;][CODE=php]&lt;?phpnamespace Cosmic\System;use Exception;use PDO;use \Pecee\Pixie\Connection;class DatabaseService {&nbsp; &nbsp; public static $instance;&nbsp;&nbsp; &nbsp; public static function connection(){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dotenv = new \Symfony\Component\Dotenv\Dotenv(true);&nbsp; &nbsp; &nbsp; &nbsp; $dotenv-&gt;loadEnv(dirname(__DIR__).'/../.env');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $config = [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'driver'&nbsp; &nbsp; =&gt; getenv('mysql'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'host'&nbsp; &nbsp; &nbsp; =&gt; getenv('localhost'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'database'&nbsp; =&gt; getenv('hotel'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'username'&nbsp; =&gt; getenv('root'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'password'&nbsp; =&gt; getenv('redneck123'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'charset'&nbsp;&nbsp; =&gt; getenv('uf8'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'collation' =&gt; getenv('collation'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'options'&nbsp;&nbsp; =&gt; [&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PDO::ATTR_TIMEOUT =&gt; 5,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PDO::ATTR_EMULATE_PREPARES =&gt; false,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; ];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!isset(self::$instance)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; self::$instance = (new \Pecee\Pixie\Connection('mysql', $config))-&gt;getQueryBuilder();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; return self::$instance;&nbsp; &nbsp; }}[/CODE][/SPOILER]</blockquote>

[QUOTE="Vik, post: 471017, member: 84388"] I thought that myself and I've reset my password twice now and matched from the MYSQL to the Config. I'm sure that's correct. [SPOILER="DatabaseService.php"][CODE=php]<?php namespace Cosmic\System; use Exception; use PDO; use \Pecee\Pixie\Connection; class DatabaseService { public static $instance; public static function connection(){ $dotenv = new \Symfony\Component\Dotenv\Dotenv(true); $dotenv->loadEnv(dirname(__DIR__).'/../.env'); $config = [ 'driver' => getenv('mysql'), 'host' => getenv('localhost'), 'database' => getenv('hotel'), 'username' => getenv('root'), 'password' => getenv('redneck123'), 'charset' => getenv('uf8'), 'collation' => getenv('collation'), 'options' => [ PDO::ATTR_TIMEOUT => 5, PDO::ATTR_EMULATE_PREPARES => false, ], ]; if(!isset(self::$instance)){ self::$instance = (new \Pecee\Pixie\Connection('mysql', $config))->getQueryBuilder(); } return self::$instance; } }[/CODE][/SPOILER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members