PHP code embeddeed Youtube
<script language="JavaScript">
function buka(url) {window.open(url, 'window_baru', 'width=800,height=600,left=320,top=100,resizable=1,scrollbars=1');}
</script>
<a href='#' onclick='buka(\"video/playvideo.php?kode=$kode_video\")'>$link_video</a>
=======================================================
playvideo.php
<?php
include"../konmysqli.php";
echo"<link href='../$PATH/$css' rel='stylesheet' type='text/css' />";
$kode_video=$_GET["kode"];
$sql="select * from `$tbvideo` where `kode_video`='$kode_video'";
$d=getField($conn,$sql);
$kode_video=$d["kode_video"];
$kode_video0=$d["kode_video"];
$kode_matpel=$d["kode_matpel"];
$judul_video=$d["judul_video"];
$deskripsi=$d["deskripsi"];
$link_video=$d["link_video"];
$hits=$d["hits"];
$status=$d["status"];
$sql="update `$tbvideo` set hits=hits+'1' where `kode_video`='$kode_video'";
$up=process($conn,$sql);
$ytarray=explode("/", $link_video);
$ytendstring=end($ytarray);
$ytendarray=explode("?v=", $ytendstring);
$ytendstring=end($ytendarray);
$ytendarray=explode("&", $ytendstring);
$ytcode=$ytendarray[0];
echo "<iframe width=\"100%\" height=\"500\" src=\"http://www.youtube.com/embed/$ytcode\" frameborder=\"0\" allowfullscreen></iframe><br>link_video :$link_video";
?>
<?php
function getJum($conn,$sql){
$rs=$conn->query($sql);
$jum= $rs->num_rows;
$rs->free();
return $jum;
}
function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}
function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
$rs->free();
return $arr;
}
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}
?>
konmysqli.php
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
if ($conn->connect_error) {
trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR);
}

Komentar
Posting Komentar