Nak Mintak Tlg! A.s.a.p!

eyda gilmore · October 14, 2008

salam..nak mintak tlg la kat sape2 yg tere php ni...kite tgh wat sistem inventori..need some help with some of the coding..im new in PHP...add me kat ym [email protected] :rolleyes:

Edited October 14, 2008 by eyda gilmore

slier · October 14, 2008

ada upah ker?

eyda gilmore · October 15, 2008

:huh:

wah~~~ kene bg upah ke~~ ( -_- :wacko:

al-siput · October 15, 2008

post la persoalan tu kat cni..

ramai2 bleh guide...

ramai orang bleh belaja sama2..

kalo YM dengan ko.. ko sorang jer la blaja...

slier · October 15, 2008

hmm..resource banyak kt internet...semua nak orang suap ker?

ko nak mintak tolong..tp org kena add ko kt ym..adeh la...

dont be too general...soklan ko mcm nak suruh org suruh siapkan kerja ko

klu nak org tolong kena la upah..

lol....

Edited October 15, 2008 by slier

drparasite · October 15, 2008

oiit sistem inventori,huhu teringat aku time wat praktikal dulu2.aku pn kena wat inventory system gak..cuba ko citer kat cni mcm mn sistem yg ko nk buat 2 kot2 ader persamaan dgn aku punya ker.

eyda gilmore · October 15, 2008

huhuu...grgnye sume..kene marah lak.. sorila abg2 sume..sifu sy pg kursus la..huhu..

sy buat sistem inventori pasal peralatan ict..

drparasite · October 15, 2008

huhuu...grgnye sume..kene marah lak.. sorila abg2 sume..sifu sy pg kursus la..huhu..
sy buat sistem inventori pasal peralatan ict..

try ko bg flow ckit pasal sistem ko..nk lg clear bg jer ERD.

eyda gilmore · October 15, 2008

nk bg erd macamane?

slier · October 15, 2008

Memandangkan ym ada prob..aku paste kt cni jer

<?php
include('includes/dbconnect.php');

            // requires the class
            require "includes/class.datepicker.php";
                    
            // instantiate the object
            $db=new datepicker();
                    
            $db->firstDayOfWeek = 1;
                
            // set the format in which the date to be returned
            $db->dateFormat = "Y-n-j";
        ?>

<!-- from here -->

<link rel=stylesheet type="text/css" href="images/style.css">
<body bgcolor="" bgproperties="fixed">
<script language="javascript">
function MM_jumpMenu(targ,selObj,restore){
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>


<!--FILE INI ADALAH UTK MAINPAGE SISTEM. SEBAGAI PENERANGAN KPD SISTEM. SO, APE2 CODING NK WAT JUST FOLO THIS FILE. SEBAB TABLE DAH FIX UTK iframe PADA index.php-->
<table width="599" height="346" border="0" cellpadding="0" cellspacing="0" align="center">
    <th bgcolor="#663399" align="left" valign="top" width="580" height="20"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font color="#FFFFFF">AGIHAN PERALATAN</font></th>
<tr>
      <td bgcolor="#F7E0FA" align="left" valign="top" width="580"><br>
<!--until here... don change it.-->


<!--kalo nk wat form, tuka dari table kat bwh ni...-->
<? if($action == 'view'){?>

  <?     $staf_id = $_GET['user'];

        $queryedit = "SELECT * FROM staff WHERE s_id='$staf_id'";
        $resultedit = mysql_query($queryedit) or die (mysql_error());
        $view = mysql_fetch_assoc($resultedit);
}?> 
        
        <? if ($_POST['submit'] != "Tambah" ){?>
        
        <form name="paparstaf" method="post" action="tambah_equip.php">
        <table width="550" border="0" align="center" cellpadding="2" cellspacing="3" dwcopytype="CopyTableRow">
    
        <tr></tr>
          <td  class="content" width="81"align="left" >CPU/Sistem Unit</td>
          <td class="content" width="402" colspan="3"> <select name="cpu">
            
              <option value="" selected>Pilih No Siri</option>
      
            
              
            
                <? /********display other level available*********/ 
                $queryview2 = "SELECT e_seriesNo FROM equipment WHERE e_type='6'";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <option value="<? echo $view2['e_seriesNo']; ?>"> <? echo $view2['e_seriesNo']; ?></option>
                <? }//end while ?>
              </select>
           </td>
        </tr>
        <tr> 
            <td  class="content" width="81"align="left" >Monitor</td>
          <td class="content" width="402" colspan="3"> <select name="monitor">
            
              <option value="" selected>Pilih No Siri</option>
      
            
              
            
                <? /********display other level available*********/ 
                $queryview2 = "SELECT e_seriesNo FROM equipment ORDER BY e_seriesNo";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <option value="<? echo $view2['e_seriesNo']; ?>"> <? echo $view2['e_seriesNo']; ?></option>
                <? }//end while ?>
              </select>
           </td>
        </tr>
        <tr> 
            <td  class="content" width="81"align="left" >Keyboard</td>
          <td class="content" width="402" colspan="3"> <select name="keyboard">
            
              <option value="" selected>Pilih No Siri</option>
      
            
              
            
                <? /********display other level available*********/ 
                $queryview2 = "SELECT e_seriesNo FROM equipment ORDER BY e_seriesNo";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <option value="<? echo $view2['e_seriesNo']; ?>"> <? echo $view2['e_seriesNo']; ?></option>
                <? }//end while ?>
              </select>
           </td>
        </tr>
        <tr> 
            <td  class="content" width="81"align="left" >Mouse</td>
          <td class="content" width="402" colspan="3"> <select name="mouse">
            
              <option value="" selected>Pilih No Siri</option>
      
            
              
            
                <? /********display other level available*********/ 
                $queryview2 = "SELECT e_seriesNo FROM equipment ORDER BY e_seriesNo";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <option value="<? echo $view2['e_seriesNo']; ?>"> <? echo $view2['e_seriesNo']; ?></option>
                <? }//end while ?>
              </select>
           </td>
        </tr>
        <tr> 
            <td  class="content" width="81"align="left" >Lain-lain</td>
            <td class="content" width="150" > <select name="select" onChange="MM_jumpMenu('parent',this,1)">
                <option value="-" selected>Pilih Peralatan</option>
                <? /********display other level available*********/ 
                $queryview2 = "SELECT DISTINCT e_type FROM equipment ";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <? $cat_id=$view2['e_type'];    
                $queryview8 = "SELECT * FROM category WHERE cat_id='$cat_id'";
                $resultview8 = mysql_query($queryview8) or die (mysql_error());
                $view8 = mysql_fetch_assoc($resultview8); ?>
                <option value="<? echo $view2['cat_id']; ?>"> <? echo $view8['cat_name']; ?></option>
                <? }//end while ?>
              </select></td>
              
            <td  class="content" width="81"align="left" >No Siri</td>
          <td class="content" width="200" > <select name="e_series_No">
            
              <option value="-" selected>Pilih No Siri</option>
      
            
              
            
                <? /********display other level available*********/ 
                $queryview2 = "SELECT e_seriesNo FROM equipment WHERE e_type='6'";
                $resultview2 = mysql_query($queryview2) or die (mysql_error());    
                while($view2 = mysql_fetch_array($resultview2)){?>
                <option value="<? echo $view2['e_seriesNo']; ?>"> <? echo $view2['e_seriesNo']; ?></option>
                <? }//end while ?>
              </select>
           </td>
        </tr>
         <tr>
              <td class="content" width="81">Tarikh terima</td>
            <td class="content" colspan="3">
                <input type="text" id="date" name="d_receive_date" value="" readonly>
                <input type="button" value="Pilih Tarikh" onClick="<?=$db->show("date")?>">
            </td>
            </tr>
             <tr>
              <td class="content" width="81">Nama staf IT </td>
              <td class="content" colspan="3">
            <input type="text" name='d_IT' value="" size="67">
            </td>
          </tr>
          <tr> <td class="content" width="107"></td><td class="content" width="340" colspan="3"> <input type="submit" name="submit" value="Tambah">  <input type="reset" value="Reset" name="reset">
          </td></tr>
      </table>
      </form>
     <? } elseif($_POST['submit'] == "Tambah") { //submit info
             $s_id                =    $_POST[s_id];
            $d_receive_date        =    $_POST[d_receive_date];
            $d_IT               =      $_POST[d_IT];
    
            if($_POST['cpu']!='')
            {
                $e_seriesNo=$_POST['cpu'];
                $add_distribution="INSERT INTO distribution VALUES (' $s_id', '$e_seriesNo', '$d_receive_date', ' ', '$d_IT')";      
                mysql_query($add_distribution) or die (mysql_error()); 
            }
            
            if($_POST['monitor']!='')
            {
                $e_seriesNo=$_POST['monitor'];
                $add_distribution="INSERT INTO distribution VALUES (' $s_id', '$e_seriesNo', '$d_receive_date', ' ', '$d_IT')";      
                mysql_query($add_distribution) or die (mysql_error()); 
            }
            
            if($_POST['keyboard']!='')
            {
                $e_seriesNo=$_POST['keyboard'];
                $add_distribution="INSERT INTO distribution VALUES (' $s_id', '$e_seriesNo', '$d_receive_date', ' ', '$d_IT')";      
                mysql_query($add_distribution) or die (mysql_error()); 
            }
            
            if($_POST['mouse']!='')
            {
                $e_seriesNo=$_POST['mouse'];
                $add_distribution="INSERT INTO distribution VALUES (' $s_id', '$e_seriesNo', '$d_receive_date', ' ', '$d_IT')";      
                mysql_query($add_distribution) or die (mysql_error()); 
            }
            
            
        
        
/*           $add_distribution="INSERT INTO distribution VALUES (' $s_id', '$e_seriesNo', '$d_receive_date', ' ', '$d_IT')";            
            $result_add = mysql_query($add_distribution) or die (mysql_error()); */
                                
            }
     ?>

    
<!--do not delete this line--></td></tr></table>
</body>

Edited October 15, 2008 by slier

eyda gilmore · October 15, 2008

hehee thank u : >

eyda gilmore · October 15, 2008

salam..nk tanye..

sy ade table EQUIPMENT, DISTRIBUTION,STAFF..

table distribution ni bridge entity antare table equipment n staff..

table distribution ni ade no siri peralatan yg dah diagihkan kat die..cth (no siri monitor)

attribute kat table distribution ni

staff_id(PK table staff)

series_no(PK table equipment)

date receive

mcmane nk buat query utk tarik maklumat pasal staff ni n peralatan yg dah diagihkan kat die..

dgn m'gunakan primary key kat bridge entity (series_no)

kat repot tu sy nk kuarkan maklumat equipment yg staff tu dpt je..cthnye jename,jenis, no local order n lain2 tp berdasarkan series_no yg kat table distribution ..

FryShadow · October 15, 2008

hint : table join

http://www.tizag.com/mysqlTutorial/mysqljoins.php

Cho Chang · October 15, 2008

Memandangkan ym ada prob..aku paste kt cni jer
........

hahaha.... nnti bleh la mintak bro slier tlong aku plak...kkekekeke.... seketoi koding dier bg.....huhuhu... aku dlu pakcik google ngan antie yahoo ja yg dok tolong....sob sob..... :lol:

eyda gilmore · October 16, 2008

heeee..

eyda gilmore · October 16, 2008

salam..btol ke camni..huhu

SELECT D.s_id,D.e_seriesNo,E.* FROM equipment E , distribution D WHERE D.e_seriesNo=E.e_seriesNo AND D.s_id='$staff_id'

eyda gilmore · October 16, 2008

nk tanye lg satu..

mcmane nk buat text box utk user masokkan time dlm format hh:mm

Sign In

Nak Mintak Tlg! A.s.a.p!

Recommended Posts

eyda gilmore 0

Share this post

Link to post

Share on other sites

slier 28

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

al-siput 2

Share this post

Link to post

Share on other sites

slier 28

Share this post

Link to post

Share on other sites

drparasite 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

drparasite 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

slier 28

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

FryShadow 90

Share this post

Link to post

Share on other sites

Cho Chang 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

eyda gilmore 0

Share this post

Link to post

Share on other sites

Join the conversation

Announcements

Browse

Activity