How to add Varchar checkbox values in MySql?

Question

I'm trying to add Varchar values from checkbox to mysql and it adding string "1" in the checked checkboxes. How I can make it to add Varchar values like below?

<?php
if (isset($_POST['dr_add'])) {
  $lightv = isset($_POST['l_vehicle']);
  $van = isset($_POST['van']);
  $truck = isset($_POST['truck']);
  $trailer = isset($_POST['tr_trailer']);
  mysql_query("INSERT INTO driving(user_id, country,l_vehicle,van, truck , tr_trailer) VALUES('$user->employeeid','$lightv','$van','$truck','$trailer')") or die(mysql_error());
}
?>
<input type="checkbox" name="l_vehicle" value="Light Vehicle"/>Light Vehicle
<input type="checkbox" name="van" value="Van">Van
<input type="checkbox" name="truck" value="Truck"/>Truck
<input type="checkbox" name="tr_trailer" value="Truck&Trailer"/>Truck&Trailer

Nana Partykar · Accepted Answer · 2016-08-10 08:10:53Z

3

You are using $trailer = isset($_POST['tr_trailer']); and it is wrong :

User below code :

 $trailer = isset($_POST['tr_trailer'])?$_POST['tr_trailer']:"";

Use this for all checkboxes

edited Aug 10, 2016 at 8:10

Nana Partykar

10.5k10 gold badges50 silver badges79 bronze badges

answered Aug 10, 2016 at 8:09

robinbansalsolutions

573 bronze badges

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

2 Comments

Nana Partykar Over a year ago

Correct. It will return 0 or 1.

K.Wayne Over a year ago

Thank you very much, exactly what I was looking for :)

Community · Accepted Answer · 2017-05-23 12:00:59Z

isset — Determine if a variable is set and is not NULL

UPDATED CODE

<?php
if (isset($_POST['dr_add'])) {
  $lightv = isset($_POST['l_vehicle']) ? $_POST['l_vehicle'] : "";
  $van = isset($_POST['van']) ? $_POST['van'] : "";
  $truck = isset($_POST['truck']) ? $_POST['truck'] : "";
  $trailer = isset($_POST['tr_trailer']) ? $_POST['tr_trailer'] : "";

  mysql_query("INSERT INTO driving(user_id, country,l_vehicle,van, truck , tr_trailer) VALUES('$user->employeeid','$lightv','$van','$truck','$trailer')") or die(mysql_error());
}
?>

[NOTE:The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead ]

mysqli

(where, $con is connection)

$stmt = mysqli_prepare($con, "INSERT INTO driving(user_id,country,l_vehicle,van,truck,tr_trailer) VALUES (?, ?, ?,?, ?, ?)");
mysqli_stmt_bind_param($stmt, 'dsssss',$user->employeeid,$lightv,$van,$truck,$trailer);

Read Prepared Statements

Collectives™ on Stack Overflow

How to add Varchar checkbox values in MySql?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related