PHP MYSQL QUERY not inserting

Question

im adding some values to my table in mysql to test it but nothing happens. it doesnt even give me an error.

<?php
//get values from index.php

$lecturerid = $_POST['studentid'];
$password = $_POST['Pass'];



// Create connection
$conn = mysqli_connect("localhost", "root", "", "coursework");

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";


$sql = "INSERT INTO studentlogin (studentid, password)
VALUES ('John', 'Doe')";




?>

can anyone tell me why.

You're not executing the query. mysqli::prepare() (php.net/mysqli.prepare) / mysqli::query() (php.net/mysqli.query) — Qirel
– Qirel, Commented Apr 22, 2017 at 17:44
Use mysqli::prepare() if you're using variables in the query, mysqli::query() can be used for static queries. — Qirel
– Qirel, Commented Apr 22, 2017 at 17:46
Can you mark one of the answer below as 'solved' since you wrote 'thanks it works'. — Louis Loudog Trottier
– Louis Loudog Trottier, Commented Apr 22, 2017 at 18:07

Vimukthi Guruge · Accepted Answer · 2017-04-22 17:55:55Z

1

You must add mysqli_query()

//get values from index.php

$lecturerid = $_POST['studentid'];
$password = $_POST['Pass'];



// Create connection
$conn = mysqli_connect("localhost", "root", "", "coursework");

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";


$sql = "INSERT INTO studentlogin (studentid, password)
VALUES ('John', 'Doe')";

mysqli_query($conn, $sql);


?>

answered Apr 22, 2017 at 17:55

Vimukthi Guruge

2853 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vimukthi Guruge Over a year ago

It's ok. Welcome

Geee · Accepted Answer · 2017-04-22 17:56:38Z

Quite simple,

<?php
    //get values from index.php

    $lecturerid = $_POST['studentid'];
    $password = $_POST['Pass'];

   // Create connection
   $conn = mysqli_connect("localhost", "root", "", "coursework");

   // Check connection
   if (!$conn) {
          die("Connection failed: " . mysqli_connect_error());
   }
   echo "Connected successfully";

   //Build query
   $sql = "INSERT INTO studentlogin (studentid, password) VALUES ('John', 'Doe')";

   //execute query
   mysqli_query($conn,$sql) or die(mysqli_error($conn));

?>

Agam Banga · Accepted Answer · 2017-04-22 17:52:14Z

0

You need to use the below methods to insert it

$firstname = "John";
$lastname = "Doe";
$stmt = $conn->prepare("INSERT INTO studentlogin (studentid, password) 
VALUES (:studentLogin, :password)");
$stmt->bindParam(':firstname', $firstname);
$stmt->bindParam(':lastname', $lastname);
$stmt->execute();

answered Apr 22, 2017 at 17:52

Agam Banga

2,6931 gold badge14 silver badges18 bronze badges

1 Comment

Louis Loudog Trottier Over a year ago

isn't this PDO syntax? the OP is using mysqli. Good call, bad number :D

Collectives™ on Stack Overflow

PHP MYSQL QUERY not inserting

3 Answers 3

1 Comment

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Related