Validate::validateUsernameInDb() - Code Metrics - ankitjain28may/openchat - Measure and Improve Code Quality continuously with Scrutinizer

Validate::validateUsernameInDb() A
last analyzed 2019-10-31 14:12 UTC

↳ Parent: Validate

Complexity

Conditions	3
Paths	3

Size

Total Lines

Duplication

Lines	11
Ratio	100 %

Importance

Changes

Metric	Value
cc	3
nc	3
nop	1
dl	11
loc	11
rs	9.9
c	0
b	0
f	0

<?php
/**
 * Validate Class Doc Comment
 *
 * PHP version 5
 *
 * @category PHP
 * @package  OpenChat
 * @author   Ankit Jain <[email protected]>
 * @license  The MIT License (MIT)
 * @link     https://github.com/ankitjain28may/openchat
 */
namespace ChatApp;
require_once dirname(__DIR__).'/vendor/autoload.php';
use mysqli;
use Dotenv\Dotenv;
$dotenv = new Dotenv(dirname(__DIR__));
$dotenv->load();


/**
 * For Validating User Data whether he is registered or not
 *
 * @category PHP
 * @package  OpenChat
 * @author   Ankit Jain <[email protected]>
 * @license  The MIT License (MIT)
 * @link     https://github.com/ankitjain28may/openchat
 */

class Validate
{
    /*
    |--------------------------------------------------------------------------
    | Validate Class
    |--------------------------------------------------------------------------
    |
    | For Validating User Data whether he is registered or not.
    |
    */

    protected $connect;

    /**
     * Create a new class instance.
     *
     * @return void

     */
    public function __construct()

    {
        $this->connect = new mysqli(
            getenv('DB_HOST'),
            getenv('DB_USER'),
            getenv('DB_PASSWORD'),
            getenv('DB_NAME')
        );
    }

    /**
     * Validating Email in Database.
     *
     * @param string $email To store email id
     *
     * @return integer 0|1
     */
    public function validateEmailInDb($email)

    {
        $query = "SELECT login_id FROM login WHERE email = '$email'";
        if ($result = $this->connect->query($query)) {
            if ($result->num_rows > 0) {
                return 1;
            } else {
                return 0;
            }
        }
    }

    /**
     * Validating Username in Database.
     *
     * @param string $username To store username
     *
     * @return integer 0|1
     */
    function validateUsernameInDb($username)

    {
        $query = "SELECT login_id FROM login WHERE username = '$username'";
        if ($result = $this->connect->query($query)) {
            if ($result->num_rows > 0) {
                return 1;
            } else {
                return 0;
            }
        }
    }
}


1		<?php
2		/**
3		* Validate Class Doc Comment
4		*
5		* PHP version 5
6		*
7		* @category PHP
8		* @package OpenChat
9		* @author Ankit Jain <[email protected]>
10		* @license The MIT License (MIT)
11		* @link https://github.com/ankitjain28may/openchat
12		*/
13		namespace ChatApp;
14		require_once dirname(__DIR__).'/vendor/autoload.php';
15		use mysqli;
16		use Dotenv\Dotenv;
17		$dotenv = new Dotenv(dirname(__DIR__));
18		$dotenv->load();
19
20
21		/**
22		* For Validating User Data whether he is registered or not
23		*
24		* @category PHP
25		* @package OpenChat
26		* @author Ankit Jain <[email protected]>
27		* @license The MIT License (MIT)
28		* @link https://github.com/ankitjain28may/openchat
29		*/
30
31		class Validate
32		{
33		/*
34		\|--------------------------------------------------------------------------
35		\| Validate Class
36		\|--------------------------------------------------------------------------
37		\|
38		\| For Validating User Data whether he is registered or not.
39		\|
40		*/
41
42		protected $connect;
43
44		/**
45		* Create a new class instance.
46		*
47		* @return void
		0 ignored issues – show Comprehensibility Best Practice introduced 2017-02-13 20:17 UTC by Report Bug Copy Issue Report Adding a `@return` annotation to constructors is generally not recommended as a constructor does not have a meaningful return value. Adding a `@return` annotation to a constructor is not recommended, since a constructor does not have a meaningful return value. Please refer to the PHP core documentation on constructors. Loading history...
48		*/
49	View Code Duplication	public function __construct()
		0 ignored issues – show Duplication introduced 2017-10-01 13:31 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
50		{
51		$this->connect = new mysqli(
52		getenv('DB_HOST'),
53		getenv('DB_USER'),
54		getenv('DB_PASSWORD'),
55		getenv('DB_NAME')
56		);
57		}
58
59		/**
60		* Validating Email in Database.
61		*
62		* @param string $email To store email id
63		*
64		* @return integer 0\|1
65		*/
66	View Code Duplication	public function validateEmailInDb($email)
		0 ignored issues – show Duplication introduced 2017-10-01 13:31 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
67		{
68		$query = "SELECT login_id FROM login WHERE email = '$email'";
69		if ($result = $this->connect->query($query)) {
70		if ($result->num_rows > 0) {
71		return 1;
72		} else {
73		return 0;
74		}
75		}
76		}
77
78		/**
79		* Validating Username in Database.
80		*
81		* @param string $username To store username
82		*
83		* @return integer 0\|1
84		*/
85	View Code Duplication	function validateUsernameInDb($username)
		0 ignored issues – show Best Practice introduced 2017-01-02 16:58 UTC by Report Bug Copy Issue Report It is generally recommended to explicitly declare the visibility for methods. Adding explicit visibility (`private`, `protected`, or `public`) is generally recommend to communicate to other developers how, and from where this method is intended to be used. Loading history... Duplication introduced 2017-01-02 16:58 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
86		{
87		$query = "SELECT login_id FROM login WHERE username = '$username'";
88		if ($result = $this->connect->query($query)) {
89		if ($result->num_rows > 0) {
90		return 1;
91		} else {
92		return 0;
93		}
94		}
95		}
96		}
97

ankitjain28may / openchat

Validate::validateUsernameInDb() A last analyzed 2019-10-31 14:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Validate::validateUsernameInDb() A
last analyzed 2019-10-31 14:12 UTC