help with php mysql checkbox

azukah · March 14, 2010

My checkbox works: when i check it I see "new" and when not checked is see nothing ("") what i can't figure out is how do i make stick so when i go into modify view, if checked to stayed checked. right now, when i go to modify a record that has the box checked, it shows unchecked. i'd like to keep it checked if checked... makes sense? any ideas woudl be greatly appreciate it!

<?php

ob_start();

require_once('../cms_config.php');

require_once('../cms_functions/ximageupload.php');

mysql_select_db($database, $makeconnection);

$sql_get_cats="SELECT *

FROM tbl_cat

ORDER BY cat_name ASC";

$get_cats = mysql_query($sql_get_cats, $makeconnection) or die(mysql_error());

$row_get_cats = mysql_fetch_assoc($get_cats);

$totalRows_get_cats = mysql_num_rows($get_cats);

if(isset ($_GET['prod'])&& $_GET['prod']!=""){

$prod_id=$_GET['prod'];

mysql_select_db($database, $makeconnection);

$sql_find_prod = "SELECT * FROM tbl_products WHERE prod_id = $prod_id";

$find_prod = mysql_query($sql_find_prod, $makeconnection) or die(mysql_error());

$row = mysql_fetch_assoc($find_prod);

$totalRows = mysql_num_rows($find_prod);

$prod_name = $_POST['prod_name'];

$prod_artist = $_POST['prod_artist'];

$prod_price = $_POST['prod_price'];

$prod_desc = $_POST['prod_desc'];

$prod_cat = $_POST['prod_cat'];

$prod_new = (isset($_POST['prod_new']) && $_POST['prod_new'] == '1')? "NEW" : "";

if (isset($_POST['submitted'])&&($_POST['submitted'] == "yes")) {

$register_query = "SELECT prod_name FROM tbl_products WHERE prod_name='$prod_name'";

mysql_select_db($database, $makeconnection);

$register_check=mysql_query($register_query, $makeconnection);

$register_found_prod = mysql_num_rows($register_check);

if($register_found_prod>1){

header ("Location: prod_modify.php?error=prodnameexists&prod=$prod_id");

}else{

if(isset($_POST['change_img']) && $_POST['change_img']=='yes'){

$prod_img=upload_prod_img();

$sql_modify = "UPDATE tbl_products SET

prod_new = '$prod_new',

prod_name = '$prod_name',

prod_artist = '$prod_artist',

prod_price = '$prod_price',

prod_cat = '$prod_cat',

prod_desc = '$prod_desc',

prod_img='$prod_img'

WHERE prod_id = '$prod_id'";

}else{

$sql_modify = "UPDATE tbl_products SET

prod_new = '$prod_new',

prod_name = '$prod_name',

prod_artist = '$prod_artist',

prod_price = '$prod_price',

prod_cat = '$prod_cat',

prod_desc = '$prod_desc'

WHERE prod_id = '$prod_id'";

}

mysql_select_db($database, $makeconnection);

$Result1 = mysql_query($sql_modify, $makeconnection) or die(mysql_error());

header ("Location: prod_view.php");

}

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Kuy:to CMS | Modify Vectors</title>

</head>

<body>

<?php include("../xcmsnav.php");?>

<h1>Modifying Detailes for: <? echo $row['prod_name']?></h1>

<p>Change vectors' name, price, category, description and/or image.</p>

</div>

<p><a href="prod_view.php"> CANCEL</a></p>

</div>

</div>

<tr>

<td colspan="2" class="myloginerror"><?php

if($_GET['error']=="catnameexists"){

echo ' <strong>Sorry... there is a problem with your category:</strong><br/>Already in use. Please try again.<br/><br/>';

}

?></td>

</tr>

<td width="200" align="right" valign="middle" class="formtext">New Vector </td>

</tr>

<td width="200" align="right" valign="middle" class="formtext">Vector Name<font color="#FF0000">*</font></td>

<span class="textfieldRequiredMsg">required!</span></span></label></td>

</tr>

<td width="200" align="right" valign="middle" class="formtext">Artist Name<font color="#FF0000">*</font></td>

<span class="textfieldRequiredMsg">required!</span></span></label></td>

</tr>

<td align="right" class="formtext">Price<font color="#FF0000">*</font></td>

<span class="textfieldRequiredMsg">required!</span><span class="textfieldInvalidFormatMsg">invalid format!</span></span></p></td>

</tr>

<td align="right" class="formtext">Category<font color="#FF0000">*</font></td>

<?php do {

if($row_get_cats['cat_id']==$row['prod_cat']){

$makestelcted=' selected="selected" ';

}else{

$makestelcted='';

}

?>

<option

<?php echo $makestelcted; ?>

value="<?php echo $row_get_cats['cat_id']; ?>"> <?php echo $row_get_cats['cat_name']; ?> </option>

<?php } while ($row_get_cats = mysql_fetch_assoc($get_cats)); ?>

</select> <span class="ptext1_emph">

<?php

if($_GET['error']=="nocat"){

echo "<strong>Please, select a category for this vector</strong>";

}

?>

</span></td>

</tr>

<td align="right" valign="top" class="formtext">Desctiption</td>

</tr>

<td align="right" valign="top" class="formtext">Image</td>

<td align="left" class="fieldtext"><p><img src="../../images/products/<? echo $row['prod_img']?>" alt="" name="img_modify" height="100" id="img_modify" /></p>

<p>

check for new image <em>(leave <strong>unchecked</strong> if you want to keep the current image)</em></p>

<em>Formats: jpg, gif, png</em></p></td>

</tr>

</tr>

</table>

</form>

</div>

</div>

<!--

var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4", "none", {validateOn:["blur"]});

var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1", "none", {validateOn:["blur"]});

var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2", "currency");

//-->

</script>

</body>

</html>

5kyy8lu3 · March 14, 2010

you'll probably want to post that in [ php ] [ /php ] tags to get helped =)

p.s. those tags only without the spaces

GalaxyTramp · March 14, 2010

<?php

$prod_new="yes";


?>

<input name="change_img" type="checkbox" class="mycheck" id="change_img" value="yes" <?php if($prod_new=="yes"){echo" checked";}?> />

Sign In

help with php mysql checkbox

Recommended Posts

azukah

Link to comment

Share on other sites

5kyy8lu3

Link to comment

Share on other sites

GalaxyTramp

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information