PHP Syntax error, am I blind?

Question

I got this syntax error saying there is a mistake on line 4, but I can't seem to find it..can you help me?

Parse error: syntax error, unexpected ':', expecting ',' or ')' in C:\XAMPP\htdocs\projekt\ajax.php on line 4

My code:

<?php
if (isset($_POST["key"])) {

    $conn = new mysqli(host:"localhost", username:"root", passwd:"", dbname:"serije_bp");

    $name = $conn->real_escape_string($_POST["naziv"]);
    $opis = $conn->real_escape_string($_POST["opis"]);
    $ocjena = $conn->real_escape_string($_POST["ocjena"]);

    if ($_POST["key"] == "dodajNovu") {
        $sql = $conn->query(query: "SELECT id FROM serije WHERE naziv = '$naziv'");
        if ($sql->num_rows > 0)
            exit("TV serija je vec unesena!");
        else {
            $conn->query(query: "INSERT INTO serija (naziv, opis, ocjena)
                                VALUES ('$naziv', '$opis', '$ocjena')");
            exit("TV serija je uspjesno unesena!");
        }
    }
}

?>

read the manual maybe? http://php.net/manual/en/function.mysqli-connect.php — Funk Forty Niner, Dec 03 '17 at 13:35
even your query failed http://php.net/manual/en/mysqli.query.php — Funk Forty Niner, Dec 03 '17 at 13:35
what is query: in this line $conn->query(query: "SELECT id FROM serije WHERE naziv = '$naziv'"); .. I don't think you need that — Dhaval Chheda, Dec 03 '17 at 13:36
*"am I blind?"* - Yes because you didn't read any of the manuals and their proper syntax. — Funk Forty Niner, Dec 03 '17 at 13:38

score -1 · Answer 1 · answered Dec 03 '17 at 13:37

-1

Like the documentation says, simply add parameters without “:“. So please remove “host:“ and so on

answered Dec 03 '17 at 13:37

brosua

46
1
5

1

this is rather a poor answer – Funk Forty Niner Dec 03 '17 at 13:39
1

@Fred-ii- i rather agree – The Codesee Dec 03 '17 at 13:43

score -1 · Answer 2 · answered Dec 03 '17 at 13:42

-1

The correct way to connect to db in mysqli would be

$conn = new mysqli("localhost", "root", "", "serije_bp");

answered Dec 03 '17 at 13:42

Gayan

3,178
1
20
33

PHP Syntax error, am I blind?

2 Answers2