Issues (67)

src/User/Question.php (1 issue)

1
<?php
2
3
namespace Alfs18\User;
4
5
use Anax\DatabaseActiveRecord\ActiveRecordModel;
6
7
/**
8
 * Example of FormModel implementation.
9
 */
10
class Question extends ActiveRecordModel
11
{
12
    /**
13
     * @var string $tableName name of the database table.
14
     */
15
    protected $tableName = "Question";
16
17
    /**
18
     * Columns in the table.
19
     *
20
     * @var integer $id primary key auto incremented.
21
     */
22
    public $id;
23
    public $acronym;
24
    public $question;
25
    // public $qComments;
26
    // public $answer;
27
    // public $aComments;
28
    public $tags;
29
    public $points;
30
    public $created;
31
    public $updated;
32
    public $deleted;
33
34
    /**
35
     * Verify the acronym and the password, if successful the object
36
     * contains all details from the databse row.
37
     *
38
     * @param string $acronym acronym to check.
39
     * @param string $question the question asked.
40
     *
41
     * @return boolean true if okey, false if something went wrong.
42
     */
43
    public function saveQuestion($di)
44
    {
45
        $db = $di->get("dbqb");
46
        // $db->connect();
47
        // $user = $db->select("question, tags")
48
        //            ->from("Question")
49
        //            ->where("acronym = ?")
50
        //            ->execute([$this->acronym])
51
        //            ->fetchAll();
52
        // var_dump($user)
53
        $db->connect()
54
            ->insert("Question", ["acronym", "question", "tags", "points", "created"])
55
            ->execute([$this->acronym, $this->question, $this->tags, $this->points, $this->created]);
56
    }
57
58
59
    /**
60
     * Change character to ÅÄÖ if needed.
61
     *
62
     * @param string $text     The string/text to be checked.
63
     *
64
     * @return array
65
     */
66
    public function changeCharacter($text)
67
    {
68
        $characters = [
69
            "/&Aring;/" => "Å",
70
            "/&aring;/" => "å",
71
            "/&Auml;/" => "Ä",
72
            "/&auml;/" => "ä",
73
            "/&Ouml;/" => "Ö",
74
            "/&ouml;/" => "ö"
75
        ];
76
77
        foreach ($characters as $key => $val) {
78
            $text = preg_replace($key, $val, $text);
79
        }
80
        return $text;
0 ignored issues
show
Bug Best Practice introduced by
The expression return $text returns the type string which is incompatible with the documented return type array.
Loading history...
81
    }
82
}
83