Why displaying nothing?

begeiste · #1 (**permalink**) 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 (**permalink**) 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 (**permalink**) Sep 28th, 2007, 12:30

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

Voodoochilli · #4 (**permalink**) 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 (**permalink**) 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 (**permalink**) 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 (**permalink**) Sep 28th, 2007, 17:20

Did you want it?

begeiste · #8 (**permalink**) Oct 1st, 2007, 16:48

Quote:

Originally Posted by alexgeek

Did you want it?

Yes, sir. Much appreciate!!!

alexgeek · #9 (**permalink**) Oct 1st, 2007, 16:51

here you go
you need to rename it obviously

begeiste · #10 (**permalink**) Oct 1st, 2007, 16:54

Can I use yours to swap mine php.ini?

alexgeek · #11 (**permalink**) Oct 1st, 2007, 16:57

yeah that was point

begeiste · #12 (**permalink**) 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 (**permalink**) 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 (**permalink**) 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 (**permalink**) Oct 1st, 2007, 17:30

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

begeiste · #16 (**permalink**) Oct 1st, 2007, 19:15

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

alexgeek · #17 (**permalink**) Oct 1st, 2007, 19:18

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

begeiste · #18 (**permalink**) 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Code is there...but not displaying...	1840dsgn	Web Page Design	3	Aug 16th, 2007 18:28
displaying menus in css	kohan	Web Page Design	7	Mar 23rd, 2007 22:28
<ul> not displaying the same in FF/IE7?	PMicro	Web Page Design	10	Mar 21st, 2007 18:49
why is it displaying in IE..??	tameem	Web Page Design	3	Oct 14th, 2006 06:09
Need help displaying XML	Zhan	Web Page Design	5	Aug 19th, 2005 18:47

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