الفريق العربي للبرمجةأرشيف المنتديات · 2000 – 2023
نسخة أرشيفية للقراءة فقط — التسجيل والمشاركة مغلقان، والمحتوى محفوظ كما كان.

جميع البينات تسحب بصورة صحيحة من الادخال من واجهة التسجيل

بدأه mahmoodsami في 10 يناير 2010 · 1 رد · 754 مشاهدة · في قواعد بيانات MySQL
مشاركة: واتساب X فيسبوك تيليجرام
#1 صاحب الموضوع

السلام عليكم

جميع البينات تسحب بصورة صحيحة من الادخال من واجهة التسجيل الا بيانة واحدة تاخذ قيمتها من جدول اخر

حيث لدي جدول لتسجيل الاستاذ وجدول اخر لتسجيل الموظف

المشكلة في ادخال البيانات في حقل واحد حيث في واجهة تسجيل الموظف تظهر اختيارات الموظف (عنوانه الوظيفي ) ولكن في التنفيذ ياخذ جميع بيانات الموظف صحيحة الا العنوان الوظيفي فانة

ياخذ لقب علمي وهي بيانات خاصة بالاستاذ

هذا جدول الموظف

DROP TABLE IF EXISTS `mahmood`.`administrators`;
CREATE TABLE  `mahmood`.`administrators` (
  `userid` varchar(75) collate utf8_unicode_ci NOT NULL,
  `password` varchar(75) collate utf8_unicode_ci default NULL,
  `fname` varchar(75) collate utf8_unicode_ci default NULL,
  `lname` varchar(75) collate utf8_unicode_ci default NULL,
  `email` varchar(75) collate utf8_unicode_ci default NULL,
  `college dep.` varchar(75) collate utf8_unicode_ci default NULL,
  `title work` varchar(75) collate utf8_unicode_ci default NULL,
  `country name` varchar(75) collate utf8_unicode_ci default NULL,
  `city name` varchar(75) collate utf8_unicode_ci default NULL,
  `number-id` varchar(75) collate utf8_unicode_ci NOT NULL,
  `mobile no.` bigint(20) default NULL,
  PRIMARY KEY  (`userid`,`number-id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

وهذه واجهة الموظف و برمجة JSP

<!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" xml:lang="en" lang="en">



<head>

  <title>Administrator Registration Information</title>
  <link href="css/style.css" rel="stylesheet" type="text/css">

</head>

<body>

 <!-- blue line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
</tr>
</table>

<!-- green line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
</tr>
</table>

<!-- the images logo and tage -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="240" height="150" align="center"><img src="image/registeradmin.gif" width="240" height="150" align="center"/></td>
</tr>

 <!--  Mnew bar  -->
<table background="image/menu-bg.gif" class="bgx" align="center" cellpadding="0" cellspacing="0" width="240" border="0">

<tr>
 <td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
<td align="center"><a href="#" ><font color="#FFFFFF" size="1">Home Page</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
<td align="center"><a href="#"><font color="#FFFFFF" size="1">Back</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
</tr>
</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>

<!-- the types of registration pages -->

<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<!-- select -->
<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Plase register your user name account & password to use them in the following :-</font></a></td>
</tr>

</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>

<form action="regadministrator.jsp" method="post">

<!-- first part of information -->
<!-- student user name and password-->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center" bgcolor="#66CC33">


   <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">UserName</font></td>
   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="userid" /></td>
   </tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

    <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" face="Arial" size="1">Password</font></td>
   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="password"  name="pwd"  /></td>
   </tr>
  <!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="90" height="7" valign="top"></td>
<td  bgcolor="#66CC33"  align="center" width="150" height="7" valign="top"></td>
</tr>

<!-- second part of information -->

<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Insert your information :-
</font></td>
</tr>

<!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<!-- personality information  -->
<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">First Name</font></td>
<td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="fname" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>
<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">Last Name  </font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="lname" /></td>
</tr>

 <tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">E-mail</font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="email" /></td>
</tr>

 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The College Department Name </font></td>
<td  align="left" width="150">
    <select name="cdepart">
 <option  value="IT">IT</option>
 <option  value="NETWORK">Network</option>
 <option  value="INTERNET">Internet</option>
</select>
</td>
</tr>

 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Title Of Work </font></td>
<td  align="left" width="150">
    <select name="work">
 <option  value="Master">Managerial</option>
 <option  value="Doctorate">Financial</option>
 <option  value="Professor">Secretariat</option>
 </select>
</td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Country Name </font></td>
<td  align="left" width="150">
    <select name="ncountry">
<option  value="Albania">Albania</option>
<option  value="Argntina">Argntina</option>
<option  value="Australia">Australia</option>
<option  value="Bahrain">Bahrain</option>
<option  value="Brazil">Brazil</option>
<option  value="Bulgaria">Bulgaria</option>
<option  value="Canada">Canada</option>
<option  value="China">China</option>
<option  value="Cuba">Cuba</option>
<option  value="Denmark">Denmark</option>
<option  value="D.P.R.Korea">Korea</option>
<option  value="Ecuador">Ecuador</option>
<option  value="Egypt">Egypt</option>
<option  value="Finland">Finland</option>
<option  value="Franca">Franca</option>
<option  value="Germany">Germany</option>
<option  value="Guinea">Guinea</option>
<option  value="Guyana">Guyana</option>
<option  value="Hungary">Hungary</option>
<option  value="Iceland">Iceland</option>
<option  value="India">India</option>
<option  value="Iran">Iran</option>
<option  value="Iraq">Iraq</option>
<option  value="Italy">Italy</option>
<option  value="Japan">Japan</option>
<option  value="Jordan">Jordan</option>
<option  value="Kenya">Kenya</option>
<option  value="Kuwait">Kuwait</option>
<option  value="Lebanon">Lebanon</option>
<option  value="U.S.A">U.S.A</option>
<option  value="other">other</option>
</select>
</td>
</tr>

 <!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The City Name </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="ncity" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Number Of ID </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nid"  /></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Mobile Number </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nmobile" /></td>
</tr>
<!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td  align="center"><input align="center" size="5" maxlength="100" type="submit" value="Submit" /></td>
<td  align="center"><input align="center" size="5" maxlength="100" type="reset" value="Reset" /></td>
</tr>
</table>

</form>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="3" valign="top"></td>
</tr>
 </table>



<!-- The footer of the home page -->

<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="#3399CC" align="center">
<tr>

<td><img src="image/b-bg.gif" alt="" width="1" height="62"></td>
<td width="100"><font face="Arial" color="#FFFFFF" size="1">Company Name</font><br><font face="Arial" color="#FFFFFF" size="1">
Phone: 01101234567</font><br><font face="Arial" color="#FFFFFF" size="1">
E-mail: info@companyname.net</font><br></td>


<td width="140" valign="middle" align="center"><a href="#" >

<STYLE TYPE="text/css">
A { text-decoration: none; }
A:link { color: #000000; }
A:visited { color: #000000; }
</STYLE>

<font face="Arial" color="#FFFFFF" size="1">Home Page</font></a> || <a href="#"><font face="Arial" color="#FFFFFF" size="1">Back</font></a></td>


</tr>
</table>



</body>

</html>

<%--
    Document   : reg student
    Created on : 29/12/2009, 07:51:01 م
    Author     : Mahmood80
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>reg administrator</title>
    </head>
    <body>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%
String user=request.getParameter("userid");
session.putValue("userid",user);
String pwd=request.getParameter("pwd");
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String cdepart=request.getParameter("cdepart");
String work=request.getParameter("work");
String ncountry=request.getParameter("ncountry");
String ncity=request.getParameter("ncity");
String nid=request.getParameter("nid");
String nmobile=request.getParameter("nmobile");
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mahmood","root","password");
Statement st= con.createStatement();
ResultSet rs;
int i=st.executeUpdate("insert into administrators values ('"+user+"','"+pwd+"','"+fname+"','"+lname+"','"+email+"','"+cdepart+"','"+work+"','"+ncountry+"','"+ncity+"','"+nid+"','"+nmobile+"')");


%>

    </body>
</html>

جدول الاستاذ

DROP TABLE IF EXISTS `mahmood`.`instructors`;
CREATE TABLE  `mahmood`.`instructors` (
  `userid` varchar(75) collate utf8_unicode_ci NOT NULL,
  `password` varchar(75) collate utf8_unicode_ci default NULL,
  `fname` varchar(75) collate utf8_unicode_ci default NULL,
  `lname` varchar(75) collate utf8_unicode_ci default NULL,
  `email` varchar(75) collate utf8_unicode_ci default NULL,
  `college dep.` varchar(75) collate utf8_unicode_ci default NULL,
  `agnomen` varchar(75) collate utf8_unicode_ci default NULL,
  `country name` varchar(75) collate utf8_unicode_ci default NULL,
  `city name` varchar(75) collate utf8_unicode_ci default NULL,
  `number-id` varchar(75) collate utf8_unicode_ci NOT NULL,
  `mobile no.` bigint(20) default NULL,
  PRIMARY KEY  (`userid`,`number-id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

واجهة الاستاذ و JSP

<!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" xml:lang="en" lang="en">



<head>

  <title>Instructor Registration Information</title>
  <link href="css/style.css" rel="stylesheet" type="text/css">

</head>

<body>

 <!-- blue line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
<td  bgcolor="#0066CC"  align="center" width="120" height="5" valign="top"></td>
</tr>
</table>

<!-- green line -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
<td  bgcolor="#99CC33"  align="center" width="120" height="10" valign="top"></td>
</tr>
</table>

<!-- the images logo and tage -->
<table width="240" height="5" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="240" height="150" align="center"><img src="image/registerteacher.gif" width="240" height="150" align="center"/></td>
</tr>

 <!--  Mnew bar  -->
<table background="image/menu-bg.gif" class="bgx" align="center" cellpadding="0" cellspacing="0" width="240" border="0">

<tr>
 <td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
<td align="center"><a href="#" ><font color="#FFFFFF" size="1">Home Page</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
<td align="center"><a href="#"><font color="#FFFFFF" size="1">Back</font></a></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" alt="" width="6" height="27"></td>
<td align="center"><img src="image/menu-sep.gif" width="6" height="27" alt=""></td>
</tr>
</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>

<!-- the types of registration pages -->

<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<!-- select -->
<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Plase register your user name account & password to use them in the following :-</font></a></td>
</tr>

</table>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>
 </table>


 <form action="reginstructor.jsp" method="post">

 <!-- first part of information -->
<!-- student user name and password-->

<table width="240" border="0" cellpadding="0" cellspacing="0" align="center" bgcolor="#66CC33">


   <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">UserName</font></td>
   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="userid" /></td>
   </tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

    <tr>
   <td  align="center" valign="baseline" width="90"><font color="#000000" face="Arial" size="1">Password</font></td>

   <td  align="left" width="150"><input align="left" size="8" maxlength="100" type="password" name="pwd" /></td>
   </tr>

  <!-- green line -->

 <tr>
<td  bgcolor="#66CC33"  align="center" width="90" height="7" valign="top"></td>
<td  bgcolor="#66CC33"  align="center" width="150" height="7" valign="top"></td>
</tr>

<!-- second part of information -->

<tr>
<td width="240" height="20" align="left"><font color="#0000FF" size="1" face="Arial">Insert your information :-
</font></td>
</tr>

<!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<!-- personality information  -->
<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">First Name</font></td>
<td  align="left" width="150"><input align="left" size="8" maxlength="100" type="text" name="fname" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">Last Name  </font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="lname" /></td>
</tr>

 <tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="80"><font color="#000000" size="1" face="Arial">E-mail</font></td>
<td  align="left" width="160"><input align="left" size="8" maxlength="100" type="text" name="email"  /></td>
</tr>

 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The College Department Name </font></td>
<td  align="left" width="150">
    <select name="cdepart">
 <option  value="IT">IT</option>
 <option  value="NETWORK">Network</option>
 <option  value="INTERNET">Internet</option>
</select>
</td>
</tr>

 <!-- green line -->
<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Agnomen </font></td>
<td  align="left" width="150">
    <select name="agnomen">
 <option  value="Master">Master</option>
 <option  value="Doctorate">Doctorate</option>
 <option  value="Professor">Professor</option>
 </select>
</td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>
<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Country Name </font></td>
<td  align="left" width="150">
    <select name="ncountry">
<option  value="Albania">Albania</option>
<option  value="Argntina">Argntina</option>
<option  value="Australia">Australia</option>
<option  value="Bahrain">Bahrain</option>
<option  value="Brazil">Brazil</option>
<option  value="Bulgaria">Bulgaria</option>
<option  value="Canada">Canada</option>
<option  value="China">China</option>
<option  value="Cuba">Cuba</option>
<option  value="Denmark">Denmark</option>
<option  value="D.P.R.Korea">Korea</option>
<option  value="Ecuador">Ecuador</option>
<option  value="Egypt">Egypt</option>
<option  value="Finland">Finland</option>
<option  value="Franca">Franca</option>
<option  value="Germany">Germany</option>
<option  value="Guinea">Guinea</option>
<option  value="Guyana">Guyana</option>
<option  value="Hungary">Hungary</option>
<option  value="Iceland">Iceland</option>
<option  value="India">India</option>
<option  value="Iran">Iran</option>
<option  value="Iraq">Iraq</option>
<option  value="Italy">Italy</option>
<option  value="Japan">Japan</option>
<option  value="Jordan">Jordan</option>
<option  value="Kenya">Kenya</option>
<option  value="Kuwait">Kuwait</option>
<option  value="Lebanon">Lebanon</option>
<option  value="U.S.A">U.S.A</option>
<option  value="other">other</option>
</select>
</td>
</tr>

 <!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The City Name </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="ncity" /></td>
</tr>

<tr>
<td  bgcolor="#66CC33"  align="center" height="7"></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Number Of ID </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nid" /></td>
</tr>

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">Mobile Number </font></td>
<td  align="left" width="150"><input align="left" size="5" maxlength="100" type="text" name="nmobile" /></td>
</tr>
<!-- green line -->

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="7" valign="top"></td>
</tr>

<tr>
<td  align="center"><input align="center" size="5" maxlength="100" type="submit" value="Submit" /></td>
<td  align="center"><input align="center" size="5" maxlength="100" type="reset" value="Reset" /></td>
</tr>

 </table>

</form>

 <!-- green line -->
<table width="240" border="0" cellpadding="0" cellspacing="0" align="center"  bgcolor="#66CC33">

<tr>
<td  bgcolor="#66CC33"  align="center" width="240" height="3" valign="top"></td>
</tr>
 </table>



<!-- The footer of the home page -->

<table width="240" border="0" cellspacing="0" cellpadding="0" bgcolor="#3399CC" align="center">
<tr>

<td><img src="image/b-bg.gif" alt="" width="1" height="62"></td>
<td width="100"><font face="Arial" color="#FFFFFF" size="1">Company Name</font><br><font face="Arial" color="#FFFFFF" size="1">
Phone: 01101234567</font><br><font face="Arial" color="#FFFFFF" size="1">
E-mail: info@companyname.net</font><br></td>


<td width="140" valign="middle" align="center"><a href="#" >

<STYLE TYPE="text/css">
A { text-decoration: none; }
A:link { color: #000000; }
A:visited { color: #000000; }
</STYLE>

<font face="Arial" color="#FFFFFF" size="1">Home Page</font></a> || <a href="#"><font face="Arial" color="#FFFFFF" size="1">Back</font></a></td>


</tr>
</table>



</body>

</html>

<%--
    Document   : reg student
    Created on : 29/12/2009, 07:51:01 م
    Author     : Mahmood80
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>reg instructor</title>
    </head>
    <body>
<%@ page import ="java.sql.*" %>
<%@ page import ="javax.sql.*" %>
<%
String user=request.getParameter("userid");
session.putValue("userid",user);
String pwd=request.getParameter("pwd");
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
String email=request.getParameter("email");
String cdepart=request.getParameter("cdepart");
String agnomen=request.getParameter("agnomen");
String ncountry=request.getParameter("ncountry");
String ncity=request.getParameter("ncity");
String nid=request.getParameter("nid");
String nmobile=request.getParameter("nmobile");
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost/mahmood","root","password");
Statement st= con.createStatement();
ResultSet rs;
int i=st.executeUpdate("insert into instructors values ('"+user+"','"+pwd+"','"+fname+"','"+lname+"','"+email+"','"+cdepart+"','"+agnomen+"','"+ncountry+"','"+ncity+"','"+nid+"','"+nmobile+"')");


%>

    </body>
</html>

سلامي

محمود

#2

السلام عليكم ورحمة الله وبركاته

المشكلة كانت في واجهة الموظف تابعوا الكود الذي تجودن فيه العنوان الوظيفي:

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Title Of Work </font></td>
<td  align="left" width="150">
    <select name="work">
 <option  value="Master">Managerial</option>
 <option  value="Doctorate">Financial</option>
 <option  value="Professor">Secretariat</option>
 </select>
</td>
</tr>

وضعوا ما يلي :

<tr>
<td align="center" valign="baseline" width="90"><font color="#000000" size="1" face="Arial">The Title Of Work </font></td>
<td  align="left" width="150">
    <select name="work">
 <option  value="Managerial">Managerial</option>
 <option  value="Financial">Financial</option>
 <option  value="Secretariat">Secretariat</option>
 </select>
</td>
</tr>

سلامي

اخوكم

محمود سامي

مواضيع مشابهة

عدد الزوار حالياً

المتواجدون خلال آخر دقيقتين · يتحدّث كل ٣٠ ثانية

—الإجمالي—أعضاء مسجّلون—زوار بدون تسجيل

جارٍ التحقق من المتواجدين…