yousamook Posted April 5, 2011 Share Posted April 5, 2011 hi everyone! So i need to get a users input from my form so i created a table with PHP that basically throws out the information and creates multiple positions in that table. the code i used was this: <?php $exit = "<table border=0 ><tr><td align=left colspan=600>"; $exit .= "<tr> <td ><span class=underline>Description</span></td> <td ><span class=underline>Date Received</span></td> <td ><span class=underline>Date Issued</span></td> <td ><span class=underline>Date Expired</span></td> <td ><span class=underline>Certificate or License Number</span></td> </tr>"; $db = new dbConnection(); $db->dbConnect(); $db->dbSelect(); $query_doc = " select dt.uniqueid, dt.description , formatDate(pd.date_received) as date_received, formatDate(date_inservice) as date_inservice, formatDate(date_expired) as date_expired, license from document_types dt left join personnel_document pd on (pd.doc_type = dt.uniqueid and pd.empnum = $EmpNum) order by 2"; $ds = mssql_query($query_doc); $exit .= "<input type=hidden value='" . mssql_query($ds). "' id=ciclos name=ciclos>"; $position = 1; while ($row = mssql_fetch_array($ds)) { extract($row); $exit .= "<tr> <td><span class=doc_style><label for = description$position> $description</label></span></td> <td><input type=text name= date_received$position id= date_received$position size=15 value= '$date_received' ></td> <td><input type=text name = date_inservice$position id= date_inservice$position value= ' $date_inservice' size=15></td> <td><input type=text name= date_expired$position id= date_expired$position value= ' $date_expired' size=15></td> <td><input type=text name = license id= license value= ' $license' size=30></td> </tr>"; $position++; } $exit .= "</td></tr></table>"; echo $exit; ?> now what that does if you do a : $keys = array_keys($_POST); $values = array_values($_POST); for ($i = 0; $i <= count($keys); $i++) echo "{$keys[$i]} = {$values[$i]} <br>"; is take out the information from the post and number it from 1 to 15 as show here : date_received1 = date_inservice1 = date_expired1 = license1 = date_received2 = date_inservice2 = date_expired2 = license2 = date_received3 = date_inservice3 = date_expired3 = license3 = date_received4 = date_inservice4 = date_expired4 = license4 = date_received5 = date_inservice5 = date_expired5 = license5 = date_received6 = date_inservice6 = date_expired6 = license6 = date_received7 = date_inservice7 = date_expired7 = license7 = etc..... I need to make an update statement to update my MS SQL with the user input but not sure how to do it... I dont want to do 15 different updates.... does anyone know a better way to get ths information into an update statement? Someone please help me with this issue! :confused: Link to comment https://forums.phpfreaks.com/topic/232808-please-help/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.