Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "localhost";// Host name
- $username="root"; // Mysql username
- $password=""; // Mysql password
- $db_name="song"; // Database name
- $conn = new mysqli($servername, $username, $password,$db_name);
- $id=$_POST['id'];
- $val=$_POST['like'];
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- } else{
- //echo "Connected successfully "."<br />\r\n";
- }
- $jsonData = array();
- $jsonTempData = array();
- $sql = "UPDATE audio SET SCORE=SCORE+'$val' WHERE NO='$id'";
- $result = $conn->query($sql);
- $jTempData['song'] =$result;
- $jsonData[]=$jTempData;
- $conn->close();
- $outputArr['song'] =$jsonData;
- // Encode Array To JSON Data
- print_r( json_encode($outputArr));
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement