สอบถามเกี่ยวกับส่งค่าลงฐานข้อมูลครับ คือทำDB แล้วตอนส่งข้อมูลเข้าDBข้อมูลในส่วนของที่เป็นtextareaบันทึกไม่หมดครับ
อันนี้เป็นส่วนของหน้า index นะครับ รับข้อมูลจากผู้ใช้Code (PHP) <head>
<title>CAR ADD</title>
<meta name="viewport" content="width=device-width, user-scalable=no" />
<!-- <meta name="viewport" content="width=device-width, target-densitydpi=high-dpi" http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> -->
<style type="text/css">
<!--
.style1 {font-family: "Times New Roman", Times, serif}
-->
</style>
</head>
<body bgcolor="#FFFFFF" rigthtmargin="10" topmargin="0" marginwidth="0" marginheight="0" OnLoad="document.frmAdd.txtDate.focus();">
<!-- Save for Web Slices (themplate_pd1.psd) -->
<form style="font-family:"Times New Roman" action="Save.php" name="frmAdd" method="post">
<table id="Table_01" rigthtmargin="10" width="800" border="0" cellpadding="0" cellspacing="0">
<tr>
<td colspan="4"><div align="center"><img src="images/pd_01.gif" width="320" height="24" alt=""></div></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left">Date</td>
<td height="35" align="left"><input name="txtDate" readonly="readonly" id="txtDate" value="<?=date('d/m/Y')?>" size="20"></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">IP Address :</td>
<td width="518" height="35" align="left"><input id="txtIPAddr" readonly="readonly" name="txtIPAddr" size="20" value="<?php echo GetHostByName($REMOTE_ADDR); ?>"></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">HostName :</td>
<td width="518" height="35" align="left"><input id="txtHost" readonly="readonly" name="txtHost" size="20" value="<?php echo gethostbyaddr($_SERVER['REMOTE_ADDR']); ?>"></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">Department :</td>
<td width="518" height="35" align="left"><label>
<select name="txtDept" id="txtDept">
<option value="1">IT</option>
<option value="2">Account</option>
<option value="3">Sales</option>
<option value="4">HR</option>
<option value="5">Molding</option>
<option value="6">Moldshop</option>
<option value="7">Inventory</option>
<option value="8">Purchase</option>
<option value="9">Planning</option>
<option value="10">Mat Control</option>
<option value="11">QC</option>
<option value="12">Finishing</option>
<option value="13">Maintenance</option>
</select>
</label></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">Employee Code :</td>
<td width="518" height="35" align="left"><input id="txtEmpCode" type="text" name="txtEmpCode" size="20" ></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">User Name :</td>
<td width="518" height="35" align="left"><input id="txtUsername" type="text" name="txtUsername" size="20"></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">Internet Used :</td>
<td width="518" height="35" align="left"><textarea style="font-family:"Times New Roman" name="txtInternet" cols="70" rows="5" id="txtInternet"></textarea></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left"><span class="style1"></span>Computer Used Program :</td>
<td width="518" height="35" align="left"><textarea name="txtComuse" cols="70" rows="5" id="txtComuse"></textarea></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">UPS Status :</td>
<td width="518" height="35" align="left"><label>
<select name="txtUps" id="txtUps">
<option value="No UPS">No UPS</option>
<option value="Work">Work</option>
<option value="Not Work">Not Work</option>
</select>
</label></td>
</tr>
<tr>
<td width="107" align="left"> </td>
<td width="175" align="left">Other :</td>
<td width="518" height="35" align="left"><textarea name="txtOther" cols="70" rows="3" id="txtOther"></textarea></td>
</tr>
<tr>
<td colspan="4">
<table align="center">
<tr align="center">
<td><input id="submit" type="submit" name="submit" value="submit" >
<input type="hidden" name="hdnLine"> </td>
</tr>
</table> </td>
</tr>
<tr>
<td colspan="4">
<div align="center"><img src="images/pd_07.gif" width="320" height="68" alt=""> </div></td>
</tr>
</table>
</form>
<!-- End Save for Web Slices -->
</body>
</html>
Code (PHP) <html>
<head>
<!-- <meta HTTP-EQUIV="Refresh" name="viewport" Content="1;URL=index.php, width=device-width, user-scalable=no," /> -->
<META HTTP-EQUIV="Refresh" Content="10;URL=index.php">
<title>Save.</title>
<body>
<table id="Table_01" width="320" border="0" cellpadding="0" cellspacing="0">
<?
$strConn = new COM("ADODB.Connection") or die("Cannot start ADO");
// $db = 'C:\AppServ\www\car\department_cost.mdb';
$db = '\\\178.108.3.1\\access_pd$\\comuse\\comuse.mdb';
$strConn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db;");
if($_POST["txtDate"] != "")
{
$strSQL = "INSERT INTO DEPT_COST ";
$strSQL .="(CDATE,IPAddr,Host,Dept,EmpCode,Username,Internet,Comuse,Ups,Other) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtDate"]."','".$_POST["txtIPAddr"]."', ";
$strSQL .="'".$_POST["txtHost"]."' ";
$strSQL .=",'".$_POST["txtDept"]."','".$_POST["txtEmpCode"]."' ";
$strSQL .=",'".$_POST["txtUsername"]."','".$_POST["txtInternet"]."' ";
$strSQL .=",'".$_POST["txtComuse"]."','".$_POST["txtUps"]."' ";
$strSQL .=",'".$_POST["Other"]."') ";
// $strSQL .=",'".$_POST["txtOther"]."','".$_POST["txtNote"]."') ";
$flgSave = $strConn->Execute($strSQL);
}
echo "Save Done.";
$strConn->Close();
$strConn = null;
?>
</table>
</body>
</html>
Tag PHP, Ms Access, HTML/CSS, Report Others
Date :
2013-06-27 11:45:04By :
naotonarakView :
781Reply :
2
ดูว่าใน table ที่เก็บข้อมูล text area มันเป็นประเภทใหน และความกว้าง คุณกำหนดใน db ไว้เท่าใหร่ครับผม
Date :
2013-06-27 11:46:32By :
deawx
Server 01
Load balance : Server 01
