Advertisement
Guest User

Test_Insert

a guest
Jan 22nd, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.16 KB | None | 0 0
  1. <?php
  2. echo "ok";
  3.  
  4. $servername = "localhost";
  5. $username = "exodus";
  6. $password = "exodus1";
  7. $dbname = "exodus";
  8. $id = 1;
  9. $on = $_POST['operation_number'];
  10. $oa = $_POST['operation_amount'];
  11. $od = $_POST['operation_datetime'];
  12. $em = $_POST['email'];
  13.  
  14.  
  15. echo $id." ".$on." ".$oa." ".$od." ".$em."<br>";
  16.  
  17.  
  18. // Create connection
  19. $conn = new mysqli($servername, $username, $password, $dbname);
  20. // Check connection
  21. if ($conn->connect_error) {
  22.     die("Connection failed: " . $conn->connect_error);}
  23.  
  24.  
  25. $sql2 = mysql_query('insert into exodus VALUES('$id','$on','$oa','$od','$em')');
  26. if ($conn->query($sql) === TRUE) {
  27.     echo "New record created successfully";
  28. } else {
  29.   echo "Error: " . $sql2 . "<br>" . $conn->error;}
  30.  
  31. echo"---<br>";
  32. echo $sql2;
  33.  
  34. $conn->close();
  35.  
  36.  
  37. //$result=mysql_query("select count(ile) as ile from test;");
  38. //$data=mysql_fetch_assoc($result);
  39. //echo "<br> ILE: ".$data['ile'];
  40. //$result2=mysql_query("select sum(ile) as sum from test;");
  41. //$data2=mysql_fetch_assoc($result2);
  42. //echo "<br> SUMA: ".$data2['sum'];
  43.  
  44.  
  45.  
  46.  
  47. mysql_close($connection);
  48. file_put_contents('dotpay.log', var_export($_POST, true), FILE_APPEND);
  49.  
  50. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement