Jump to content

Archived

This topic is now archived and is closed to further replies.

Adrian4263

Show checkbox is checked based on database value.

Recommended Posts

How could I declare checkbox, if checkbox is checked = 1 else = 0.And insert to mySQL.

 

<input type="checkbox" name="homepage" value="1" />   <-----this is my checkbox code. Only this i know.

 

somemore,if i already insert data to mySQL, how could i display checkbox is checked based on database, 1 = checked, 0 = unchecked.

 

I had try many code,but it won't work as well..Now i've no idea.

 

P/S:I'm using php code.

 

Please help.

Thanks.

Regards.

 

Share this post


Link to post
Share on other sites

 

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

 

Where $homepage is the data retrieved from your database.

Share this post


Link to post
Share on other sites
<input type="checkbox" name="homepage" value="1" <?php echo ($homepage == 1) ? 'checked="checked"' : ''; ?>/>

Where $homepage is the data retrieved from your database.

 

Thanks for your answer, i had tried your code, but the checkbox still show unchecked even my database value is 1

Share this post


Link to post
Share on other sites
Here is a sample that works:



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


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


 

I suspect your database value is not in $homepage.

 

try:

 



<?php 
var_dump($homepage);
?>


 

To see if the value is actually there from the DB.

Share this post


Link to post
Share on other sites

Here is a sample that works:

 

 

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


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

I suspect your database value is not in $homepage.

 

try:

 

 

<?php 
var_dump($homepage);
?>
 

To see if the value is actually there from the DB.

 

Thanks for your answer. I tried the code that you gave. If i add the code, it will add 2 more checkbox out, 1 is checked and the other one is unchecked. 1 of the checkbox always show checked, even the value is 0.

 

<?php 
var_dump($homepage);
?>
It come out value is "NULL"

I put this code at after the checkbox code.

 

What's wrong?

Share this post


Link to post
Share on other sites

Your database value is not in the variable.

 

How are you getting the value from Database?

 

How are you storing the value in Database?

Share this post


Link to post
Share on other sites

<?php

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


?>
<html>
<head>
<title>De Closet | Update Product</title>

<link rel="stylesheet" type="text/css" href="css/lstyle.css" />
<link rel="stylesheet" type="text/css" href="css/login.css" />
</head>
<body>
<?php
include("oHeader.php");
?>

<p>
<div id="cslay">
<?php
include("oSide.php");
?>

<div id="content">
<div id="login" style="width:648px">
<form action="proEditPros.php" method=POST style="width:420px" enctype="multipart/form-data">
<?php
include("config.php");

//$querySelect="SELECT * FROM product WHERE prodID='$prodID'";
//$resultSelect=mysql_query($querySelect) or die ('Error: '.mysql_error ()) ;
//$sql = "SELECT * FROM product WHERE homepage='".$_GET['homepage']."'";
//$result = mysql_query($sql);
//$row = mysql_fetch_array($result);
//$checked = $result['homepage'];

?>

<?php
include("config.php");
$query1="SELECT * FROM product WHERE id='".$_GET['id']."'";
$result1=mysql_query($query1);
while($row1=mysql_fetch_array($result1))
{
?>
<label for="prodID">Product ID:</label>
<input type="text" id="prodID" name="prodID" value="<?php echo $row1['prodID']; ?>" />
<br />
<label for="prodName">Product Name:</label>
<input type="text" id="prodName" name="prodName" value="<?php echo $row1['prodName']; ?>" />

<label for="prodPrice">Price(MYR):</label>
<input type="text" id="prodPrice" name="prodPrice" value="<?php echo $row1['prodPrice']; ?>" />

<label for="prodCat">Category:</label>
<input type="text" id="prodCat" name="prodCat" value="<?php echo $row1['prodCat']; ?>" />
<br />

<label for="pDetails">Product Details:</label>
<textarea rows="29" cols="50" name="prodDet" id="prodDet" value="<?php echo nl2br($row1['prodDet']); ?>"></textarea>
<br />



<td>
<!--<label><input type="checkbox" id="homepage" name="homepage" value="1" />Tick for show at Homepage for this product</label> -->
<input type="checkbox" name="homepage" value="1" <?php echo ($homepage == 1) ? 'checked="checked"' : ''; ?>/>

</td>

<br />
<br />
<label for="prodImage">New Main Image:</label>
<input type="file" name="prodImage" id="prodImage" />
<?php

?>
<!--<label for="prodImage">Images:</label>
<input type="file" name="prodImage" id="prodImage" />-->
<?php
}
?>

<div id="lower" style="background: #F5D0A9">

<input type="submit" name="update" value="Update Product" style="width:150px" />
</form>

<button style="width:100px"><a href="products.php">Back</a></button>

</div><!--/ lower-->

</div>
</div>

<div id="blay5">
</div>

</div>
</p>
<?php
include("oBottom.php");
?>
</body>
</html>
this is interface name it as proEdit.php

Share this post


Link to post
Share on other sites

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">

<?php

@session_start();
if(!isset($_POST['update']))
{
header('Location:index.php');
}
?>



<html>
<head>
<title>De Closet | Update Product</title>

<link rel="stylesheet" type="text/css" href="css/lstyle.css" />
<link rel="stylesheet" type="text/css" href="css/tableStyle.css" />
<script>
document.onkeydown = function(){
switch (event.keyCode){
case 116 : //F5 button
event.returnValue = false;
event.keyCode = 0;
return false;
case 82 : //R button
if (event.ctrlKey){
event.returnValue = false;
event.keyCode = 0;
return false;
}
}
}
</script>

</head>
<body>
<?php
include("oHeader.php");
?>
<p>
<div id="cslay">
<?php
include("oSide.php");
?>

<div id="content">

<?php
include("config.php");

$prodID=$_POST["prodID"];
$prodName=$_POST["prodName"];
$prodPrice=$_POST["prodPrice"];
$prodCat=$_POST["prodCat"];
$prodImage=$_POST["prodImage"];
$prodDet=$_POST["prodDet"];
$homepage=$_POST["homepage"];


$queryCheck = "SELECT prodID FROM product WHERE prodID='$prodID'";
$resultCheck = mysql_query($queryCheck);

//if(mysql_num_rows($resultCheck)==0)
//{
/*
$allowedExts = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $_FILES["prodImage"]["name"]);
$extension = end($temp);
if ((($_FILES["prodImage"]["type"] == "image/gif")
|| ($_FILES["prodImage"]["type"] == "image/jpeg")
|| ($_FILES["prodImage"]["type"] == "image/jpg")
|| ($_FILES["prodImage"]["type"] == "image/pjpeg")
|| ($_FILES["prodImage"]["type"] == "image/x-png")
|| ($_FILES["prodImage"]["type"] == "image/png"))
&& ($_FILES["prodImage"]["size"] < 20000)
&& in_array($extension, $allowedExts))
{
if ($_FILES["prodImage"]["error"] > 0)
{
echo "Return Code: " . $_FILES["prodImage"]["error"] . "<br>";
}
else
{

}
}
else
{

//echo "Invalid file";
}
*/
if(!empty($_FILES['image']['tmp_name']))
{
$tmpName = $_FILES['prodImage']['tmp_name'];

// Read the file
$fp = fopen($tmpName, 'r');
$data = fread($fp, filesize($tmpName));
$data = addslashes($data);
fclose($fp);

$query="UPDATE product SET prodID='$prodID', prodName='$prodName', prodPrice='$prodPrice', prodCat='$prodCat', prodDet='$prodDet', prodImage='$data', homepage='$homepage' WHERE prodID='$prodID'" ;
$result = mysql_query($query) or die ('Error: '.mysql_error ()) ;
}
else
{
$query="UPDATE product SET prodID='$prodID', prodName='$prodName', prodPrice='$prodPrice', prodCat='$prodCat', prodDet='$prodDet', homepage='$homepage' WHERE prodID='$prodID'" ;
$result = mysql_query($query) or die ('Error: '.mysql_error ()) ;
}
if($result)
{
$query1="SELECT * FROM product WHERE prodID='$prodID'";

echo "You have update a product.<a href='products.php'>Click here</a> to continue.";
$querySelect="SELECT * FROM product WHERE prodID='$prodID'";
$resultSelect=mysql_query($querySelect) or die ('Error: '.mysql_error ()) ;
while($row=mysql_fetch_array($resultSelect))
{
?>

<table cellspacing='0' id="tStyle"> <!-- cellspacing='0' is important, must stay -->

<!-- Table Header -->
<thead>
<tr>
<th></th>
<th>Product Detail</th>
</tr>
</thead>
<!-- Table Header -->

<!-- Table Body -->
<tbody>

<tr>
<td>Product ID</td>
<td><?php echo $row["prodID"]; ?></td>

</tr><!-- Table Row -->

<tr class="even">
<td>Product Name</td>
<td><?php echo $row["prodName"]; ?></td>

</tr><!-- Darker Table Row -->

<tr>
<td>Price</td>
<td><?php echo "RM".$row["prodPrice"].""; ?></td>

</tr>

<tr class="even">
<td>Category</td>
<td><?php echo $row["prodCat"]; ?></td>
</tr>

<tr>
<td>Image</td>
<td>
<img src="data:image/jpeg;base64,<?php echo base64_encode($row["prodImage"]); ?>" width="190px" height="190px" />
</td>
</tr>
</tbody>
<!-- Table Body -->

</table>
<?php

}

}

else
{
echo "Failed to update.";
}

//}
//else
//{
//echo '<h4>Sorry! Product ID has been in the database. <a href="newProduct.php"> Try again </a></h4>';
//}
?>

</div>

<div id="blay5">
</div>

</div>
</p>
</body>
</html>
this is action page, i name it as proEditPros.php

Share this post


Link to post
Share on other sites

replace:

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

 

With:

<input type="checkbox" name="homepage" value="1" <?php echo ($row1['homepage'] == 1) ? 'checked="checked"' : ''; ?>/>

Share this post


Link to post
Share on other sites

replace:

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

 

With:

<input type="checkbox" name="homepage" value="1" <?php echo ($row1['homepage'] == 1) ? 'checked="checked"' : ''; ?>/>

It's work. Thanks.

 

I got another question to ask..

Let say i have 10 product, only 2 of the product i tick the checkbox, and checkbox checked only list out the product. How should i write the code? I will show you the code after this post.

Share this post


Link to post
Share on other sites

<?php
	@session_start();
?>

<html>
	<head>
		<title>De Closet | Home</title>
		<link rel="icon" type="image/png" href="images/set5.png" />
		<link rel="stylesheet" type="text/css" href="css/lstyle.css" />
		<link rel="stylesheet" type="text/css" href="css/catalog.css" />
		<link rel="stylesheet" type="text/css" href="css/button.css" />

	</head>
	<body>

		<?php
			include("oHeader.php");
		?>

		<?php
			include("config.php");

			$queryPromo="SELECT * FROM promo";

			$resultPromo=mysql_query($queryPromo);

			while($rowPromo=mysql_fetch_array($resultPromo))
			{
				echo '<div id="promo">';
				echo '<img src="data:image/jpeg;base64,'.base64_encode($rowPromo["image"]).'" width="940px" height="260px" />';
				echo '</div>';
			}
		?>

		<p>
			<div id="cslay">
				<?php
					include("oSide.php");
				?>

				<div id="content">
					<?php
						include("config.php");

						$query="SELECT * FROM product ORDER BY id DESC";
						$result=mysql_query($query);
						while($row=mysql_fetch_array($result))
						{
							?>
							<div id="product">
								<a href="pDetails.php?id=<?php echo $row['id']; ?>">
									<img src="data:image/jpeg;base64,<?php echo base64_encode($row["prodImage"]);?>" width="190px" height="190px" />
								</a>
								<p>
									<b><?php echo $row["prodID"]; ?></b>
								</p>
								<p><?php echo $row["prodName"]; ?></p>
								<p>RM<?php echo $row["prodPrice"]; ?></p>
								<p>
									<a href="pDetails.php?id=<?php echo $row['id']; ?>" class="button">Product Details</a>
								</p>
							</div>

							<?php
						}
					?>
				</div>

				<div id="blay5">
				</div>

			</div>
		</p>
		<?php
			include("oBottom.php");
		?>
	</body>
</html>
This is my homepage code, i name it as index.php

whatever i tick(checked) the product,it will show out at this page(homepage)

How should i write the code if checkbox checked then this product will show at homepage(index.php).

 

Thanks

Regards.

Share this post


Link to post
Share on other sites

<?php
	@session_start();
?>

<html>
	<head>
		<title>De Closet | Home</title>
		<link rel="icon" type="image/png" href="images/set5.png" />
		<link rel="stylesheet" type="text/css" href="css/lstyle.css" />
		<link rel="stylesheet" type="text/css" href="css/catalog.css" />
		<link rel="stylesheet" type="text/css" href="css/button.css" />

	</head>
	<body>

		<?php
			include("oHeader.php");
		?>

		<?php
			include("config.php");

			$queryPromo="SELECT * FROM promo";

			$resultPromo=mysql_query($queryPromo);

			while($rowPromo=mysql_fetch_array($resultPromo))
			{
				echo '<div id="promo">';
				echo '<img src="data:image/jpeg;base64,'.base64_encode($rowPromo["image"]).'" width="940px" height="260px" />';
				echo '</div>';
			}
		?>

		<p>
			<div id="cslay">
				<?php
					include("oSide.php");
				?>

				<div id="content">
					<?php
						include("config.php");

						$query="SELECT * FROM product ORDER BY id DESC";
						$result=mysql_query($query);
						while($row=mysql_fetch_array($result))
						{
							?>
							<div id="product">
								<a href="pDetails.php?id=<?php echo $row['id']; ?>">
									<img src="data:image/jpeg;base64,<?php echo base64_encode($row["prodImage"]);?>" width="190px" height="190px" />
								</a>
								<p>
									<b><?php echo $row["prodID"]; ?></b>
								</p>
								<p><?php echo $row["prodName"]; ?></p>
								<p>RM<?php echo $row["prodPrice"]; ?></p>
								<p>
									<a href="pDetails.php?id=<?php echo $row['id']; ?>" class="button">Product Details</a>
								</p>
							</div>

							<?php
						}
					?>
				</div>

				<div id="blay5">
				</div>

			</div>
		</p>
		<?php
			include("oBottom.php");
		?>
	</body>
</html>
This is my homepage code, i name it as index.php

whatever i tick(checked) the product,it will show out at this page(homepage)

How should i write the code if checkbox checked then this product will show at homepage(index.php).

 

Thanks

Regards.

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.