Discussion: Lesson 2 - First database table and MySQL PHP drivers

Is the db.php your creation or?

Yes, it's our wrapper for working with the database.

Exactly what license does this source code use?

It's under ICT.social free license. Basically, the only thing you need to do is to keep our link in the source code. More at https://www.ict.social/licenses

Hello,I am having this issue.. may someone help me please? Thanks!

Fatal error: Undefined class constant 'PDO::MYSQL_AT­TR_INIT_COMMAN­D' in C:\Program Files (x86)\EasyPHP-Devserver-16.1\eds-www\DatabaseTes­t\Db.php on line 52

Look at this: http://stackoverflow.com/…and-with-pdo

Thanks it solved the prob! Now i am running on to another problem, i can not connect to my database.
Briefly, i am not using the default port of localhost which is supposed to be '80', i changed it for particular reason to '90' and phpmyadmin is working fine.
Now when i run this code:
<?php
require_once ('Db.php');
$host = "localhost:90";
$database = "web_database";
$user = "root";
$password = "admin";

$success = Db::connect($host, $database, $user, $password);
if($success){
echo 'Connected!';
}else
echo 'Error occurred';
?>

I got this error message:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. ' in C:\xampp\htdoc­s\DatabaseTes­t\Db.php:54 Stack trace: #0 C:\xampp\htdoc­s\DatabaseTes­t\Db.php(54): PDO->__construct('mys­ql:host=loca.­..', 'root', '', Array) #1 C:\xampp\htdoc­s\DatabaseTes­t\index.php(8): Db::connect('lo­calhost:90', 'web_database', 'root', '') #2 {main} thrown in C:\xampp\htdoc­s\DatabaseTes­t\Db.php on line 54

Could anybody help?

Try this:

$host = 'localhost;port=90';

the wrapper you made , is it necessary to understand it for beginners to database?

Absolutely not, you should be only able to use it