howcodeorg / social-network Goto Github PK

You added this but didn't add it to the branch of episode 3
https://youtu.be/n3VhNiFg3iA?t=46s

It should be

include($_SERVER['DOCUMENT_ROOT'].'/classes/DB.php');

instead of

include('classes/DB.php');

This repository doesn't seem to have a license. If there is a restriction on how we can use this, please let the community know.

Getting this error in my PHP logs:
[Mon Jan 16 16:42:43.787722 2017] [:error] [pid X] [client X] PHP Notice: Undefined variable: data in //classes/DB.php on line 16, referer: /login.php

My PHP is this:
`<?php

class DB {
private static function connect() {

	$pdo = new PDO('mysql:host=X;dbname=gimmesne_SN;charset=utf8', 'gimmesne_sn', 'X');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);	
	return $pdo;
}
public static function query($query, $params = array()) {
	$statement = self::connect()->prepare($query);
	$statement->execute($params);
	
	if (explode(' ', $query)[0] == 'SELECT') {	
	$date = $statement->fetchAll();
	return $data;
	}
}

}

?>`

Undefined offset: 0 in C:\wamp\www\Neeu Chat\api\index.php on line 19

Hello the code is same to same but everytime i execute i found this error.

use null instead of ''

DB::query('INSERT INTO users VALUES (null, :username, :password, :email)', array(':username'=>$username, ':password'=>$password, ':email'=>$email));

instead of

DB::query('INSERT INTO users VALUES ('', :username, :password, :email)', array(':username'=>$username, ':password'=>$password, ':email'=>$email));