473,508 Members | 2,355 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to insert value of datepicker into mysql database

1 New Member
Sir would like to know how to insert date, month and year selected from datepicker into mysql database thorugh php.
I am trying to store the value of datepicker but it shows 00-00-00 kindly help with code.
Jan 9 '12 #1
1 5064
Dormilich
8,658 Recognized Expert Moderator Expert
I am trying to store the value of datepicker but it shows 00-00-00 kindly help with code.
seems like you try an invalid date format for inserting. MySQL usually uses YYYY-MM-DD for its DATE type.
Jan 9 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
6694
by: Jassim Rahma | last post by:
Hi, I am using C# to insert a date value from the DatePicker into a DateTime filed in mySQL database.. I am using the following syntax: '" + datePicker.Value + "' I also triend it withour...
2
1244
by: ravina | last post by:
plz help me... i need a code : I want to insert into the Mysql database output of another php program.. how do i do this????
6
2158
by: fpcreator2000 | last post by:
Hello everyone. I'm having problems with a page I've created that is used to insert data into a database. It uploads two files into two distinct folder, and it takes the filenames and inserts...
3
9177
by: ghjk | last post by:
Could some one tell me how to pass drop down list value from php to mysql database?
2
1413
by: ashi1290 | last post by:
im getting exception message is null ... whwni print the stack trace its says something like this....... ResultSet rs;int i=-1; PreparedStatement ps; Class.forName("com.mysql.jdbc.Driver");...
3
9692
by: dakshayini | last post by:
Hi all, i need to store data having subscript and super script like chemical equations symbols...values in to mysql database and fetch it and display. for that i need to convert that text into...
0
1017
by: tedpottel | last post by:
Hi I am trying to right a script to keep a local copy of my mysql database in a local access file. I was able to do this in Access visual basic, but cannot get it to work in python. The...
17
17432
by: msmjsuarez | last post by:
Hello, I need help... How to automatically insert data to mysql database without submit button using php? Is there a way on this? thanks a lot.
2
4162
by: yusufjammy | last post by:
How to insert image in mysql database via php and how to retrieve in php ?
4
8229
by: Francesca | last post by:
Hi everybody, I am a real newbie in both perl and relational databases like mysql, and I have been banging my head on the wall trying to understand how to populate a mysql database using an Excel...
0
7224
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7379
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7038
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7493
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5625
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5049
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4706
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3192
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3180
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.