Sahnarts APP / kullanıcıların yüklediği videoların ana akış da gösterimesi için kullanılan web servis.

sahnartsvideoakis.php

<?php





if($_SERVER['REQUEST_METHOD']=='POST'){
	
$servername = "delete";
$username = "delete";
$password = "delete";
$dbname = "delete";

	$mailx  = $_POST["mailx"];

	
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

	
	
	
	
$v = $conn->prepare("select * from register where mail='$mailx' AND videoname=?    ");
$v->execute(array('1'));

$statement = $conn->prepare("SELECT username, mail, durum,imagename,tconay,videoname FROM register where videoname != 1 ");
$statement->execute();
$array = $statement->fetchAll(PDO::FETCH_ASSOC);
				$result["employees"] = $array;

		echo json_encode($result);
	

    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
}
	
?>