Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('install_lang_japanese.php');
- include('functions.php');
- if (phpversion() >='4.1.0') {
- include_once('vars4.1.0.php');
- }else {
- include_once('vars4.0.6.php');
- }
- //connect to database
- $dbc=mysql_connect(_SRV,_ACCID,_PWD) or die(_ERROR15.": ".mysql_error());
- $db=mysql_select_db("QPL",$dbc) or die(_ERROR17.": ".mysql_error());
- $target_path = "data/";
- $target_path = $target_path . basename( $_FILES['uploadedfile']['name']);
- //print_r($_FILES);
- if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
- echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
- }
- else{
- echo "There was an error uploading the file, please try again!";
- }
- switch(postVar('action')) {
- case 'oqcdata' :
- oqcdata(postVar('mod'),postVar('no'),postVar('lotno'),postVar('date'),
- postVar('sym'),postVar('coz'),postVar('stat'),postVar('cm'),postVar('detail'));
- break;
- }
- function oqcdata($mod,$no,$lotno,$date,$sym,$coz,$stat,$cm,$detail) {
- $Model = mysql_real_escape_string($mod);
- $Serial = mysql_real_escape_string($no);
- $Lot = mysql_real_escape_string($lotno);
- $Date = mysql_real_escape_string($date);
- $Sym = mysql_real_escape_string($sym);
- $Coz = mysql_real_escape_string($coz);
- $Stat = mysql_real_escape_string($stat);
- $CM = mysql_real_escape_string($cm);
- $Detail = mysql_real_escape_string($detail);
- $Model = strtoupper($Model);
- $Serial = strtoupper($Serial);
- $Lot = strtoupper($Lot);
- $Sym = stripcslashes($Sym);
- $Coz = stripcslashes($Coz);
- $Stat = stripcslashes($Stat);
- //build query
- $sql = "INSERT INTO OQC ";
- $sql.= "(Model, Serial, Lotno, Date, Symptom, Cause, Status, CM,Detail) ";
- $sql.= "VALUES ('";
- $sql.= $Model."','".$Serial."','".$Lot."','".$Date."','".$Sym."','".$Coz."','";
- $sql.= $Stat."','".$CM."','".$Detail."')";
- echo $sql;
- $result=mysql_query($sql) or die(_ERROR26.": ".mysql_error());
- echo $result;
- mysql_close($dbc);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement