syira86 2 Report post Posted May 5, 2010 salam...sy sudah buat coding register ini dan ia jalan dng baik tp bila msukkn tmbahn maklumat dlm form register..die xnk jalan pulak...sy tmbah dlm form register ialah date join work..harap semua dpt mmbantu cr punca die..mybe mata sy xdapat tgkap mslah kt mne..rabun truk sgt ..hehee.. nie database n coding die [code] -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 04, 2010 at 09:18 PM -- Server version: 5.1.37 -- PHP Version: 5.3.0 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `estaff` -- -- -------------------------------------------------------- -- -- Table structure for table `staff` -- CREATE TABLE IF NOT EXISTS `staff` ( `id` int(11) NOT NULL AUTO_INCREMENT, `staff_no` varchar(200) NOT NULL, `password` varchar(200) NOT NULL, `name` varchar(200) NOT NULL, `last` varchar(60) NOT NULL, `email` varchar(200) NOT NULL, `gender` varchar(200) NOT NULL, `dob` varchar(200) NOT NULL, `position` varchar(200) NOT NULL, `department` varchar(200) NOT NULL, `qualification` varchar(200) NOT NULL, `join` varchar(100) NOT NULL, `address` text NOT NULL, `tell_o` varchar(200) NOT NULL, `tell_h` varchar(200) NOT NULL, `tell_fax` varchar(200) NOT NULL, `pic` varchar(200) NOT NULL, `cat` int(11) NOT NULL, `moto` varchar(200) NOT NULL, `hobi` varchar(200) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Dumping data for table `staff` -- INSERT INTO `staff` (`id`, `staff_no`, `password`, `name`, `last`, `email`, `gender`, `dob`, `position`, `department`, `qualification`, `join`, `address`, `tell_o`, `tell_h`, `tell_fax`, `pic`, `cat`, `moto`, `hobi`) VALUES (3, '1', '1', 'jamal abdila', '', '[email protected]', '1', '1-January-1900', 'Officer', '2nd Prod (Audio/Key)', '', '', 'jalan hitam', '04-665656', '017921545564', '424654654', 'nophoto.gif', 0, '', ''), (11, '123456', '123456', 'Ass. Manager la beb', 'RUSDI', '[email protected]', '1', '1-January-1900', 'Assistant Manager', 'Engineering 1 (Electrical)', '', '', '', '', '', '', 'nophoto.gif', 1, '', ''), (12, 'abc123', 'pokok', 'abdullah', '', '[email protected]', '1', '13-August-1913', 'Officer', 'Product Planing', '', '', '', '', '', '', 'nophoto.gif', 0, '', ''), (13, 'kucing', 'popo', 'jojambul', '', '[email protected]', '2', '7-October-1910', 'Clerk', 'Micom Group', '', '', 'sfdfsdf', 'hjhgjghj', 'ghjgh', 'rtterter', 'nophoto.gif', 0, '', ''), (14, 'admin', '123456', 'Rosman Jamal bin Ahmad', 'Jamal', '[email protected]', '2', '19-April-1919', 'Senior Manager', 'Engineering 2 (Mechanical)', '', '', 'koko', 'kokok', 'kokoko', 'kokok', '41.gif', 0, '', ''), (15, '456789', '456789', 'Banci A/L Kasmin', '', '[email protected]', '1', '18-August-1940', 'Manager', 'Shipping & Warehouse', '', '', '', '', '', '', 'nophoto.gif', 0, '', ''), (16, 'asd123', '', 'said al-jamal', '', '[email protected]', '1', '30-August-1918', 'Officer', 'Product Planing', '', '', 'sdfsdfs', '453534534534', '435345', '345345', 'nophoto.gif', 0, '', ''), (17, 'A123456', 'A123456', 'kamariah rahmah bte samsudin', '', '[email protected]', '1', '9-July-1926', 'Officer', 'Human Resourse', '', '', 'alamat la', '075698562', '0135987456', '0145687652', 'haslinda.png', 0, '', ''), (18, 'test', 'test2', 'test2', '', '[email protected]', '', '', 'Clerk', 'Human Resourse', '', '', '', '', '', '', 'nophoto.gif', 0, '', ''), (19, 'A456789', 'A456789', 'Kamarul Akmal Karim', '', '[email protected]', '1', '18-November-1952', 'Senior Manager', 'Human Resourse', '', '', 'biarlah rahsia', '035698745', '0135698745', '036578521', 'Abdul-Jalil.png', 0, '', ''), (20, 'asas', 'asas', 'wewe dfdfd', 'dfdfd', '[email protected]', '1', '1-January-1900', 'Senior Officer', 'Shipping & Warehouse', '', '', 'sasasa', '4234324', '23424', '32432423', 'nophoto.gif', 0, '', ''), (21, 'A540216', 'TOMOSHI', 'RUSHDI', 'RUSDI', '[email protected]', '1', '1-October-1925', 'Assistant Manager', 'Cost Control', '', '', 'THTHH', '049987909', '0194592764', '055693848', 'nophoto.gif', 0, '', ''), (22, '540216', 'cintaku', 'sally a/p samy', 'sally', '[email protected]', '1', '1-January-1900', 'Clerk', 'Account', 'DEGREE', '', 'rtghtyhygggggggggggggggggggggggggggggggggggggggggggggg', '044435157', '019456789', '04567903', 'nophoto.gif', 0, 'be good', 'cooking'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; [/code] [code] <script src="js/SpryAssets/SpryValidationTextField.js" type="text/javascript"></script> <link href="js/SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" /> <script src="js/SpryAssets/SpryValidationSelect.js" type="text/javascript"></script> <script src="js/SpryAssets/SpryValidationTextarea.js" type="text/javascript"></script> <script src="js/SpryAssets/SpryValidationPassword.js" type="text/javascript"></script> <script src="js/SpryAssets/SpryValidationConfirm.js" type="text/javascript"></script> <link href="js/SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" /> <link href="js/SpryAssets/SpryValidationTextarea.css" rel="stylesheet" type="text/css" /> <link href="js/SpryAssets/SpryValidationPassword.css" rel="stylesheet" type="text/css" /> <link href="js/SpryAssets/SpryValidationConfirm.css" rel="stylesheet" type="text/css" /> <div id='subtitle'><img src='images/knob.gif' width='4' height='4' hspace='0' vspace='0' align='left'>New Registration Staff</div> <?php //add process if(isset($_POST["Submit"])){ $dob = $_POST["day"]."-".$_POST["month"]."-".$_POST["year"]; $join= $_POST["join"]."-".$_POST["month"]."-".$_POST["year"]; //$name = $_POST["name"]." ".$_POST["last"]; mysql_query("INSERT INTO staff (staff_no,password,name,last,email,gender,dob,position,department,qualification,join,address,tell_o,tell_h,tell_fax,pic) VALUES ( '".$_POST["staff_no"]."', '".$_POST["password"]."', '".$_POST["name"]."', '".$_POST["last"]."', '".$_POST["email"]."', '".$_POST["gender"]."', '".$dob."', '".$_POST["position"]."', '".$_POST["department"]."', '".$_POST["qualification"]."', '".$join."', '".$_POST["address"]."', '".$_POST["tell_o"]."', '".$_POST["tell_h"]."', '".$_POST["tell_fax"]."', '".$_POST["moto"]."', '".$_POST["hobi"]."', 'nophoto.gif' )"); //redirect page to cat list print "<meta http-equiv='refresh' content='1;URL=?page=home'>"; print "Add Data Successfull<br />"; } ?> <form name='form1' method='post' action=''> <table width="100%" border="0" cellspacing="0" cellpadding="5"> <tr> <td colspan="2" align="right"> </td> </tr> <tr> <td align="right">Staff Id : </td> <td><span id="sprytextfield1"> <input class="validate" name="staff_no" type="text" id="staff_no" size="40" /> <span class="textfieldRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td align="right">Password : </td> <td><span id="sprypassword1"> <input name="password1" type="password" id="password1" size="40" /> <span class="passwordRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td align="right">Confirm Password : </td> <td><span id="spryconfirm1"> <input class="validate" name="password" type="password" id="password" size="40" /> <span class="confirmRequiredMsg">A value is required.</span><span class="confirmInvalidMsg">The password don't match.</span></span></td> </tr> <tr> <td width="30%" align="right">Name : </td> <td width="70%"><span id="sprytextfield4"> <input class="validate" name="name" type="text" id="name" size="40" /> <span class="textfieldRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td width="30%" align="right">Nick Name : </td> <td width="70%"><span id="sprytextfield9"> <input name="last" type="text" class="validate" id="last" size="40" maxlength="5" /> <span class="textfieldRequiredMsg">A value is required.</span></span><font color="#FF0000">*Max 5 Char</font></td> </tr> <tr> <td align="right">E-Mail : </td> <td><span id="sprytextfield5"> <input class="validate" name="email" type="text" id="email" size="40" /> <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td> </tr> <tr> <td align="right">Gender : </td> <td><span id="spryselect1"> <select name="gender" id="gender"> <option>--Select--</option> <option value="1">Male</option> <option value="2">Female</option> </select> <span class="selectRequiredMsg">Please select an item.</span></span></td> </tr> <tr> <td align="right">D.O.B</td> <td> <?php print"<select name='day' id='day'>"; for($i=1;$i<=31;$i++){ print "<option value='".$i."'>".$i."</option>"; } print"</select> <select name='month' id='month'> <option value='January'>January</option> <option value='Febuary'>Febuary</option> <option value='Mac'>Mac</option> <option value='April'>April</option> <option value='Mei'>Mei</option> <option value='June'>June</option> <option value='July'>July</option> <option value='August'>August</option> <option value='September'>September</option> <option value='October'>October</option> <option value='November'>November</option> <option value='December'>December</option> </select> <select name='year' id='year'>"; for($i=1900;$i<=2010;$i++){ print "<option value='".$i."'>".$i."</option>"; } print"</select>"; ?> </td> </tr> <tr> <td align="right">Position :</td> <td><span id="spryselect2"> <select name="position" id="position"> <option>-- Please Choose --</option> <option value="Senior Manager">Senior Manager</option> <option value="Assistant Manager">Assistant Manager</option> <option value="Senior Officer">Senior Officer</option> <option value="Officer">Officer</option> <option value="Clerk">Clerk</option> </select> <span class="selectRequiredMsg">Please select an item.</span></span></td> </tr> <tr> <td align="right">Department :</td> <td><span id="spryselect3"> <select name="department" id="department"> <option>-- Please Choose --</option> <option value="Managment Information System">Managment Information System</option> <option value="Purchasing">Purchasing</option> <option value="Sales">Sales</option> <option value="Account">Account</option> <option value="Cost Control">Cost Control</option> <option value="Human Resourse">Human Resourse</option> <option value="Engineering 1 (Electrical)">Engineering 1 (Electrical)</option> <option value="Engineering 2 (Mechanical)">Engineering 2 (Mechanical)</option> <option value="Micom Group">Micom Group</option> <option value="Product Planing">Product Planing</option> <option value="1st Prod (Auto)">1st Prod (Auto)</option> <option value="2nd Prod (Audio/Key)">2nd Prod (Audio/Key)</option> <option value="3rd Prod (Onkyoavr)">3rd Prod (Onkyoavr)</option> <option value="Prod Control">Prod Control</option> <option value="Part Control">Part Control</option> <option value="Shipping & Warehouse">Shipping & Warehouse</option> <option value="Quality Control">Quality Control</option> </select> <span class="selectRequiredMsg">Please select an item.</span></span></td> </tr> <tr> <td align="right">Qualification :</td> <td><span id="spryselect4"> <select name="qualification" id="qualification"> <option>-- Please Choose --</option> <option value="MASTER">MASTER</option> <option value="DEGREE">DEGREE</option> <option value="DIPLOMA">DIPLOMA</option> <option value="STPM">STPM</option> <option value="SPM">SPM</option> </select> <span class="selectRequiredMsg">Please select an item.</span></span></td> </tr> <tr> <td align="right">Date join work</td> <td> <?php print"<select name='join' id='join'>"; for($i=1;$i<=31;$i++){ print "<option value='".$i."'>".$i."</option>"; } print"</select> <select name='month' id='month'> <option value='January'>January</option> <option value='Febuary'>Febuary</option> <option value='Mac'>Mac</option> <option value='April'>April</option> <option value='Mei'>Mei</option> <option value='June'>June</option> <option value='July'>July</option> <option value='August'>August</option> <option value='September'>September</option> <option value='October'>October</option> <option value='November'>November</option> <option value='December'>December</option> </select> <select name='year' id='year'>"; for($i=1900;$i<=2010;$i++){ print "<option value='".$i."'>".$i."</option>"; } print"</select>"; ?> </td> </tr> <tr> <td align="right">Address : </td> <td><span id="sprytextarea1"> <textarea name="address" cols="30" rows="5" id="address"></textarea> <span class="textareaRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td align="right">Tel Office : </td> <td><span id="sprytextfield6"> <input class="validate" name="tell_o" type="text" id="tell_o" size="40" /> <span class="textfieldRequiredMsg">A value is required.</span><span class="textfieldInvalidFormatMsg">Insert number.</span></span></td> </tr> <tr> <td align="right">Tel Hp : </td> <td><span id="sprytextfield7"> <input class="validate" name="tell_h" type="text" id="tell_h" size="40" /> <span class="textfieldRequiredMsg">Insert number.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td> </tr> <tr> <td align="right">Fax No. : </td> <td><span id="sprytextfield8"> <input class="validate" name="tell_fax" type="text" id="tell_fax" size="40" /> <span class="textfieldRequiredMsg">Insert number.</span><span class="textfieldInvalidFormatMsg">Invalid format.</span></span></td> </tr> <tr> <td width="30%" align="right">Motto: </td> <td width="70%"><span id="sprytextfield9"> <input class="validate" name="moto" type="text" id="moto" size="40" /> <span class="textfieldRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td align="right">Interest/Hobby : </td> <td><span id="sprytextarea2"> <textarea name="hobi" cols="30" rows="5" id="hobi"></textarea> <span class="textareaRequiredMsg">A value is required.</span></span></td> </tr> <tr> <td align="right"> </td> <td><input type="submit" name="Submit" value="Submit"></td> </tr> </table> </form> <script type="text/javascript"> <!-- var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1"); var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield4"); var sprytextfield4 = new Spry.Widget.ValidationTextField("sprytextfield9"); var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "email"); var sprytextfield9 = new Spry.Widget.ValidationTextField("sprytextfield9"); var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1"); var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2"); var spryselect3 = new Spry.Widget.ValidationSelect("spryselect3"); var spryselect4 = new Spry.Widget.ValidationSelect("spryselect4"); var sprytextarea1 = new Spry.Widget.ValidationTextarea("sprytextarea1"); var sprytextarea2 = new Spry.Widget.ValidationTextarea("sprytextarea2s"); var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6", "integer"); var sprytextfield7 = new Spry.Widget.ValidationTextField("sprytextfield7", "integer"); var sprytextfield8 = new Spry.Widget.ValidationTextField("sprytextfield8", "integer"); var sprypassword1 = new Spry.Widget.ValidationPassword("sprypassword1"); var spryconfirm1 = new Spry.Widget.ValidationConfirm("spryconfirm1", "password1"); //--> </script> [/code] Quote Share this post Link to post Share on other sites
deejagothic 1 Report post Posted May 5, 2010 (edited) Kat query ko tu ..cube buh mysql_error [code] mysql_query("Insert into....blablabla") or die("Letak code panjang2 tapi susah aku nk baca! ".mysql_error()); [/code] Edited May 5, 2010 by deejagothic Quote Share this post Link to post Share on other sites
