ช่วยดูโค้ดปฏิทินกิจกรรมให้หน่อยค่ะ พอเพิ่มกิจกรรมแล้วไม่ save ลงฐานข้อมูล
ไฟล์ default.htmlCode (PHP) <!DOCTYPE html>
<html>
<head>
<link href='css/fullcalendar.css' rel='stylesheet' />
<script src='js/jquery.min.js'></script>
<script src='js/jquery-ui.custom.min.js'></script>
<script src='js/fullcalendar.min.js'></script>
<script>
$(document).ready(function() {
var date = new Date();
var d = date.getDate();
var m = date.getMonth();
var y = date.getFullYear();
var calendar = $('#calendar').fullCalendar({
editable: true,
header: {
left: 'prev,next today',
center: 'title',
right: 'month,agendaWeek,agendaDay'
},
events: "http://localhost:8888/fullcalendar/events.php",
// Convert the allDay from string to boolean
eventRender: function(event, element, view) {
if (event.allDay === 'true') {
event.allDay = true;
} else {
event.allDay = false;
}
},
selectable: true,
selectHelper: true,
select: function(start, end, allDay) {
var title = prompt('Event Title:');
var url = prompt('Type Event url, if exits:');
if (title) {
start = $.fullCalendar.formatDate(start, "yyyy-MM-dd HH:mm:ss");
end = $.fullCalendar.formatDate(end, "yyyy-MM-dd HH:mm:ss");
$.ajax({
url: 'http://localhost:8888/fullcalendar/add_events.php',
data: 'title='+ title+'&start='+ start +'&end='+ end +'&url='+ url ,
type: "POST",
success: function(json) {
alert('Added Successfully');
}
});
calendar.fullCalendar('renderEvent',
{
title: title,
start: start,
end: end,
allDay: allDay
},
true // make the event "stick"
);
}
calendar.fullCalendar('unselect');
},
editable: true,
eventDrop: function(event, delta) {
start = $.fullCalendar.formatDate(event.start, "yyyy-MM-dd HH:mm:ss");
end = $.fullCalendar.formatDate(event.end, "yyyy-MM-dd HH:mm:ss");
$.ajax({
url: 'http://localhost:8888/fullcalendar/update_events.php',
data: 'title='+ event.title+'&start='+ start +'&end='+ end +'&id='+ event.id ,
type: "POST",
success: function(json) {
alert("Updated Successfully");
}
});
},
eventResize: function(event) {
start = $.fullCalendar.formatDate(event.start, "yyyy-MM-dd HH:mm:ss");
end = $.fullCalendar.formatDate(event.end, "yyyy-MM-dd HH:mm:ss");
$.ajax({
url: 'http://localhost:8888/fullcalendar/update_events.php',
data: 'title='+ event.title+'&start='+ start +'&end='+ end +'&id='+ event.id ,
type: "POST",
success: function(json) {
alert("Updated Successfully");
}
});
}
});
});
</script>
<style>
body {
margin-top: 40px;
text-align: center;
font-size: 14px;
font-family: "Lucida Grande",Helvetica,Arial,Verdana,sans-serif;
}
#calendar {
width: 900px;
margin: 0 auto;
}
</style>
</head>
<body>
<div id='calendar'></div>
</body>
</html>
Code (PHP) <?php
// Values received via ajax
$title = $_POST['title'];
$start = $_POST['start'];
$end = $_POST['end'];
$url = $_POST['url'];
// connection to the database
/*try {
$bdd = new PDO('mysql:host=localhost;dbname=car', 'root', '12345');
} catch(Exception $e) {
exit('Unable to connect to database.');
}
*/
// insert the records
require_once("dbcon.php");
$sql = "INSERT INTO evenement (title, start, end, url) VALUES (1,1,1,1)";
$q = $bdd->prepare($sql);
$q->execute(array(':title'=>1, ':start'=>1, ':end'=>1, ':url'=>1));
?>
Tag PHP, MySQL
Date :
2013-10-22 20:36:32By :
eii-mianView :
1516Reply :
5
ลอง echo $sql; อาจจะเจอ error ครับ
Date :
2013-10-22 20:52:01By :
apisitp
ตอน insert หนูบังคับให้ทุกค่าเป็น 1 หมด พอลองรัน sql แล้ว แสดงตามข้างล่างค่ะ
Date :
2013-10-22 21:32:08By :
eii-mian
dbcon.php นี่มันเป็นยังไงครับ แล้ว
Date :
2013-10-22 21:37:46By :
PlaKriM
ไฟล์ dbcon.phpCode (PHP) <?php
$host="localhost";//enter the server name
$username="root";//Enter the user name
$password="12345";
$dbname="car"; // ชื่อฐานข้อมูล
//เชื่อมฐานข้อมูล
$objConnect=mysql_connect($host,$username,$password) or die("<br><br><br><br><br><br><center>ไม่สามารถเชื่อมต่อกับฐานข้อมูลได้</center><br><br>");
$objDB = mysql_select_db("dbname");
mysql_query("SET NAMES UTF8");
?>
Date :
2013-10-22 22:26:30By :
eii-mian
แบบนี้ครับ <?php
// Values received via ajax
$title = $_POST['title'];
$start = $_POST['start'];
$end = $_POST['end'];
$url = $_POST['url'];
// connection to the database
try {
$bdd = new PDO('mysql:host=localhost;dbname=car', 'root', '12345');
} catch(Exception $e) {
exit('Unable to connect to database.');
}
// insert the records
//require_once("dbcon.php");
$sql = "INSERT INTO evenement (title, start, end, url) VALUES (1,1,1,1)";
$q = $bdd->prepare($sql);
$q->execute(array(':title'=>1, ':start'=>1, ':end'=>1, ':url'=>1));
?>
Date :
2013-10-22 22:37:24By :
sakuraei
Server 01
Load balance : Server 01
