erp_upload.php 1017 B

12345678910111213141516171819202122232425262728293031
  1. <?php
  2. //mysql server
  3. $dbserver = "localhost";
  4. $dbuser = "root";
  5. $dbpass = "Gold@53743001";
  6. $dbname = "app";
  7. //$con =mysqli_connect($dbserver,$dbuser,$dbpass,$dbname);
  8. date_default_timezone_set('Asia/Taipei');
  9. echo date('Y-m-d H:i:s');
  10. $date= date("'Y-m-d H:i:s'");
  11. $pd_name= $_POST["Name"];
  12. $count= $_POST["Count"];
  13. $location= $_POST["Location"];
  14. //$img= $_POST["Img"];
  15. $con =mysqli_connect($dbserver,$dbuser,$dbpass,$dbname);
  16. if ($con->connect_error) {
  17. die("connect error: " . $con->connect_error);
  18. }
  19. if (empty($name).empty($job).empty($account).empty($password)){
  20. echo 'value :null';
  21. }else{
  22. $sql = "INSERT INTO `erp_app`(`Date`,`Name`, `Count`, `Location`) VALUES(now(),'$pd_name','$count','$location')";
  23. mysqli_query($con,$sql) or die(mysqli_error($con). "<hr/>Line:".__LINE__."br/>$sql");
  24. mysqli_close($con);
  25. echo 'OK';}
  26. //}else echo 'failed';
  27. //echo $data;
  28. ?>