date:20100131

[PHP-DB] Need Help with data sorting

2010-01-31 Thread nagendra prasad

Hi,

I have a database of MP3s in mysql and I have created a php search engine.
Now I want to sort it in ascending or descending order if user clicks on the
title of the table. For example if user want to arrange the table in
ascending or descending order by Name, Size, or by any other field. Also, I
am unable to arrange the table properly. Please help me?? Below is the
code.

Type = Rock, Pop etc.
Url = file url
Name= Name of the song
Size = size



?php


//get data
$button = $_GET['submit'];
$search = $_GET['search'];


$s = $_GET['s'];
if (!$s)
$s = 0;


$e = 30; // Just change to how many results you want per page


$next = $s + $e;
$prev = $s - $e;




 if (strlen($search)=2)
  echo Must be greater then 3 chars;
 else
 {
  echo br /tabletrtdfont face='sana-serif' size='10'font
color='blue' bMymp3/b/bfont face='sana-serif'
size='3'reg;/tdtdform action='search.php' method='GET'input
type='text' onclick=value='' size='50' name='search' value='$search' input
type='submit' name='submit' value='Search'/form/td/tr/table;

  //connect to database
  mysql_connect(localhost,root,);
  mysql_select_db(mp3);

   //explode out search term
   $search_exploded = explode( ,$search);

   foreach($search_exploded as $search_each)
   {

//construct query
$x++;
if ($x==1)
 $construct .= name LIKE '%$search_each%';
else
 $construct .=  OR name LIKE '%$search_each%';

   }

  //echo outconstruct
  $constructx = SELECT * FROM mp3 WHERE $construct;

  $construct = SELECT * FROM mp3 WHERE $construct ORDER BY se DESC LIMIT
$s,$e ;
  $run = mysql_query($constructx);

  $foundnum = mysql_num_rows($run);


  $run_two = mysql_query($construct);

  if ($foundnum==0)
   echo No results found for b$search/b;
  else
  {
   echo table bgcolor='#FF' width='100%' height='1px'br
//tabletable bgcolor='#f0f7f9' width='100%' height='10px'trtddiv
align='right'Showing 1-20 of b$foundnum/b results found for
b$search./b/div/td/tr/tablep;

   echo table bgcolor='#FF' width='100%' height='1px'br
//tabletable bgcolor='#f0f7f9' width='100%' height='10px'trtdfont
face='sana-serif' size='3'
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;Type
bnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
Name/b
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;  Size
/div/td/tr/tablep;

   while ($runrows = mysql_fetch_assoc($run_two))
   {
//get data
   $type = $runrows['type'];
   $date = $runrows['date'];
   $url = $runrows['url'];
   $name = $runrows['name'];
   $size = $runrows['size'];


   print 'table width=800 border=0 align=center ';

   print 'tdfont color=blue'.$type.'/font/td';


//print 'tdfont color=blue'.http://localhost/mymp3/.;a
herf='$url'$name.'/font/td';


print 'tdfont color=blue'.a href='$url'$name.'/font/td';


print 'tdfont color=blue'.$size.'/font/td';



  print '/tr';

  print '/tr';
print '/table';

  /* echo table width='300px' height='10px'
   h4 font color='blue'$type --   $name/fontbbrSize: $size
/b/abr /
  font color='00CC00'Date Added: $date/font/table/h4
   ;   */
   }
?

table width='100%'
tr
td
div align=center
brbr
?php
if (!$s=0)
 echo a href='search.php?search=$searchs=$prev'Prev/a;

$i =1;
for ($x=0;$x$foundnum;$x=$x+$e)
{


 echo  a href='search.php?search=$searchs=$x'$i/a ;


$i++;


}

if ($s$foundnum-$e)
  echo a href='search.php?search=$searchs=$next'Next/a;

}
}


?
/div
/td
/tr
/table

-- 
Guru Prasad
Ubuntu Voice GTK+ Forum

Re: [PHP-DB] Need Help with data sorting

2010-01-31 Thread Amit Tandon

Hello,

I a not clear why are u using so many tables, and also div's within the
table. Either use tableless (css tables ) or simply use table(preferably
one) without divs in it

regds
amit

The difference between fiction and reality? Fiction has to make sense.


On Sun, Jan 31, 2010 at 3:45 PM, nagendra prasad
nagendra802...@gmail.comwrote:

 Hi,

 I have a database of MP3s in mysql and I have created a php search engine.
 Now I want to sort it in ascending or descending order if user clicks on
 the
 title of the table. For example if user want to arrange the table in
 ascending or descending order by Name, Size, or by any other field. Also, I
 am unable to arrange the table properly. Please help me?? Below is the
 code.

 Type = Rock, Pop etc.
 Url = file url
 Name= Name of the song
 Size = size


 

 ?php


 //get data
 $button = $_GET['submit'];
 $search = $_GET['search'];


 $s = $_GET['s'];
 if (!$s)
 $s = 0;


 $e = 30; // Just change to how many results you want per page


 $next = $s + $e;
 $prev = $s - $e;




  if (strlen($search)=2)
  echo Must be greater then 3 chars;
  else
  {
  echo br /tabletrtdfont face='sana-serif' size='10'font
 color='blue' bMymp3/b/bfont face='sana-serif'
 size='3'reg;/tdtdform action='search.php' method='GET'input
 type='text' onclick=value='' size='50' name='search' value='$search'
 input
 type='submit' name='submit' value='Search'/form/td/tr/table;

  //connect to database
  mysql_connect(localhost,root,);
  mysql_select_db(mp3);

   //explode out search term
   $search_exploded = explode( ,$search);

   foreach($search_exploded as $search_each)
   {

//construct query
$x++;
if ($x==1)
 $construct .= name LIKE '%$search_each%';
else
 $construct .=  OR name LIKE '%$search_each%';

   }

  //echo outconstruct
  $constructx = SELECT * FROM mp3 WHERE $construct;

  $construct = SELECT * FROM mp3 WHERE $construct ORDER BY se DESC LIMIT
 $s,$e ;
  $run = mysql_query($constructx);

  $foundnum = mysql_num_rows($run);


  $run_two = mysql_query($construct);

  if ($foundnum==0)
   echo No results found for b$search/b;
  else
  {
   echo table bgcolor='#FF' width='100%' height='1px'br
 //tabletable bgcolor='#f0f7f9' width='100%' height='10px'trtddiv
 align='right'Showing 1-20 of b$foundnum/b results found for
 b$search./b/div/td/tr/tablep;

   echo table bgcolor='#FF' width='100%' height='1px'br
 //tabletable bgcolor='#f0f7f9' width='100%' height='10px'trtdfont
 face='sana-serif' size='3'

 nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;Type

 bnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
 Name/b

 nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;

 nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;
 nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;  Size
 /div/td/tr/tablep;

   while ($runrows = mysql_fetch_assoc($run_two))
   {
//get data
   $type = $runrows['type'];
   $date = $runrows['date'];
   $url = $runrows['url'];
   $name = $runrows['name'];
   $size = $runrows['size'];


   print 'table width=800 border=0 align=center ';

   print 'tdfont color=blue'.$type.'/font/td';


//print 'tdfont color=blue'.http://localhost/mymp3/.;a
 herf='$url'$name.'/font/td';


print 'tdfont color=blue'.a href='$url'$name.'/font/td';


print 'tdfont color=blue'.$size.'/font/td';



  print '/tr';

  print '/tr';
 print '/table';

  /* echo table width='300px' height='10px'
   h4 font color='blue'$type --   $name/fontbbrSize: $size
 /b/abr /
  font color='00CC00'Date Added: $date/font/table/h4
   ;   */
   }
 ?

 table width='100%'
 tr
 td
 div align=center
 brbr
 ?php
 if (!$s=0)
  echo a href='search.php?search=$searchs=$prev'Prev/a;

 $i =1;
 for ($x=0;$x$foundnum;$x=$x+$e)
 {


  echo  a href='search.php?search=$searchs=$x'$i/a ;


 $i++;


 }

 if ($s$foundnum-$e)
  echo a href='search.php?search=$searchs=$next'Next/a;

}
 }


 ?
 /div
 /td
 /tr
 /table

 --
 Guru Prasad
 Ubuntu Voice GTK+ Forum

[PHP-DB] Need Help with data sorting

Re: [PHP-DB] Need Help with data sorting

2 matches

Site Navigation

Mail list logo

Footer information