Checkboxes

Question

urbanthistleuk 0 Newbie Poster

12 Years Ago

Hi all,

My apologies if this has been asked before, but I am unable to find any help with this problem I am experiencing.

I have currently developed a mysql database with a php form that allow me to fill out all fields and check boxes which works fine and updates the database ok.

My problem is when I call the data back on a view/edit page (form), I get all data in the text boxes but not in the check boxes, I am stumbled on how to do this and I also want to be able to update the check boxes if required,

Any help would be great,

Martin

php

3 Contributors
20 Replies
152 Views
1 Day Discussion Span
Latest Post 12 Years Ago Latest Post by urbanthistleuk

All 20 Replies

deceptikon 1,790 Code Sniper

12 Years Ago

If the checkbox should be checked, add checked="checked" to the input tag attributes:

<input type="checkbox" name="foo" value="1" <?= $foo ? 'checked="checked"' : '' ?> >

deceptikon 1,790 Code Sniper

12 Years Ago

This is a stupid question, but taking my example above, are you making sure that $foo contains the value you expect?

simplypixie 123 Posting Pro in Training

12 Years Ago

Simply this:

<input type="checkbox" name="variablename" value="yourrequiredvalue" <?php if (!empty($variablename) && $variablename == 'yourrequiredvalue') { echo 'selected'; } ?> >

Obviously you need to replace the name and value in the checkbox to match your variables and values and then compare the value of the variable that matches what is stored in your database for this checkbox with the value you have stipulated for the checkbox and if they match echo selected.

Edited 12 Years Ago by simplypixie because: n/a

simplypixie 123 Posting Pro in Training

12 Years Ago

The variable declaration should be in brackets:

$intro = 'yes';

simplypixie 123 Posting Pro in Training

12 Years Ago

Sorry, that should have said should NOT be in brackets as in the example code I posted.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

urbanthistleuk 0 Newbie Poster · Answer 1 · 2012-01-26T04:05:50+00:00

Thanks for your reply deceptikon,

I have added this to existing code but I am still having problems - when I open the form to edit it, the tick boxes are unticked,

On submitting the form the check boxes are ticked

Martin

urbanthistleuk 0 Newbie Poster · Answer 2 · 2012-01-26T16:21:39+00:00

This is a stupid question, but taking my example above, are you making sure that $foo contains the value you expect?

My apologies if this is a stupid question, I am quite new the php development and have never used checkboxes in any my projects before

urbanthistleuk 0 Newbie Poster · Answer 3 · 2012-01-26T16:22:27+00:00

Thanks simplypixie for the replay,

I will try this later

Martin

urbanthistleuk 0 Newbie Poster · Answer 4 · 2012-01-27T00:35:33+00:00

Thanks for your replies,

Have managed to figure it out, got some of it working

urbanthistleuk 0 Newbie Poster · Answer 5 · 2012-01-27T01:14:22+00:00

Hi,

I have used the following code

<input class="auto-style6" name="intro" type="checkbox" value="yes"  <?php if (!empty($intro) && $intro == 'yes') { echo 'selected'; } ?> />

And declared intro at the top of my page and set as below

$intro = ('yes');

But still having problems when I load the page and the checkboxes staying blank, in the database intro is marked as yes, but some on my other checkboxes are blank so the checkboxes should remain blank on my page,

Any thoughts to where I'm going wrong

urbanthistleuk 0 Newbie Poster · Answer 6 · 2012-01-27T01:48:12+00:00

The variable declaration should be in brackets:
$intro = 'yes';

Hi simplypixie,

Thanks for coming back to me,

I have put the variables in brackets but still getting the same problem

urbanthistleuk 0 Newbie Poster · Answer 7 · 2012-01-27T01:55:49+00:00

Sorry, that should have said should NOT be in brackets as in the example code I posted.

Thanks,

Have tried both ways still not working for me I'm afraid

Thanks for your assistance

simplypixie 123 Posting Pro in Training · Answer 8 · 2012-01-27T02:04:17+00:00

My bad again - it should be

echo 'checked';

, not

echo 'selected';

urbanthistleuk 0 Newbie Poster · Answer 9 · 2012-01-27T02:26:53+00:00

My bad again - it should be
echo 'checked';
, not
echo 'selected';

Thanks,

It is now showing them ticked in my form which is great,

Only got one last problem, all ones ones which are blank in the database are also being ticked in the form, is there way of only showing the ones which are ticked and leaving the ones which are blank empty

simplypixie 123 Posting Pro in Training · Answer 10 · 2012-01-27T02:49:52+00:00

If each checkbox has a corresponding field name in the table and you are assigning the values stored in the database to corresponding variable names then they should only be checked if the value = 1. I cannot help any more without your new code (php that is querying the db and assigning values to variables and your form code) to see what you are doing now after the changes.

urbanthistleuk 0 Newbie Poster · Answer 11 · 2012-01-27T02:57:47+00:00

Hi,

Thanks for coming back to me,

I have included my code below

PHP

<?php
$intro = 'yes';
?>

<?php
mysql_connect("localhost", "user", "pass")or die("cannot connect");
mysql_select_db("dbname")or die("cannot select DB");

$id=$_GET['migid'];

$sql="SELECT * FROM tabe_db WHERE migid='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>

HTML

<form action="proc.php" method="post">
			
Intro : 

<input class="auto-style6" name="intro" type="checkbox" value="yes" <?php if (!empty($intro) && $intro == 'yes') { echo 'checked'; } ?> />
<input class="auto-style6" name="Submit1" type="submit" value="Update" />
</form>

Thanks,

simplypixie 123 Posting Pro in Training · Answer 12 · 2012-01-27T03:20:35+00:00

Your code makes no sense I am afraid - you are not displaying the results from your query anywhere and you only have one checkbox in your form. I am confused.

urbanthistleuk 0 Newbie Poster · Answer 13 · 2012-01-27T03:37:25+00:00

Your code makes no sense I am afraid - you are not displaying the results from your query anywhere and you only have one checkbox in your form. I am confused.

Sorry for the confusion,

I only copied in some of the code as there is allot of it,

I have included all code below

<!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>

<?php

session_start();

if (!isset($_SESSION['usersession'])) {
        header('Location: index.php');
}

?>
<?php
$intro = 'yes';
$pos_domain_add  = 'yes';
$dns_mx  = 'yes';
$dns_srv = 'yes';
$org_pro = 'yes';
$mbox_created = 'yes';
$mbox_renamed = 'yes';
$aliase_add = 'yes';
$help_desk = 'yes';
$dns_prop = 'yes';
$pos_moved = 'yes';
$mbox_tested = 'yes';
$bes_add = 'yes';
$smartphone_add = 'yes';
$mbox_deleted = 'yes';
$reminder = 'yes';
?>
<?php
mysql_connect("localhost", "user", "pass")or die("cannot connect");
mysql_select_db("db")or die("cannot select DB");

$id=$_GET['migid'];

$sql="SELECT * FROM tabe WHERE migid='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>
</head>

<body>

<table align="center" cellpadding="4" class="auto-style1" style="width: 60%">
	<tr>
		<td style="width: 70px">
		<img height="48" src="img/image001.png" width="429" class="auto-style6" /></td>
		<td class="auto-style8">
		<a href="view-edit.php">View/Edit</a> - <a href="main.php">Control Panel </a></td>
	</tr>
	<tr>
		<td class="auto-style2" style="height: 48px" colspan="2"><strong>&nbsp;Edit Log </strong></td>
	</tr>
	<tr>
		<td colspan="2">
		<form action="proc.php" method="post">
			<table style="width: 100%">
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Status&nbsp;: </td>
					<td>
					<select name="status" class="auto-style6" style="height: 24px">
					<option><? echo $rows['status']; ?></option>
					<option>-- Update --</option>
					<option>Open</option>
					<option>On Hold</option>
					<option>Work in Progress</option>
					<option>Completed</option>
					</select></td>
				</tr>
				<tr>
					<td class="auto-style3" colspan="2">&nbsp;<span class="auto-style4"><strong><span class="auto-style7">-- 
					Detials</span></strong><span class="auto-style7"> -- </span>
					</span></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;ID 
					: </td>
					<td>
					<input class="auto-style6" name="id" type="text" style="width: 250px" value="<? echo $rows['id']; ?>" /></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Customer 
					: </td>
					<td>
					<input class="auto-style6" name="customer" type="text" style="width: 250px" value="<? echo $rows['customer']; ?>" /></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Primary 
					Domain : </td>
					<td>
					<input class="auto-style6" name="pri_domain" type="text" style="width: 250px" value="<? echo $rows['pri_domain']; ?>" /></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Accepted 
					Domains (Aliases) : </td>
					<td>
					<textarea class="auto-style6" name="acp_domains" style="width: 250px; height: 80px"><? echo $rows['acp_domains']; ?></textarea></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Agreed 
					Migration Date :&nbsp;</td>
					<td>
					<input class="auto-style6" name="agree_date" type="text" style="width: 250px" value="<? echo $rows['agree_date']; ?>" /></td>
				</tr>
				<tr>
					<td class="auto-style5" colspan="2"><strong>&nbsp;--&nbsp;Checklist&nbsp;-- </strong></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Introduction/Questions 
					: </td>
					<td class="auto-style6">
					<input class="auto-style6" name="intro" type="checkbox" value="yes" <?php if (!empty($intro) && $intro == 'yes') { echo 'checked'; } ?> /></td>
					
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;Postini 
					(Domain Added if Req) : </td>
					<td class="auto-style6">
					<input class="auto-style6" name="pos_domain_add" type="checkbox" value="yes" <?php if (!empty($pos_domain_add) && $pos_domain_add == 'yes') { echo 'checked'; } ?> /></td>
				</tr>
				<tr>
					<td class="auto-style6" style="width: 226px">&nbsp;DNS : </td>
					<td class="auto-style6">MX
					<input class="auto-style6" name="dns_mx" type="checkbox" value="yes" <?php if (!empty($dns_mx) && $dns_mx == 'yes') { echo 'checked'; } ?> />/>SRV
					<input class="auto-style6" name="dns_srv" type="checkbox" value="yes" <?php if (!empty($dns_srv) && $dns_srv == 'yes') { echo 'checked'; } ?> /> /></td>
				</tr>
				</table>
		</form>
		</td>
	</tr>
	<tr>
<?
mysql_close();
?>
		<td class="auto-style6" colspan="2">&nbsp;</td>
	</tr>
</table>

</body>

</html>

Thanks

simplypixie 123 Posting Pro in Training · Answer 14 · 2012-01-27T04:01:00+00:00

I can quite clearly see the problem now. You have set all your variables to equal yes when what you should be using the information from your database. So in the checkboxes you need to use the data like you do in your other form fields, for example:

<input class="auto-style6" name="intro" type="checkbox" value="yes" <?php if (!empty($rows['intro']) && $rows['intro'] == 'yes') { echo 'checked'; } ?> />

urbanthistleuk 0 Newbie Poster · Answer 15 · 2012-01-27T04:09:47+00:00

I can quite clearly see the problem now. You have set all your variables to equal yes when what you should be using the information from your database. So in the checkboxes you need to use the data like you do in your other form fields, for example:
<input class="auto-style6" name="intro" type="checkbox" value="yes" <?php if (!empty($rows['intro']) && $rows['intro'] == 'yes') { echo 'checked'; } ?> />

Thanks You simplypixie so much for your help on this one, it is most appreciated, this worked like a dream, a knew it could be done but didn't have a clue as I have not used checkboxes before

Thanks Again,
Martin

Checkboxes

Recommended Answers Collapse Answers

All 20 Replies

Recommended Answers