Filtering Coding

[echah 0]

Assalamualaikum kekwn sume...
nk tnye r satu benda if nk wat filtering gune selection option kt database n view kt website cam ne erk??
bile select je kt button selection tu die akan view ape yg kite nk...contoh:

LAPTOP
DESKTOP

p/s: bile enter selection utuk LAPTOP kt website akan view only LAPTOP jek...

[darkwinz_volrath 0]

xpaham ... ko nak coding dalam language apa ... database ko pakai ape?

[echah 0]

xpaham ... ko nak coding dalam language apa ... database ko pakai ape?

dlm PHP coding.... database gune xampp

sebelum ni sy gune button n x gune selection...

ni coding utk button filtering :

<?php
//connect to mysql server
$db=mysql_connect("localhost","root","root08")
or die
("could not connect to database, please check that mysql is running");

//$db=mysql_pconnect();
mysql_select_db("csd");//database name

$action = $_REQUEST['action'];
$cond = $_REQUEST['cond'];

if($action == "change")
{
echo "masuk sini";
$query1 = "UPDATE data SET Complaint_Number='".$Complaint_Number."', Date='".$Date."' where Status='".$Status."'";
mysql_query($query1);

}

if($action == "filter")
{
$query="SELECT * FROM data WHERE Status='".$cond."'";
$result=mysql_query($query);
$num_rows=mysql_num_rows($result);

}

else
{
$query="SELECT * FROM data";
$result=mysql_query($query);
$num_rows=mysql_num_rows($result);
}
?>

<table cellpadding="0" cellspacing="0" width="999" height="405">
<!-- MSTableType="layout" -->
<tr>
<td valign="top" width="227">
<table border="0" width="100%">
<tr>
<td align="center">
<form name="frmnew" method="post" action="page 3.php">
<input name="action" type="hidden" value="filter">
<input name="cond" type="hidden" value="New">
<input name="listNewComplaint" type="submit" id="listNewComplaint" value="List New Complaint" style="width:170px"></form></td>
</tr>
<tr>
<td align="center">

<form name="frmAssigned" method="post" action="page 3.php">
<input name="action" type="hidden" value="filter">
<input name="cond" type="hidden" value="Assigned">
<input name="listAssignedComplaint" type="submit" id="listAssignedComplaint" value="List Assigned Complaint" style="width:170px"></form></td>
</tr>
<tr>
<td align="center">
<form name="frmreassigned" method="post" action="page 3.php">
<input name="action" type="hidden" value="filter">
<input name="cond" type="hidden" value="ReAssigned">
<input name="listReassignedComplaint2" type="submit" id="listReassignedComplaint2" value="List Reassigned Complaint" style="width:170px"></form></td>
</tr>
<tr>
<td align="center">
<form name="frmclosed" method="post" action="page 3.php">
<input name="action" type="hidden" value="filter">
<input name="cond" type="hidden" value="Closed">
<input name="listClosedComplaint" type="submit" id="listClosedComplaint" value="List Closed Complaint" style="width:170px"></form></td>
<tr>
<td align="center">
<form name="formupdate" action="page 3.php" method="post">
<input name="action" type="hidden">
<input type="submit" name="btnSubmit" value="ALL" style="width:170px">
</form></td>
</tr>

<tr>
<td align="center">
<form name="frmclosed" method="post" action="form complaint.php">
<input name="EnterNewComplaint" type="submit" id="listClosedComplaint" value="Enter New Complaint" style="width:170px"></form></td>
</tr>
</table>
</td>
<td valign="top" height="405" width="772">
<table border="0" width="100%">
<tr>
<td><center>
<div align="center"><span class="style8">Customer Complaint Form</span>
<? if ($num_rows>0){ ?></div>
<center>

<table width="99%" border="0">
<tr bgcolor="#666666">
<td width="7%"><div align="center" class="style19 style1 style5 style6">
<div align="center"><span class="style15">
NO</span></div>
</div></td>
<td width="44%"><div align="center" class="style19 style1 style5 style6"><span class="style15">
Complaint Number</span></div></td>
<td width="25%"><div align="center" class="style19 style1 style5 style6"><span class="style15">
Date</span></div></td>
<td width="24%"><div align="center" class="style19 style1 style5 style6"><span class="style15">
Status</span></div></td>
<td width="24%"><div align="center" class="style19 style1 style5 style6"><span class="style15">
Detail</span></div></td>
</tr>
<?
$bgcolor="#999999";
for($i=1;$i<=$num_rows;$i++){
$row=mysql_fetch_array($result); ?>
<tr bgcolor=<?php echo $bgcolor; ?>>
<td bgcolor="#999999"><div align="center"><font face="verdana" color="#FFFFFF" size="2"><span class="style6"><? echo $i?></span></div></td>
<td><div align="center" class="style23"><span class="style9"><font face="verdana" color="#000000 " size="2"><? echo $row["Complaint_Number"]?></font></span></div></td>
<td><div align="center" class="style23"><span class="style9"><font face="verdana" color="#000000 " size="2"><? echo $row["Date"]?></font></span></div></td>
<td><div align="center" class="style23"><span class="style9"><font face="verdana" color="#000000 " size="2"><? echo $row["Status"]?></font></span></div></td>
<center><td><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
<a href="detail2.php?Complaint_Number=<? echo $row["Complaint_Number"]?>" class="style50"?>
<font color="#553F00" face="Verdana" style="font-size: 10pt">Edit</font></a></font></td>
</center>
</tr>
<?
if($bgcolor=="#999999"){
$bgcolor="#999999";
}
else{
$bgcolor="999999";
}

}//end for
} //end if
else{ ?>
There is no record to show.....
<? }//end else?>
</table>
</center></td>
</tr>
</table>
</td>
</tr>
</table>



so sekrng ni sy nk gune format selection xnk gune button...erm...awk fhm x??hihihih...
xfhm awk tnye lg erk...mekaceh awk...

uhuk3...buntu dah pale otak ni....cr coding kt w3school byk lak error...urm...xcukup terer lg r...hahak...

[darkwinz_volrath 0]

hmm... tanak nak guna button ... tapi dalam code diatas ada 5 button ..... cuba terangkan lebih lanjut

[echah 0]

hmm... tanak nak guna button ... tapi dalam code diatas ada 5 button ..... cuba terangkan lebih lanjut

ish...xd r awk... tu sy bg contoh tuk button...

sy nk tau contoh tuk selection lak... adakah ianye lebeh kurang jek codingnye?? (skema lak ayat hahak..)

[darkwinz_volrath 0]

ooo .. jap ek .. cuba pk...

[echah 0]

ooo .. jap ek .. cuba pk...

mekaceh awk...kite same2 fikir erk....

[darkwinz_volrath 0]

ok ... macam ni ... leh tak citer proses nyer .. fungsi nyer/sistem anda secara detail ... selection / filtering tuh berdasarkan apa .... and adakah user tuh nak kena masukkan certain data ker ......

[echah 0]

ok ... macam ni ... leh tak citer proses nyer .. fungsi nyer/sistem anda secara detail ... selection / filtering tuh berdasarkan apa .... and adakah user tuh nak kena masukkan certain data ker ......

fuyo...byk soklan...urm ni yg lemah ni kena xplain...hihih..ok i'll try erk...1st sy kena develope satu system like inventory system...contoh system tu...wat spare part pricing...so sy dah import all the data to insert into the databse using xampp..gune mysql r erk...so skrg ni...sy kena wat satu form untuk update data dr databse tu...die ade 3 columns kt databse :

1) Part Number 2) Description 3)suggested Retail Price....

so skrg bahagian Part Number sy nk wat format selection...n die akan view only dr selection yag kite select tu...mcm filtering r...tu saje wat mase ni....erm...fhm x??lif x fhm tnye lg erk...mekaceh awk...

[DrASAG 0]

dlm PHP coding.... database gune xampp

database guna xampp? uik.... database dia mysql lor......

apa masalahnya ni? apa maksud ko tanak guna button, tapi nk guna selection? maksud ko nak buat satu dropdown list yg ada part number, pastu bila pilih part number dia view semua info based on part number tu ker?

[echah 0]

database guna xampp? uik.... database dia mysql lor......

apa masalahnya ni? apa maksud ko tanak guna button, tapi nk guna selection? maksud ko nak buat satu dropdown list yg ada part number, pastu bila pilih part number dia view semua info based on part number tu ker?

erk...ok2..database gune mysql..hihih..ampun...
ha!!! betul r tu...gune dropdown list...betul2.... tu yg sy nak...xnk gune button...urm...

[DrASAG 0]

hohohoho.. awat yang susah sgt tulih manjang2.. bgtau camtu jer kan senang. hokhokhok... coba paste apa yg hang dah buat.....

[echah 0]

hohohoho.. awat yang susah sgt tulih manjang2.. bgtau camtu jer kan senang. hokhokhok... coba paste apa yg hang dah buat.....

hihihih...tu yg sy ckp sush bab nk xpalin ni..hihih...ok2....nnt sy paste kan erk...mekaceh awk...

hihihih...tu yg sy ckp sush bab nk xpalin ni..hihih...ok2....nnt sy paste kan erk...mekaceh awk...

tp kan awk...sy nk tnye ckit if kite gune access kan nk wat dropdown list ru cam ne erk kt Part Number tu??urm???

[DrASAG 0]

CODE

....
....
....

$result = mysql_query ("SELECT * FROM tbl_hang");                
if ($row = mysql_fetch_array($result))
{
    do
    {
            $partnumber = $row["partnumber"];
            echo "<OPTION value=$partnumber>$partnumber</option>";
        }
      while($row = mysql_fetch_array($result));
}

[echah 0]

CODE

....
....
....

$result = mysql_query ("SELECT * FROM tbl_hang");                
if ($row = mysql_fetch_array($result))
{
    do
    {
            $partnumber = $row["partnumber"];
            echo "<OPTION value=$partnumber>$partnumber</option>";
        }
      while($row = mysql_fetch_array($result));
}

orait...cantik...mekaceh awk...sy try erk pki coding ni.....

[echah 0]

orait...cantik...mekaceh awk...sy try erk pki coding ni.....

<?php
//connect to mysql server
$db=mysql_connect("localhost","root","root08")
or die
("could not connect to database, please check that mysql is running");

mysql_select_db("spare part pricing");//database name

$result = mysql_query ("SELECT * FROM master spare parts pricing");
if ($row = mysql_fetch_array($result))
{
do
{
$Part Number = $row["Part Number"];
echo "<OPTION value=$Part Number>$Part Number</option>";
}
while($row = mysql_fetch_array($result));
}
?>
<style type="text/css">
<!--
.style9 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
-->
</style><? if ($num_rows>0){ ?>
<table width="453" border="0">
<tr bgcolor="#99D2C1">
<td width="118"><div align="center"><span class="style9">Part Number </span></div></td>
<td width="141"><div align="center"><span class="style9">Description</span></div></td>
<td width="180"><div align="center"><span class="style9">Suggested Retail Price </span></div></td>
</tr>
<tr bgcolor="#FF925E">
<td><?
// Code to select data from author
$qauthor="SELECT * FROM master spare parts pricing";
$rsa=mysql_query ($qauthor);
$nrML=mysql_num_rows($rsa);
?><select name="Part Number"><option value="no selection" selected> -Select Model No- </option>
<?
for
($i=0; $i<$nrML; $i++) {
$row2=mysql_fetch_array($rsa);
$aid=$row2["Description"];
$aname=$row2["Part Number"];

if ($aid==$row["Description"]){
?>
<option value="<? echo $aid ?>" selected> <? echo $aname ?></option>
<? }//end if
else{?>
<option value="<? echo $aid ?>"> <? echo $aname ?></option>
<?
}//end else
}//end for
?>
</select></td>
<td><? echo $row["Description"]?></td>
<td><? echo $row["Suggested Retail Price"]?></td>
</tr>
</table>



erk....error....huhuhu....cam tunggang langgang jek coding ni...

[DrASAG 0]

tah, aku tgk pon pening. apesal ko tak paste dlm style code? huhuhuhuhu.... lagik satu, apesal nama database, table, field ada spaces? huhuhuhu... nama variable pun hang buat ada spaces jgk. $Part Number tu yg variable cuma Part jer, Number tu hapa? pastu, ko tak bgtau error apa. aku malas nak test. huihuihui...

CODE

<?php
//connect to mysql server
$db=mysql_connect("localhost","root","root08")
or die
("could not connect to database, please check that mysql is running");

mysql_select_db("spare part pricing");//database name

$result = mysql_query ("SELECT * FROM master spare parts pricing");
if ($row = mysql_fetch_array($result))
{
do
{
$Part Number = $row["Part Number"];
echo "<OPTION value=$Part Number>$Part Number</option>";
}
while($row = mysql_fetch_array($result));
}
?>
<style type="text/css">
<!--
.style9 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
-->
</style><? if ($num_rows>0){ ?>
<table width="453" border="0">
<tr bgcolor="#99D2C1">
<td width="118"><div align="center"><span class="style9">Part Number </span></div></td>
<td width="141"><div align="center"><span class="style9">Description</span></div></td>
<td width="180"><div align="center"><span class="style9">Suggested Retail Price </span></div></td>
</tr>
<tr bgcolor="#FF925E">
<td><?
// Code to select data from author
$qauthor="SELECT * FROM master spare parts pricing";
$rsa=mysql_query ($qauthor);
$nrML=mysql_num_rows($rsa);
?><select name="Part Number"><option value="no selection" selected> -Select Model No- </option>
<?
for
($i=0; $i<$nrML; $i++) {
$row2=mysql_fetch_array($rsa);
$aid=$row2["Description"];
$aname=$row2["Part Number"];

if ($aid==$row["Description"]){
?>
<option value="<? echo $aid ?>" selected> <? echo $aname ?></option>
<? }//end if
else{?>
<option value="<? echo $aid ?>"> <? echo $aname ?></option>
<?
}//end else
}//end for
?>
</select></td>
<td><? echo $row["Description"]?></td>
<td><? echo $row["Suggested Retail Price"]?></td>
</tr>
</table>

Edited November 6, 2008 by DrASAG

[echah 0]

tah, aku tgk pon pening. apesal ko tak paste dlm style code? huhuhuhuhu.... lagik satu, apesal nama database, table, field ada spaces? huhuhuhu... nama variable pun hang buat ada spaces jgk. $Part Number tu yg variable cuma Part jer, Number tu hapa? pastu, ko tak bgtau error apa. aku malas nak test. huihuihui...

CODE

<?php
//connect to mysql server
$db=mysql_connect("localhost","root","root08")
or die
("could not connect to database, please check that mysql is running");

mysql_select_db("spare part pricing");//database name

$result = mysql_query ("SELECT * FROM master spare parts pricing");
if ($row = mysql_fetch_array($result))
{
do
{
$Part Number = $row["Part Number"];
echo "<OPTION value=$Part Number>$Part Number</option>";
}
while($row = mysql_fetch_array($result));
}
?>
<style type="text/css">
<!--
.style9 {font-family: Geneva, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
-->
</style><? if ($num_rows>0){ ?>
<table width="453" border="0">
<tr bgcolor="#99D2C1">
<td width="118"><div align="center"><span class="style9">Part Number </span></div></td>
<td width="141"><div align="center"><span class="style9">Description</span></div></td>
<td width="180"><div align="center"><span class="style9">Suggested Retail Price </span></div></td>
</tr>
<tr bgcolor="#FF925E">
<td><?
// Code to select data from author
$qauthor="SELECT * FROM master spare parts pricing";
$rsa=mysql_query ($qauthor);
$nrML=mysql_num_rows($rsa);
?><select name="Part Number"><option value="no selection" selected> -Select Model No- </option>
<?
for
($i=0; $i<$nrML; $i++) {
$row2=mysql_fetch_array($rsa);
$aid=$row2["Description"];
$aname=$row2["Part Number"];

if ($aid==$row["Description"]){
?>
<option value="<? echo $aid ?>" selected> <? echo $aname ?></option>
<? }//end if
else{?>
<option value="<? echo $aid ?>"> <? echo $aname ?></option>
<?
}//end else
}//end for
?>
</select></td>
<td><? echo $row["Description"]?></td>
<td><? echo $row["Suggested Retail Price"]?></td>
</tr>
</table>

erk...ayat perli tu..hahak...xtau r nk paste coding kt ne..hik3....

tu r lame dah meninggalkn bidang coding ni...byk lupe lak..huhuh... terpakse r kena tukar table baru kt mysql...hihihi...ok2...

[echah 0]

CODE

<?
// Connect database
mysql_connect("localhost","root","root08");
mysql_select_db("tutorial");

if(isset($select)&&$select!=""){
$select=$_GET['select'];
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<form id="form1" name="form1" method="get" action="<? echo $PHP_SELF; ?> ">
Staff Number :
<select name="select">
<option value="">--- Select ---</option>
<?
$list=mysql_query("select * from name_list order by id asc");


while($row_list=mysql_fetch_assoc($list)){
?>
<option value="<? echo $row_list['id']; ?>" <? if($row_list['id']==$select){ echo "selected"; } ?>><? echo $row_list['id']; ?></option>
<?

}
?>
</select>
<input type="submit" name="Submit" value="Select" />
</form>
<hr>
<p>
<?

if(isset($select)&&$select!=""){


$result=mysql_query("select * from name_list where id='$select'");
$row=mysql_fetch_assoc($result);
?>
Information about <strong><? echo $row['name']; ?></strong> company...</p>
<p>........................................<br>
........................................<br>
........................................
<?
// End if statement.
}

// Close database connection.
mysql_close();
?>
</p>
</body>
</html>

erm.... cam ne lak bile dah wat dropdown menu ni bile select jek trus connect ngn database??
n akan view only one staff punye data...huh...dungu dah mncr ..hahak.. Edited November 18, 2008 by echah