Може ли да се направи админ панел ?

nobody21

Registered
Здравейте,хора може ли някой да направи админ панел за тази системка която проба е дал за ФЛВ видео ...

и ако може видеотата да се одобряват
Знам че искам много но моля ако някой може да помогне и ще пуснем скритпа като урок :)

config.php :

Код:
<?php 
$user = "потребител"; 
$pass = "парола"; 
$db = "база данни"; 
$host = "хост"; 
$connection = mysql_connect("$host", "$user", "$pass") or die(mysql_error()); 
$db = mysql_select_db("$db",$connection)or die(mysql_error()); 
?>


addclip.php

Код:
<?php 
include_once "config.php"; 
?> 
<style> 
fieldset 
{ 
width: 400px; 
background: #ffffff; 
} 
</style> 
<center> 
<fieldset> 
<legend>Добави Клип</legend> 
<form method="POST"> 
<table> 
<tr> 
<td>Име на клипа:</td><td> 
<input type="text" name="ime" class="input"> 
</td> 
</tr> 
<tr> 
<td width="40%"> 
URL на клипчето:</td> 
<td> 
<input type="text" name="url" class="input"> 
</td> 
</tr> 
<tr> 
<td>URL на картинка:</td> 
<td> 
<input type="text" name="kartinka" class="input"> 
</td> 
</tr> 
</table> 
<br><input name="clips" type="submit" value="Добави Клипа!" class="button"> 
</form> 
</fieldset> 
<?php 
if($_POST['clips']) 
{ 
$video = $_POST['url']; 
$kartinka = $_POST['kartinka']; 
$title = $_POST['ime']; 
$query = mysql_query("INSERT INTO `clips` (ime, url, pic) VALUES('$title','$video','$kartinka')") or die(mysql_error()); 
echo '<br>Клипът е добавен успешно!'; 
} 
echo "</center>"; 
?>



clips.php :

Код:
<?php 
include_once "config.php"; 
echo '<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">'; 
if(!isset($_GET['page'])) 
{ 
$page = 1; 
} 
else 
{ 
$page = $_GET['page']; 
} 
echo "<table bgcolor='white' border='1' style='border-collapse: collapse' bordercolor='#cccccc' width='765'>"; 
echo "<tr>"; 
$max_results = 20; 
$from = (($page * $max_results) - $max_results); 
// старт 
$mysql = mysql_query("SELECT * FROM clips ORDER BY id DESC LIMIT $from, $max_results"); 
echo"<table border=\"0\" cellspacing=\"2\" align=\"center\"><tr>"; 
while($r = mysql_fetch_array($mysql)) 
{ 
$vid=$r['id']; 
$title=$r['ime']; 
$pic=$r['pic']; 
if($pic != null) 
{ 
echo "<td><center><a href='view.php?id=$vid' title='$title'><img src='$pic' border='0' alt='$title' width='120' height='90'></a></center></td>"; 
$i++; 
} 
else 
{ 
echo "<td><center><a href='view.php?id=$vid' title='$title'><img src='no.jpg' border='0' alt='$title'></a></center></td>"; 
$i++; 
} 
if($i > 4) 
{ 
echo"</tr><tr>";$i = "0"; 
} 
} 
echo"</tr></table>"; 
echo "<br>"; 
echo "<center>Страници:  "; 
// стоп 
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM clips"),0); 
$total_pages = ceil($total_results / $max_results); 
if($page > 1){ 
$prev = ($page - 1); 
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"></a> "; 
} 

for($i = 1; $i <= $total_pages; $i++){ 
if(($page) == $i){ 
echo "$i "; 
} else { 
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; 
} 
} 
if($page < $total_pages){ 
$next = ($page + 1); 
echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\"></a>"; 
} 
echo "</center>"; 
?>


view.php :

Код:
<?php 
include_once "config.php"; 
$gid=$_GET['id']; 
$query = "SELECT * FROM clips where id='$gid'"; 
$result = mysql_query($query); 
while($r=mysql_fetch_array($result)) 
{ 
$url=$r[url]; 
$ime=$r['ime']; 
echo "<center>"; 
echo "<b>Вие гледате:</b>   <b><font color='red'>$ime</b></font><br>"; 
?> 
<script type="text/javascript" src="swfobject.js"></script> 
<div id="flashcontent"></div> 
<script type="text/javascript"> 
var so = new SWFObject("video.swf?videoPath=<?php echo "$url"; ?>&autoStart=true&volAudio=60&newWidth=480&newHeight=385&disableMiddleButton=false&playSounds=true&soundBarColor=0x0066FF&barColor=0x0066FF&barShadowColor=0x91BBFB&subbarColor=0xffffff", "sotester", "480", "385", "9", "#efefef"); 
so.addParam("allowfullscreen","true"); 
so.write("flashcontent"); 
</script> 
<?php 
echo "<a href='$url' target='_blank' title='Свали'><font color='#000000'>Свали клипа</font></a>"; 
echo "</center>"; 
} 
?>
 
опа сорка пропуснал съм го

Код:
CREATE TABLE `clips` 
( 
`id` int(11) NOT NULL auto_increment, 
`ime` varchar(255) NOT NULL, 
`url` varchar(255) NOT NULL, 
`pic` text NOT NULL, 
PRIMARY KEY (`id`) 
) 
ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
 
на мен неможе да ми се гледат клиповете.
 

Горе