Data not being sent to the table during a successful database connection

Question

I have created the database and the table and the connection with the database was successful but the data is not being sent to the database

<?php

$mysqli = mysqli_connect('****************', '***************', '*************', '******posts');
if ($mysqli) {
    echo "conn established";
} else {
    echo "conn failed";
}

if (isset($_POST["submit"])) {
    $one = "one";
    $two = "two";
    $three = "three";
    $four = "four";
    $five = "five";
    $push = mysqli_query($mysqli, "INSERT INTO articles 
        (id,title,thumbnail,upvotes,views,url) 
        VALUES ('$one','$two','$three','$four','$five')");
    if ($push) {
        echo "---------pushed----------";
    } else {
        echo "-----not pushed----";
    }
}

`mysqli_query($mysqli, $query) or die(mysqli_error());` please check what error are you getting? — Dilip Hirapara, Aug 10 '19 at 04:23
@DilipHirapara but i dont have $query in my code, should i replace push with query? — Milad Deraawi, Aug 10 '19 at 04:29
is your table name and columns correct ,where is your html ? — Swati, Aug 10 '19 at 04:57
conn established Error: INSERT INTO articles (id,title,thumbnail,upvotes,views,url2) VALUES ('one','two','three','4','5',) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 — Milad Deraawi, Aug 10 '19 at 07:12

score -1 · Answer 1 · answered Aug 10 '19 at 04:35

-1

checkout this code

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "nepalroute";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);

 if(isset($_POST["submit"])) {
    $one = "one";
    $two = "two";
    $three = "three";
    $four = "four";
    $five = "five";
    $sql = "INSERT INTO articles (id,title,thumbnail,upvotes,views,url) 
    VALUES ('$one','$two','$three','$four','$five')";
        if ($conn->query($sql) === TRUE) {
            echo "New record created successfully";
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error;
        }

 }

 ?>

answered Aug 10 '19 at 04:35

Rajkumar Sharma

554
1
4
9

didnt work brother – Milad Deraawi Aug 10 '19 at 04:39
its not even showing the errors – Milad Deraawi Aug 10 '19 at 04:40
does it print any error – Rajkumar Sharma Aug 10 '19 at 04:40
what is the name of your button from where you submit the form – Rajkumar Sharma Aug 10 '19 at 04:41
your button name should be like ```````` – Rajkumar Sharma Aug 10 '19 at 04:42
submit – Milad Deraawi Aug 10 '19 at 04:47
check ````
````
– Rajkumar Sharma Aug 10 '19 at 04:48
also those are true – Milad Deraawi Aug 10 '19 at 07:06
now it says conn establishedError: INSERT INTO articles (id,title,thumbnail,upvotes,views,url2) VALUES ('one','two','three','4','5',) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 – Milad Deraawi Aug 10 '19 at 07:12
after ````'$five',```` replace with ````VALUES ('$one','$two','$three','$four','$five')";```` – Rajkumar Sharma Aug 10 '19 at 08:55
1

you might have extra ````, ```` after $five – Rajkumar Sharma Aug 10 '19 at 08:55

score -1 · Answer 2 · answered Aug 10 '19 at 05:33

-1

Use this function for run query

mysqli_query($conn, $sql)

answered Aug 10 '19 at 05:33

Jatin kabariya

21
2
6

conn established Error: INSERT INTO articles (id,title,thumbnail,upvotes,views,url2) VALUES ('one','two','three','4','5',) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 – Milad Deraawi Aug 10 '19 at 07:12

Data not being sent to the table during a successful database connection

2 Answers2