rmariano02 Posted August 17, 2011 Share Posted August 17, 2011 when i try to run this code no error comes out but the values is not storing in the database please help T_T Interface(client.php) Quote <form action="reserve.php" method="post"> Date: <select name='month'> <?php $montharray = array ("01","02","03","04", "05","06","07","08","09" ,"10","11","12"); foreach($montharray as $month){ echo "<option value=$month>$month</option>"; } ?> </select> <select name='day'> <?php for($i=1; $i<=31; $i++){ echo "<option value=$i>$i</option>"; } ?> </select> <select name='year'> <?php for($i=date(Y); $i>=1935; $i--){ echo "<option value=$i>$i</option>"; } ?> </select> <br/> Time: <select name="time"> <option value="10:00"> 10:00 am</option> <option value="11:00"> 11:00 am</option>s <option value="12:00"> 12:00 pm</option> <option value="1:00"> 1:00 pm</option> <option value="2:00"> 2:00 pm</option> <option value="3:00"> 3:00 pm</option> <option value="4:00"> 4:00 pm</option> <option value="5:00"> 5:00 pm</option> <option value="6:00"> 6:00 pm</option> <option value="7:00"> 7:00 pm</option> <option value="8:00"> 8:00 pm</option> </select> <br/> Service:<br/> <input name="0" value="check" type="checkbox"> Facial</input><br/> <input name="1" value="check" type="checkbox"> Diamond Microderma</input><br/> <input name="2" value="check" type="checkbox"> Peeling Procedure</input><br/> <input name="3" value="check" type="checkbox"> Pimple Treatment</input><br/> <input name="4" value="check" type="checkbox"> Pimple Injection</input><br/> <input name="5" value="check" type="checkbox"> Acne Surgery</input><br/> <input name="6" value="check" type="checkbox"> Cautery</input><br/> <input name="7" value="check" type="checkbox"> Acne-prone skin microneeding</input><br/> <input name="8" value="check" type="checkbox"> Advanced stem cell microneeding therapy</input><br/> <input name="9" value="check" type="checkbox"> Needle-less stem cell infusion</input><br/> <input name="10" value="check" type="checkbox"> Needle-less mesolift</input><br/> <input name="11" value="check" type="checkbox"> Botox</input><br/> <input name="12" value="check" type="checkbox"> Bio hair growth stem cell infusion</input><br/> <input name="13" value="check" type="checkbox"> RF Figure countour</input><br/> <input name="14" value="check" type="checkbox"> Slimming Massage</input><br/> <input name="15" value="check" type="checkbox"> PT Metabolic Accelerator</input><br/> <input name="16" value="check" type="checkbox"> Mesotherapy</input><br/> <input name="17" value="check" type="checkbox"> Ultrasonic Liposuction</input><br/> <input name="18" value="check" type="checkbox"> Filler</input><br/> <input name="19" value="check" type="checkbox"> Hair Removal</input><br/> <input name="20" value="check" type="checkbox"> Photorejuvenation</input><br/> <input name="21" value="check" type="checkbox"> Hyperpigmentation</input><br/> <input name="22" value="check" type="checkbox"> Acnecontrol</input><br/><br/> <input name="reserve" type="submit" onclick="show_alert()" value="Make Resevation"> </form> Validation(reserve.php) Quote <?php include('chkconnection.php'); session_start(); $user = $_SESSION['loggedInUser']; for($x=0;$x<=23;$x++){ $chk[$x] = 'uncheck'; } if(isset($_POST["reserve"])){ for($x=0;$x<=23;$x++){ if(isset($_POST["$x"])){ $chk[$x] = $_POST["$x"]; } } $date = $_POST["year"].$_POST["month"].$_POST["day"]; $time = $_POST["time"]; mysql_query("INSERT INTO ff_tblreserve (Facial, Diamond_Microderma, PeelingsProcedure, Pimple_Treatment, Pimple_Injection, Acne_Surgery, Acne_prone_skin_microneeding, Advanced_stem_cell_microneeding_therapy, Needle_less_stem_cell_infusion, Needle_less_mesolift, Botox, Bio_hair_growth_stem_cell_infusion, RF_Figure_countour, Slimming_Massage, PT_Metabolic_Accelerator, Mesotherapy, Ultrasonic_Liposuction, Filler, Hair_Removal, Photorejuvenation, Hyperpigmentation, Acnecontrol, time, date, id) VALUES ('$chk[1]','$chk[2]','$chk[3]','$chk[4]','$chk[5]','$chk[6]','$chk[7]','$chk[8]','$chk[9]','$chk[10]','$chk[11]', '$chk[12]','$chk[13]','$'chk[14]','$chk[15]','$chk[16]','$chk[17]','$chk[18]','$chk[19]','$chk[20]','$chk[21]', '$chk[22]','$chk[23]','$time','$date',$user)");} ?> Link to comment https://forums.phpfreaks.com/topic/245059-php-array-checkbox-help-xd-storing-in-database/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.