Click here to Skip to main content
15,887,832 members
Home / Discussions / Web Development
   

Web Development

 
QuestionGenerating HTML from within Apex using such Dynamic Visualforce Components? Pin
Aniard21-Aug-13 20:12
professionalAniard21-Aug-13 20:12 
QuestionRe: Generating HTML from within Apex using such Dynamic Visualforce Components? Pin
Aniard24-Aug-13 21:39
professionalAniard24-Aug-13 21:39 
GeneralWCF HTTP 400 Pin
Member 1045459221-Aug-13 3:47
professionalMember 1045459221-Aug-13 3:47 
QuestionUpload dialog on img click in PHP Pin
Jassim Rahma20-Aug-13 12:51
Jassim Rahma20-Aug-13 12:51 
QuestionColumnspan in gridview Pin
captainronohio20-Aug-13 9:50
captainronohio20-Aug-13 9:50 
AnswerRe: Columnspan in gridview Pin
Anurag Gandhi23-Aug-13 7:41
professionalAnurag Gandhi23-Aug-13 7:41 
QuestionWCF Test Client - How to set the Value's dropdownlist Pin
Member 1045459220-Aug-13 5:51
professionalMember 1045459220-Aug-13 5:51 
Questionproblem saving datepicker value to MySQL Pin
Jassim Rahma17-Aug-13 11:36
Jassim Rahma17-Aug-13 11:36 
Hi,

I am using JQuery datepicker and trying to save its value to MySQL date field but it's always saving it as 1970-01-01. How can I solve this?

here is my php:

XML
<script type="text/javascript">
    $(function ()
    {
        $("#dateBirthday").datepicker({ dateFormat: "dd-mm-yy",
        changeYear: true,
        showOn: "button",
        buttonImage: "http://localhost/xoompage/images/calendar.gif",
        buttonImageOnly: false })
    });
</script>


<input type="text" id="dateBirthday" name="dateBirthday" value="<?php echo $member_date_of_birth; ?>" autocomplete="off" disabled required>


and in the form action php file:

$date_of_birth = $_POST['dateBirthday'];


$mysql_command = "CALL sp_update_member_personal_information(:param_member_guid, :param_member_title, :param_first_name, :param_middle_name, :param_last_name, :param_date_of_birth, :param_gender, :param_marital_status, :param_nationality, :param_home_country, :param_current_country, :param_home_phone, :param_mobile_phone, :param_brief_introduction)";


$mysql_query->bindParam(':param_date_of_birth', $date_of_birth, PDO::PARAM_STR);


and in the stored procedure:

SQL
UPDATE members SET
member_title = param_member_title,
first_name = param_first_name,
middle_name = param_middle_name,
last_name = param_last_name,
date_of_birth = param_date_of_birth,
gender = param_gender,
marital_status = param_marital_status,
nationality = param_nationality,
home_country = param_home_country,
current_country = param_current_country,
home_phone = param_home_phone,
mobile_phone = param_mobile_phone,
brief_introduction = param_brief_introduction
WHERE member_guid = param_member_guid AND is_active = TRUE and is_blocked = FALSE;



can you please help..

thanks,
Jassim


Technology News @ www.JassimRahma.com

QuestionVideo Tag not working in Chrome and Internet Explorer Pin
B.Sudhir16-Aug-13 18:48
B.Sudhir16-Aug-13 18:48 
AnswerRe: Video Tag not working in Chrome and Internet Explorer Pin
Anurag Gandhi23-Aug-13 7:44
professionalAnurag Gandhi23-Aug-13 7:44 
GeneralRe: Video Tag not working in Chrome and Internet Explorer Pin
B.Sudhir24-Aug-13 4:43
B.Sudhir24-Aug-13 4:43 
QuestionStorage in Database or in XML file?? Pin
User 1006066515-Aug-13 18:38
User 1006066515-Aug-13 18:38 
AnswerRe: Storage in Database or in XML file?? Pin
Richard MacCutchan15-Aug-13 22:09
mveRichard MacCutchan15-Aug-13 22:09 
GeneralMessage Closed Pin
16-Aug-13 2:53
User 1006066516-Aug-13 2:53 
GeneralRe: Storage in Database or in XML file?? Pin
Richard MacCutchan16-Aug-13 3:19
mveRichard MacCutchan16-Aug-13 3:19 
GeneralMessage Closed Pin
16-Aug-13 17:13
User 1006066516-Aug-13 17:13 
GeneralRe: Storage in Database or in XML file?? Pin
Richard MacCutchan16-Aug-13 22:00
mveRichard MacCutchan16-Aug-13 22:00 
QuestionI am trying to use HTML 5 VIDEO PLAYER.given is my code but its not running my video,i am using chrome 28? Pin
Member 1020762713-Aug-13 8:52
Member 1020762713-Aug-13 8:52 
AnswerRe: I am trying to use HTML 5 VIDEO PLAYER.given is my code but its not running my video,i am using chrome 28? Pin
Richard MacCutchan13-Aug-13 21:09
mveRichard MacCutchan13-Aug-13 21:09 
AnswerRe: I am trying to use HTML 5 VIDEO PLAYER.given is my code but its not running my video,i am using chrome 28? Pin
bilal.hobnail23-Aug-13 3:01
bilal.hobnail23-Aug-13 3:01 
Questionvideo insertion in mysql? Pin
Member 1020762713-Aug-13 8:48
Member 1020762713-Aug-13 8:48 
QuestionBest cloud providers for deploying multi tenant web application? Pin
PetMAc11-Aug-13 2:28
PetMAc11-Aug-13 2:28 
Questionhelp with htaccess please Pin
Jassim Rahma10-Aug-13 11:13
Jassim Rahma10-Aug-13 11:13 
QuestionRe: help with htaccess please Pin
Richard MacCutchan10-Aug-13 22:56
mveRichard MacCutchan10-Aug-13 22:56 
AnswerRe: help with htaccess please Pin
Bernhard Hiller11-Aug-13 22:27
Bernhard Hiller11-Aug-13 22:27 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.