AL\Common\DAO\ValidateLinkDAO

Complexity

Total Complexity

2

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	addValidateLink()	0	20	1
A	__construct()	0	2	1

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;

/**
 * DAO for links submitted by users that need to be validated
 */
class ValidateLinkDAO {
    private $mysqli;

    public function __construct($mysqli) {
        $this->mysqli = $mysqli;
    }

    /**
     * Add a new link to validate
     *
     * @param  string $name        Name of the link
     * @param  string $url         URL of the link
     * @param  string $description Description of the link
     * @return integer ID of the inserted link to validate
     */
    public function addValidateLink($name, $url, $description) {
        $stmt = \AL\Db\execute_query(
            "ValidateLinkDAO: Add link",
            $this->mysqli,
            "INSERT INTO website_validate (
                website_name,
                website_url,
                website_date,
                website_description,
                user_id
            )
            VALUES (?, ?, ?, ?, ?)",
            "ssiss", $name, $url, time(), $description, $_SESSION['user_id']
        );

        $id = $stmt->insert_id;

        $stmt->close();

        return $id;
    }
}