Jump to content

Please help!!!


yousamook

Recommended Posts

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: :confused: :o

Link to comment
https://forums.phpfreaks.com/topic/232808-please-help/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.