<?php include("connect_db.php"); session_start(); function add_project(){ global $project_id; $sql = "INSERT INTO project (budget_true) VALUES ('$budget_true') "; // กำหนดคำสั่ง SQL เพื่อเพิ่มข้อมูลแบบคีย์ในคำสั่ง SQL //echo $sql; if(!$result = mysql_query($sql)){ echo mysql_error(); exit; } } add_project(); ?> <script language="javascript"> alert("Save Data Successfully"); window.location = "<?php echo $server_host;?>/list_budget2.php"; </script>
<?php include("connect_db.php"); session_start(); function get_project(){ $sql = "SELECT * FROM project ORDER BY project_id "; if(!$result = mysql_query($sql)){ echo mysql_error(); exit; } return $result; } /*-------------------------------------- Main Program --------------------------------------------*/ $project_rs = get_project(); $row_array = mysql_fetch_array($project_rs); ?> <?php include("inc_meta.php");?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Balanced Scorecard</title> <meta name="description" content=""> <meta name="keywords" content=""> <link href="style.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- .style2 { color: #FFFFFF; font-size: large; } .style4 {font-size: 14px} .style11 {font-family: Arial} .style12 {font-size: 9} .style14 {color: #CC00FF} --> </style> </head> <body style="background: #ffffff"> <div align="center"> <table border="0" cellpadding="0" cellspacing="0" width="1000"> <tr> <td height="155" style="background: url(images/H.jpg)" valign="top"><div style="padding: 38px 0 0 75px"></div></td> </tr> <tr><td style="background: #cc00cc"></td></tr> <tr> <td style="background: #990099" height="20"> <table border ="0" bordercolor="#cc00cc"cellpadding="0" cellspacing="0" width="100%"> <tr> <td> </td> </tr> </table> </td> </tr> <tr><td style="background: #33393C"><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td></tr> </table> <table style="background: #990099" border ="0" cellpadding="0" cellspacing="0" width="1000"> <tr> <td valign="top" style="background: #990099" > <table style="background: #990099" border="0" cellpadding="0" cellspacing="0" > <tr> <td ><img src="images/main.gif" height="30" width="215" border="0" alt=""></td> </tr> <tr> <td ><a href="home.php"><img src="images/home.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="http://www.pea4-padang.com/HTML/About.html"><img src="images/pawat.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="project.php"><img src="images/project.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="task.php"><img src="images/task.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="bsc.php"><img src="images/bsc1.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="report.php"><img src="images/report.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><img src="images/user.gif" height="30" width="215" border="0" alt=""></td> </tr> <tr> <td ><a href="profile.php"><img src="images/profile.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr> <td ><a href="logout.php"><img src="images/logout.gif" height="30" width="215" border="0" alt=""></a></td> </tr> <tr><td style="background: #990099"> <img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td><td rowspan="4"><img src="images/spacer.gif" width="1" height="1" border="0" alt=""></td></tr> <tr><td style="background: #990099"> </td></tr> <tr><td width="215"> </td></tr> </table></td> <td valign="top" width="80%"> <table width="100%" border="1" bordercolor="#ff66ff" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="30" style="background: #ff66ff"> <div align="center" class="tblb style2 style4">Welcome to Balanced Scorecard System </div></td> </tr> <tr> <td style="background: #ffffff"align="center"><table width="100%" border="0" align="center" cellpadding="5" cellspacing="5"> <tr> <td> <div align="left" > <form name="form1" action="<?php echo $server_host;?>/bsc_budget2_save.php" method="post" onSubmit="return validate_form(this);"> <p> </p> <p><span class="tblb"><span class="style14">Balanced Scorecard > เปรียบเทียบการใช้งบประมาณ :</span><br> <br> <img src="images/ico.gif" width="11" height="13"> โครงการที่ต้องการตรวจสอบ </span><br> </td> <table width="90%" border="0" align="center" cellpadding="5" cellspacing="5"> <tr> <td> <p> <table width="100%" border="0" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" align="center"> <tr> <!-- <td><font face="verdana,arial" size=-1><?php echo $row_array["project_id"];?></font></td>--> <td width="15%" ><font size=-1 face="verdana,arial" class="tblb"><b>โครงการ :</b></font></td> <td width="15%" ><font face="verdana,arial" size=-1><?php echo $row_array["project_name"];?></font></td> <td width="35%" ><font size=-1 face="verdana,arial" class="tblb"><b>รายละเอียดโครงการ :</b></font></td> <td width="35%" ><font face="verdana,arial" size=-1><?php echo $row_array["description"];?></font></td> </tr> </table> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- <br><br> <table width="100%" border="0" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" > <tr> <!-- <td><font face="verdana,arial" size=-1><?php echo $row_array["project_id"];?></font></td>--> <td width="15%" ><font size=-1 face="verdana,arial" class="tblb"><b>งบประมาณตั้งต้น :</b></font></td> <td width="15%" ><font face="verdana,arial" size=-1><?php echo $row_array["project_Budget"];?></font></td> </tr><tr> <td width="15%" ><font size=-1 face="verdana,arial" class="tblb"><b>งบประมาณใช้จริง :</b></font></td> <td > <font face="verdana,arial" size=-1><input type="text" size = "5" name="b_score " value="<?php echo $budget_true;?>"></font> </td> </tr> </table> <tr style="height:30px" > <td align="center"><button onClick="javascript:window.location='<?php echo $server_host;?>/bsc_budget2_save.php?project_id=<?php echo $project_id;?>'" name="add">ตกลง</button> <button onClick="javascript:window.location='<?php echo $server_host;?>/bsc_budget.php'" name="add">กลับ</button></td></tr> </table> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </table> </td> </tr> </table> </td> </tr> </table> <input type="hidden" name="project_id" value="<?php echo $project_id;?>"> </form> <?php include("footer.php"); ?> <!-- Start of StatCounter Code --> <script type="text/javascript" language="javascript"> var sc_project=1952940; var sc_invisible=1; var sc_partition=17; var sc_security="fa1db912"; </script> <script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script> <noscript> <a href="http://icetemplates.com/" target="_blank"><img src="http://c18.statcounter.com/counter.php?sc_project=1952940&java=0&security=fa1db912&invisible=1" alt="website templates" border="0"></a> </noscript> <!-- End of StatCounter Code --> </div> </body> </html>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
