It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.
Storing a PHP Checkbox in a Database
Hello
I have a PHP page with text and Database fields.
This is the code that draws the checkbox:
This is the code that stores the texts fields in the database:
How do I store which of the php checkboxes are checked into the database. What kind of field do I need to create in the database table. All my text fields are Varchar. I was thinking maybe bit?
Many Thanks
I have a PHP page with text and Database fields.
This is the code that draws the checkbox:
<tr>
<td width="43"><label for="business_type">Salon</label></td>
<td width="30"><input type="checkbox" name="business_type[]" id="business_type" value="salon" /></td>
<td width="38"><label for="business_type">Mobile</label></td>
<td width="30"><input type="checkbox" name="business_type[]" id="business_type" value="mobile" /></td>
<td width="53"><label for="business_type">Student</label></td>
<td width="25"><input type="checkbox" name="business_type[]" id="business_type" value="student" /></td>
<td width="37"><label for="business_type">Other</label></td>
<td width="434"><input type="checkbox" name="business_type[]" id="business_type" value="other" /></td>
</tr>
This is the code that stores the texts fields in the database:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?
$trainee_name=$_POST['trainee_name'];
$company_name=$_POST['company_name'];
$address=$_POST['address'];
$telephone=$_POST['telephone'];
$email_address=$_POST['email_address'];
$website=$_POST['website'];
$trainer_name=$_POST['trainer_name'];
$training_date=$_POST['training_date'];
$trainer_notes=$_POST['trainer_notes'];
$area_consultant=$_POST['area_consultant'];
mysql_connect("localhost", "web46-training", "training") or die(mysql_error());
mysql_select_db("web46-training") or die(mysql_error());
mysql_query("INSERT INTO `data` VALUES ('$trainee_name', '$company_name', '$address', '$telephone', '$email_address', '$website', '$trainer_name', '$training_date', '$trainer_notes', '$area_consultant')");
Print "Your information has been successfully added to the database.";
?>
</body>
</html>
How do I store which of the php checkboxes are checked into the database. What kind of field do I need to create in the database table. All my text fields are Varchar. I was thinking maybe bit?
Many Thanks
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In your specific case an SET with values 'salon','mobile','student'
Then again, I suspect that you really want to use radiobuttons rather than checkboxes (in that case use ENUM instead of SET).
In both cases you have to use the correct insert syntax for the field type of course, but the advantage over a bit is that you can use meaningful content directly generated from the business_type[] array
Then again, I suspect that you really want to use radiobuttons rather than checkboxes (in that case use ENUM instead of SET).
In both cases you have to use the correct insert syntax for the field type of course, but the advantage over a bit is that you can use meaningful content directly generated from the business_type[] array
You can concatenate with | or , the selected values and store them in text filed. So that you can split the entries back.
BTW, you do know that you should be more careful with handing input data to mySQL?
What if someone maliciously entered
What if someone maliciously entered
foo'); truncate table data;
Are you able to show me an example? I'm new to this.
Enterint the above code did nothing to the database. Isn't that because a VARCHAR field is purely for storing text? Please feel free to tell me i'm talking rubbish lol.
Enterint the above code did nothing to the database. Isn't that because a VARCHAR field is purely for storing text? Please feel free to tell me i'm talking rubbish lol.
I would create four columns of type VARCHAR. I would put the values from the checkboxes into these columns. That way your data base table will be easier to read. If you use separate columns, it will be easy to add more definitions (with ALTER TABLE) and all your existing queries will still work after you do that.
If you do not already know about it, here is a helpful tool:
http://www.phpmyadmin.net/home_page/index.php
A good book to help you get started learning PHP and MySQL is available here:
http://www.sitepoint.com/books/phpmysql5/
You definitely need to learn about this PHP function. While the comment from thehagman at ID: 38001662 is not really applicable (MySQL_Query() will not run more than one query) it is still a good practice to filter and escape your external data.
http://php.net/manual/en/function.mysql-real-escape-string.php
You also need to learn about this function. MySQL is not a black box; it can and will fail, sometimes for reasons outside of your control. So you must test the return values from its functions and (immediately) visualize the error information.
http://php.net/manual/en/function.mysql-error.php
Best of luck with your project, ~Ray
If you do not already know about it, here is a helpful tool:
http://www.phpmyadmin.net/home_page/index.php
A good book to help you get started learning PHP and MySQL is available here:
http://www.sitepoint.com/books/phpmysql5/
You definitely need to learn about this PHP function. While the comment from thehagman at ID: 38001662 is not really applicable (MySQL_Query() will not run more than one query) it is still a good practice to filter and escape your external data.
http://php.net/manual/en/function.mysql-real-escape-string.php
You also need to learn about this function. MySQL is not a black box; it can and will fail, sometimes for reasons outside of your control. So you must test the return values from its functions and (immediately) visualize the error information.
http://php.net/manual/en/function.mysql-error.php
Best of luck with your project, ~Ray
I would prefer the data type as 'text' .
$chkbox = $_REQUEST['business_type']
$chboxval = implode(",",$chkbox);
insert query.....
$chkbox = $_REQUEST['business_type']
$chboxval = implode(",",$chkbox);
insert query.....
I tried to post a link to this article earlier, but apparently it did not "take," so here it is...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_5450-Common-Sense-Examples-Using-Checkboxes-with-HTML-JavaScript-and-PHP.html
HTH, ~Ray
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_5450-Common-Sense-Examples-Using-Checkboxes-with-HTML-JavaScript-and-PHP.html
HTH, ~Ray
Wow, what was wrong with the answers? You did not even ask for clarifying information - you just gave a marked-down grade. Please see the grading guidelines here:
http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26
Please tell us what you expected and why you didn't respond if you thought our posts did not have enough information for your needs. thanks, ~Ray
http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26
Please tell us what you expected and why you didn't respond if you thought our posts did not have enough information for your needs. thanks, ~Ray
Premium Content
You need an Expert Office subscription to comment.Start Free Trial