problemas con insert de datepicker
Publicado por fernando (11 intervenciones) el 18/01/2020 01:35:17
Estimados tengo problemas para insertar capo fecha con datepicker
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
<!DOCTYPE html>
<html lang="es">
<head>
<meta charset="UTF-8">
<title>Form Theme v1</title>
<link rel="stylesheet" href="form-theme.css">
<link rel="stylesheet" href="form-icons.css">
</head>
<body>
<link href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/jquery-ui.css" rel="stylesheet"/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.11.4/jquery-ui.js"></script>
<script>
$(function () {
$.datepicker.setDefaults($.datepicker.regional["es"]);
$("#datepicker").datepicker({
dateFormat: 'dd/mm/yy',
firstDay: 1}).datepicker("setDate", new Date());
});
</script>
<form method="POST" action="guardar.php">
<div class="frmTop"></div>
<div class="frmLine"></div>
<div class="frmDivide">
<div style="width: 80%;">
<label for="fmRemito">Nº Remito</label> <br>
<input type="text" id="fmRemito" name="fmRemito">
</div>
<div style="width: 15%;">
<label for="frmFecha">Fecha</label> <br>
<input type="text" id="datepicker" style="padding: 2px 8px;">
</div>
</div>
<div class="frmDivide">
<div style="width: 84%;">
<button class="frmButtons" type="submit">Enviar información</button>
</div>
<div style="width: 15%;">
<button class="frmButtons" type="reload" style="background:#FF2626">Borrar todo</button>
</div>
</div>
</form>
<script>
var coll=document.getElementsByClassName("frmCollapse");var i;for(i=0;i<coll.length;i++){coll[i].addEventListener("click",function(){this.classList.toggle("active");var frmDivideCollapse=this.nextElementSibling;if(frmDivideCollapse.style.maxHeight){frmDivideCollapse.style.maxHeight=null;}else{frmDivideCollapse.style.maxHeight = frmDivideCollapse.scrollHeight + "px";}});}
</script>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?php
$con = mysql_connect("localhost","root","clave");
if (!$con)
{die('Could not connect: ' . mysql_error());
}mysql_select_db("base", $con);
$sql="insert into remitos(remito,fecha)
values('$_POST[fmRemito]',concat(substr('$_POST[datepicker]',7,4),'-',substr('$_POST[datepicker]',4,2),'-',substr('$_POST[datepicker]',1,2)))";if (!mysql_query($sql,$con))
{die('Error: ' . mysql_error());
}?>
Valora esta pregunta
0
