Patiphan Konkhon' Blogspot

Controller : c_tete.php

<?php
class C_tete extends CI_controller {

public $data;

public function index() {
$this->load->view('v_tete1');
}

public function show() {
$this->data['no'] = $this->input->post('no');
$this->data['name'] = $this->input->post('name');
$this->data['audio'] = $this->input->post('audio');
$this->data['subtitle'] = $this->input->post('subtitle');
$this->data['detail'] = $this->input->post('detail');

$this->load->view('v_tete2',$this->data);
}
}
?>

_________________________________________________________________________________

View : v_tete1.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>โรงภาพยนตร์ แหลมทอง บางแสน SF Cinema City</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#createRows").click(function(){
var tr

tr = tr + "<tr>";
tr = tr + "<td>" + "<select name='no[]' id='no' align='center' required>" +
"<option value=''>กรุณาเลือก</option>" +
"<option value='1'>1</option>" +
"<option value='2'>2</option>" +
"<option value='3'>3</option>" +
"</select></td>";
tr = tr + "<td>" + "<input type='text' id='name' align='center' name='name[]' required>" + "</td>";
tr = tr + "<td>" + "<select name='audio[]' id='audio' align='center' required>" +
"<option value=''>กรุณาเลือก</option>" +
"<option value='Thai'>Thai</option>" +
"<option value='English'>English</option>" +
"</select></td>";
tr = tr + "<td>" + "<select name='subtitle[]' id='subtitle' align='center' required>" +
"<option value=''>กรุณาเลือก</option>" +
"<option value='Thai'>Thai</option>" +
"<option value='English'>English</option>" +
"</select></td>";
tr = tr + "<td>" + "<textarea align='center' name='detail[]' required></textarea>" + "</td>";
tr = tr + "</tr>";

$('#myTable > tbody:last').append(tr);
});

$("#deleteRows").click(function(){
if ($("#myTable tr").length != 1) {
$("#myTable tr:last").remove();
}
});
});
</script>
</head>

<body>
<form name="form1" action="index.php/c_tete/show" method="post" >
<h2>โรงภาพยนตร์ แหลมทอง บางแสน SF Cinema City</h2>
<table width="600" border="1" id="myTable" >
<thead>
<tr>
<td> <div align="center">รอบฉาย </div></td>
<td> <div align="center">ชื่อภาพยนตร์</div></td>
<td> <div align="center">เสียง </div></td>
<td> <div align="center">บรรยาย </div></td>
<td> <div align="center">รายละเอียด </div></td>
</tr>
</thead>
<tbody>
<tr>
<td> <select name="no[]" id="no" align="center" required>
<option value="">กรุณาเลือก</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select></td>
<td> <input type="text" id="name" align="center" name="name[]" required> </td>
<td> <select name="audio[]" id="audio" align="center" required>
<option value="">กรุณาเลือก</option>
<option value="Thai">Thai</option>
<option value="English">English</option>
</select></td>
<td> <select name="subtitle[]" id="subtitle" align="center" required>
<option value="">กรุณาเลือก</option>
<option value="Thai">Thai</option>
<option value="English">English</option>
</select></td>
<td> <textarea align="center" name="detail[]" required></textarea> </td>
</tr>
</tbody>
</table>
<br />
<input type="button" id="createRows" value="Insert">
<input type="button" id="deleteRows" value="Delete">
<input type="reset" value="Reset">
<input type="submit" value="Submit">
</form>
</body>

</html>

_________________________________________________________________________________

View : v_tete2.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>โรงภาพยนตร์ แหลมทอง บางแสน SF Cinema City</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
</head>

<body>
<h2>ข้อมูลภาพยนตร์ทั้งหมด</h2>
<table width="600" border="1" id="myTable" >
<thead>
<tr>
<td> <div align="center">รอบฉาย </div></td>
<td> <div align="center">ชื่อภาพยนตร์</div></td>
<td> <div align="center">เสียง </div></td>
<td> <div align="center">บรรยาย </div></td>
<td> <div align="center">รายละเอียด </div></td>
</tr>
</thead>
<tbody>
<?php
$count_index = count($no);
for($i=0;$i<$count_index;$i++){
echo "<tr>";
echo "<td>".$no[$i]."</td>";
echo "<td>".$name[$i]."</td>";
echo "<td>".$audio[$i]."</td>";
echo "<td>".$subtitle[$i]."</td>";
echo "<td>".$detail[$i]."</td>";
echo "</tr>";
}
?>
</tbody>
</table>

<h2>ข้อมูลเสียงพากย์</h2>
<table width="270" border="1" id="myTable">
<thead>
<tr>
<td> <div align="center">เสียง </div></td>
<td> <div align="center">ชื่อภาพยนตร์</div></td>
</tr>
</thead>
<tbody>
<?php
$count_index = count($no);
$count_audio = array_unique($audio);
foreach ($count_audio as $key => $value){
if($count_audio == $count_audio){
echo "<tr>";
echo "<td>".$value."</td>";
echo "<td>"."</td>";
echo "</tr>";
}
for($i=0;$i<$count_index;$i++){
if($value == $audio[$i]){
echo "<tr>";
echo "<td>"."</td>";
echo "<td>".$name[$i]."</td>";
echo "</tr>";
}
}
}
?>
</tbody>
</table>

<h2>ข้อมูลการบรรยาย</h2>
<table width="270" border="1" id="myTable">
<thead>
<tr>
<td> <div align="center">บรรยาย</div></td>
<td> <div align="center">ชื่อภาพยนตร์</div></td>
</tr>
</thead>
<tbody>
<?php
$count_index = count($no);
$count_audio = array_unique($subtitle);
foreach ($count_audio as $key => $value){
if($count_audio == $count_audio){
echo "<tr>";
echo "<td>".$value."</td>";
echo "<td>"."</td>";
echo "</tr>";
}
for($i=0;$i<$count_index;$i++){
if($value == $subtitle[$i]){
echo "<tr>";
echo "<td>"."</td>";
echo "<td>".$name[$i]."</td>";
echo "</tr>";
}
}
}
?>
</tbody>
</table>

<br><br>


<div id="graph1" style="min-width: 200px; max-width: 600px; height: 400px; margin: 0 auto"></div>
<?php $value_audio = array_count_values($audio); ?>
<script>
$(function () {
$('#graph1').highcharts({
chart: {
type: 'column'
},
title: {
text: 'กราฟแสดงเสียงพากย์'
},
xAxis: {
categories: [ 'เสียง' ]
},
yAxis: {
min: 0,
title: {
text: 'จำนวน'
}
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'Thai',
color: '#00FF00',
data: [ <?php
foreach ($value_audio as $key => $value){
if($key == "Thai"){
echo $value;
}
}
?> ]
}, {
name: 'English',
color: '#FFFF00',
data: [ <?php
foreach ($value_audio as $key => $value){
if($key == "English"){
echo $value;
}
}
?> ]
}]
});
});
</script>

<br><br>

<div id="graph2" style="min-width: 200px; max-width: 600px; height: 400px; margin: 0 auto"></div>
<?php $value_sub = array_count_values($subtitle); ?>
<script>
$(function () {
$('#graph2').highcharts({
chart: {
type: 'column'
},
title: {
text: 'กราฟแสดงการบรรยาย'
},
xAxis: {
categories: [ 'บรรยาย' ]
},
yAxis: {
min: 0,
title: {
text: 'จำนวน'
}
},
plotOptions: {
column: {
pointPadding: 0.2,
borderWidth: 0
}
},
series: [{
name: 'Thai',
color: '#00FFFF',
data: [ <?php
foreach ($value_sub as $key => $value){
if($key == "Thai"){
echo $value;
}
}
?> ]
}, {
name: 'English',
color: '#FF00FF',
data: [ <?php
foreach ($value_sub as $key => $value){
if($key == "English"){
echo $value;
}
}
?> ]
}]
});
});
</script>


</body>

</html>

Patiphan Konkhon' Blogspot

Monday, June 23, 2014

CI tete