connParam, true ); if( $_POST['action'] == 'post' ) { $count = $conn->getOne( "select count(*) from $config->table where partnumber=" . $conn->quote($_POST['partnumber']) ); if( $count == 0 ) { // insert $fields = "partnumber,mfgPN,type,od,data1,data2,data3,data4,data5,data6,data7,data8,data9,realNum,intNum,price,imageURL,pdfloc"; //$sth = $conn->prepare( "insert into $config->table " . CDB::buildInsertSQL( $conn, $_POST, $fields ) ); $arFields = explode("," , $fields); $sql = "insert into $config->table ($fields) values ("; foreach( $arFields as $f ) { $sql .= "?,"; } $sql = trim($sql,",") . ")"; $sth = $conn->prepare( $sql ); // prepare sql $arValues = __getValues($arFields); // get the real values $result = $conn->execute( $sth, $arValues ); // execute sql } else { // update the item $fields = "mfgPN,type,od,data1,data2,data3,data4,data5,data6,data7,data8,data9,realNum,intNum,price,imageURL,pdfloc"; // $sth = $conn->prepare( "update $config->table set " . CDB::buildUpdateSQL( $conn, $_POST, $fields ) . " WHERE partnumber=?" ); $sth = $conn->prepare( "update $config->table set mfgPN=?,type=?,od=?,data1=?,data2=?,data3=?,data4=?,data5=?,data6=?,data7=?,data8=?,data9=?,realNum=?,intNum=?,price=?,imageURL=?,pdfloc=? WHERE partnumber=?"); $arFields = explode(",",$fields); $arValues = __getValues($arFields); array_push($arValues, $_POST['partnumber']); $result = $conn->execute( $sth, $arValues ); if( CDB::IsError( $result ) ) { print_r($result); die; } if( $_POST['link'] ) redirect( urlencode($_POST['link']) ); } $conn->disconnect(); redirect( 'add_part.php?type=' . urlencode($_POST['type']) ); die; } ?> add part getRow( "select $field from $config->table where partnumber=" . $conn->quote( $_GET['partnumber'] ), null, DB_FETCHMODE_ASSOC ); } $conn->disconnect(); ?>
cwsbytemark.com Data Entry Form v1.3 (Shared Data)
>

Type:

Part Number
 
mfgPN (AL mH/Sq.N, Power, Range)
O.D.
 
Data1
(Impedance, Dimension, Diameter, Inductance)
 
Data 2 (I.D, AL, Length, N1)
 
Data 3 (Hgt, Length, Material)
 
Data 4 (Material, Impedance@25, Desc)
 
Data 5 (Impedance@100)
 
Data 6
Data 7
Data 8
 
Data 9
Integer Number (intNum, usually maps to U=)
Price US$
 
Image URL
 
PDF Loc
 
Coilws.com, Inc employees only.