Professional Web Applications Themes

Please Help ! - PHP Development

> I know this is really basic but i have a form for users to enter the > date of an event that i would like to store in a mysql database how do i > get the users input into the database in the right format. Read up in the manual of mySQL, and the parts of the PHP doc on mySQL. mySQL dates are stored YYYY-MM-DD. -Dan...

  1. #1

    Default Re: [PHP] Please Help !

    > I know this is really basic but i have a form for users to enter the
    > date of an event that i would like to store in a mysql database how do i
    > get the users input into the database in the right format.
    Read up in the manual of mySQL, and the parts of the PHP doc on mySQL.

    mySQL dates are stored YYYY-MM-DD.

    -Dan

    Dan Anderson Guest

  2. #2

    Default Please Help !

    Hi,

    I know this is really basic but i have a form for users to enter the
    date of an event that i would like to store in a mysql database how do i
    get the users input into the database in the right format.



    Sean O'Reilly Guest

  3. #3

    Default Re: Please Help !

    look up two functions in the online manual. strtotime() and date()
    strtotime will give you a unix timestamp for just about any date possable,
    date will format it the way you need. to get it into a mySQL date field,
    basicaly, you do this:

    date("y-m-d", strtotime($_POST['date']))

    where $_POST['date'] is whatever variable you used.

    - Anthony


    "Sean O'Reilly" <s.oreillysuscoast.co.uk> wrote in message
    news:1057675256.17432.55.camelsean.linnovations.c o.uk...
    > Hi,
    >
    > I know this is really basic but i have a form for users to enter the
    > date of an event that i would like to store in a mysql database how do i
    > get the users input into the database in the right format.
    >
    >
    >

    Anthony Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139