[SOLVED] PHP and Mysql Date

abch624 · June 24, 2008

Hi All,

I have a piece of code that inserts user data into the database. I have a HTML for that gets the date of birth as three separate variables $month, $date, $year. I then concatenate these before inserting into the db like this:

$dateofbirth=$year."-".$month."-".$date;

but when I execute the update sql query every thing gets updated but the date gets set to 0000-00-00!!!

The dateofbirth field in the database which is a mysql database is set as type = date.

I have attached the code that is related to this. Please have a look and help:)

Piece of code for EditProfile.php

<form class="form" method="post" action="editprofileupdate.php">
				<table border="0" cellpadding="0" cellspacing="0" width="600" align="center">
		   		  	<tr>
      				  	  	<td width="250" class="formEdit">First Name*:</td>
      					  	<td width="135"><input name="firstname" value="<?php echo $row_personal['firstName']; ?>" id="firstname"></td>
      				 	</tr>
					<tr>
      				  	  	<td width="250" class="formEdit">Last Name*:</td>
      					  	<td width="135"><input name="lastname" value="<?php echo $row_personal['lastName']; ?>" id="lastname"></td>
						<td><input type="checkbox" name="lastnamecheck" value="Yes" id="lastnamecheck"></td>
      				 	</tr>
					<tr>
      				  	  	<td width="250" class="formEdit">Occupation*:</td>
      					  	<td width="135"><input name="occupation" value="<?php echo $row_personal['occupation']; ?>" id="occupation"></td>
      				 	</tr>
					<tr>
      				  	  	<td width="250" class="formEdit" valign="top">Profile Picture:</td>
      					  	<td width="135" height="130"><img height="130" alt="logo" src="./images/profile.jpg" width="130"></td>
						<td width="250" valign="bottom"><input type="submit" value="Choose Picture"></td>
      				 	</tr>
					<tr>
      				  	  	<td width="250" class="formEdit">Gender*:</td>
						<td width="135" class="formInput">Male<input type="radio" name="sex" value="M" td="" <?php if ($row_personal['sex'] == "M") { echo 'CHECKED';} ?>>Female<input type="radio" name="sex" value="F" td=""<?php if ($row_personal['sex'] == "F") { echo 'CHECKED';} ?>></td>
      				 	</tr>
					<tr>
      				  	  	<td width="250" class="formEdit">Birthday*:</td>
						<td width="250">
							<select name="month">
								<option value="01" selected="">January</option>
								<option value="02">February</option>
								<option value="03">March</option>
								<option value="04">April</option>
								<option value="05">May</option>
								<option value="06">June</option>
								<option value="07">July</option>
								<option value="08">August</option>
								<option value="09">September</option>
								<option value="10">October</option>
								<option value="11">November</option>
								<option value="12">December</option>
							</select>
							<select name="date">
								<option value="1" selected="">1</option>
								<option value="2">2</option>
								<option value="3">3</option>
								<option value="4">4</option>
								<option value="5">5</option>
								<option value="6">6</option>
								<option value="7">7</option>
								<option value="8">8</option>
								<option value="9">9</option>
								<option value="10">10</option>
								<option value="11">11</option>
								<option value="12">12</option>
								<option value="13">13</option>
								<option value="14">14</option>
								<option value="15">15</option>
								<option value="16">16</option>
								<option value="17">17</option>
								<option value="18">18</option>
								<option value="19">19</option>
								<option value="20">20</option>
								<option value="21">21</option>
								<option value="22">22</option>
								<option value="23">23</option>
								<option value="24">24</option>
								<option value="25">25</option>
								<option value="26">26</option>
								<option value="27">27</option>
								<option value="28">28</option>
								<option value="29">29</option>
								<option value="30">30</option>
								<option value="31">31</option>
							</select>
							<select name="year">
								<option value="2008" selected="">2008</option>
								<option value="2007">2007</option>
								<option value="2006">2006</option>
								<option value="2005">2005</option>
								<option value="2004">2004</option>
								<option value="2003">2003</option>
								<option value="2002">2002</option>
								<option value="2001">2001</option>
								<option value="2000">2000</option>
								<option value="1999">1999</option>
								<option value="1998">1998</option>
								<option value="1997">1997</option>
								<option value="1996">1996</option>
								<option value="1995">1995</option>
								<option value="1994">1994</option>
								<option value="1993">1993</option>
								<option value="1992">1992</option>
								<option value="1991">1991</option>
								<option value="1990">1990</option>
								<option value="1989">1989</option>
								<option value="1988">1988</option>
								<option value="1987">1987</option>
								<option value="1986">1986</option>
								<option value="1985">1985</option>
								<option value="1984">1984</option>
								<option value="1983">1983</option>
								<option value="1982">1982</option>
								<option value="1981">1981</option>
								<option value="1980">1980</option>
								<option value="1979">1979</option>
								<option value="1978">1978</option>
								<option value="1977">1977</option>
								<option value="1976">1976</option>
								<option value="1975">1975</option>
								<option value="1974">1974</option>
								<option value="1973">1973</option>
								<option value="1972">1972</option>
								<option value="1971">1971</option>
								<option value="1970">1970</option>
								<option value="1969">1969</option>
								<option value="1968">1968</option>
								<option value="1967">1967</option>
								<option value="1966">1966</option>
								<option value="1965">1965</option>
								<option value="1964">1964</option>
								<option value="1963">1963</option>
								<option value="1962">1962</option>
								<option value="1961">1961</option>
								<option value="1960">1960</option>
								<option value="1959">1959</option>
								<option value="1958">1958</option>
								<option value="1957">1957</option>
								<option value="1956">1956</option>
								<option value="1955">1955</option>
								<option value="1954">1954</option>
								<option value="1953">1953</option>
								<option value="1952">1952</option>
								<option value="1951">1951</option>
								<option value="1950">1950</option>
								<option value="1949">1949</option>
								<option value="1948">1948</option>
								<option value="1947">1947</option>
								<option value="1946">1946</option>
								<option value="1945">1945</option>
								<option value="1944">1944</option>
								<option value="1943">1943</option>
								<option value="1942">1942</option>
								<option value="1941">1941</option>
								<option value="1940">1940</option>
							</select>
						</td>
						<td><input type="checkbox" name="birthdaycheck" value="Yes" id="birthdaycheck"></td>
      				 	</tr>

Piece of code for EditProfileUpdate.php that turns concatenates the date:

$month=$_POST['month'];
$date=$_POST['date'];
$year=$_POST['year'];
$dateofbirth=$year."-".$month."-".$date;
$birthdaycheck=$_POST['birthdaycheck'];

The sql statement that updates the table is:

$sql_personal_update="UPDATE $tbl_personal SET firstName='$firstname', lastName='$lastname', dateOfBirth='$dateofbirth', occupation='$occupation', mobileNumber='$mobilenumber', landNumber='$landnumber', addressLine1='$addressline1', addressLine2='$addressline1', zip='$zip', sex='$sex', blogsUser='$bloguserid' WHERE personalDetailsID='$personalDetailsID'";

Guys help on this...

Cheers - Zahid

PFMaBiSmAd · June 24, 2008

Echo $sql_personal_update to see what it actually contains.

abch624 · June 24, 2008

Hey,

That actually helped a bit silly of me not do that before lol but the problem was that the date was supposed to be going in the format 0000-00-00 but in this case it was 1999-05-8 the date was not a double....

Thanks - Zahid

Sign In

[SOLVED] PHP and Mysql Date

Recommended Posts

abch624

Link to comment

Share on other sites

PFMaBiSmAd

Link to comment

Share on other sites

abch624

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information