Advertisement
Guest User

Untitled

a guest
Aug 31st, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";// Host name
  3. $username="root"; // Mysql username
  4. $password=""; // Mysql password
  5. $db_name="song"; // Database name
  6.  
  7. $conn = new mysqli($servername, $username, $password,$db_name);
  8. $id=$_POST['id'];
  9. $val=$_POST['like'];
  10.  
  11. // Check connection
  12. if ($conn->connect_error) {
  13. die("Connection failed: " . $conn->connect_error);
  14. } else{
  15. //echo "Connected successfully "."<br />\r\n";
  16. }
  17. $jsonData = array();
  18. $jsonTempData = array();
  19. $sql = "UPDATE audio SET SCORE=SCORE+'$val' WHERE NO='$id'";
  20. $result = $conn->query($sql);
  21. $jTempData['song'] =$result;
  22. $jsonData[]=$jTempData;
  23. $conn->close();
  24.  
  25. $outputArr['song'] =$jsonData;
  26. // Encode Array To JSON Data
  27. print_r( json_encode($outputArr));
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement