PHP MySQLi not inserting into tables

Question

I've looked at some of the other similar questions, but still can't seem to get it working. FWIW, I am not getting any specific error message.

<?php

// Create connection
$con=mysqli_connect("localhost","username","password");
mysqli_select_db($con, "database");
//let's start our session, so we have access to stored data
session_start();

$class = mysqli_real_escape_string($_SESSION['exclass']);
$fullname = mysqli_real_escape_string($_SESSION['fullname']);
$june = mysqli_real_escape_string($_SESSION['June']);
$july = mysqli_real_escape_string($_SESSION['July']);
$email = mysqli_real_escape_string($_POST['email']);
$phone = mysqli_real_escape_string($_POST['phone']);

//let's create the query
$insert_query = "INSERT INTO Responses (class,fullname,June,July,email,phone) VALUES ('$class','$fullname',$june,$july,'$email','$phone',)";

//let's run the query
$result = mysqli_query($con,$insert_query);

if($result){
    echo "Your response has been recorded. Thank you!";

}else{

    printf("Insert failed: %s\n", mysqli_error());
}
?>

What happens when you run the query directly in MySQL either through the command line or a tool like phpmyadmin? — John Conde
– John Conde, Commented Mar 7, 2013 at 17:27
You have a trailing comma after '$phone' which breaks the query. Not sure why you aren't seeing the error message though - that should report a syntax error. — Michael Berkowski
– Michael Berkowski, Commented Mar 7, 2013 at 17:28
Is there a reason why you've not enclosed $june,$july in single quotes? — PGallagher
– PGallagher, Commented Mar 7, 2013 at 17:28

Daniel Li · Accepted Answer · 2013-03-08 01:12:50Z

3

MySQL does not support trailing comma notation.

Thus, replace:

,'$phone',)

with

,'$phone')

Also, add a fallback condition to see the error output buffer:

mysqli_query($con, $insert_query) or die(mysqli_error($con));

edited Mar 8, 2013 at 1:12

answered Mar 7, 2013 at 17:28

Daniel Li

15.6k6 gold badges45 silver badges60 bronze badges

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

1 Comment

Echlori Over a year ago

Thanks to all who pointed out the trailing comma, I did miss that.

christopher · Accepted Answer · 2013-03-07 17:29:06Z

1

"INSERT INTO Responses (class,fullname,June,July,email,phone) VALUES    ('$class','$fullname',$june,$july,'$email','$phone',<--- LOOK AT THIS COMMA)

This will more than likely explain the failure to insert into the database. Remove the comma from the SQL string, and it will parse correctly.

answered Mar 7, 2013 at 17:29

christopher

27.4k6 gold badges59 silver badges90 bronze badges

Collectives™ on Stack Overflow

PHP MySQLi not inserting into tables

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related