syira86
-
Content Count
34 -
Joined
-
Last visited
Posts posted by syira86
-
-
error nie
Build started: Project: Assignment, Configuration: Debug Win32 ------
1> assignment.cpp
1>c:\documents and settings\maluser01\desktop\assignment\assignment\assignment.cpp(3): fatal error C1083: Cannot open include file: 'iostream.h': No such file or directory
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========
cmne nak fix -
[b] salam....nk mntk ckit boleh tak..nak tanya pasal soalan C++ ini...saya tak dapat nak jawab...harap kwn2 dapat tolong
Write a C++ program to calculate the average of a set of grades and counting the number of failing test grades, the output are shown as following:-
How many grades will you be entering? 7
... Enter grade #1 : 93
Enter grade #2 : 63
Enter grade #3 : 87
Enter grade #4 : 65
Enter grade #5 : 62
Enter grade #6 : 88
Enter grade #7 : 76
Grade average = 76.29
Number of failures = 2[/b] -
ok sy cuba ye..tima ksh ye
-
salam ,sy masih baru dalam prgmming c++ nie, saya dapat soalan dari lect dan saya tak tahu bagaimana nak buat sebab nie invidual assgmnt..saya harap sgt abg2x n kak2x dpt tolong ajar saya..tq...ini soalan
Write a [b]C++ [/b]Program to capture user input on FIRST number, SECOND number and OPERATOR which is either +, -, * or /, then using a [b]SWITCH..CASE[/b] programming construct to calculate the numbers based on the OPERATOR selected, an invalid user input, such as “p”, “1” or “=” will results an error message, such as “Unknown Operator!!” .
The example output is shown as below:-
Please enter FIRST number: 10
Please enter SECOND number: 5
Please enter OPERATOR [+, -, *, /] : *
Result of 10 * 5 = 50
[b][size=4] [/size][/b] -
[quote name='dans kam' date='30 April 2010 - 12:20 AM' timestamp='1272558011' post='1028314']
0oo tgh praktikal rupenye.. ok la kene buat sistem. Kirenye apply la jugak knowledge yg di belajar kat U..
Kalo ade pape nanti bleh je tanya lg kat sini.. Ramai otai2 php kat pdc ni. Cuma mgkin la ni dorang bz kot..
Aku tlg sekadar yg termampu je.. Lgpun skrg ni bosan, xde keje programming yg baru dah, asyik buat training, testing & repair coding je. Huhu... Tu yg rajin kat putera nih.. Dapat gak mende baru. Hehe...
papepun.. Semoga sukses kepada syira86
[/quote]
sy nak tnya psal cuti ini kan...baru terpikir idea ini...kan department ini cuti diberikan adlah berlainan mngikut tahun mereka berkerja..so sy nak 1 fungsi yang boleh bgtau berapa cuti yang mereka mohon dan akan keluar message over limit if sudah melebihi cuti yang diambil dan mereka juga boleh tau balance cuti mereka
kira pekerja yg berkerja selma 2thn tp kurang 5thn=14hari sethun
5thn tp kurang 10thn=17hari sthn
10thn tp kurang 15thn=21hari sthn
15thn dan ke'atas=27hari sethn
pada borang daftar sy dah buat form untk tarikh mereka msuk kerja...so sy nak tanye bgaimana nak buat coding ini...harap sedara dans kam dan sume dpt mmbantu sy... -
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] -
xenomorf dan deejagothic tima ksh ye sudi jwb soalan sy 2
-
[quote name='dans kam' date='29 April 2010 - 12:33 PM' timestamp='1272515607' post='1028186']
Orait xde hal.. aku pun dpt knowledge baru jugak.
Pd pendapat aku, kalo diorang nak fungsi tu je, kira ok dah tu.
Cuma untuk menyenangkan ko pada masa depan in case diorang nak tambah fungsi lain, better ko design database tu se'fleksible' yang mungkin.
Yang boleh expend utk tambah fungsi2 lain kemudian hari.
Kalo dapat 'normalise'kan table2 yang ada, nanti senang skit nak expend.
Sekadar pendapat..
[/quote]
tima ksh tau pdapt ...mybe nati ade progrmmer lain kot ada pas sy habs prtikal...nie just cadgn dorg nk buat cuti online...amik masa gak nk approve sistem ini..anywhre tima ksh awk n semua... -
dans kam..sy dah dapat buat...tima ksh ye awk dan semua yg tlg sy....cuma sy nk tnya n mintak pndapat or idea la
dalam sistem staf ini ada fungsi
hebahan
apply cuti
upload fail
diary staff
profile
rasanya dah ckup ke fungsi sy buat coz department just nk fungsi apply cuti shja... -
maaf ye dam kam...bru fhm..hehhehe..
nie database application
[code]
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 28, 2010 at 07:52 PM
-- Server version: 5.1.37
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `estaff`
--
-- --------------------------------------------------------
--
-- Table structure for table `application`
--
CREATE TABLE IF NOT EXISTS `application` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`staff_no` varchar(200) NOT NULL,
`name` varchar(200) NOT NULL,
`department` varchar(200) NOT NULL,
`position` varchar(200) NOT NULL,
`start` varchar(200) NOT NULL,
`end` varchar(200) NOT NULL,
`day` varchar(200) NOT NULL,
`reason` text NOT NULL,
`choice` varchar(200) NOT NULL,
`date_apply` varchar(30) NOT NULL,
`date_check` varchar(30) NOT NULL DEFAULT 'NOT',
`date_apprve` varchar(30) NOT NULL DEFAULT 'NOT',
`approve` int(11) NOT NULL,
`remark` text NOT NULL,
`remark_by` varchar(99) NOT NULL,
`status` int(11) NOT NULL,
`status_sm` int(11) NOT NULL,
`cat` int(11) NOT NULL,
`cop_sm` varchar(30) NOT NULL DEFAULT 'NOT',
`cop_am` varchar(30) NOT NULL DEFAULT 'NOT',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `application`
--
INSERT INTO `application` (`id`, `staff_no`, `name`, `department`, `position`, `start`, `end`, `day`, `reason`, `choice`, `date_apply`, `date_check`, `date_apprve`, `approve`, `remark`, `remark_by`, `status`, `status_sm`, `cat`, `cop_sm`, `cop_am`) VALUES
(14, 'A123456', 'kamariah rahmah bte samsudin', 'Human Resourse', 'Officer', '22.01.2010', '25.01.2010', '3', 'suke2', 'Casual leave', '', '13-03-2010', 'NOT', 0, '', '', 0, 0, 1, 'NOT', 'RUSDI'),
(15, 'A123456', 'kamariah rahmah bte samsudin', 'Human Resourse', 'Officer', '30.01.2010', '28.02.2010', '30', 'nk g melancong sat', 'Unpaid leave', '', '13-03-2010', '18-03-2010', 0, '', '', 2, 0, 0, 'JAMAL', 'RUSDI'),
(16, 'A123456', 'kamariah rahmah bte samsudin', 'Human Resourse', 'Officer', '13.03.2010', '14.03.2010', '2', 'lalala', 'Maternity leave', '13.03.2010', '13-03-2010', '13-03-2010', 0, '', '', 2, 0, 0, 'jamal', 'RUSDI'),
(17, '123456', 'Ass. Manager la beb', 'Engineering 1 (Electrical)', 'Assistant Manager', '26.03.2010', '25.03.2010', '4', 'gfdgdfgd', 'Half day unpaid leave', '11.03.2010', '12-03-2010', '13-03-2010', 0, '', '', 2, 0, 0, 'JAMAL', 'JAMAL'),
(18, 'A123456', 'kamariah rahmah bte samsudin', 'Human Resourse', 'Officer', '19.04.2010', '19.04.2010', '1', '', 'Mc leave', '19.04.2010', '19-04-2010', '19-04-2010', 0, '', '', 2, 0, 0, '', 'RUSDI');
[/code]
[URL=http://img402.imageshack.us/i/15096811.jpg/][IMG]http://img402.imageshack.us/img402/2696/15096811.jpg[/IMG][/URL]
Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL] -
sy pn xfham ape di mintak..itu yg bg semua..harap ada yg bantu nti -
jenis cuti itu blh amik kt dtbse kn...jenis cuti=choice
nk buat 2 bukan bntuk table la...data je mcm dalam table...rupa die mcm picture sy post 2
mcm nie sy post dari mula borang cuti..ok
nie borang cuti
[code]
<div id='subtitle'><img src='images/knob.gif' width='4' height='4' hspace='0' vspace='0' align='left'>Leave Application</div>
<?php include "js/zxcz.html";
$date = date('d.m.Y');
//add process
if(isset($_POST["Submit1"])){
mysql_query("INSERT INTO application
(staff_no,name,department,position,start,end,day,reason,choice,date_apply)
VALUES (
'".$_POST["staff_no"]."',
'".$_POST["name"]."',
'".$_POST["department"]."',
'".$_POST["position"]."',
'".$_POST["start"]."',
'".$_POST["end"]."',
'".$_POST["day"]."',
'".$_POST["reason"]."',
'".$_POST["choice"]."',
'".$date."'
)");
//redirect page to cat list
print "<meta http-equiv='refresh' content='1;URL=?page=result'>";
print "Add Data Successfull<br />";
}
//select data from database according to id
$q = mysql_query("SELECT * FROM staff WHERE staff_no='".$ses_name."'");
$r = mysql_fetch_array($q);
?>
<form name='form1' method='post' action=''>
<table width="100%" border="0" cellpadding="0">
<tr>
<td width="21%"><div align="right"></div></td>
<td width="53%"> </td>
<td width="26%"> </td>
</tr>
<tr>
<td><div align="right">Staff Id :</div></td>
<td><input name="staff_no" type="text" id="staff_no" value="<?php print $r["staff_no"];?>" size="40" readonly="readonly"></td>
<td rowspan="8" valign="top"><table width="100%" border="0" cellpadding="0">
<tr>
<td colspan="2"><div id='subtitle'><img src='images/knob.gif' width='4' height='4' hspace='0' vspace='0' align='left'>Please Choice</div></td>
</tr>
<tr>
<td width="14%"><input name="choice" type="radio" value="Annual leave"></td>
<td width="86%">Annual leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Hospital leave"></td>
<td>Hospital leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Mc leave"></td>
<td>Mc leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Unpaid leave"></td>
<td>Unpaid leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Half day unpaid leave"></td>
<td>Half day unpaid leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Casual leave"></td>
<td>Casual leave</td>
</tr>
<tr>
<td><input name="choice" type="radio" value="Maternity leave"></td>
<td>Maternity leave</td>
</tr>
</table></td>
</tr>
<tr>
<td><div align="right">Name : </div></td>
<td><input name="name" type="text" id="name" value="<?php print $r["name"];?>" size="40" readonly="readonly"></td>
</tr>
<tr>
<td><div align="right">Department : </div></td>
<td><input name="department" type="text" id="department" value="<?php print $r["department"];?>" size="40" readonly="readonly"></td>
</tr>
<tr>
<td><div align="right">Position : </div></td>
<td><input name="position" type="text" id="position" value="<?php print $r["position"];?>" size="40" readonly="readonly"></td>
</tr>
<tr>
<td valign="top"><div align="right">Date of leave : </div></td>
<td><input name="start" id="start"><input type=button value="select" onclick="displayDatePicker('start', false, 'dmy', '.');" readonly="readonly">
Until<br>
<input name="end" id="end"><input type=button value="select" onclick="displayDatePicker('end', false, 'dmy', '.');" readonly="readonly"></td>
</tr>
<tr>
<td><div align="right">No of Day : </div></td>
<td><?php print"<select name='day' id='day'>";
for($i=1;$i<=100;$i++){
print "<option value='".$i."'>".$i."</option>";
}
print"</select>"; ?></td>
</tr>
<tr>
<td><div align="right">Reason : </div></td>
<td><textarea name="reason" cols="35" rows="6" id="reason"></textarea></td>
</tr>
<tr>
<td> </td>
<td><input name="Submit1" type="submit" id="Submit1" value="Submit">
<input type="reset" name="Reset" value="Reset"></td>
</tr>
</table>
</form>
[/code]
nie result die pas isi borang
[code]
<div id='subtitle'><img src='images/knob.gif' width='4' height='4' hspace='0' vspace='0' align='left'>Application Applied</div>
<br>
<script type="text/javascript" src="js/highslide/highslide-with-html.js"></script>
<link rel="stylesheet" type="text/css" href="js/highslide/highslide.css" />
<script type="text/javascript">
hs.graphicsDir = 'js/highslide/graphics/';
hs.outlineType = 'rounded-white';
hs.wrapperClassName = 'draggable-header';
</script>
<table width="100%" border="0" cellpadding="0">
<tr>
<td><div align="right"><img src="images/f2.png" border="0"><a href="?page=history">History Application Leave</a> <img src="images/star.png" border="0"><a href="?page=result">Application Applied</a></div></td>
</tr>
</table>
<?php
//process for single deletion
if(isset($_GET["id"])){
mysql_query("DELETE FROM application
WHERE id=".$_GET["id"]);
}
//move to draf
if(isset($_GET["pid"])){
mysql_query("UPDATE application SET cat=1
WHERE id=".$_GET["pid"]);
}
print "
<table width='100%' border='0' cellspacing='0' cellpadding='3'>
<tr>
<td width='21%' background='images/button.gif'><strong>Choice</strong></td>
<td width='28%' background='images/button.gif'><strong>Start Date</strong></td>
<td width='36%' background='images/button.gif'><strong>End Date </strong></td>
<td width='5%' background='images/button.gif'><div align='center'><strong>Print</strong></div></td>
<td width='5%' background='images/button.gif'><div align='center'><strong>Status</strong></div></td>
<td width='5%' background='images/button.gif'><div align='center'><strong>Cancel</strong></div></td>
</tr>";
$q = mysql_query("SELECT * FROM application WHERE staff_no='".$ses_name."'&& cat=0");
if(!$q || mysql_num_rows($q) < 1){
print "<tr><td colspan='6' align='center' bgcolor='#FF6600'><h3><strong>No Data Found</strong></h3></td></tr>";
}
else{
$count=1;
while($r = mysql_fetch_array($q)){
if($count == 1){
$color="#e3e3e3";
$count++;
}
else{
$color="#f1f1f1";
$count = 1;
}
print "<tr bgcolor='".$color."'>
<td><a href='?page=job_list&act=result&id=".$r["bid"]."'onclick='return hs.htmlExpand(this)'>".$r["choice"]."</a>"; ?>
<div class="highslide-maincontent">
<?php print"<table width='100%' cellspacing='0' cellpadding='3'>
<tr>
<td width='32%' valign='top'>Title : </td>
<td width='41%' valign='top'>".$r["choice"]."</td>
</tr>
<tr>
<td valign='top'>Date of leaving : </td>
<td valign='top'>Start <b>".$r["start"]." </b> Until <b>".$r["end"]."</b></td>
</tr>
<tr>
<td valign='top'>No of Days : </td>
<td valign='top'>".$r["day"]." Days</td>
</tr>
<tr>
<td valign='top'>Reason : </td>
<td valign='top'>".$r["reason"]."</td>
</tr>
</table>"; ?>
</div>
<?php print"</td>
<td>".$r["start"]."</a></td>
<td>".$r["end"]."</td>";
if($r["status"] == 2){
print "
<td><a href='?page=printform&id=".$r["id"]."' target='_blank'><img src='images/print.png' border'0' title='Print Form'</a> </td>
<td align='center'><img border='0' src='images/approve.png' title='Approved'></a></td>
<td align='center'><a href='?page=result&pid=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/f2.png' title='Move to History Application Leave'></a></td>";
}
if($r["status"] == 1){
print "<td></td><td align='center'><img border='0' src='images/check.png' title='Check'></a></td>
<td align='center'><a href='?page=result&id=".$r["id"]."' onClick='return confirm_act();'><img src='images/delete24.png' width='20' height='20' border='0' title='Cencle'/></a></td>";
}
if($r["status"] == 0){
print "<td></td><td align='center'><img border='0' src='images/pending1.png' title='Pending'></a></td>
<td align='center'><a href='?page=result&id=".$r["id"]."' onClick='return confirm_act();'><img src='images/delete24.png' width='20' height='20' border='0' title='Cencle'/></a></td>";
}
print"
</tr>";
//----
}
}
//print the rest of the table structure and form
print "</table></form>";
?>
[/code]
result nie bergntung pd officer yg check n luluskn
nie pulak senarai nama n cuti staff dalam admin
[code]
<style type="text/css">
<!--
@mediaprint{
.hideforprint {
display:none;
}
}
-->
</style>
<div id='subtitle'><img src='images/knob.gif' width='4' height='4' hspace='0' vspace='0' align='left'>Staff Leave Application <img src="images/star.png" border="0">
</div><br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="19" colspan="6"><div align="right"><img src="images/comment.png" width="16" height="16"><a href="?page=sum">Staff Leave List</a></div></td>
</tr>
<br>
<script type="text/javascript" src="js/highslide/highslide-with-html.js"></script>
<link rel="stylesheet" type="text/css" href="js/highslide/highslide.css" />
<script type="text/javascript">
hs.graphicsDir = 'js/highslide/graphics/';
hs.outlineType = 'rounded-white';
hs.wrapperClassName = 'draggable-header';
</script>
<?php
$date = date('d-m-Y');
$q1 = mysql_query("SELECT * from staff");
while ($r1 = mysql_fetch_array($q1)){
if ($r1["staff_no"] == $ses_name)
{
$last = $r1["last"];
$position = $r1["position"];
}
}
//status application
if(isset($_GET["pid"])){
mysql_query("UPDATE application SET
status=1,
date_check='".$date."',
cop_am='".$last."'
WHERE id=".$_GET["pid"]);
}
if(isset($_GET["aid"])){
mysql_query("UPDATE application SET
status=2,
date_apprve='".$date."',
cop_sm='".$last."'
WHERE id=".$_GET["aid"]);
}
if(isset($_GET["cid"])){
mysql_query("UPDATE application SET
status=1,
date_apprve='".$date."',
cop_sm='".$last."'
WHERE id=".$_GET["cid"]);
}
if(isset($_GET["did"])){
mysql_query("UPDATE application SET status=0
WHERE id=".$_GET["did"]);
}
print "
<table width='100%' border='0' cellspacing='0' cellpadding='3'>
<tr>
<td width='21%' background='images/button.gif'><strong>Staff Id</strong></td>
<td width='21%' background='images/button.gif'><strong>Choice</strong></td>
<td width='28%' background='images/button.gif'><strong>Start Date</strong></td>
<td width='36%' background='images/button.gif'><strong>End Date </strong></td>
<td width='5%' background='images/button.gif'><div align='center'><strong>Status</strong></div></td>";
if($ses_cat != 3){ print"
<td width='5%' background='images/button.gif'><div align='center'><strong>Reject</strong></div></td>";
} print"
</tr>";
$q = mysql_query("SELECT * FROM application");
if(!$q || mysql_num_rows($q) < 1){
print "<tr><td colspan='6' align='center' bgcolor='#FF6600'><h3><strong>No Data Found</strong></h3></td></tr>";
}
else{
$count=1;
while($r = mysql_fetch_array($q)){
if($count == 1){
$color="#e3e3e3";
$count++;
}
else{
$color="#f1f1f1";
$count = 1;
}
print "<tr bgcolor='".$color."'>
<td><a href='?page=job_list&act=result&id=".$r["bid"]."'onclick='return hs.htmlExpand(this)'>".$r["staff_no"]."</a>"; ?>
<div class="highslide-maincontent">
<?php print"<table width='100%' cellspacing='0' cellpadding='3'>
<tr>
<td valign='top'>Staff Id : </td>
<td valign='top'>".$r["staff_no"]."</td>
</tr>
<tr>
<td valign='top'>Name : </td>
<td valign='top'>".$r["name"]."</td>
</tr>
<tr>
<td valign='top'>Department : </td>
<td valign='top'>".$r["department"]."</td>
</tr>
<tr>
<td valign='top'>Position : </td>
<td valign='top'>".$r["position"]."</td>
</tr>
<tr>
<td width='32%' valign='top'>Title : </td>
<td width='41%' valign='top'>".$r["choice"]."</td>
</tr>
<tr>
<td valign='top'>Date of leaving : </td>
<td valign='top'>Start <b>".$r["start"]." </b> Until <b>".$r["end"]."</b></td>
</tr>
<tr>
<td valign='top'>No of Days : </td>
<td valign='top'>".$r["day"]." Days</td>
</tr>
<tr>
<td valign='top'>Reason : </td>
<td valign='top'>".$r["reason"]."</td>
</tr>
</table>"; ?>
</div>
<?php print"</td>
<td>".$r["choice"]."</a></td>
<td>".$r["start"]."</td>
<td>".$r["end"]."</td>";
if($r["status"] == 2){
} print"</td>";
if($ses_cat == 1 && $position == "Assistant Manager"){
//status part
if($r["status"] == 1){
print"<td></td><td align='center'><a href='?page=staffapp&did=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/check.png' title='Check'></a></td>";
}
if($r["status"] == 0){
print "<td></td><td align='center'><a href='?page=staffapp&pid=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/pending1.png' title='Pending'></a></td>";
}//end status
if($r["status"] == 2){
print "<td align='center'><img border='0' src='images/approve.png' title='Approve'></a></td>";
}//end status
print"<td align='center'><a href='?page=result&id=".$r["id"]."' onClick='return confirm_act();'><img src='images/delete24.png' width='20' height='20' border='0'/></a></td>";
}//end if
if($ses_cat == 1 && $position == "Senior Manager"){
//status part
if($r["status"] == 0){
print "<td></td><td align='center'><img border='0' src='images/pending1.png' title='Pending'></a></td>";
}
if($r["status"] == 1){
print"<td></td><td align='center'><a href='?page=staffapp&aid=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/check.png' title='Check'></a></td>";
}
if($r["status"] == 2){
print "<td align='center'><a href='?page=staffapp&cid=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/approve.png' title='Approve'></a></td>";
}
print"<td align='center'><a href='?page=staffapp&id=".$r["id"]."' onClick='return confirm_act();'><img src='images/delete24.png' width='20' height='20' border='0'/></a></td>";
}//end if
if($ses_cat == 3){
//status part
if($r["status"] == 0){
print "<td></td><td align='center'><img border='0' src='images/pending1.png' title='Pending'></a></td>";
}
if($r["status"] == 1){
print"<td></td><td align='center'><a href='?page=staffapp&aid=".$r["id"]."' onClick='return confirm_act();'><img border='0' src='images/check.png' title='Check'></a></td>";
}
if($r["status"] == 2){
print "<td align='center'><img border='0' src='images/approve.png' title='Approve'></a></td>";
}
//print"<td align='center'><a href='?page=staffapp&id=".$r["id"]."' onClick='return confirm_act();'><img src='images/delete24.png' width='20' height='20' border='0'/></a></td>";
}//end if
print"</tr>";
}
}
print "</table></form>";
?>
[/code]
coding cuma tnjuk semua result psal staf n cuti die....yang skrg sy nk buat untuk jumlahkn cuti yang diambil oleh setiap staf..kira cm dalam table yg post 2..harap nie dpt membantu -
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\xampp\staff2\admin\sum.php on line 4
ade error la awk
[URL=http://img11.imageshack.us/i/71268261.jpg/][IMG]http://img11.imageshack.us/img11/9077/71268261.jpg[/IMG][/URL]
Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL]
sy nk wat mcm kat atas nie -
[quote name='dans kam' date='27 April 2010 - 02:54 AM' timestamp='1272308071' post='1027604']
Salam....
Tah mcmane aku rasa kurang faham lak ko nak buat mcmane sbnrnye..
Kalo tgk kat Table ko tu, ko dah listkan mcm tu, so, masalah 1st dah setel.
Sekarang ni masalah nak setelkan jumlah cuti pulak kan?
rasanye kalo ikut contoh yang deejagothic bg tu dah boleh setel dah..
[code]select sum(day) from application where staff_no = '123456'; [/code]
Cumanye aku rasa baik ko buat table lain sebagai summary jumlah cuti staff daripada ko sekalikan kat table tu jugak. Nampak mcm redundant jumlah cuti tu nanti.
Nak coding pun senang..
[i]harap membantu....[/i]
[/quote]
tima ksh ye sume..sy rasa dah silap sbenarnye..sy nk generate report untuk keseluruhan cuti untuk semua staf
kira 1staf amik cuti yg berlainan dan dijumlahkan.itu yg sebenarnye sy nak buat..maaf ye ats kesilapan nie..harap sume dapat membantu...dan kams if ade coding,..hulurkan la ckit.. -
[quote name='dans kam' date='24 April 2010 - 05:51 PM' timestamp='1272102673' post='1027221']
wsalam....
Kalo guna MySQL bleh guna fungsi [b]sum()[/b]
Atau ko boleh guna [b]mysql_num_rows()[/b]
[color="#FF0000"]*[/color] Bergantung kepada struktur database/table ko mcmane..
Semoga membantu utk dapat idea..
[/quote]
tima ksh la awk sudi reply....sy sudah buat coding tp cuma paparkan staff id,department,jnis cuti dan bape hari yg di amek..cume xdpt buat la total cuti.kira kene guna sum..sy cube try coding ke internet tp xjdi..ade error n tak respond pn,,,blh awk or ssape dpt tlng sy...
[code]
<?php
$q = mysql_query("SELECT * FROM application ");
if(!$q || mysql_num_rows($q) < 1){
print "<tr><td colspan='6' align='center' bgcolor='#FF6600'><h3><strong>No Data Found</strong></h3></td></tr>";
}
else{
$count=1;
while($r = mysql_fetch_array($q)){
if($count == 1){
$color="#e3e3e3";
$count++;
}
else{
$color="#f1f1f1";
$count = 1;
}
print "<tr bgcolor='".$color."'>
<td><font color='#CC6666'><b>".$r["staff_no"]."</b…
<td align='center'>".$r["department"]."</td>
<td>".$r["choice"]."</td><td align='center'>".$r["day"]."</td>
</tr>
";
//}
}
}
print"</table>";
?>
[/code]
result dri coding sy buat 2 mcm nie..cuma kt total leave je tak dapat buat
[URL=http://img208.imageshack.us/i/58461973.png/][IMG]http://img208.imageshack.us/img208/628/58461973.png[/IMG][/URL]
share all file 2 silap taip..hehe
Uploaded with [URL=http://imageshack.us]ImageShack.us[/URL] -
salam..sy nk mntk tlg sume org...
soalannye bgaimana nak kira semua cuti yang dipohon oleh staf
dalam table sy ade staff no,department dan jenis cuti yang dipohon
cthnye staff id 123456 derptmnet personal mohon 3jenis cuti iaitu mc(2hari),annualy(3hari..jumlahnye 5hari kn
so bgaimana nk buat jumlah cuti nie...
kira result die macm nie
staff id department leave
123456 personal 5
harap ssape dtp tlong sy la ....tq -
salam...maaf la menganggu sume yang ade kat sini. sy jumpa coding nie kat http://hubpages.com/hub/Simple-Event-calendar-PHP--MySQL .sya ade ubah coding dan ia jadi tapi bila clik ke bulan depan..ia akn pegi kt home page saya...saya rasa masalah die kat
[code]
document.location.href = '<?php echo $_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year
[/code]
sya tak tahu ubahnya bila kat cni....dah blur sgt...cari coding email tp dapt coding calendar pulak....ingatkn boleh jadi coding calendar tapi bertmbah blur adalah...harap sgt la ade yang sudi tolong sy.....
nie coding die [code]
<script>
function goLastMonth(month, year){
// If the month is January, decrement the year
if(month == 1){
--year;
month = 13;
}
document.location.href = '<?php echo $_SERVER['PHP_SELF'];?>?month='+(month-1)+'&year='+year;
}
//next function
function goNextMonth(month, year){
// If the month is December, increment the year
if(month == 12){
++year;
month = 0;
}
document.location.href = '<?php echo $_SERVER['PHP_SELF'];?>?month='+(month+1)+'&year='+year;
}
function remChars(txtControl, txtCount, intMaxLength)
{
if(txtControl.value.length > intMaxLength)
txtControl.value = txtControl.value.substring(0, (intMaxLength-1));
else
txtCount.value = intMaxLength - txtControl.value.length;
}
function checkFilled() {
var filled = 0
var x = document.form1.calName.value;
//x = x.replace(/^\s+/,""); // strip leading spaces
if (x.length > 0) {filled ++}
var y = document.form1.calDesc.value;
//y = y.replace(/^s+/,""); // strip leading spaces
if (y.length > 0) {filled ++}
if (filled == 2) {
document.getElementById("Submit").disabled = false;
}
else {document.getElementById("Submit").disabled = true} // in case a field is filled then erased
}
</script>
<body>
<div id="legend">
<img src="images/sq.jpg" /> Scheduled Events<br/><img src="images/calBg.jpg" height="10"/> Todays Date</div>
<?php
//$todaysDate = date("n/j/Y");
//echo $todaysDate;
// Get values from query string
$day = (isset($_GET["day"])) ? $_GET['day'] : "";
$month = (isset($_GET["month"])) ? $_GET['month'] : "";
$year = (isset($_GET["year"])) ? $_GET['year'] : "";
//comparaters for today's date
//$todaysDate = date("n/j/Y");
//$sel = (isset($_GET["sel"])) ? $_GET['sel'] : "";
//$what = (isset($_GET["what"])) ? $_GET['what'] : "";
//$day = (!isset($day)) ? $day = date("j") : $day = "";
if(empty($day)){ $day = date("j"); }
if(empty($month)){ $month = date("n"); }
if(empty($year)){ $year = date("Y"); }
//set up vars for calendar etc
$currentTimeStamp = strtotime("$year-$month-$day");
$monthName = date("F", $currentTimeStamp);
$numDays = date("t", $currentTimeStamp);
$counter = 0;
//$numEventsThisMonth = 0;
//$hasEvent = false;
//$todaysEvents = "";
//run a selec statement to hi-light the days
function hiLightEvt($eMonth,$eDay,$eYear){
//$tDayName = date("l");
$todaysDate = date("n/j/Y");
$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;
if($todaysDate == $dateToCompare){
//$aClass = '<span>' . $tDayName . '</span>';
$aClass='class="today"';
}else{
//$dateToCompare = $eMonth . '/' . $eDay . '/' . $eYear;
//echo $todaysDate;
//return;
$sql="select count(CalDate) as eCount from CalTbi where CalDate = '" . $eMonth . '/' . $eDay . '/' . $eYear . "'";
//echo $sql;
//return;
$result = mysql_query($sql);
while($row= mysql_fetch_array($result)){
if($row['eCount'] >=1){
$aClass = 'class="event"';
}elseif($row['eCount'] ==0){
$aClass ='class="normal"';
}
}
}
return $aClass;
}
?>
<table width="350" cellpadding="0" cellspacing="0">
<tr>
<td width="50" colspan="1">
<input type="button" value=" < " onClick="goLastMonth(<?php echo $month . ", " . $year; ?>);">
</td>
<td width="250" colspan="5">
<span class="title"><?php echo $monthName . " " . $year; ?></span><br>
</td>
<td width="50" colspan="1" align="right">
<input type="button" value=" > " onClick="goNextMonth(<?php echo $month . ", " . $year; ?>);">
</td>
</tr>
<tr>
<th>S</td>
<th>M</td>
<th>T</td>
<th>W</td>
<th>T</td>
<th>F</td>
<th>S</td>
</tr>
<tr>
<?php
for($i = 1; $i < $numDays+1; $i++, $counter++){
$dateToCompare = $month . '/' . $i . '/' . $year;
$timeStamp = strtotime("$year-$month-$i");
//echo $timeStamp . '<br/>';
if($i == 1){
// Workout when the first day of the month is
$firstDay = date("w", $timeStamp);
for($j = 0; $j < $firstDay; $j++, $counter++){
echo "<td> </td>";
}
}
if($counter % 7 == 0){
?>
</tr><tr>
<?php
}
?>
<!--right here--><td width="50" <?=hiLightEvt($month,$i,$year);?>><a href="<?php echo $_SERVER['PHP_SELF'] . '?month='. $month . '&day=' . $i . '&year=' . $year;?>&v=1"><?php echo $i;?></a></td>
<?php
}
?>
</table>
<?php
if(isset($_GET['v'])){
if(isset($_POST['Submit'])){
$sql="insert into CalTbi(CalName,CalDesc,CalDate,CalStamp) values('" . $_POST['CalName'] ."','" . $_POST['CalDesc'] . "','" . $_POST['CalDate'] . "',now())";
mysql_query($sql);
}
$sql="select CalName,CalDesc, DATE_FORMAT(CalStamp, '%a %b %e %Y') as CalStamp from CalTbi where calDate = '" . $month . '/' . $day . '/' . $year . "'";
//echo $sql;
//return;
$result = mysql_query($sql);
$numRows = mysql_num_rows($result);
?>
<a href="<?php echo $_SERVER['PHP_SELF'];?>?month=<?php echo $_GET['month'] . '&day=' . $_GET['day'] . '&year=' . $_GET['year'];?>&v=1&f=true">New Event</a><br/>
<?php
if(isset($_GET['f'])){
include 'calForm.php';
}
if($numRows == 0 ){
echo '<h3>No Events</h3>';
}else{
//echo '<ul>';
echo '<h3>Events Listed</h3>';
while($row = mysql_fetch_array($result)){
?>
<div class="output">
<h5><?php echo $row['CalName'];?></h5>
<?php echo $row['CalDesc'];?><br/>
Listed On: <?php echo $row['CalStamp'];?>
</div>
<?php
}
}
}
?>
</body>
</body>
</html>
[/code] -
[quote name='OngBok' date='01 April 2010 - 03:07 PM' timestamp='1270105664' post='1024087']
awak nak jadikan web server as mail server jugak ker?
benda nie memang complicated.
banyak benda ke setting.
awak dah sedia ker?
[/quote]
susah ke nak buat????.....saya rasa macam tak bersedia..zero la dalam email ini.... -
salam...nk tnye n mntk guideline ckit...bgmana nk buat email guna php dan run dalam xampp server...harap sume org dapat bantu sy dengan mmberi tunjur ajar dan penerangan kerana sy dah blur dng coding email kt internet nii -
salam sume....harap sume sht2 ye..sy nk tnye bgaimana nk buat 2search yg berlainan dalam 1page ..contoh 1st search by staff name 2nd search by staff id..harap sume blh bntu sy....tima ksh -
[quote name='slier' date='09 March 2010 - 06:20 PM' timestamp='1268130043' post='1020771']
boleh je
gunan php image library manipulation if u develope it using php le
[/quote]
bgaimana itu???...cop itu akn date n waktu am/pm berubah akn??...boleh ke??? -
salam....nk tanya pendapat sume warga tanya putera dot com nie....dalam pic ini ada cop,..cop dalam borang ini dicop secara manual la...so soalannye boleh tak cop ini dicop secara automatik...sy buat borang cuti secara online, so nak cop ini tapi mengikut tarikh n masa yang berlainan..tq
p/s:harap soalan xpelik la...sy pikir mcm tak leh buat cop itu je...tapi permintaan penyelia sy yg nak cop 2..harap ade yang beri pendapat....
[URL=http://img718.imageshack.us/i/13942077.jpg/][IMG]http://img718.imageshack.us/img718/8296/13942077.th.jpg[/IMG][/URL] -
tima kasih ye toy..sy dah dpt wat...devguy..nk format php....toy dah kasi dah... -
salam..nak tnye bgmana nk fix num...contohnye 10/3=3.3333...so bgmana nk jadikan 2digit iaitu 3.33shja..harap kak n abg2 dpt tlg
Bagaimana Nak Buat Coding Soalan C++ Nie
in C, C++
Posted · Report reply