home *** CD-ROM | disk | FTP | other *** search
/ csi.uticak12.org / csi.uticak12.org.tar / csi.uticak12.org / back / photos_edit.php < prev    next >
PHP Script  |  2011-10-20  |  4KB  |  108 lines
  1. <?
  2. include 'guard.php';
  3. mysql_connect(HostName,UserName,Password) or die("<html><body>Can not connect to MySql server!<br></body></html>");
  4. mysql_select_db (DBName) or die ("<html><body>Could not select database ".DBName."<br></body></html>");
  5.  
  6. if ($act=='1') {
  7. $ftitle=addslashes($ftitle);
  8. $fvideo=addslashes($fvideo);
  9.  
  10. $query=mysql_query("UPDATE `gal_photos` SET `video`='$fvideo', `approved`='$fapproved', `cat_id`='$fcat_id', `title`='$ftitle' WHERE `id`='$id'") or die (mysql_error());
  11.  
  12. $photo_id=$id;
  13. $filename=$_FILES['bpic2']['tmp_name'];
  14. if ($filename!="") {
  15. if (file_exists('photos/photo_'.$photo_id.'.jpg')) {unlink ('photos/photo_'.$photo_id.'.jpg');};
  16. copy ($filename, 'photos/photo_'.$photo_id.'.jpg'); 
  17. };
  18.  
  19. echo '<script>location.href="photos.php?pn='.$pn.'&cat_id='.$cat_id.'&title='.$title.'"</script>';
  20. } else {
  21. $query=mysql_query("SELECT * FROM `gal_photos` WHERE `id`='$id'") or die (mysql_error());
  22. $f=mysql_fetch_array($query);
  23. $ftitle=stripslashes($f['title']);
  24. $fvideo=stripslashes($f['video']);
  25. $fcat_id=$f['cat_id'];
  26. $fapproved=$f['approved'];
  27. };
  28.  
  29. ?>
  30.  
  31.  
  32. <?    $header = "Photos - Edit entry";
  33.     include ('top.inc'); ?>
  34.  
  35.  
  36. <form action="photos_edit.php?id=<?=$id?>&pn=<?=$pn?>&cat_id=<?=$cat_id?>&title=<?=$title?>" method="post" name="form1" ENCTYPE="multipart/form-data">
  37. <table border=0 cellspacing=0 cellpadding=5 align=center width="100%">
  38.     <tr>
  39.         <td class="border">
  40.             <table border=0 cellspacing=1 cellpadding=5 width="100%" class="back">
  41.                 <tr>
  42.                     <td class="th" colspan=2><p align="center">Photo</p></td>
  43.                 </tr>
  44.                 <tr>
  45.                     <td class="even" align=right width="40%"><b>Approved:</b></td>
  46.                     <td class="even"><input type="checkbox" name="fapproved" value="1" <? if ($fapproved=='1') {echo 'checked';};?>></td>
  47.                 </tr>
  48.                 <tr>
  49.                     <td width="40%" align="right" class="odd"><strong>Title:</strong></td>
  50.                     <td class="odd"><input type="text" size="70" class="inp" name="ftitle" value="<?=$ftitle?>"></td>
  51.                 </tr>
  52.                 <tr>
  53.                     <td class="even" align=right width="40%"><b>Gallery:</b></td>
  54.                     <td class="even" align="left">
  55.                         <select name="fcat_id" class="inp">
  56.                         <option value="">-- please select --</option>
  57.  
  58. <?
  59. $res=mysql_query("SELECT * FROM `gal_cats` ORDER BY `title`");
  60. while ($f=mysql_fetch_array($res)) {
  61. if ($fcat_id==$f['id']) {$add="selected";} else {$add="";};
  62. echo '<option value="'.$f['id'].'" '.$add.'>'.stripslashes(ucfirst(strtolower($f['title']))).'</option>'; 
  63. };
  64. ?>
  65.                         </select>
  66.                     </td>
  67.                 </tr>
  68.                 <tr>
  69.                     <td colspan="2" align="center" class="odd">
  70.                             <img src="
  71. <?
  72. if (file_exists("photos/photo_".$id.".jpg")) {
  73. echo "photos/photo_".$id.".jpg";} else {
  74. echo "int/0.gif";
  75. };
  76. ?>
  77.  
  78.                                                     " alt="" height="100" name="img_big2" border="1"><br><br>
  79.                     </td>
  80.                 </tr>
  81.                 <tr>
  82.                     <td class="even" align=right width="40%">
  83.                         <b>Browse image:</b>
  84.                     </td>
  85.                     <td class="even">
  86.                         <input type="file" size="30" class="inp" name="bpic2" onFocus="if (form1.bpic2.value!='') {document.all['img_big2'].src=form1.bpic2.value; form1.bpic2.value=form1.bpic2.value;}">
  87.                     </td>
  88.                 </tr>
  89.                 <tr>
  90.                     <td width="40%" align="right" class="odd"><strong>Video HTML code:</strong></td>
  91.                     <td class="odd"><textarea cols="70" rows="5" class="inp" name="fvideo"><?=$fvideo?></textarea></td>
  92.                 </tr>
  93.  
  94.                 <tr>
  95.                     <td class="tf" align=center colspan="2">
  96.                     <input type=submit class="btn" value="Save"> 
  97.                     <input type=button class="btn" value="Cancel" onClick="location.href='photos.php?pn=<?=$pn?>&cat_id=<?=$cat_id?>&title=<?=$title?>'">
  98.                     </td>
  99.                 </tr>
  100.             </table>
  101.         </td>
  102.     </tr>
  103. </table>
  104.  
  105. <input type="hidden" name="act" value="1">
  106. </form>
  107.  
  108. <? include ('btm.inc'); ?>