From ali, 6 Years ago, written in Plain Text.
Embed
  1. <?php
  2.  
  3. include("includes/db.php");
  4. //purchase.php
  5. if(isset($_REQUEST["lot"]))
  6. {
  7.         // echo "<pre>";
  8.         // print_r($_REQUEST);
  9.         // die;
  10.         $lot=$_REQUEST["lot"];
  11.         $pdate=$_REQUEST["pdate"];
  12.         $operator=$_REQUEST["operator"];
  13.         $iname=$_REQUEST["iname"];
  14.         $qty=$_REQUEST["qty"];
  15.         $disc=$_REQUEST["disc"];
  16.         $rate=$_REQUEST["rate"];
  17.         $amnt=$_REQUEST["amnt"];
  18.         $file=$_FILES["file"]["name"];
  19.         $tmp_name=$_FILES["file"]["tmp_name"];
  20.         $path="image/".$file;
  21.         move_uploaded_file($tmp_name,$path);
  22.         $comment=$_REQUEST["comment"];
  23.         mysqli_query($con,"insert into purchased(lot,pdate,operator,item_name,quantity,discount,rate,amount,file,comment)values('$lot','$pdate','$operator','$iname','$qty','$disc','$rate','$amnt','$file','$comment')");
  24. }
  25. ?>
  26.  
  27. <!DOCTYPE html>
  28. <html>
  29. <head>
  30. <meta charset="utf-8" />
  31. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  32. <title>Page Title</title>
  33. <meta name="viewport" content="width=device-width, initial-scale=1">
  34. <link rel="stylesheet" type="text/css" media="screen" href="main.css" />
  35. <script src="main.js"></script>
  36. </head>
  37. <body>
  38.  
  39.  
  40. <form method="post"  enctype="multipart/form-data">
  41.  
  42. Lot # :<Input type="text" name="lot" required><br><br>
  43.  
  44. Date:<Input type="text" name="pdate" required><br><br>
  45.  
  46. Operator :<Input type="radio"name="operator"value="Zong" required>Zong<Input type="radio"name="operator"value="Telenor" required>Telenor<Input type="radio"name="operator"value="Jazz" required>Jazz
  47. </select><br><br>
  48.  
  49. Item-Name:
  50. <?php $filename = 'includes/iname.txt';
  51. $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
  52. echo '<select name="iname" id="value" required>';
  53. echo "<option value=''>Select Anyone</option>";
  54. foreach($eachlines as $lines){
  55. echo "<option value='{$lines}'>{$lines}</option>";
  56. }
  57. echo '</select>'; ?><br><br>
  58.  
  59. Quantity:<Input type="text" name="qty"><br><br>
  60.  
  61. Discount:<Input type="text" name="disc"><br><br>
  62.  
  63. Rate:<Input type="text" name="rate"><br><br>
  64.  
  65. Amount:<Input type="text" name="amnt"><br><br>
  66.  
  67. File Upload
  68. <input type="file" name="file">
  69. <br><br>
  70.  
  71. Comments:<Input type="text" name="comment" required><br><br>
  72. <Input type="submit" value="insert" name="submit">
  73.  
  74. </form>
  75.  
  76. </body>
  77.  
  78. </html>