Why displaying nothing?

begeiste · #1 Sep 28th, 2007, 01:24

Hi

I have copied the codes from the book "Build your own Database driven Website" from sitepoint, not sure those codes display nothing while calling it on the browser http://localhost:8888/gallery/index.php? Any inputs and helps will be much appreciated!!

Code: Select all

<?php
    $dbcnx = @mysql_connect('localhost','root','root');
    if(!$dbcnx){
        exit('<p>Unable to connect to the '.'database server at this time.</p>');
    }
if(!@mysql_select_db('photos')){
    exit('<p> Unable to locate the photos '. 'database at this time</p>');
}

if(isset($_GET['action'])){
    $action = $_GET['action'];
}else{ $action = '';

}
if(($action == 'view' or $action == 'gallery') and isset($_GET['id'])){
    $id = $_GET['id'];
    
    //User is retrieving a file
    $sql = "SELECT filename, mimetype, filedata FROM gallery WHERE id='$id'";
    $result= @mysql_query($sql);
    if(!$result){
        exit('Database error: '. mysql_error());
    }
    
    $file = mysql_fetch_array($result);
    if(!$file){ 
    exit('File with given ID not found in database!');
    }
    $filename = $file['filename'];
    $mimetype = $file['mimetype'];
    $filedata = $file['filedata'];
    $description = 'inline';
    
    if($action == 'gallery'){
        $disposition = 'attachment';
        if(strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE 5') or strpos($_SERVER['HTTP_USER_AGENT'], 'Opera 7')){ 
            $mimetype = 'application/x-download';
        }
    }
    
    header("content-disposition: $disposition; filename=$filename");
    header("content-type: $mimetype");
    header('content-length: '. strlen($filedata));
    
    echo $filedata;
    exit();
}elseif($action == 'del' and isset($_GET['id'])){
    $id = $_GET['id'];
    
    //user is deleting a file
    $sql = "DELETE FROM gallery WHERE id = '$id'";
    $ok = mysql_query($sql);
    if(!$ok){
        exit ('Database error: '. mysql_error());
    }
    
    header('Location: '. $_SERVER['PHP_SELF']);
    exit();
}elseif(isset($_FILES['upload'])){

    //Bail out if the file isn't really an upload
    if(!is_uploaded_file($_FILES['upload'] ['tmp_name'])){
        exit('There was no file uploaded!');
    }
    $uploadfile = $_FILES['upload']['tmp_name'];
    $uploadname = $_FILES['upload']['name'];
    $uploadtype = $_FILES['upload']['type'];
    $uploaddesc = $_POST[['upload']['desc'];
    
    //open file for binary reading ('rb')
    $tempfile = fopen($uploadfile, 'rb');
    
    //read the entire file into memory using PHP's
    //filesize function to get the file size
    $filedata = fread($tempfile, filesize($uploadfile));
    
    //prepare for database insert by adding backslashes
    //before special characters.
    $filedata = addslashes($filedata);
    
    //create the SQL query
    $sql = "INSERT INTO gallery SET filename ='$uploadname', mimetype = '$uploadtype', description ='$uploaddesc', filedata = '$filedata'";
    
    //perform the insert
    $ok = @mysql_query($sql);
    if(!$ok){
        exit('Database error storing file: '. mysql_error());
    }header('Location: '.$_SERVER['PHP_SELF']);
    exit();
}

//Default page view: lists stored files

$sql = 'SELECT id, filename, mimetype, description FROM gallery';
$filelist = @mysql_query($sql);
if(!$filelist){
    exit('Database error '. mysql_error());
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>gallery Repository index</title>
</head>

<body>
<h1>Gallery Repository</h1>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
    <P><label>Upload File:<br /><input type="file" name="upload" /></label></P>
    <p><label>File Description:<br /><input type="text" name="desc" maxlength="255" /></label></p>
    <p><input type="submit" value="Upload" /></p>
</form>
<p>The following files are stored in the database:</p>
<table>
<tr><th>File Name</th><th>Type</th><th>Description</th></tr>
<?php
    if(mysql_num_rows($filelist) > 0){
        while($f = mysql_fetch_array($filelist)){
        ?>
        <tr valign="top">
        <td><a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=view&id=<?php echo $f['id']; ?>"><?php echo $f['filename']; ?></a></td>
        <td><?php echo $f['mimetype']; ?></td>
        <td><?php echo $f['description']; ?></td>
        <td>[<a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=gallery&id=<?php echo $f['id']; ?>"> Download</a> | <a href="<?php echo $_SERVER['PHP_SELF']; ?>?action=del&id=<?php echo $f['id']; ?>" onclick="return confirm('Delete this file?');">Delete</a> ]</td>
        </tr>
        <?php
            }
        }else{
        ?>
        <tr><td colspan="3"> No Files!</td></tr>
        <?php
        }
?>
</table>
</body>
</html>

Rakuli · #2 Sep 28th, 2007, 10:34

So you have PHP and MySQL configured to work on your computer?

If you aren't getting anything then you probably have a fatal PHP error.

Try taking away the error suppression ( the @ symbol) before

@mysql_connect and @mysql_select_db

and check you PHP error log to see what errors you are getting.

I've had a look at the code and can't see any blatent errors.

Voodoochilli · #3 Sep 28th, 2007, 12:30

try commenting out parts of the code which could be causing the problem

Voodoochilli · #4 Sep 28th, 2007, 12:32

also, its probably just me, but for an 'or' condition I use || and for an 'and' condition I use &&, but you probably can do it the way you do.

alexgeek · #5 Sep 28th, 2007, 14:54

I had this before
you need to cinfigure you php.ini
if you want i'll send you mine

begeiste · #6 Sep 28th, 2007, 17:13

Quote:

Originally Posted by alexgeek

I had this before
you need to cinfigure you php.ini
if you want i'll send you mine

I appreciated all you guys comments!!!

alexgeek · #7 Sep 28th, 2007, 17:20

Did you want it?

begeiste · #8 Oct 1st, 2007, 16:48

Quote:

Originally Posted by alexgeek

Did you want it?

Yes, sir. Much appreciate!!!

alexgeek · #9 Oct 1st, 2007, 16:51

here you go
you need to rename it obviously

begeiste · #10 Oct 1st, 2007, 16:54

Can I use yours to swap mine php.ini?

alexgeek · #11 Oct 1st, 2007, 16:57

yeah that was point

begeiste · #12 Oct 1st, 2007, 17:03

I saw the maximum upload filesize and post maximum filesize : 2M and 8M in your php.ini, but when I upload 1.1MB mp3, I got this error:
Database error storing file: Got a packet bigger than 'max_allowed_packet' bytes

alexgeek · #13 Oct 1st, 2007, 17:07

i think you need twice as much for each download or something
change them to something like 30M and see what happenes

begeiste · #14 Oct 1st, 2007, 17:22

I have increased them and restarted the apache, mysql. Still got the same problem.

Database error storing file: Got a packet bigger than 'max_allowed_packet' bytes

alexgeek · #15 Oct 1st, 2007, 17:30

database error?
are you trying to store a file in a database or something :S

begeiste · #16 Oct 1st, 2007, 19:15

Yes. I wanted to insert records to store in the database.

alexgeek · #17 Oct 1st, 2007, 19:18

you can insert strings and integers but not files.
At least not that i know of

begeiste · #18 Oct 1st, 2007, 19:22

I have inserted records of the small file size without any problems in database, but the file size beyond 2MB.

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Why displaying nothing?