Preview It (32) PHP help...?

[puretaurus21]

Okay, I don't really get it :S. I tried experimenting and I made this  

Code:

$id = trim($_GET['id']);

$mode = mysql_escape_string($_GET['type']);

if (!isset($type) || empty($type))
{   $type = 'index';   }

switch($type)
{  
     case 'templates';

$q="SELECT download from templates where id='$id'";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$download = $row['download'];

$q2="update templates set counter=counter+1 where id='$id'";
$result2= mysql_query($q2) or die
("Could not execute query : $q2." . mysql_error());

if ($result2) // updated counter so let user download file
{
header('Location: '.$download );
} #end result2

} #end while

   break;

   case 'avatars';

$q="SELECT download from avatars where id='$id'";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$download = $row['download'];

$q2="update avatars set counter=counter+1 where id='$id'";
$result2= mysql_query($q2) or die
("Could not execute query : $q2." . mysql_error());

if ($result2) // updated counter so let user download file
{
header('Location: '.$download );
} #end result2

} #end while

break;

}

I uploaded that code but it didn't work. I really didn't get you about what it say on the code you told before about the update query thing because theres two :S

[Melfina]

You only need to add the connection stuff there. I really don't think you need to add the $id = trim($_GET['id']); thing there. Try first with it and remove it if it doesn't work well:

Code:

<?php

$id = trim&#40;$_GET['id'&#93;&#41;;

$type = mysql_escape_string&#40;$_GET['type'&#93;&#41;; 

if &#40;!isset&#40;$type&#41; || empty&#40;$type&#41;&#41; 
&#123;   $type = 'index';   &#125; 

switch&#40;$type&#41; 
&#123;  
     case 'templates';

$hostname="localhost";
$user="yourusernamehere";
$pass="yourpasshere";
$dbase="yourdatabasenamehere"; 
$connection = mysql_connect&#40;"$hostname" , "$user" , "$pass"&#41;;
$db = mysql_select_db&#40;$dbase , $connection&#41;;

$q="SELECT download from templates where id='$id'";
$result= mysql_query&#40;$q&#41; or die
&#40;"Could not execute query &#58; $q." . mysql_error&#40;&#41;&#41;;

while &#40;$row=mysql_fetch_array&#40;$result&#41;&#41;
&#123;
$download = $row['download'&#93;;

$q2="update templates set counter=counter+1 where id='$id'";
$result2= mysql_query&#40;$q2&#41; or die
&#40;"Could not execute query &#58; $q2." . mysql_error&#40;&#41;&#41;;

if &#40;$result2&#41; // updated counter so let user download file
&#123;
header&#40;'Location&#58; '.$download &#41;;
&#125; #end result2

&#125; #end while

   break; 

   case 'avatars';

$hostname="localhost";
$user="yourusernamehere";
$pass="yourpasshere";
$dbase="yourdatabasenamehere"; 
$connection = mysql_connect&#40;"$hostname" , "$user" , "$pass"&#41;;
$db = mysql_select_db&#40;$dbase , $connection&#41;;


$q="SELECT download from avatars where id='$id'";
$result= mysql_query&#40;$q&#41; or die
&#40;"Could not execute query &#58; $q." . mysql_error&#40;&#41;&#41;;

while &#40;$row=mysql_fetch_array&#40;$result&#41;&#41;
&#123;
$download = $row['download'&#93;;

$q2="update avatars set counter=counter+1 where id='$id'";
$result2= mysql_query&#40;$q2&#41; or die
&#40;"Could not execute query &#58; $q2." . mysql_error&#40;&#41;&#41;;

if &#40;$result2&#41; // updated counter so let user download file
&#123;
header&#40;'Location&#58; '.$download &#41;;
&#125; #end result2

&#125; #end while

break; 

&#125; 

?>

[puretaurus21]

Oh thanks, Melfina! It worked very well. Thank you for helping me, I'll make sure to credit you :D

[Arwen]

Thanks for posting the tutorial, BUT I think I'm stuck! I created a table in my MySQL database made two files (view.php and download.php), uploaded them to my server AND now I'm stuck! What do I do next? Please, help!!!!!!!!!!!!

[Blackstone]

Erm, how are you stuck? Can you give us some more details?

[Arwen]

Well, just like I said, I created a table in my MySQL database, created two files (view.php and download.php), uploaded them to my server and I don't know what to do next. Do I need to add my .zip files to the database or something...?  :?

[Blackstone]

You need to enter information into your database. It all really depends on how you've set up the databases and the PHP files.