how to use mysqli_query

Question

I have typed the code but it shows the error in querying.

<?php
$firstname=$_POST['firstname'];
$lastname=$_POST['lastname'];
$class=$_POST['class'];
$gen=$_POST['gender'];
$email=$_POST['email'];
$dbc= mysqli_connect('localhost','sam','xxx','student') or die('error in mysql');           
$query="INSERT INTO student(firstname,lastname,class,gender,email)"
    ."VALUES('$firstname','lastname','class','gen','email')";
$result= mysqli_query($dbc,$query) or die('error in querying');
mysqli_close($dbc);
echo 'your name:'.$name.'<br>';
echo 'your class:'.$class.'<br>';
echo 'your email:'.$email.'<br>';
echo 'your gender:'.$gen.'<br>';
?>

Post your code for a review with errors shown – Mubo Jul 11 '14 at 12:27 — Mubo, Jul 11 '14 at 12:27
Space between `student` and `(firstname, ...)`? – putvande Jul 11 '14 at 12:29 — putvande, Jul 11 '14 at 12:29

score 1 · Answer 1 · edited May 23 '17 at 10:32

1

It should be:

$query="INSERT INTO student(firstname,lastname,class,gender,email)"
    ." VALUES('$firstname','lastname','class','gen','email')";

with space before VALUES.

I don't know if you want to insert other variables values into database or just put strings here for test only, so maybe you wanted also:

$query="INSERT INTO student(firstname,lastname,class,gender,email)"
    ." VALUES('$firstname','$lastname','$class','$gen','$email')";

What you want to do are the basics of PHP. So look at PHP manual to learn how to use variables and mysqli

In addition this code is very unsafe. Read more about SQL Injection

edited May 23 '17 at 10:32

Community

1
1

answered Jul 11 '14 at 12:30

Marcin Nabiałek

109,655
42
258
291

Can i know why it will not insert $firstname value? – Ajit Singh Jul 11 '14 at 12:35
@MarcinNabiałek You could hint at the constant strings 'lastname', 'class', ... instead. – VMai Jul 11 '14 at 12:38

score 0 · Answer 2 · answered Jul 11 '14 at 12:31

0

try the below code it will work

$query="INSERT INTO student(firstname,lastname,class,gender,email) VALUES('$firstname','$lastname','$class','$gen','$email')";

answered Jul 11 '14 at 12:31

Ajit Singh

1,132
1
13
24

why -1 for the answer? – Ajit Singh Jul 11 '14 at 12:32

how to use mysqli_query

2 Answers2