Jump to content

display autogenerate number on a row where the button was click


Recommended Posts

Hi..I encountered problem in displaying joborder number or JO_No inside while loop.I want to happen is only JO_No will display after I click the Approved button and it will only appear on the row where the Approved button was click.Now in my code the JO_No was display automatically in the row of JO_No .here is my code:

<?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);$Date_Shelve =date('Y-m-d H:i:s'); ?><html><head><title>Job Order</title><link rel="stylesheet" type="text/css" href="kanban.css" />   </head><body><div id="SR_date"><label>Date :</label><input type="text" name="Date_Shelve" id="Date_Shelve" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;">   </div><div id="kanban_table"><table width="auto"><th> JO No.</th><th> ETD </th><th> PO No. </th><th> SKU Code </th><th> Description </th><th> PO Req </th><th> Requirements </th><th> Priority</th><?php$sql = "SELECT ETD, PO_No, SKUCode, Description, POReqFROM sales_order";$res_so = mysql_query($sql, $con);$Approved = isset($_POST['priority']);if ($Approved){    $PO_No = $_POST['PO_No'];//----I want to display only the jo_number after click the approved button and it only display on the row where I click the approved button---    $sql = "SELECT jo_number FROM job_order ORDER BY jo_date DESC LIMIT 1";	    $result = mysql_query($sql, $con);	   	    if (!$result) {		    echo 'failed';		    die();	    }	    $total = mysql_num_rows($result);	    if ($total <= 0) {		    $currentSRNum = 1;			 $currentYear  = (int)(date('y'));		    $currentMonth = (int)(date('m'));		    $currentDay = (int)(date('d'));		  		    $currentSRYMD = substr($row['jo_number'], 0, 6);		    $currentYMD = date("ymd");		    if ($currentYMD > $currentSRYMD)		    { 			    $currentSRNum = 1;		    }		    else		    { 			    $currentSRNum += 1;		    }					    }	    else {//----------------------------------------		    $row = mysql_fetch_assoc($result);		   		    $currentSRNum = (int)(substr($row['jo_number'],0,3));		   		    $currentSRYear  = (int)(substr($row['jo_number'],2,2));		    $currentSRMonth = (int)(substr($row['jo_number'],0,2));		    $currentSRNum = (int)(substr($row['jo_number'],6,4));		    $currentYear  = (int)(date('y'));		    $currentMonth = (int)(date('m'));		    $currentDay = (int)(date('d'));		  		    $currentSRYMD = substr($row['jo_number'], 0, 6);		    $currentYMD = date("ymd");		    if ($currentYMD > $currentSRYMD)		    { 			    $currentSRNum = 1;		    }		    else		    { 			    $currentSRNum += 1;		    }										  	    }			    $yearMonth = date('ymd');   	    $currentSR = $currentYMD . sprintf("%04d", $currentSRNum); //JO_No}while($row = mysql_fetch_assoc($res_so)){echo "<form name='joborder_form' action='' method='post'>";$PO_No = $row['PO_No']; echo "<tr><td><input type='text' name='JO_No' id='JO_No' value='$currentSR' style='border:none;width:auto;' size='10'></td><td><input type='text' name='ETD' id='ETD' value='$row[ETD]' style='border:none;width:auto;' size='10'></td><td><input type='text' name='PO_No' id='PO_No' value='$row[PO_No]' style='border:none;' size='30'></td><td><input type='text' name='SKUCode' id='SKUCode' value='$row[sKUCode]' style='border:none;' size='15'></td><td><input type='text' name='Description' id='Description' value='$row[Description]' style='border:none;' size='35'></td><td><input type='text' name='POReq' id='POReq' value='$row[POReq]' style='border:none;width:auto;' size='10'></td><td> </td><td><input type='submit' name='priority' value='Approved' id='priority'></td></tr>";echo "</form>";}?></table></div></body></html>

Any help is highly appreciatedThank you

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...