how to insert value from radio button into mysql using php

Question

i have tried this code to insert value into database, but i don't Know why, the value was not send into the databases. The table i have created in the mysql :

    <?php
    require_once "connection.php";
        $conn = connect();
        $db = connectdb();

    mysql_select_db($db,$conn) or die (mysql_error() . "\n");
    $query_usr = "select * from soalselidik";
    $usr = mysql_query($query_usr,$conn) or die(mysql_error()."\n".$query_usr);
    $row_usr=mysql_fetch_assoc($usr);

//to insert in database
    $a1=$_POST['a1'];
    $a2=$_POST['a2'];
    $a3=$_POST['a3'];
    $a4=$_POST['a4'];
    $b1=$_POST['b1'];
    $b2=$_POST['b2'];
    $b3=$_POST['b3'];
    $b4=$_POST['b4'];
    $c1=$_POST['c1'];
    $c2=$_POST['c2'];
    $c3=$_POST['c3'];
    $c4=$_POST['c4'];
    $d1=$_POST['d1'];
    $d2=$_POST['d2'];
    $d3=$_POST['d3'];
    $d4=$_POST['d4'];
    $e1=$_POST['e1'];
    $f1=$_POST['f1'];

    echo $query ="insert into soalselidik (a1,a2,a3,a4,b1,b2,b3,b4,c1,c2,c3,c4,d1,d2,d3,d4,e1,f1) values('$a1','$a2','$a3','$a4','$b1','$b2','$b3','$b4','$c1','$c2','$c3','$c4''$d1','$d2','$d3','$d4','$e1','$f1')";
    $result = mysql_query($query);

    echo "<script languange = 'Javascript'>
                    alert('thankyou ! Penilaian anda diterima ');
                    location.href = 'home.php';</script>";

    ?>

Can you verify that it's actually making it into your $_POST? Perhaps add your HTML to the question? Also, I recommend using mysqli ( php.net/manual/en/book.mysqli.php ) or PDO ( php.net/manual/en/ref.pdo-mysql.php ) for more secure database querying. — muttley91
– muttley91, Commented Sep 2, 2014 at 3:20
You have 18 $_POSTed variables....which ones are inserting? Some or none? — The One and Only ChemistryBlob
– The One and Only ChemistryBlob, Commented Sep 2, 2014 at 3:20
Also, check you PHP error log to see if some of these posted vars are undefined...you should have a PHP warning or notice in your error log for these — The One and Only ChemistryBlob
– The One and Only ChemistryBlob, Commented Sep 2, 2014 at 3:22

Community · Accepted Answer · 2017-05-23 10:26:22Z

3

'$c4''$d1'

Find that in your query and fix it :) And please do some error checking, and please stop using MySQL_* for your own good. Why should people not run any error checking mechanism that's already provided in the language and expect others to debug typos?

In case you didn't get it, there's a comma missing

How can I prevent SQL injection in PHP?

edited May 23, 2017 at 10:26

CommunityBot

11 silver badge

answered Sep 2, 2014 at 3:22

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

1 Comment

muttley91 Over a year ago

I just want to second the "stop using MySQL_* because it's very important. It's been deprecated, and you're way safer using another method. I prefer PDO myself.

Collectives™ on Stack Overflow

how to insert value from radio button into mysql using php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related