PHP SQL + HTML checkboxes

denby · 26 Nov 2012 at 09:25

Hi

im just looking for a bit of help on the best way to do this..

so i have a sample SQL Database

now from that DB i want my HTML page to show checkboxes ticked if there is a "1" in the corresponding checkbox field

can anyone advise on the best way to do this?

thanks

Edward01 · 26 Nov 2012 at 09:39

<?php if($var == 1) : ?>checked="checked"<?php endif;?>

denby · 26 Nov 2012 at 09:54

hi

thanks for the response

im guessing i will have make the query a variable first?

eg:

Code:

$var = mysql_query("SELECT * FROM chkbx1")

denby · 26 Nov 2012 at 15:23

how about

Code:

<?php
include_once 'includes/db.php';

$sql = "SELECT somecolumm FROM sometable";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$checked = $result['somecolumm'];

?>

<input type="checkbox" name="somecolumm" value="1" <?php if ($checked == 1) echo 'checked'; ?> />

Varsh · 26 Nov 2012 at 18:21

I've expanded on denby's example as his is spot on, the only difference is that instead of "include_once" I would always use "require_once" whenever the database connection file is concerned, I'd rather have the script stop immediately if there's an error.

Code:

<?php
	require_once "db.php";
	$sql 		= "SELECT * FROM database_name";
	$result 	= mysql_query($sql);
	$row 		= mysql_fetch_array($result);
	$chkbox1 	= $result['chkbx1'];
	$chkbox2 	= $result['chkbx2'];
?>
<table>
	<tr>
		<td>1</td>
		<td><input type="checkbox"
			<?php
				if ($chkbox1 == 1)
					echo " checked "
			?>	
		/></td>
	</tr>
	<tr>
		<td>2</td>
		<td><input type="checkbox"
			<?php
				if ($chkbox2 == 1)
					echo " checked "
			?>	
		/></td>
	</tr>
</table>

denby · 26 Nov 2012 at 19:18

Varsh said:
I've expanded on denby's example as his is spot on, the only difference is that instead of "include_once" I would always use "require_once" whenever the database connection file is concerned, I'd rather have the script stop immediately if there's an error.

Code:

<?php require_once "db.php"; $sql = "SELECT * FROM database_name"; $result = mysql_query($sql); $row = mysql_fetch_array($result); $chkbox1 = $result['chkbx1']; $chkbox2 = $result['chkbx2']; ?> <table> <tr> <td>1</td> <td><input type="checkbox" <?php if ($chkbox1 == 1) echo " checked " ?> /></td> </tr> <tr> <td>2</td> <td><input type="checkbox" <?php if ($chkbox2 == 1) echo " checked " ?> /></td> </tr> </table>

Nice one , one thing though it doesn't say which table in the DB to pull data from

Should it be select * from database where. Colummname = chkbox1;

?

Stryda09 · 26 Nov 2012 at 19:30

denby said:
Nice one , one thing though it doesn't say which table in the DB to pull data from

Should it be select * from database where. Colummname = chkbox1;

?

SELECT * FROM tableName

The SQL connection connects to the database, queries are then performed on the tables in that Database.

denby · 26 Nov 2012 at 19:55

Hi

thanks for all your replies so far , it is greatly appreciated

now they are both constantly checked,even though one of the columns has a "0" in it

Code:

<?php

define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'XXXXXXXXXX');
define('DB_PASSWORD', 'XXX');
define('DB_DATABASE', 'sbsuppli_game');
$connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
$database = mysql_select_db(DB_DATABASE) or die(mysql_error());

$sql = "SELECT * FROM game";
	$result 	= mysql_query($sql);
	$row 		= mysql_fetch_array($result);
	$chkbox1 	= $result['chkbx1'];
	$chkbox2 	= $result['chkbx2'];
	
?>
<table>
	<tr>
		<td>1</td>
		<td><input type="checkbox"
			<?php
				if ($chkbox1 == 1)
					echo " checked "
			?>	
		</td>
	</tr>
	<tr>
		<td>2</td>
		<td><input type="checkbox"
			<?php
				if ($chkbox2 == 1)
					echo " checked "
			?>	
		</td>
	</tr>
</table>
?>

Stryda09 · 26 Nov 2012 at 20:13

I think it should be checked="checked" not just checked.

so, replace:

echo " checked "

with

echo' checked="checked" '

Edit: Not sure if you need ; with inline php in a html doc. I usually just write pure php.

denby · 26 Nov 2012 at 20:27

changed that , ive put some ; in and i have named the checkboxes
still no good

PHP CODE:
http://pastebin.com/EF3i9xgn
HTML Code:
http://pastebin.com/PbdR17KS

Stryda09 · 26 Nov 2012 at 20:33

Ok. I don't have WAMP installed at the moment so can't quickly change it all.

It looks like you are crossing between php and html without stating that you are. Is this a .html file or a .php file?

If it is .html I think the check section should be like this:

<?php
if ($chkbox2 == 1)
{
echo ' checked="checked" ';
}
?>

The saving of the Database values to variables $chkbox1 and 2 are wrong. It should be:

$sql = "SELECT * FROM game";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$chkbox1 = $row['chkbx1'];
$chkbox2 = $row['chkbx2'];

I'll sort WAMP out in a minute and write it all out properly. If you want it as a php file all html content (The stuff the user actually sees) should be echoed.

e.g. echo ' <table></table>';

denby · 26 Nov 2012 at 20:34

thanks Styda09 i really appreciate your help

Stryda09 · 26 Nov 2012 at 21:03

Right. This is for a .php file to be run off the server, so game.php for instance. This code works, obviously change your database settings, sorry I changed it so much I'm not used the the DEFINE thing. I tend to put the db connection in an includes file and just require it at start of php code.

<?php

$host = "localhost";

$username = "root";

$password = "";

$database = "test";

$conn = mysql_connect($host, $username, $password) or die ("Could not connect");
$db = mysql_select_db($database, $conn) or die ("Could not select DB");

$strSQL = "SELECT * FROM game";
$result = mysql_query($strSQL);
$row = mysql_fetch_assoc($result);
$chkbox1 = $row['chkbx1'];
$chkbox2 = $row['chkbx2'];

echo '
<table>
<tr>
<td>1</td>
<td><input type="checkbox"';

if ($chkbox1 == 1)
{
echo ' checked="checked" ';
}
echo '
</td>
</tr>
<tr>
<td>2</td>
<td><input type="checkbox"
';
if ($chkbox2 == 1)
{
echo ' checked="checked" ';
}

echo '
</td>
</tr>
</table>
';
?>

http://pastebin.com/0bgxEGrN (For some coloured formatting)

Any problems just ask.

denby · 26 Nov 2012 at 21:08

that works perfectly..thankyou

i shall go through it line by line and learn it for next time

thanks again

Varsh · 26 Nov 2012 at 22:18

Stryda09 said:
I think it should be checked="checked" not just checked.

Edit: Not sure if you need ; with inline php in a html doc. I usually just write pure php.

It was working for me with just checked but it works either way anyway, also if you don't use the curly brackets then you don't need a semi-colon but I suppose it is good practice to always use curly brackets and the semi-colon.