Getting Info from DB

[Keith_Scott]

I am new to php and learning as I go, so bear with me. I have a database created with a field called username. I have a redirect script running that will redirect based on u/n, but I only want the files in their directory to be listed. I am getting all the folders in my audio directory . For some reason, it's not going the extra step and going to their folder. The folder name and username are the same.

Here is part of the code:

<?php


//prevents caching
header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();

session_start();

//require the config file
require ("/home/usr/public_html/downloads/config.php");
require ("/home/usr/public_html/downloads/functions.php");

//make the connection to the database
$connection = @mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = @mysql_select_db($db_name,$connection)or die(mysql_error());

//make query to database
$sql ="SELECT * FROM $table_name WHERE username= 'username'";
$result = @mysql_query($sql,$connection) or die(mysql_error());
$row = get("SELECT * FROM $table_name WHERE username = $username");

// Some functions
function get_database_row($s_db_query, $s_db_connstring="") {


if ($s_db_connstring == "") {
	global $db_connstring;
	$connstring = $db_connstring;
} else {
	$connstring = $s_db_connstring;
}

$file_list = getDirFiles("/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/");

$count = count($file_list);

?>

Any help would be appreciated and thanks in advance.

[Smeep]

What's your code?

[Keith_Scott]

That would help...see first post. I edited to include code.

Thanks

[Smeep]

Heh, I learned that the hardway too. This one also:

wrap these around your code

[ php]
[ /php]

without the space between the [p and [/

[rincewind456]

Whats this line do?

$row = get("SELECT * FROM $table_name WHERE username = $username");

This line

$sql ="SELECT * FROM $table_name WHERE username= 'username'";

is only going to return results where username is equal to username.
I think you'll want it to look like this

$sql ="SELECT * FROM $table_name WHERE username= '$username'";

[Keith_Scott]

So the $sql line will get username within the table and then "insert" that into the

$file_list = getDirFiles("/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/");

line? Should I remove the $row?

[rincewind456]

No you need to fetch the result from the DBwith something like this

$row = mysql_fetch_array($result);

And then you will have to make $row a global within the function get_database_row()

[Keith_Scott]

Um..ok. Not really sure how to go about that.

[rincewind456]

Next to the line

global $db_connstring;

put

global $row;

[Keith_Scott]

Ok. Did all that, now get:

Parse error: parse error, unexpected T_VARIABLE, expecting ',' or ';' in /home/usr/public_html/downloads/audio2.php on line 31

Line 31 is:

 $connstring = $db_connstring; 

Here is the updated code I am using:

<?php


//prevents caching
header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();

session_start();

//require the config file
require ("/home/usr/public_html/downloads/config.php");
require ("/home/usr/public_html/downloads/functions.php");

//make the connection to the database
$connection = @mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = @mysql_select_db($db_name,$connection)or die(mysql_error());

//make query to database
$row = mysql_fetch_array($result); 
$sql ="SELECT * FROM $table_name WHERE username= '$username'";
$result = @mysql_query($sql,$connection) or die(mysql_error());

// Some functions 
function get_database_row($s_db_query, $s_db_connstring="") { 


if ($s_db_connstring == "") { 
    global $db_connstring; global $row
    $connstring = $db_connstring; 
} else { 
    $connstring = $s_db_connstring; 
} 

$file_list = getDirFiles("/home/usr/public_html/downloads/audio/" . $row['username'] . "/"); 

$count = count($file_list); 

?>
<table border=0 width=100% bgcolor=0 cellpadding=5 cellspacing=0>
<tr>

	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		File Name (<?=$row['username'];?>)
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Size
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Date
	</b></td>

</tr>
<?
$size = 0;
for($i=0;$i<=$count;$i++) {

	$file = $file_list[$i];
	$path = "/home/usr/public_html/downloads/audio/" . $row['username'] . "/";
	if ($file != "index.php" && $file != "") {
		?>
			<tr>

				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<img src="/images/file.gif" align=middle> <a href="/audio/<?=$row['username']?>/<?=$file?>?key=<?=time()?>&validate=md5&log_user=<?=$userid?>"><?=$file?></a>
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=round(filesize($path . $file)/1024/1024, 2);?> MB
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=date("m/d/y H:i:s", filectime($path . $file));?>
				</td>

			</tr>
		<?
	}

}

   function getDirFiles($dirPath)
   {
     if ($handle = opendir($dirPath)) 
     {
         while (false !== ($file = readdir($handle))) 
             if ($file != "." && $file != "..") 
                 $filesArr[] = trim($file);

     closedir($handle);
 }  

 @sort($filesArr);    
 @reset($filesArr);
	return $filesArr;
   } 

function fsize($file){
       $size=0;
       $range = Array ('B', 'K', 'M', 'G');

   if(is_dir($file))
           if ($dh = opendir($file)){
                   while (($filecnt = readdir($dh)) !== false) {
                           if($filecnt == "." || $filecnt == "..")continue;
                           if(is_dir($file."/".$filecnt))
                                   $size += fsize($file."/".$filecnt);
                           else
                                   $size += filesize($file."/".$filecnt);
                           echo "\n$file/$filecnt";
                   }
                   closedir($dh);
           }else
                   return false;
   else
           $size = filesize($file);

   for ($i = 0; $size >= 1024 && $i < count($range); $i++)
           $size /= 1024;

   return round($filesize,2).$range[$i];
}

print("</td></tr></table>");

Thanks in advance...

[Keith_Scott]

I am beginning to think I have TOO much code in there. Reading other posts and follwing a link to PHP Easy Step, I think one of two things...too much code, or I'm way over my head....

[Keith_Scott]

Followed the above suggestions, now getting parse error:

Parse error: parse error, unexpected $ in /home/zackpowe/public_html/downloads/audio2.php on line 124

Here is the code I am using

<?php


//prevents caching
header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();

session_start();

//require the config file
require ("/home/zackpowe/public_html/downloads/config.php");
require ("/home/zackpowe/public_html/downloads/functions.php");

//make the connection to the database
$connection = @mysql_connect($server, $dbusername, $dbpassword) or die(mysql_error());
$db = @mysql_select_db($db_name,$connection)or die(mysql_error());

//make query to database
$row = mysql_fetch_array($result); 
$sql ="SELECT * FROM $table_name WHERE username= '$username'";
$result = @mysql_query($sql,$connection) or die(mysql_error());

// Some functions 
function get_database_row($s_db_query, $s_db_connstring="") { 


if ($s_db_connstring == "") { 
    global $db_connstring; 
    global $row;
    $connstring = $db_connstring; 
} else { 
    $connstring = $s_db_connstring; 
} 

$file_list = getDirFiles("/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/"); 

$count = count($file_list); 

?>
<table border=0 width=100% bgcolor=0 cellpadding=5 cellspacing=0>
<tr>

	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		File Name (<?=$row['username'];?>)
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Size
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Date
	</b></td>

</tr>
<?
$size = 0;
for($i=0;$i<=$count;$i++) {

	$file = $file_list[$i];
	$path = "/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/";
	if ($file != "index.php" && $file != "") {
		?>
			<tr>

				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<img src="/images/file.gif" align=middle> <a href="/audio/<?=$row['username']?>/<?=$file?>?key=<?=time()?>&validate=md5&log_user=<?=$userid?>"><?=$file?></a>
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=round(filesize($path . $file)/1024/1024, 2);?> MB
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=date("m/d/y H:i:s", filectime($path . $file));?>
				</td>

			</tr>
		<?
	}

}

   function getDirFiles($dirPath)
   {
     if ($handle = opendir($dirPath)) 
     {
         while (false !== ($file = readdir($handle))) 
             if ($file != "." && $file != "..") 
                 $filesArr[] = trim($file);

     closedir($handle);
 }  

 @sort($filesArr);    
 @reset($filesArr);
	return $filesArr;
   } 

function fsize($file){
       $size=0;
       $range = Array ('B', 'K', 'M', 'G');

   if(is_dir($file))
           if ($dh = opendir($file)){
                   while (($filecnt = readdir($dh)) !== false) {
                           if($filecnt == "." || $filecnt == "..")continue;
                           if(is_dir($file."/".$filecnt))
                                   $size += fsize($file."/".$filecnt);
                           else
                                   $size += filesize($file."/".$filecnt);
                           echo "\n$file/$filecnt";
                   }
                   closedir($dh);
           }else
                   return false;
   else
           $size = filesize($file);

   for ($i = 0; $size >= 1024 && $i < count($range); $i++)
           $size /= 1024;

   return round($filesize,2).$range[$i];
}

print("</td></tr></table>");

[Keith_Scott]

Changed a few things from above code based on what I read at phpeasystep, but still getting:

Parse error: parse error, unexpected $ in /ho
me/zackpowe/public_html/downloads/audio2.php on line 113

Here is the revised code:

<?php


//prevents caching
header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();

session_start();

//require the config file
require ("/home/zackpowe/public_html/downloads/config.php");
require ("/home/zackpowe/public_html/downloads/functions.php");

// Connect to server and select databse.
mysql_connect("$server", "$dbusername", "$dbpassword")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

// Some functions 
while($rows=mysql_fetch_array($result)){

$file_list = getDirFiles("/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/"); 

$count = count($file_list); 

?>
<table border=0 width=100% bgcolor=0 cellpadding=5 cellspacing=0>
<tr>

	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		File Name (<? echo $rows['username']; ?>)
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Size
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Date
	</b></td>

</tr>
<?
$size = 0;
for($i=0;$i<=$count;$i++) {

	$file = $file_list[$i];
	$path = "/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/";
	if ($file != "index.php" && $file != "") {
		?>
			<tr>

				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<img src="/images/file.gif" align=middle> <a href="/audio/<?=$row['username']?>/<?=$file?>?key=<?=time()?>&validate=md5&log_user=<?=$userid?>"><?=$file?></a>
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=round(filesize($path . $file)/1024/1024, 2);?> MB
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=date("m/d/y H:i:s", filectime($path . $file));?>
				</td>

			</tr>
		<?
	}

}

   function getDirFiles($dirPath)
   {
     if ($handle = opendir($dirPath)) 
     {
         while (false !== ($file = readdir($handle))) 
             if ($file != "." && $file != "..") 
                 $filesArr[] = trim($file);

     closedir($handle);
 }  

 @sort($filesArr);    
 @reset($filesArr);
	return $filesArr;
   } 

function fsize($file){
       $size=0;
       $range = Array ('B', 'K', 'M', 'G');

   if(is_dir($file))
           if ($dh = opendir($file)){
                   while (($filecnt = readdir($dh)) !== false) {
                           if($filecnt == "." || $filecnt == "..")continue;
                           if(is_dir($file."/".$filecnt))
                                   $size += fsize($file."/".$filecnt);
                           else
                                   $size += filesize($file."/".$filecnt);
                           echo "\n$file/$filecnt";
                   }
                   closedir($dh);
           }else
                   return false;
   else
           $size = filesize($file);

   for ($i = 0; $size >= 1024 && $i < count($range); $i++)
           $size /= 1024;

   return round($filesize,2).$range[$i];


print("</td></tr></table>");

The last line of the code is line 113

[rincewind456]

Your missing some curly brackets the last lines of your code should look like this

       return round($filesize,2).$range[$i]; 
}

print("</td></tr></table>");
}
?>

[Keith_Scott]

Ok. Took care of that, now getting:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/zackpowe/public_html/downloads/audio2.php on line 24

[rincewind456]

That's probably because the query is empty, where is $tbl_name coming from?

[Keith_Scott]

from my included config.php file

[rincewind456]

Ok but I think you'll find that if you echo out the $sql variable you'll find it hasn't got a table name in it.

[Keith_Scott]

I echo'd that, and didn't get the table name. I guess it's not "importing" the table name with the include at the beginning of the code. I added the $tbl_name to the beginning of the code, and got the echo. Now get a:

Fatal error: Call to undefined function: getdirfiles() in /home/zackpowe/public_html/downloads/audio2.php on line 30

What I don't understand is that function (getdirfiles) worked before...

Here is the code:

<?php


//prevents caching
header("Expires: Sat, 01 Jan 2000 00:00:00 GMT");
header("Last-Modified: ".gmdate("D, d M Y H:i:s")." GMT");
header("Cache-Control: post-check=0, pre-check=0",false);
session_cache_limiter();
$tbl_name="authorize"; // Table name 


session_start();

//require the config file
require ("/home/zackpowe/public_html/downloads/config.php");
require ("/home/zackpowe/public_html/downloads/functions.php");

// Connect to server and select databse.
mysql_connect("$server", "$dbusername", "$dbpassword")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

echo $tbl_name;

// Some functions 
while($row = mysql_fetch_array($result)){

$file_list = getDirFiles("/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/"); 

$count = count($file_list); 

?>
<table border=0 width=100% bgcolor=0 cellpadding=5 cellspacing=0>
<tr>

	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		File Name (<? echo $row['username']; ?>)
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Size
	</b></td>
	<td bgcolor=#eeeeee style="font-family: Tahoma; font-size: 11px;"><b>
		Date
	</b></td>

</tr>
<?
$size = 0;
for($i=0;$i<=$count;$i++) {

	$file = $file_list[$i];
	$path = "/home/zackpowe/public_html/downloads/audio/" . $row['username'] . "/";
	if ($file != "index.php" && $file != "") {
		?>
			<tr>

				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<img src="/images/file.gif" align=middle> <a href="/audio/<?=$row['username']?>/<?=$file?>?key=<?=time()?>&validate=md5&log_user=<?=$userid?>"><?=$file?></a>
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=round(filesize($path . $file)/1024/1024, 2);?> MB
				</td>
				<td bgcolor=#ffffff style="font-family: Tahoma; font-size: 11px;">
					<?=date("m/d/y H:i:s", filectime($path . $file));?>
				</td>

			</tr>
		<?
	}

}

   function getDirFiles($dirPath)
   {
     if ($handle = opendir($dirPath)) 
     {
         while (false !== ($file = readdir($handle))) 
             if ($file != "." && $file != "..") 
                 $filesArr[] = trim($file);

     closedir($handle);
 }  

 @sort($filesArr);    
 @reset($filesArr);
	return $filesArr;
   } 

function fsize($file){
       $size=0;
       $range = Array ('B', 'K', 'M', 'G');

   if(is_dir($file))
           if ($dh = opendir($file)){
                   while (($filecnt = readdir($dh)) !== false) {
                           if($filecnt == "." || $filecnt == "..")continue;
                           if(is_dir($file."/".$filecnt))
                                   $size += fsize($file."/".$filecnt);
                           else
                                   $size += filesize($file."/".$filecnt);
                           echo "\n$file/$filecnt";
                   }
                   closedir($dh);
           }else
                   return false;
   else
           $size = filesize($file);

   for ($i = 0; $size >= 1024 && $i < count($range); $i++)
           $size /= 1024;

   return round($filesize,2).$range[$i];
}

print("</td></tr></table>");
}
?>

[rincewind456]

It shouldn't make any difference but try putting your functions at the top of the script