[Resolved] MySQL + <tables>

[goaman]

Hi there,
I'm trying get all the filenames from database and divide them into 3 so that I can view in table properly. Any help would be appreciated.

<table width="100%" border="1" cellspacing="0" >  

<?
// prepare the query string
$query = "SELECT id, filenames ". 
"FROM uploads ORDER BY id DESC ";

$result = mysql_query($query) or die('Error, query failed [$query]'); 

while($row = mysql_fetch_array($result))
{
list($id,$filenames) = $row; 


//here I need to divide the $filenames into 3 so that I can view it peoperly
//(how to divide into 3 parts?)




//after that, view it properly....
echo '<tr>
<td width="30%">' . $filename1 . '</td>
<td width="40%">' . $filename2 . '</td>
<td width="30%">' . $filename3 . '</td>
</tr>'; 

}
?>
</table> 

[bpat1434]

Perhaps what would best serve you is a search & explode function?

How are you separating the filenames in the database? Are they by '.' or '/' or ' ' or '-' or what? Once you know that, you can use the explode() function and call it from an array like so:

list($id,$filenames) = $row;
$file = explode(".", $filenames);

echo '<tr>
<td width="30%">' . $file[0] . '</td>
<td width="40%">' . $file[1] . '</td>
<td width="30%">' . $file[2] . '</td>
</tr>';  

You could even do it like this:

<table width="100%" border="1" cellspacing="0" >  

<?
// prepare the query string
$query = "SELECT id, filenames ". 
"FROM uploads ORDER BY id DESC ";

$result = mysql_query($query) or die('Error, query failed [$query]'); 

while($row = mysql_fetch_array($result))
{
$data = $row['filenames'];
$data2 = $row['id'];

list($filename1, $filename2, $filename3) = explode(".", $data);
list($file_id_1, $file_id_2, $file_id_3) = explode(".", $data2);

echo '<tr>
<td width="30%">' . $filename1 . '</td>
<td width="40%">' . $filename2 . '</td>
<td width="30%">' . $filename3 . '</td>
</tr>'; 

}
?>
</table>

I think that is what you're trying to do.

~Brett

[goaman]

Hi Brett,
Thanks for the fast reply 🙂

I've followed the 2nd step, it's viewing all the filenames on the Left side of column(not on the center nor on the right one), it doesn't split the filenames, what could be the problem? 🙁

p.s: filenames are saved in the "filenames" Field in mysql.[id, filenames, date]. Filenames are saved in mysql without any space or dots or slashes.

[bpat1434]

Well that's unfortunate. It would behoove you to actually edit that database (if it's small enough) and add a character in between each filename. Otherwise you won't be able to split it.

If they look like:

filename1filename2filename3

you can't do it. But if you edited them to be:

filename1.zip-filename2.zip-filename3.zip

you would be able to explode on the "-" and get the 3 file names.

~Brett

[goaman]

Originally posted by bpat1434

But if you edited them to be:
filename1.zip-filename2.zip-filename3.zip
you would be able to explode on the "-" and get the 3 file names.

~Brett

Hi Brett,
I've edited the database and add "+" between all filenames, so now they look like: filename1+filename2+filename3+filename4+ etc...

and I've tried to explode them with "+", it shows all filenames in the middle column.. I've attached the screenshot, pls take a look at it.


code looks like this now..

//to check
echo $data;

list($filenamex, $filenamey, $filenamez) = explode("+", $data);

echo '<tr>
<td width="30%">' . $filenamex . '</td>
<td width="40%">' . $filenamey . '</td>
<td width="30%">' . $filenamez . '</td>
</tr>'; 

}

[bpat1434]

Try this really quicK:

take out the width="XX%" in the table column items. That may be causing a problem.

~Brett

[goaman]

Originally posted by bpat1434
Try this really quicK:

take out the width="XX%" in the table column items. That may be causing a problem.

~Brett

Without width="XX%", it shows like this, picture is attached..

[bpat1434]

Ok, so how do you have yoru DB set up? How many rows? because mine won't loop through:
Viewable Here
Just click on Filenames from DB.
Code will be printed below output.

I have 1 row with:
File1+File2+File3+File4+File5+File6

They work out just fine.

Show me the rest of your code...

~Brett

EDIT

I think I figured it out.

Get rid of the +signs with the filename so that your data looks like:

Filename1+Filename2+Filename3
Filename4+Filename5+Filename6

That is waht's causing it I think.

[goaman]

Originally posted by bpat1434
Ok, so how do you have yoru DB set up? How many rows? because mine won't loop through:
http://bpatterson.net/test

I have 1 row with:
File1+File2+File3+File4+File5+File6

They work out just fine.

Show me the rest of your code...

~Brett

code:

<html>
<head>
</head>

<body>

<table width="100%" border="1" cellspacing="0" >  

<?
//connect to DB
include 'dbconfig.php';

// prepare the query string
$query = "SELECT id, filenames ". 
"FROM uploaded_files ORDER BY id DESC ";

$result = mysql_query($query) or die('Error, query failed [$query]'); 

while($row = mysql_fetch_array($result))
{
$data = $row['filenames'];
//$data2 = $row['id'];
echo $data;

list($filenamex, $filenamey, $filenamez) = explode("+", $data);
//list($file_id_1, $file_id_2, $file_id_3) = explode("+", $data2);

echo '<tr>
<td >' . $filenamex . '</td>
<td >' . $filenamey . '</td>
<td >' . $filenamez . '</td>
</tr>'; 

}
?>
</table>  

</body>
</html>

I've attached the database(table) screenshot too.. pls take a look at it

[goaman]

attachment

[bpat1434]

Can't attach more than 1 file at a time!!!

EDIT
I HAVE THE ANSWER!!! I'll continue to edit this post.

By storing the filenames in different rows, it is absolutely unnecessary to do what you are doing. I believe that you should do this instead:

Viewable Here
Just click on Filenames from DB.
Code will be printed below output.

~Brett

[goaman]

Thankyou Brett, I appreciate your help,
It's working just fine.. 😃

[bpat1434]

No problem. But if you wanted to use the table version you were using before, use the code I just posted:

By table version I mean 1 filename per row. This makes it easier if you are going to upload files via the web-browser.

<table width="100%">
<?
//query the Database
$query = "SELECT * FROM uploads ORDER BY id DESC";

$result = mysql_query($query) or die('ERROR: Query failed ['.$query.']<br>'.mysql_error());

$x = 1;

echo('<table width="100%" border="1">');
echo('<tr>');

for($x=1; $x<=mysql_num_rows($result); $x++){
    $row = mysql_fetch_array($result);
    echo('<td>'.$row['filenames'].'</td>');
    if($x%3==0){
        echo('</tr>'."\n");
        echo('<tr>');
    }
}
?>
</table>

Glad to know that it works.

~Brett

[goaman]

woow, great.. this is exactly what I needed from the beginning.. 😃

thanks again 🙂

[bpat1434]

You may need this, to help understand what's going on:

<?
//query the Database
$query = "SELECT * FROM uploads ORDER BY id DESC";

$result = mysql_query($query) or die('ERROR: Query failed ['.$query.']<br>'.mysql_error());

// Set the numerical counter to default
$x = 1;

echo('<table width="100%" border="1">');
echo('<tr>');

/* Basically what is done here is for $x = 1 initially, and as long as it is less than or equal to the number of rows that the query returns, then go through the loop, and increment it by 1 when it's done. */
for($x=1; $x<=mysql_num_rows($result); $x++){
    // Put data into an array.
    $row = mysql_fetch_array($result);
    echo('<td>'.$row['filenames'].'</td>');
    /*  Here is a nifty part of the code.  This checks to see if $x is divisble by 3.  If there is no remainder (i.e. $x = 3, 6, 9, 12...) then it goes through the loop, otherwise it skips.  Change this number to add or remove columns.  Easy as pie. */
    if($x%3==0){
        echo('</tr>'."\n");
        echo('<tr>');
    }
}
?>

This would have saved us a lot of time had I known this was something that you were going for.

Glad that I could help you out.

~Brett

[goaman]

thankyou Brett, now it's even easier to understand whats going on 😃

thanks again, very nicely commented 🙂