Login Register
🎂 Happy 14th Birthday Sinisterly!
Proxyvizr - The Proxy Marketplace (Residential / Mobile / Datacenter / ISP). 10+ Providers, Instant Auto-delivery, Pay with Crypto.


What's the best way to store dates using html select fields? filter_list
Author
Message
AkarMathers13 Offline
Junior Member
Twelve Years of Service
Posts: 25
Threads: 4
Reputation: 0
Currency: 0 SP
What's the best way to store dates using html select fields? 08-14-2014, 03:15 PM #1
Hello Guys, I have a question, Just like the title says, What's the best way to store dates in the database using select fields and a PHP script? I use it for registration. Here is my HTML code:

Code:
<p>Birthday:<select name="birthday"> <option value="1">Jan</option> <option value="2">Feb</option> <option value="3">Mar</option> <option value="4">Apr</option> <option value="5">May</option> <option value="6">Jun</option> <option value="7">Jul</option> <option value="8">Aug</option> <option value="9">Sep</option> <option value="10">Oct</option> <option value="11">Nov</option> <option value="12">Dec</option> </select> <select name="birthday"> <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="birthday"> <option value="2011">2011</option> <option value="2010">2010</option> <option value="1905">1905</option> </select></p>


Thanks!

Reply

AkarMathers13 Offline
Junior Member
Twelve Years of Service
Posts: 25
Threads: 4
Reputation: 0
Currency: 0 SP
What's the best way to store dates using html select fields? 08-14-2014, 03:15 PM #2
Hello Guys, I have a question, Just like the title says, What's the best way to store dates in the database using select fields and a PHP script? I use it for registration. Here is my HTML code:

Code:
<p>Birthday:<select name="birthday"> <option value="1">Jan</option> <option value="2">Feb</option> <option value="3">Mar</option> <option value="4">Apr</option> <option value="5">May</option> <option value="6">Jun</option> <option value="7">Jul</option> <option value="8">Aug</option> <option value="9">Sep</option> <option value="10">Oct</option> <option value="11">Nov</option> <option value="12">Dec</option> </select> <select name="birthday"> <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="birthday"> <option value="2011">2011</option> <option value="2010">2010</option> <option value="1905">1905</option> </select></p>


Thanks!

Reply

Singularity_mybb_import13102 Offline
Infosploit
Thirteen Years of Service
Posts: 197
Threads: 9
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 03:28 PM #3
If you could elaborate, I should be able to help you. There are several different types of databases. What are you using, what's the table name, what's the description of said table, etc
(This post was last modified: 08-14-2014, 03:28 PM by MaltShizzle.)
[Image: obDhRdK.gif]

Reply

Singularity_mybb_import13102 Offline
Infosploit
Thirteen Years of Service
Posts: 197
Threads: 9
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 03:28 PM #4
If you could elaborate, I should be able to help you. There are several different types of databases. What are you using, what's the table name, what's the description of said table, etc
(This post was last modified: 08-14-2014, 03:28 PM by MaltShizzle.)
[Image: obDhRdK.gif]

Reply

Ex094 Offline
F3aR M3
 ***
Registered (Bronze)
Thirteen Years of Service
Posts: 3,143
Threads: 100
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 04:12 PM #5
Ahh I got ya problem, I think this might be yer solution http://rijamedia.com/blog/2011/02/dynami...nu-in-php/
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Website
Reply

Ex094 Offline
F3aR M3
 ***
Registered (Bronze)
Thirteen Years of Service
Posts: 3,143
Threads: 100
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 04:12 PM #6
Ahh I got ya problem, I think this might be yer solution http://rijamedia.com/blog/2011/02/dynami...nu-in-php/
My Blog: http://www.procurity.wordpress.com
Donations: 1HLjiSbnWMpeQU46eUVCrYdbkrtduX7snG

Website
Reply

AkarMathers13 Offline
Junior Member
Twelve Years of Service
Posts: 25
Threads: 4
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 04:49 PM #7
@Singularity MySQL Database, And a users table.

Reply

AkarMathers13 Offline
Junior Member
Twelve Years of Service
Posts: 25
Threads: 4
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 04:49 PM #8
@Singularity MySQL Database, And a users table.

Reply

Singularity_mybb_import13102 Offline
Infosploit
Thirteen Years of Service
Posts: 197
Threads: 9
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 05:06 PM #9
@AkarMathers13
Login to MySQL and give me the output of:
use databasenamehere;
desc usertablenamehere;

I need to know what rows/columns there are, where to store the information, etc...
Have you ever even implemented a database, how do you have a user table and not know how to add a date? Have you not added users either?
I'm just trying to help here, but I still need more information.
(This post was last modified: 08-14-2014, 05:06 PM by MaltShizzle.)
[Image: obDhRdK.gif]

Reply

Singularity_mybb_import13102 Offline
Infosploit
Thirteen Years of Service
Posts: 197
Threads: 9
Reputation: 0
Currency: 0 SP
RE: What's the best way to store dates using html select fields? 08-14-2014, 05:06 PM #10
@AkarMathers13
Login to MySQL and give me the output of:
use databasenamehere;
desc usertablenamehere;

I need to know what rows/columns there are, where to store the information, etc...
Have you ever even implemented a database, how do you have a user table and not know how to add a date? Have you not added users either?
I'm just trying to help here, but I still need more information.
(This post was last modified: 08-14-2014, 05:06 PM by MaltShizzle.)
[Image: obDhRdK.gif]

Reply







Users browsing this thread: 1 Guest(s)