001.<form action="Company_add_save.php" method="post" name="form1" target="_blank" id="form1" enctype="multipart/form-data">
002.<?
003.$link = mysql_connect("localhost", "root", "password");
004.mysql_select_db("reference_database", $link);
005.
006.$result = mysql_query("SELECT * FROM university", $link);
007.$num_rows = mysql_num_rows($result);
008.
009.$Line=$num_rows;
010.?>
011.<form id="formRegister" name="formRegister" method="post" action="Company_add_save.php" enctype="multipart/form-data">
012.<p>บริษัท ||
013. <select name="Com_ID" id="Com_ID">
014. <option value="">เลือกบริษัท</option>
015. <?php
016. $sql="select * from company ";
017. $a=mysql_query($sql);
018. while($objResult=mysql_fetch_array($a)){
019.?>
020. <option value="<?=$objResult['Com_ID']?>"><?= $objResult['Com_name']?></option>
021.<?php } ?>
022. </select></p>
023.<br/>
024.<p>ฐานข้อมูล Reference Database ||
025. <select name="Rf_ID" id="Rf_ID">
026. <option value="">เลือกฐานข้อมูล Reference Database ที่ต้องการ</option>
027. <?php
028. $sql="select * from reference_data ";
029. $a=mysql_query($sql);
030. while($objResult=mysql_fetch_array($a)){
031.?>
032. <option value="<?=$objResult['Rf_ID']?>"><?=$objResult['Rf_name']?></option>
033.<?php } ?>
034. </select></p>
035.<br/>
036.แนบไฟล์เอกสาร ||
037. <input name="file_name" type="file" id="file_name" enctype="multipart/form-data" />
038.<br/><br/><br/>
039.
040.<?
041.$strSQL = "SELECT * FROM university";
042.
043.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
044.?>
045.
046.<script language="JavaScript">
047.function IsNumeric(sText,obj)
048.{
049. var ValidChars = "0123456789,.";
050. var IsNumber=true;
051. var Char;
052. for (i = 0; i < sText.length && IsNumber == true; i++)
053. {
054. Char = sText.charAt(i);
055. if (ValidChars.indexOf(Char) == -1)
056. {
057. IsNumber = false;
058. }
059. }
060. if(IsNumber==false){
061. alert("กรอกข้อมูลเฉพาะตัวเลข เช่น 1,000");
062. obj.value=sText.substr(0,sText.length-1);
063. }
064. }
065.</script>
066.<table align="center" border="3" bgcolor="#EDEDED" width="50" class="table table-bordered table-hover" id="example2">
067. <tr>
068. <td rowspan="3" bgcolor="#f79e45" style="text-align: center">ชื่อมหาวิทยาลัย</td>
069. <tr>
070. <td colspan="5" bgcolor="#f79e45" style="text-align: center">เดือน :
071. <label for="Month"></label>
072. <select name="Month" id="Month">
073. <option value="">เลือกเดือนที่ต้องการ</option>
074. <option value="January">January</option>
075. <option value="February">February</option>
076. <option value="March">March</option>
077. <option value="April">April</option>
078. <option value="May">May</option>
079. <option value="June">June</option>
080. <option value="July">July</option>
081. <option value="August">August</option>
082. <option value="September">September</option>
083. <option value="October">October</option>
084. <option value="November">November</option>
085. <option value="December">December</option>
086. </select>
087. ปี :
088. <label for="Years"></label>
089. <select name="Years" id="Years">
090. <option value="">เลือกเดือนที่ต้องการ</option>
091. <option value="2015">2015</option>
092. <option value="2016">2016</option>
093. <option value="2017">2017</option>
094. <option value="2018">2018</option>
095. <option value="2019">2019</option>
096. <option value="2020">2020</option>
097. </select>
098. </tr>
099. <tr>
100. <td bgcolor="#f79e45" style="text-align: center">Searches</td>
101. <td bgcolor="#f79e45" style="text-align: center"><p>Full_Text</p>
102. <p>Requests</p></td>
103. <td bgcolor="#f79e45" style="text-align: center"><p>Sub</p>
104. <p>sessions</p></td>
105. <td bgcolor="#f79e45" style="text-align: center">Queries</td>
106. <td bgcolor="#f79e45" style="text-align: center"><p>Citation</p>
107. <p>Events</p></td>
108. </tr>
109.<?php
110.while($objResult = mysql_fetch_array($objQuery))
111.{
112. if ($bg=="#ffffff"){
113. $bg="#fcdebf";}
114. else {
115. $bg="#ffffff";}
116.?>
117. <tr>
118. <tr bgcolor="<?=$bg?>">
119. <td><input type="text" name="Univer_name" readonly="1" value="<?=$objResult['Univer_name']?>" size="60"><input name="Univer_ID[]" type="hidden" value="<?=$objResult['Univer_ID']?>" /></td>
120.
121. <td><input type="text" name="Searches[]" id="Searches" size="10" onKeyUp="IsNumeric(this.value,this)" ></td>
122.
123. <td><input type="text" name="Full_Text_Requests[]" id="Full_Text_Requests" onKeyUp="IsNumeric(this.value,this)" size="10"></td>
124.
125. <td><input type="text" name="Sub_sessions[]" id="Sub_sessions" onKeyUp="IsNumeric(this.value,this)" size="10"></td>
126.
127. <td><input type="text" name="Queries[]" id="Queries" onKeyUp="IsNumeric(this.value,this)" size="10"></td>
128. <td><input type="text" name="Citation_Events[]" id="Citation_Events" onKeyUp="IsNumeric(this.value,this)" size="10"></td>
129. </tr>
130. <?php
131. }
132. ?>
133.</table>
134.<? echo $msg ;?>
135.<br/>
136. <div align="center"><input type="submit" name="submit" value="บันทึก">
137.
138. </div>
139.
140. </form>
