How to insert norman date in mysql using php? -

-

I'm completely new to php and mysql; Need some help with this, I want to put a date in mysql table, formatted as DD / MM / yay.

I have 4 columns in my table: id, name, age & amp; Birthday.

My HTML code 

  & lt; Form action = "php_creat_cliente.php" method = "post" & gt; Name: & lt; Input name = "context" type = "article" /> gt; & Lt; Br / & gt; Age: & lt; Input name = "focus" type = "text" / & gt; & Lt; Br / & gt; Birthday: & lt; Input name = "date" type = "text" /> gt; & Lt; Br / & gt; & Lt; / Form & gt;   
 My PHP-code  
  & lt? Include php ('config.php'); $ Name = $ _ post ['name']; $ Age = $ _ post ['age']; $ Birthday = $ _ post ['birthday']; Include $ save = mysql_query values ​​("Debt (name, age, birthday) '(' $ name ',' $ age ',' $ birthday ')); Header (" location: index.html "); Exit );? & Gt;   
 Currently, the date is entered in mm / dd / yyyy format, but I need it in DD / MM / yyyy format.  < / div> 
 
 
 MySQL accepts a string in the format of 'yyyy-mm-dd' or 'yyyymmdd' for the date, Enter whatever format you want in the text field As long as you make sure that you have reproduced a valid format (as I mentioned) before sending it to the database (in your code).  
 Or you You can specify yourself as a format:  
  $ save = mysql_query ("Include the loan (name, age, birthday) values ​​('$ name', '$ age', STR_TO_DATE   
 This form is popular for dates. In the present way (The method shown here at least), and everything in between if you want to be a web developer, I recommend you to know about these attacks.  
 Edit:  
 Does a jQuery UI Datepicker help in choosing a date text field in a valid date format? You can specify the format in which you want the widget to show your date like this:  
  $ ("#datepicker") .datepicker ("option", "dateFormat", " Dd-mm -Y y ");   
 And then you can make sure that the MySQL submitting the date format in your order of your entry as I have shown above:  
  STR_TO_DATE ('$ birthday', '% d-% m-% Y')

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more