PHP - Load Data From Db Into A Option Box

Hi..

I need to add code to check if the compound that was choose is reach the maximum value then if it is already reach theirs a notification displayed that he already gain the maximum.

the problem is..I don't know how can I check if what the user choose before run the condition.

here is my code:

Code: [Select]
<?php
  $config['BASE_DIR']  = dirname(dirname(__FILE__));   
  $config['BASE_DIR'] = $config['BASE_DIR']. '\MES PROJECT';
   define('SMARTY_DIR', $config['BASE_DIR']. '/INCLUDE/smarty/libs/');


  require(SMARTY_DIR . 'Smarty.class.php');
  $smarty = new Smarty();

  $smarty = new Smarty();
  $smarty->template_dir = $config['BASE_DIR'].  '/smarty/templates';
  $smarty->config_dir   = $config['BASE_DIR'].  '/smarty/config';
  
  $smarty->cache_dir    = $config['BASE_DIR'].  '/INCLUDE/smarty/cache';
  $smarty->compile_dir  = $config['BASE_DIR'].  '/INCLUDE/smarty/templates_c';                                                       

// =================================================================================================================
$con= mysql_connect('localhost', 'root', '');
 if (!$con) {
    echo 'failed'; 
    die();
 }
 
mysql_select_db("mes", $con);
 
$hostAddr = $_SERVER['REMOTE_ADDR'];

 $terminal = $hostAddr; //<-enable this in server
//$terminal = $_POST['doThis'];  //<- disable this in server
$terminal = "192.168.1.101";
switch ($terminal) {
       case "192.168.1.101" : //<< enable this in server
       //case "1" :
       
          $smarty->assign('process', 'Rubber/Chemical Preparation');      
          $smarty->assign('termNo', 'Terminal 1');      
          
          $smarty->assign('text_name1','Compound Code');
          $smarty->assign('text_name2','Lot Traveler ID');
          $smarty->assign('text_name3','Kit Weight ');
          $smarty->assign('text_name4','Operator Code');
          
         [b]  $smarty->assign('compoundIndexValue', array('0',  'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));[/b]           
           $smarty->assign('names', array('<Choose Code>',   'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));

           $smarty->assign('weightIndexValue', array('0',  '60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
           
           $smarty->assign('kitWeight', array('<Choose Weight>','60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
       
          //Chemical weighing Process :  Terminal 1
          $smarty->display('header.tpl');  // common Header 
          $smarty->display('box_1.tpl');
          $smarty->display('footer.tpl');
          

       [b] $compound = mysql_real_escape_string($_POST['compoundIndexValue']);
        $sql = "SELECT 
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min,
                P47, P47_max, P47_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
        
        $row = mysql_fetch_assoc($res_pcode);
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];
        
            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];
            
            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];
            
            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];
            
            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];
           
            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];
            
            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];
            
            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];
            
            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];
            
            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];
            
            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];
            
            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];
            
            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];
        
           
        $sql = "SELECT PCODE, total FROM kanban_checker WHERE PCODE = '$compound' ORDER BY PCODE";
        $res_kanban = mysql_query($sql, $con);
        
        $row_kanban = mysql_fetch_assoc($res_kanban);
        
        $PCODE = $row_kanban['PCODE'];
        $total = $row_kanban['total'];
        
        if($compound == $P28 && $total == $P28_max){
         echo "<script type='text/javascript'>notify(P28 gain total maximum)</script>";   
        }
        else {
            echo '';
        }
        
       if($compound == $P30 && $total == $P30_max){
         echo "<script type='text/javascript'>notify(P30 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P32 && $total == $P32_max){
         echo "<script type='text/javascript'>notify(P32 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P33 && $total == $P33_max){
         echo "<script type='text/javascript'>notify(P33 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35 && $total == $P35_max){
         echo "<script type='text/javascript'>notify(P35 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35M && $total == $P35M_max){
         echo "<script type='text/javascript'>notify(P35M gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35W && $total == $P35W_max){
         echo "<script type='text/javascript'>notify(P35W gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P38 && $total == $P38_max){
         echo "<script type='text/javascript'>notify(P38 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P41 && $total == $P41_max){
         echo "<script type='text/javascript'>notify(P41 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P42 && $total == $P42_max){
         echo "<script type='text/javascript'>notify(P42 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P43 && $total == $P43_max){
         echo "<script type='text/javascript'>notify(P43 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P46 && $total == $P46_max){
         echo "<script type='text/javascript'>notify(P46 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P47 && $total == $P47_max){
         echo "<script type='text/javascript'>notify(P47 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }[/b]        
       break;
    
       case "192.168.1.102" : //<< enable this in server
       //case "2" :
    
          $smarty->assign('process', 'Compounding Process');
          $smarty->assign('termNo', 'Terminal 2');   
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');
   
          $smarty->assign('machineID', array('0', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
         
          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;
       
       case "192.168.1.103" : //<< enable this in server     
       //case "3" :
          $smarty->assign('process', 'Extrusion Process');
          $smarty->assign('termNo', 'Terminal 3');              
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');
         
          $smarty->assign('machineID', array('0', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;
    
       case "192.168.1.104" : //<< enable this in server
       //case "4" :
          $smarty->assign('process', 'Half Shell Forming');
          $smarty->assign('termNo', 'Terminal 4');              

          $smarty->assign('text_name1','Lot Traveler ID');

          $smarty->assign('text_nameDG','New Lot ID');
          
          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');
          
          $smarty->assign('id', array('0', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));
          $smarty->assign('id_name', array('<Choose Machine ID>', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));
          
          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;
       
       case "192.168.1.105" : //<< enable this in server   
       //case "5" :
          
          $smarty->assign('process', 'Half Shell Deflashing'); //= to be implemented
          $smarty->assign('termNo', 'Terminal 5');              
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');

$smarty->assign('id',      array('0', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));
$smarty->assign('id_name', array('<Choose Machine ID>', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));


          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;

    
}
?>

My only purpose is to avoid adding data so i need to prompt if he already reach the maximum per compound.


Thank you so much

I have made a data table out of my mySQL table and I should have a search option.
Lik where you have 3 boxes on one line :
Naam - Date1 - Date2
Naam is just searching results with that value
You can insert Date1 and Date 2 and then it must search between those dates.
But what will it do if i only put 1 date ? Like 2011-12-23 and date2 open
will it then only show the dates from 2011-12-23 ?   <html><body><?php$username="";$password="";$database="";mysql_connect(localhost,$username,$password);@mysql_select_db($database) or die( "Unable to select database");$query = "SELECT middenoosten2.*, users.naam ". "FROM middenoosten2, users ". "WHERE middenoosten2.speler = users.inlog order by id asc";$result=mysql_query($query);$num=mysql_numrows($result);mysql_close();?><p><b>Scores middenoosten : Zee en rivieren</b></p><table border="1" cellspacing="2" cellpadding="2"><tr><th><font face="Arial, Helvetica, sans-serif">Id</font></th><th><font face="Arial, Helvetica, sans-serif">Naam</font></th><th><font face="Arial, Helvetica, sans-serif">Score 11/...</font></th><th><font face="Arial, Helvetica, sans-serif">datum</font></th><th><font face="Arial, Helvetica, sans-serif">uur</font></th><th><font face="Arial, Helvetica, sans-serif">percent</font></th><th><font face="Arial, Helvetica, sans-serif">duur</font></th></tr><?php$i=0;while ($i < $num) {$f1=mysql_result($result,$i,"id");$f2=mysql_result($result,$i,"naam");$f3=mysql_result($result,$i,"score");$f4=mysql_result($result,$i,"datum");$f5=mysql_result($result,$i,"tijd");$f6=mysql_result($result,$i,"percent");$f7=mysql_result($result,$i,"crono");?><tr><td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td><td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td></tr><?php$i++;}?></body></html>()

Thank you

Hi..

I need to save data from a while loop and data from select option, Now I encountered that using my query I only save is the last part of my while loop and also the data that I choose in select option did not save.

here is my code:

Code: [Select]
<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items = $_POST['Items'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
ON DUPLICATE KEY UPDATE
sr_date = '$sr_date', sr_number = '$sr_number', Items = '$Items', SubItems = '$SubItems', ItemCode = '$ItemCode', DemandedQty = '$DemandedQty',
UoM = '$UoM', Class = '$Class', Description = '$Description', BINLocation = '$BINLocation', RequestedBy = '$RequestedBy',
ApprovedBy = '$ApprovedBy', ReceivedBy = '$ReceivedBy', IssuedBy = '$IssuedBy'";

$result = mysql_query($sql, $con);

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));

            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);  
?>
<html>
<title>Stock Requisition</title>
<head>
<style type="text/css">
#ddcolortabs{
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}


#ddcolortabs a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs a span{
float:none;
}


#ddcolortabs a:hover{
background-color: #678b3f;
}

#ddcolortabs a:hover span{
background-color: #678b3f ;
}

#ddcolortabs #current a, #ddcolortabs #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>
<style type="text/css">
#ddcolortabs1{
position: relative;
top: 10px;
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs1 ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs1 li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}


#ddcolortabs1 a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs1 a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs1 a span{
float:none;
}


#ddcolortabs1 a:hover{
background-color: #678b3f;
}

#ddcolortabs1 a:hover span{
background-color: #678b3f ;
}

#ddcolortabs1 #current a, #ddcolortabs1 #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>

<style>
#SR_date{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
   
}
#SR_number{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 270px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
   
}
table {         
    margin: 10px;
    font-family: Arial, Helvetica, sans-serif; 
    font-size: .9em;
    border: 1px solid #DDD;
    width: auto;
}

th {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    background: #694;
    color: #FFF;
    padding: 2px 6px;
    border-collapse: separate;
    border: 1px solid #000;
}   

td {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    border: 1px solid #DDD;
    text-align: left;
}

#RequestedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ApprovedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ReceivedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}
#IssuedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
    margin-right: 120px;
}
#save_btn{
    position: relative;;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 10px;
    top: 10px;
}
</style>

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items = document.getElementById("Items").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
   
    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items="+Items+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
   
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
   
   
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>
</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">   
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/>
</div>
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php

$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$row[Items]' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";       

$sql = "SELECT SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$row[Items]' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 while($row_sub = mysql_fetch_assoc($res_sub)){

    echo "<tr>
        <td style='border: none;'>&nbsp;</td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$row_sub[SubItems]' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode' value='$row_sub[ItemCode]' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM' value='$row_sub[UoM]' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class' value='$row_sub[Class]' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description' value='$row_sub[Description]' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation' value='$row_sub[BINLocation]' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>     
        </tr>";
}
}   
               
?>
</table>
</div>

<div id='RequestedBy'>
<label>Requested By:</label>
<select name="Requested_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ApprovedBy'>
<label>Approved By:</label>
<select name="Approved_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ReceivedBy'>
<label>Received By:</label>
<select name="Received_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id='IssuedBy'>
<label>Issued By:</label>
<select name="Issued BY">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onclick="save_sr()">
</div>
</body>
</html>


I also I attach the display data.

Thank you

Hello. If someone can help me, i'll be grateful
So i have a foreach and an $output .= function that fills some infos in a table. Inside it i have a div for each line that when hovering your mouse should get some data .. Here i have a big problem, because for each line it should get some data and i don't know how to do it ...

i'll post here some of my code for better understanding.

Quote

//some java here
<?php
require "class.php";

  $server_list = query_group();
  $misc   = server_misc($server);

foreach ($server_list as $server)
    {
      $misc   = server_misc($server);
      $server = server_html($server);
      $idi = "{$server['o']['id']}";
$harta = "<a onmouseover=\"ShowContent('harta'); return true;\" onmouseout=\"HideContent('harta'); return true;\" href='".link($server['o']['id'])."' target=\"_self\">{$server['s']['map']}</a>
<div style=\"position:absolute;\" id=\"harta\" class=\"FAQ\">file_get_contents('http://mysite/player.php?d={$idi}')</div> ";

$output .= "
<table>
........... some code.....
<td>
{$harta}
        </td>
.......



so basicly when i hover my mouse over each row it should get data from the file for that id... The problem is that only one page can be loaded with file_get_contents. I read over the internet that some ajax functions can do it but i really don't know how.
Please help me, i've been looking for 3 days already without any luck 

I wonder whether someone may be able to help me please.

I'm trying to put together a PHP within Aurigma Image Uploader which will create an image gallery. To do this I need to extract the image from a folder called 'Thumbnails' and image data from a file called 'files.xml'.

The code below is an extract of the default script that performs this functionality and I've tested and it works without any issues.

Code: [Select]
<?php 
   
  //This variable specifies relative path to the folder, where the gallery with uploaded files is located. 
  //Do not forget about the slash in the end of the folder name. 
  $galleryPath = 'UploadedFiles/'; 
    
  $thumbnailsPath = $galleryPath . 'Thumbnails/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR; 
    
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
I have now changed my folder and file structure to the following:

UploadedFiles (Folder)
username (Subfolder containing the 'location' folder) location (Subfolder containing 'Thumbnails folder and image, and 'files.xml') Please note that both the 'username' and 'location' folders are dynamically created when the user initially uploads the images.
To try and accomodate the new file structure I changed my code to:

Code: [Select]
<?php 
   
  //This variable specifies relative path to the folder, where the gallery with uploaded files is located. 
  //Do not forget about the slash in the end of the folder name. 
  $galleryPath = 'UploadedFiles/'; 
    
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $usernamefolder . DIRECTORY_SEPARATOR . $locationfolder . DIRECTORY_SEPARATOR; 
  
  $thumbnailsPath = $galleryPath . 'Thumbnails/'; 
  
  $descriptions = new DOMDocument('1.0'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
?>
But when I run this I receive the following error:

Quote

d333603417/htdocs/development/UploadedFiles/files.xml" in /homepages/2/d333603417/htdocs/development/gallery.php on line 14

Line 14 is this line:
Code: [Select]
$descriptions->load($absGalleryPath . 'files.xml');

I've been working on this for days and I just can't seem to find the answer.

I just wondered whether someone could possibly look at this and let me know where I'm going wrong.

If it helps, I've added the upload script below.

Code: [Select]
<?php
require_once 'Includes/gallery_helper.php'; 
require_once 'ImageUploaderPHP/UploadHandler.class.php'; 
$galleryPath = 'UploadedFiles/'; 
 
function onFileUploaded($uploadedFile) { 
  global $galleryPath; 
 
  $packageFields = $uploadedFile->getPackage()->getPackageFields(); 
  $username=$packageFields["username"]; 
  $locationid=$packageFields["locationid"]; 
  $username = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['username']); 
  $location = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['locationid']); 
  $dirName = preg_replace('/[^a-z0-9_\-\.()\[\]{}]/i', '_', $_POST['folder']); 
 
  $absGalleryPath = realpath($galleryPath) . DIRECTORY_SEPARATOR . $username . DIRECTORY_SEPARATOR . $location . DIRECTORY_SEPARATOR; 
  $absThumbnailsPath = $absGalleryPath . 'Thumbnails' . DIRECTORY_SEPARATOR; 
 
  if (!is_dir($absGalleryPath)) mkdir($absGalleryPath, 0777, true); 
  chmod($absGalleryPath, 0777); 
  if (!is_dir($absGalleryPath . $dirName)) mkdir($absGalleryPath . $dirName, 0777, true); 
  chmod($absGalleryPath . $dirName, 0777); 
 
  if ($uploadedFile->getPackage()->getPackageIndex() == 0 && $uploadedFile->getIndex() == 0) 
    initGallery($absGalleryPath, $absThumbnailsPath, FALSE); 
 
  $originalFileName = $uploadedFile->getSourceName(); 
  $files = $uploadedFile->getConvertedFiles(); 
  $sourceFileName = getSafeFileName($absGalleryPath, $originalFileName); 
  $sourceFile = $files[0]; 
 
  if ($sourceFile) $sourceFile->moveTo($absGalleryPath . $sourceFileName); 
  $thumbnailFileName = getSafeFileName($absThumbnailsPath, $originalFileName); 
  $thumbnailFile = $files[1]; 
  if ($thumbnailFile) $thumbnailFile->moveTo($absThumbnailsPath . $thumbnailFileName); 
  
  $descriptions = new DOMDocument('1.0', 'utf-8'); 
  $descriptions->load($absGalleryPath . 'files.xml'); 
  
  $xmlFile = $descriptions->createElement('file'); 
  // <-- please check the following line 
  $xmlFile->setAttribute('name', $_POST['folder'] . '/' . $originalFileName); 
  $xmlFile->setAttribute('source', $sourceFileName); 
  $xmlFile->setAttribute('size', $uploadedFile->getSourceSize()); 
  $xmlFile->setAttribute('originalname', $originalFileName); 
  $xmlFile->setAttribute('thumbnail', $thumbnailFileName); 
  $xmlFile->setAttribute('description', $uploadedFile->getDescription()); 
  $xmlFile->setAttribute('username', $username); 
  $xmlFile->setAttribute('locationid', $locationid); 
  $xmlFile->setAttribute('folder', $dirName); 
 

  $descriptions->documentElement->appendChild($xmlFile); 
  $descriptions->save($absGalleryPath . 'files.xml'); 
} 
 
$uh = new UploadHandler(); 
$uh->setFileUploadedCallback('onFileUploaded'); 
$uh->processRequest(); 
?>
Many thanks