I got a mistake when I run the this code:

Question

$result = "Insert into insert_data (namapelajar1, namapelajar2, 
            namapelajar3, nopendaftaran1,nopendaftaran2,nopendaftaran3) 
          values                
         ('$namapelajar1','$namapelajar2','$namapelajar3',
          '$nopendaftaran1', '$nopendaftaran2','$nopendaftaran3',
          '$kelas', '$tajukprojek');";

It always prompt

Parse error: Parse error: syntax error, unexpected '$result' (T_VARIABLE) in C:\xampp\htdocs\sistem\insert_data.php on line 20

Any one can keep me some advise?? Many thanks!!

and there is an extra semi collon at the end where you close the bracket of values(..) — Muhammad Usman, Sep 27 '16 at 13:41
I doubt you are using $result variable before above statement? — Aju John, Sep 27 '16 at 13:41
@MuhamamdUsman all your comments have nth to do with problem — nospor, Sep 27 '16 at 13:42
6 vs 8 ????? ? ?, u are missing `kelas, tajukprojek` columns, but u r getting Parse error in php right — devpro, Sep 27 '16 at 13:43
If this is line 20, look at the line above. Your error has nothing to do with this particular code. — aynber, Sep 27 '16 at 13:43
@KartikKathiresan right now you have php error which has nth to do with mysql. Error is cause because some lines above you have wrong code, probably mising semi colon, so show us code above — nospor, Sep 27 '16 at 13:44
there is no Parse error: in your this code, yes, query having some problem, already highlited. share more code. — devpro, Sep 27 '16 at 13:46

score 0 · Accepted Answer · answered Sep 27 '16 at 13:43

0

There are two extra column inside values only 6 field are specified but you enter 8 values. Try this

$result = " Insert into insert_data(namapelajar1,namapelajar2,namapelajar3,nopendaftaran1,nopendaftaran2,nopendaftaran3) values ('$namapelajar1','$namapelajar2','$namapelajar3','$nopendaftaran1','$nopendaftaran2','$nopendaftaran3')";

answered Sep 27 '16 at 13:43

Jithin Kuriakose

317
5
22

Thanks to Your Advice – Kartik Kathiresan Sep 27 '16 at 13:50
@KartikKathiresan can you find out what was your error. – Jithin Kuriakose Sep 27 '16 at 13:52
Any question about php, mysql or android studio error can ask here right – Kartik Kathiresan Sep 27 '16 at 13:52
Error is Solved – Kartik Kathiresan Sep 27 '16 at 13:53
@KartikKathiresan Oh Yes. If you got your desired output you can verify it. – Jithin Kuriakose Sep 27 '16 at 13:54
Ok, I am now inserting data into mysql database using android studio but i want to insert 7 field can ahh?? Comment immediately – Kartik Kathiresan Sep 27 '16 at 13:55
@KartikKathiresan Pardon – Jithin Kuriakose Sep 27 '16 at 13:57

I got a mistake when I run the this code:

1 Answers1