Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

9 Neutral

About newphpcoder

  • Rank
  1. Hi, I have this code for setFilterGrid and it works fine: <form name="material_form" action="<?php echo $PHP_SELF; ?>" method="post" autocomplete="off"><div id="WH_list"><table id="mat_list"><thead><tr><th>DATE ENTRY</th><th>PO NUMBER</th><th>KIND</th><th>ITEM CODE</th><th>DESCRIPTION</th><th>UoM</th><th>SUPPLIER</th><th>QTY</th><th>WH #</th><th>ROW #</th><th>RACK #</th><th>LEVEL</th><th>RECEIVED BY&
  2. Hi,I used IIS as my web server. I have 5 websites already setup in IIS. Now I add one more website, but when I run the url instead of displaying the forms it display the codes.I have no idea how can I fixed this problem. When I tried to remove all the php codes it display the form.I hope somebody can help me to fixed this error.Thank you.
  3. Hi, I have form that displaying report per week. First thing to do is choose what week then automatically display the date/shift that week ranges. here is my weekly_report.php <?php error_reporting(0); session_start(); ob_start(); date_default_timezone_set("Asia/Singapore"); include('connection.php'); ?><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><title>Weekly Report</title><head><link rel="stylesheet" type="text/css" href="op_report.css" /><script type="text/javascript" src="jquery.js">
  4. Hi,I have webpage that consist of table where I display the list of employee, the problem is there's a lot of employee list so I need to add scrollbar to my table but the header is fixed, when I tried to add code autoflow:auto; in my css for <div> operator_list it did not work.here is my css code:#operator_list{ position: absolute; margin-left: 350px; overflow: auto; }table { margin: 12px; margin-left: 3px; border: 1px solid #DDD; }th { background: #694; color: #FFF; padding: 2px 6px; border-collapse: separate; border: 1px solid #000;}td { bord
  5. Hi Good day!I have 2 tables for my dtr database.first the employees where all the data of employee was save.employees fields:EmployeeIDLastnameFirstnameSubDepartmentattendance_logEMP_IDLOG_TIME (datetime)INDICATORI tried lots of query to get the EmployeeID where no attendance on the date I want to check who are the absentee.I just want to select the EmployeeId where no LOG_TIME with the date 2013-05-02attendance_log table is the table where the time in and out was save.I hope somebody can help me to get only the EmployeeId with no attendance where Sub = 'REG' and Department IN ('QA', 'Engineer
  6. Hi Good day! I got encountered problem in displaying my page in IE8, especially in my background image. It was not displayed fully on the page. It also repeated. I want to happen is the background is displayed fully. here is my css code: html {background: url(images/background.png) no-repeat fixed;-webkit-background-size: cover;-moz-background-size: cover;-o-background-size: cover;background-size: cover; } Any help is highly appreciated. Thank you so mcuh.
  7. Hi..I found code that has a sum below from this link :http://tablefilter.free.fr/ex.php#tbl9Sample Table 7: <script language="javascript" type="text/javascript">//<![CDATA[var totRowIndex = tf_Tag(tf_Id('table7'),"tr").length; var table7_Props = { rows_counter: true, loader: true, loader_text: "Filtering data...", col_operation: { id: ["table8Tot1","table8Tot2"], col: [2,4], operation: ["sum","sum"], write_method: ["innerHTML","setValue"], exclude_row: [totRowIndex], decimal_precision: [1,0] }, rows_always_visible: [totRowIndex] };var tf7 = setFilterGrid( "table7",t
  8. Hi,I resolved my first problem which is 0 become -. I just exchange the value of 0 and -.Now my problem is how can I put the lot_number value from my database to barcode value which handled by $text. I mean no need to declare to : $bc->build('LO130319001'); manually.I just get the lotnumber value to:$_SESSION["rm_id"] = mysql_insert_id(); $sql = "SELECT r.lot_number, m.mat_code, m.description FROM wms_receiving AS r LEFT JOIN bom_material AS m ON r.uid_mat = m.uid_mat WHERE r.rm_id = " . $_SESSION["rm_id"]; $res = mysql_query($sql); $row = mysql_fetch_assoc($res);$lot
  9. Hi... I saw this thread I tried this code: <?php $bc = new barCode();$bc->build('LO130319001'); class barCode{ public $bcHeight, $bcThinWidth, $bcThickWidth, $bcFontSize, $mode; function __construct($mode='gif', $height=25, $thin=1, $thick=2, $fSize=1) { $this->bcHeight = $height; $this->bcThinWidth = $thin; $this->bcThickWidth = $this->bcThinWidth * $thick; $this->fontSize = $fSize; $this->mode = $mode; $this->outMode = array('gif'=>'gif', 'png'=>'png', 'jpeg'=>'jpeg', 'wbmp'=>'vnd.wap.wbmp'); $this->codeMap =
  10. Hi,Good day!I found a sample code in generating barcode.here's the link:http://www.brandonchecketts.com/archives/quick-php-script-to-generate-a-barcodeand this is the code: <?php$number = isset($_GET['number']) ? $_GET['number'] : '';$barcode_font = dirname(__FILE__).'/fonts/FREE3OF9.TTF';$plain_font = dirname(__FILE__).'/fonts/plain.pfb';$width = 200;$height = 80;$img = imagecreate($width, $height);// First call to imagecolorallocate is the background color$white = imagecolorallocate($img, 255, 255, 255);$black = imagecolorallocate($img, 0, 0, 0);// Reference for the imagettftext() func
  11. HiGood day!I just want to know if what syntax/code should I use to put - in my data variable.for example I have this data.$lot_number_indi_scan = 'LO130315002LO130318001';I want to create a new variable and the output has added - between the lot_number_indi_scan like this:$newlot = 'LO130315002-LO130318001';I want to happen is first I will check the length of $lot_number_indi_scan if length is greater than 10 every lot_number_indi_scan has -like this: $newlot = 'LO130315002-LO130318001';Any help is highly appreciated.Thank you so much.
  12. Hi...Good day!I already had codes on setFilterGrid on my table, now I need to add the total qty at the row which is i don't have any idea if it is possible using javascript and how. I want to happen is every time I filter the item code the Quantity will SUM and display on the last row.here is my code: <?php include('connection.php'); ?><html><title>Raw Materials Inventory</title><head><link rel="stylesheet" type="text/css" href="css/kanban.css" /><script language="javascript" type="text/javascript" src="tablefilter.js"></script> <sty
  13. Hi, Good day!I encountered difficulties in checking of the data is like on the data from my table.I have tablewms_pickingand I have lot_number field and value = 'LO130318001-LO130318002' and item_code = 'MAT-CHE-0010'then I have variable:$lot_number = 'LO130318001LO130318002';$mat_code = 'MAT-CHE-0010';I created query:select s.sr_id, p.item_code, p.lot_number from sr_chemicals AS s JOIN wms_picking AS p ON (s.sr_id = p.sr_id) WHERE p.item_code = '$mat_code' and p.lot_number LIKE '%$lot_number%';select s.sr_id, p.item_code, p.lot_number from sr_chemicals AS s JOIN wms_picking AS p ON (s.sr
  14. HiGood day!I have form created that I used setFilterGrid in my table, so that I can easily filter the data.Now Every time I filter the item code I need to sum all the quantity , same with if I filter the item code and wh location it also sum the quantiy. Is it possible in javascript?Here is my code: <?php include('connection.php'); ?><html><title>Raw Materials Inventory</title><head><link rel="stylesheet" type="text/css" href="css/kanban.css" /><script language="javascript" type="text/javascript" src="tablefilter.js"></script> <style
  15. Hi,Good day!I have problem in checking if the two values of variables is match or like.sample 1:in this sample 1 my condition works fine. lot_number = LO130227003lot_number_scan = LO130227003if(lot_number === lot_number_scan){alert('correct');}else{alert('wrong');} sample 2:in this sample 2 my condition did not work. lot_number = LO130227003-LO130228001lot_number_scan = LO130227003 if(lot_number === lot_number_scan){alert('correct');}else{alert('wrong');} I tried to find the solution in this problem but I can't find the same problem.I want to happen is: if(LO130227003-LO130228001 LIKE OR
  • Create New...