"; $table = chop(fgets(STDIN)); if($table == 1){ $tablename = item_deji; }if($table == 2){ $tablename = item_kaden; }if($table ==3 ){ $tablename = item_pc; }if($table == 4){ $tablename = item_ofice; }if($table == 5){ $tablename = item_cdvd; }else{ exit; } print "ID =>"; $ID = chop(fgets(STDIN)); print "name =>"; $name = chop(fgets(STDIN)); print "maker =>"; $maker = chop(fgets(STDIN)); print "price =>"; $price = chop(fgets(STDIN)); print "point =>"; $point = chop(fgets(STDIN)); print "fix =>"; $fix = chop(fgets(STDIN)); print"number=>"; $number = chop(fgets(STDIN)); $sql="lock table ".$tablename." in exclusive mode nowait"; $stmt=oci_parse($con,$sql); $sql="insert into ".$tablename." values('$ID','$name','$maker','$price','$point', '$fix','$number')"; $stmt=oci_parse($con,$sql); if(!oci_execute($stmt,OCI_DEFAULT)){ oci_rollback($con); }else{ oci_commit($con); } oci_close($con); ?>