Guest User

Untitled

a guest
Feb 12th, 2019
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. Warning: fopen(/store/secure/mas/) [function.fopen]: failed to open stream: No such file or directory in /getdetails.php on line 15
  2.  
  3. Warning: fputs(): supplied argument is not a valid stream resource in /getdetails.php on line 36
  4.  
  5. Warning: fclose(): supplied argument is not a valid stream resource in /getdetails.php on line 39
  6.  
  7. <?php
  8.  
  9. $MYSQL_HOST="localhost";
  10. $MYSQL_USERNAME="***";
  11. $MYSQL_PASSWORD="***";
  12. $MYSQL_DATABASE="shop";
  13. $MYSQL_TABLE="ds_orders";
  14. mysql_connect( "$MYSQL_HOST", "$MYSQL_USERNAME", "$MYSQL_PASSWORD" ) or die( mysql_error( ) );
  15. mysql_select_db( "$MYSQL_DATABASE") or die( mysql_error( $conn ) );
  16.  
  17.  
  18. $filename="Order_Details";
  19. $directory = "/store/secure/mas/";
  20. $csv_filename = $filename.".csv";
  21.  
  22. $fd = fopen ( "$directory" . $cvs_filename, "w");
  23.  
  24.  
  25. $today="2009-03-17";
  26. $disp_date="05122008";
  27. $sql = "SELECT * FROM $MYSQL_TABLE where cDate='$today'";
  28.  
  29. $result=mysql_query($sql);
  30. $rows=mysql_num_rows($result);
  31. echo $rows;
  32. if(mysql_num_rows($result)>0){
  33.  
  34. $fileContent="Record ID,Discount Percentn";
  35. while($data=mysql_fetch_array($result))
  36. {
  37.  
  38. $fileContent.= "".$data['oID'].",".$data['discount']."n";
  39. }
  40.  
  41.  
  42. $fileContent=str_replace("nn","n",$fileContent);
  43. fputs($fd, $fileContent);
  44. }
  45.  
  46. fclose($fd);
  47. ?>
Add Comment
Please, Sign In to add comment