/* tolong guna perkataan yang lengkap. Kurangkan bahasa SMS. Thanks */
/* ongbok */
OngBok wrote:kalau nak buat dalam dreamweaver, kena install dulu dreamweaver.
awak nak guna dreaweaver ver berapa? Cerita sikit awak dah mula dah ker....,
sampai kat mana dah sekrang nie... kalau belum buat apa2 lagi,
1. install Xampp WebServer
Download Panduan Install Xampp & Dreamweaver
2. install Dreamweaver (any version)
satu lagi kalau boleh jangan guna perkataan ringkas. susah nak baca.
takut nanti orang lari. tengok pakcik taip perkataan penuh. :afro
ok.
syira86 wrote:
tq la awk, sy dah install xampp dan dreamweaver, sekarang tengah buat register staff, masalah pada started work , sy nk buat tarikh dalam code php , dah cri tp still xdapt, yang dapat pn calendar dan time je
year of started work:
day
<label>
<select name="select" id="select">
</select>
</label>
month
<label>
<select name="select2" id="select2">
</select>
</label>
year
<label>
<select name="select3" id="select3">
</select>
</label>
</body>
<?php
//add process
if(isset($_POST["submit"])){
mysql_query("INSERT INTO staff
(idstaf,username,password,name,age,position,dept,gender,add,telo,telhp,fax_num,email,pic)
VALUES (
'".$_POST["idstaf"]."',
'".$_POST["username"]."',
'".$_POST["password"]."',
'".$_POST["name"]."',
'".$_POST["age"]."',
'".$_POST["position"]."',
'".$_POST["dept"]."',
'".$_POST["gender"]."',
'".$_POST["telo"]."',
'".$_POST["telhp"]."',
'".$_POST["fax_num"]."',
'".$_POST["email"]."',
'".$_POST["pic"]."'
)");
//redirect page to cat list
print "<meta http-equiv='refresh' content='1;URL=?page=home'>";
print "<tr>
<td align='center' bgcolor='#99CC33'><strong><h1>Add Data Successfull</h1></strong></td>
</tr><br />";
}
?>
<tr bgcolor="#FFCCCC">
<form action='' method='post' name='borang'>
<table width="100%" border="0" cellspacing="2">
<tr bgcolor="#FFCCCC">
<td colspan="2" align="center"><strong>User Information</strong></td>
</tr>
<tr>
<td width="22%" align="left"><div align="center">Staff Id</div></td>
<td width="78%"><label>
<input type="text" name="text" id="idstaf">
</label></td>
</tr>
<tr>
<td align="left"><div align="center">Username:</div></td>
<td><span id="sprytextfield1">
<input name='username' type='text' size='40' id="username" />
</span></td>
</tr>
<tr>
<td align="left"><div align="center">Password</div></td>
<td><input name='password' type='password' id="password" size='40' /></td>
</tr>
<tr>
<td align="left"><div align="center">Name:</div></td>
<td><input name='name' type='text' size='40' id="name" /></td>
</tr>
<tr>
<td align="left"><div align="center">Age:</div></td>
<td><label>
<input type="age" name="text" id="age">
</label></td>
</tr>
<tr>
<td align="left"><div align="center">Position:</div></td>
<td><label>
<input type="position" name="text" id="position">
</label></td>
</tr>
<tr>
<td align="left"><div align="center">Department:</div></td>
<td><label>
<input type="dept" name="text" id="dept">
</label></td>
</tr>
<tr align="center">
<td>Gender</td>
<td align="left"><label>
<input name="gender" type="radio" id="gender" value="radio">
Male
<input type="radio" name="gender" id="gender" value="radio2">
Female</label></td>
</tr>
<tr align="center">
<td>Address</td>
<td align="left"><textarea name="add" cols="35" id="add"></textarea></td>
</tr>
<tr align="center">
<td>Tel Office:</td>
<td align="left"><input name='tel' type='text' size='40' id="telo" /></td>
</tr>
<tr align="center">
<td>Tel hp:</td>
<td align="left"><input name='telhp' type'text' size'40' id "telhp"/></td>
</tr>
<tr align="center">
<td>Fax:</td>
<td align="left"><input name='com_fax' type='text' size='40' id="com_fax" />
<input name="pic" type="hidden" id="pic" value="nophoto.gif" size="60" /></td>
</tr>
<tr align="center">
<td>Email:</td>
<td align="left"><input name='email' type='text' id="email" size='40' /></td>
</tr>
<tr align="center">
<td> </td>
<td align="left"><input type="reset" name="Reset" id="button3" value="Reset" />
<input name='submit' type='submit' id="submit" value='Register' /></td>
</tr>
</table>
</form>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td> </td>
</tr>
</table>
<?
include config.php
?>
<?php if($ses_cat != 0){
$q1 = mysql_query("SELECT * from staff");
while ($r1 = mysql_fetch_array($q1)){
if ($r1["username"] == $ses_name)
{
$name = $r1["name"];
}
}
?>
<img src="images/ciboy10.png" width="50" height="50"> <h1 class="style3">Welcome back <?php echo $name;?></h1>
<?php } ?>
<?php if($ses_cat == 0){?>
<h1 class="style3">Welcome to our site</h1>
<?php } ?>
<?php
if(isset($_POST["Submit"])){
$matrix = $_POST["username"];
$pass = $_POST["password"];
$query = "SELECT * FROM staff WHERE username='".$matrix."' AND password='".$password."'";
$result = mysql_query($query);
if (!$result || mysql_num_rows($result) < 1) {
print "<meta http-equiv='refresh' content='1;URL=?'>";
print" Please try again";
}
else{
while($row=mysql_fetch_array($result)){
$user_name = $row["username"];
}
$query = "UPDATE sessionstaff SET ses_name='".$user_name."', ses_cat='1' WHERE ses_id='".$sid."'";
mysql_query($query);
print "<meta http-equiv='refresh' content='3;URL=?'>";print "<align=right><font color='green'> You now login</font>";
}
}
//jika member
if($ses_cat == 0){
print" <td><table width = '50px' height='29px' border = '10px'>
<form id='form1' name='form1' method='post' action=''>
<tr> </tr>
<tr>
<td>User ID</span>
</td>
<td>
<input type='text' name='username' id='username' />
</td>
</tr>
<tr>
<td>Password
</td>
<td>
<input type='password' name='password' id='password' />
</td>
</tr>
<tr>
<td><li><a href=?page=reg class='style2'>Sign up</a></li></td>
<td><input type='submit' name='Submit' value='Login' /></td>
</tr>
<tr>
<td colspan='2'>";
print"</td>
</tr>
</form>
</table>";
}
?>
xpham skit, yg date started tu nk masukkan kedalam reg.php gak ek?syira86 wrote:betol juga kn....lagi senang buat mcm 2...cume masalah kat register ....coding ini ambil kat budak sem lepas punya...macam sama je tp ade error pulak....xfaham sangat coding die
<select name="year">
<?php
echo "<option selected value=''>Year</option>";
for ($i=date("Y")-30; $i<=date("Y"); $i++) {
echo "<option value='$i'>$i</option>\n";
}
?>
</select>
<input type="text" name="text" id="idstaf">
$_POST["idstaf"]
<input type="text" name="idstaf" id="idstaf">
<?php
//connect to database
mysql_connect("localhost","root","")
or die("not Connect");
//select database
mysql_select_db("ccss")
or die("cannot reached database");
?>
<?php
//add process
if(isset($_POST["submit"])){
mysql_query("INSERT INTO staff
(id_staff,username,password,name,age,gender,birth,position,dept,add,tel_of,tel_hp,email,fax_num,pic)
VALUES (
'".$_POST["id_staff"]."',
'".$_POST["username"]."',
'".$_POST["password"]."',
'".$_POST["name"]."',
'".$_POST["password"]."',
'".$_POST["age"]."',
'".$_POST["gender"]."',
'".$_POST["birth"]."',
'".$_POST["position"]."',
'".$_POST["dept"]."',
'".$_POST["add"]."',
'".$_POST["tel_of"]."',
'".$_POST["tel_hp"]."',
'".$_POST["email"]."',
'".$_POST["fax_num"]."',
'".$_POST["pic"]."',
)");
//redirect page to cat list
print "<meta http-equiv='refresh' content='1;URL=?page=home'>";
print "<tr>
<td align='center' bgcolor='#99CC33'><strong><h1>Add Data Successfull</h1></strong></td>
</tr><br />";
}
?>
<form name='borang' method='post' action=''>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr><tr bgcolor="#FFCCCC">
<td colspan="2" align="center"><strong>Staff Information</strong></td>
</tr>
<tr>
<td width="123">Staff Id:</td>
<td width="357"><input type="text" name="id_staff" id="id_staff"></td>
</tr>
<tr>
<td>Username:</td>
<td>
<input name="username" type="text" id="username" size="40">
</td>
</tr>
<tr>
<td>Password:</td>
<td>
<input type="password" name="password" id="password">
</td>
</tr>
<tr>
<td>Name:</td>
<td>
<input name="name" type="text" id="name" size="40">
</td>
</tr>
<tr>
<td>Age:</td>
<td>
<input name="age" type="text" id="age" size="8">
</td>
</tr>
<tr>
<td>Gender:</td>
<td>
<input type="radio" name="gender" id="gender" value="radio">
Male
<input type="radio" name="gender" id="gender" value="radio2">
Female</td>
</tr>
<tr>
<td>Birth of Date:</td>
<td>
<input type="text" name="birth" id="birth">
(dd/mm/yyyy)</td>
</tr>
<tr>
<td>Position:</td>
<td>
<input name="position" type="text" id="position" size="40">
</td>
</tr>
<tr>
<td>Department:</td>
<td>
<input name="dept" type="text" id="dept" size="40">
</td>
</tr>
<tr>
<td height="69">Address</td>
<td>
<textarea name="add" id="add" cols="45" rows="5"></textarea>
</td>
</tr>
<tr>
<td>Tel Office:</td>
<td>
<input type="text" name="tel_of" id="tel_of">
</td>
</tr>
<tr>
<td>Tel Hp:</td>
<td>
<input type="text" name="tel_hp" id="tel_hp">
</td>
</tr>
<tr>
<td>Email:</td>
<td>
<input name="email" type="text" id="email" size="40">
</td>
</tr>
<tr>
<td>Fax_num:</td>
<td>
<input type="text" name="fax_num" id="fax_num">
</td>
</tr>
<tr>
<td>Pic:</td>
<td>
<input type="file" name="pic" id="pic">
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="reset" name="Reset" id="button" value="Reset">
<input type="submit" name="button2" id="button2" value="Submit">
</td>
</tr>
</table>
</form>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td> </td>
</tr>
</table>
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 28, 2009 at 01:16 AM
-- Server version: 5.1.37
-- PHP Version: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `e-staff`
--
-- --------------------------------------------------------
--
-- Table structure for table `staff`
--
CREATE TABLE IF NOT EXISTS `staff` (
`id_staff` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(100) NOT NULL,
`name` varchar(200) NOT NULL,
`age` varchar(20) NOT NULL,
`gender` varchar(100) NOT NULL,
`birth` varchar(200) NOT NULL,
`position` varchar(225) NOT NULL,
`dept` varchar(225) NOT NULL,
`add` varchar(255) NOT NULL,
`tel_of` varchar(24) NOT NULL,
`tel_hp` varchar(100) NOT NULL,
`email` varchar(255) NOT NULL,
`fax_num` varchar(30) NOT NULL,
`pic` varchar(255) NOT NULL,
PRIMARY KEY (`id_staff`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `staff`
--
<?php
//connect to database
mysql_connect("localhost","root","")
or die("not Connect");
//select database
mysql_select_db("ccss")
or die("cannot reached database");
?>
<?php
//add process
if(isset($_POST["submit"])){
mysql_query("INSERT INTO staff
(id_staff,username,password,name,age,gender,birth,position,dept,add,tel_of,tel_hp,email,fax_num,pic)
VALUES (
'".$_POST["id_staff"]."',
'".$_POST["username"]."',
'".$_POST["password"]."',
'".$_POST["name"]."',
'".$_POST["password"]."',
'".$_POST["age"]."',
'".$_POST["gender"]."',
'".$_POST["birth"]."',
'".$_POST["position"]."',
'".$_POST["dept"]."',
'".$_POST["add"]."',
'".$_POST["tel_of"]."',
'".$_POST["tel_hp"]."',
'".$_POST["email"]."',
'".$_POST["fax_num"]."',
'".$_POST["pic"]."',
)");
//redirect page to cat list
print "<meta http-equiv='refresh' content='1;URL=?page=home'>";
print "<tr>
<td align='center' bgcolor='#99CC33'><strong><h1>Add Data Successfull</h1></strong></td>
</tr><br />";
}
?>
<form name='borang' method='post' action=''>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr><tr bgcolor="#FFCCCC">
<td colspan="2" align="center"><strong>Staff Information</strong></td>
</tr>
<tr>
<td width="123">Staff Id:</td>
<td width="357"><input type="text" name="id_staff" id="id_staff"></td>
</tr>
<tr>
<td>Username:</td>
<td>
<input name="username" type="text" id="username" size="40">
</td>
</tr>
<tr>
<td>Password:</td>
<td>
<input type="password" name="password" id="password">
</td>
</tr>
<tr>
<td>Name:</td>
<td>
<input name="name" type="text" id="name" size="40">
</td>
</tr>
<tr>
<td>Age:</td>
<td>
<input name="age" type="text" id="age" size="8">
</td>
</tr>
<tr>
<td>Gender:</td>
<td>
<input type="radio" name="gender" id="gender" value="radio">
Male
<input type="radio" name="gender" id="gender" value="radio2">
Female</td>
</tr>
<tr>
<td>Birth of Date:</td>
<td>
<input type="text" name="birth" id="birth">
(dd/mm/yyyy)</td>
</tr>
<tr>
<td>Position:</td>
<td>
<input name="position" type="text" id="position" size="40">
</td>
</tr>
<tr>
<td>Department:</td>
<td>
<input name="dept" type="text" id="dept" size="40">
</td>
</tr>
<tr>
<td height="69">Address</td>
<td>
<textarea name="add" id="add" cols="45" rows="5"></textarea>
</td>
</tr>
<tr>
<td>Tel Office:</td>
<td>
<input type="text" name="tel_of" id="tel_of">
</td>
</tr>
<tr>
<td>Tel Hp:</td>
<td>
<input type="text" name="tel_hp" id="tel_hp">
</td>
</tr>
<tr>
<td>Email:</td>
<td>
<input name="email" type="text" id="email" size="40">
</td>
</tr>
<tr>
<td>Fax_num:</td>
<td>
<input type="text" name="fax_num" id="fax_num">
</td>
</tr>
<tr>
<td>Pic:</td>
<td>
<input type="file" name="pic" id="pic">
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="reset" name="Reset" id="button" value="Reset">
<input type="submit" name="button2" id="button2" value="Submit">
</td>
</tr>
</table>
</form>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td> </td>
</tr>
</table>
<?php
//a little tweak
$conn = "localhost";
$user = " root";
$pass = "";
//connect to database
mysql_connect($conn,$user,$pass)
or die("not Connect");
//select database
mysql_select_db("ccss")
or die("cannot reached database");
?>
<?php
include ("db.php"); // include() db.php
//add process
if(isset($_POST["submit"])){
mysql_query("INSERT INTO staff
(id_staff,username,password,name,age,gender,birth,position,dept,add,tel_of,tel_hp,email,fax_num,pic)
VALUES (
'".$_POST["id_staff"]."',
'".$_POST["username"]."',
'".$_POST["password"]."',
'".$_POST["name"]."',
'".$_POST["password"]."',
'".$_POST["age"]."',
'".$_POST["gender"]."',
'".$_POST["birth"]."',
'".$_POST["position"]."',
'".$_POST["dept"]."',
'".$_POST["add"]."',
'".$_POST["tel_of"]."',
'".$_POST["tel_hp"]."',
'".$_POST["email"]."',
'".$_POST["fax_num"]."',
'".$_POST["pic"]."',
)");
//redirect page to cat list
print "<meta http-equiv='refresh' content='1;URL=?page=home'>";
print "<tr>
<td align='center' bgcolor='#99CC33'><strong><h1>Add Data Successfull</h1></strong></td>
</tr><br />";
}
?>
<form name='borang' method='post' action=''>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr><tr bgcolor="#FFCCCC">
<td colspan="2" align="center"><strong>Staff Information</strong></td>
</tr>
<tr>
<td width="123">Staff Id:</td>
<td width="357"><input type="text" name="id_staff" id="id_staff"></td>
</tr>
<tr>
<td>Username:</td>
<td>
<input name="username" type="text" id="username" size="40">
</td>
</tr>
<tr>
<td>Password:</td>
<td>
<input type="password" name="password" id="password">
</td>
</tr>
<tr>
<td>Name:</td>
<td>
<input name="name" type="text" id="name" size="40">
</td>
</tr>
<tr>
<td>Age:</td>
<td>
<input name="age" type="text" id="age" size="8">
</td>
</tr>
<tr>
<td>Gender:</td>
<td>
<input type="radio" name="gender" id="gender" value="radio">
Male
<input type="radio" name="gender" id="gender" value="radio2">
Female</td>
</tr>
<tr>
<td>Birth of Date:</td>
<td>
<input type="text" name="birth" id="birth">
(dd/mm/yyyy)</td>
</tr>
<tr>
<td>Position:</td>
<td>
<input name="position" type="text" id="position" size="40">
</td>
</tr>
<tr>
<td>Department:</td>
<td>
<input name="dept" type="text" id="dept" size="40">
</td>
</tr>
<tr>
<td height="69">Address</td>
<td>
<textarea name="add" id="add" cols="45" rows="5"></textarea>
</td>
</tr>
<tr>
<td>Tel Office:</td>
<td>
<input type="text" name="tel_of" id="tel_of">
</td>
</tr>
<tr>
<td>Tel Hp:</td>
<td>
<input type="text" name="tel_hp" id="tel_hp">
</td>
</tr>
<tr>
<td>Email:</td>
<td>
<input name="email" type="text" id="email" size="40">
</td>
</tr>
<tr>
<td>Fax_num:</td>
<td>
<input type="text" name="fax_num" id="fax_num">
</td>
</tr>
<tr>
<td>Pic:</td>
<td>
<input type="file" name="pic" id="pic">
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="reset" name="Reset" id="button" value="Reset">
<input type="submit" name="button2" id="button2" value="Submit">
</td>
</tr>
</table>
</form>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr valign="middle">
<td> </td>
</tr>
</table>