fenzo666 Posted October 14, 2008 Share Posted October 14, 2008 Here is the table I want to move: http://db.pokesav.org/ I am moving to a new root folder as well as a new site layout. I want to bring the tables along. There is a table for each Pokemon organized by letter and by generation, as well as an "all pokemon" table. Which part of the code would I need to copy and paste into the new page? (Note: I ONLY want the code for the tables, not the site layout and sidebars, headings, etc.)Thanks! CODE: <?php $querystring = $_SERVER['QUERY_STRING']; list($sortby, $sortbyletter) = split(':', $querystring); $set = ''; if ($sortby == '') { $header = '<li class="selected"> <a href="index.php?:A">numb.</a></li><li><a href="index.php?name:A">Name</a></li>'; $sortby = 'numb'; $set = 'y'; } if ($sortby == 'name') { $header = '<li><a href="index.php?:A">numb.</a></li><li class="selected"><a href="index.php?name:A">Name</a></li>'; $set = 'y'; } if ($sortby == 'missing') { $header = '<li><a href="index.php?:A">numb.</a></li><li><a href="index.php?name:A">Name</a></li>'; $set = 'y'; } if ($set != 'y') { echo 'The variable at the end of the web address did not match one required by the code. Please check the web address for errors.'; exit; } $sortbyletter = strtolower($sortbyletter); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en"> <head> <title>The PKM Database</title> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <meta name="description" content="An extensive Pokemon file database, including hundreds of events and an upload bin." /> <meta name="keywords" content="pokemon,database,pkm,pokesav,event,wonder card,wondercard,iritegood,fenzo" /> <link rel="stylesheet" href="include/style.css" type="text/css" media="screen,projection" /> </head> <body> <?php include("include/header.php"); ?> <div id="container" ><div id="header"> <h1>The PKM Database</h1> <h2> <?php $randtext[] = "[slogan here]!"; $randtext[] = "Where Pokémon meet Pokésav!"; $randtext[] = "A collector's heaven."; $randtext[] = "These PKM files have hex data!"; srand ((double) microtime() * 1000000); $randomtext = rand(0,count($randtext)-1); echo $randtext[$randomtext]; ?> </h2></div><div id="navigation"> <ul> <?php echo $header.""; ?><li><a href="event.php">Events</a></li><li><a href="video.php">Videos</a></li><li><a href="other.php">Other</a></li><li><a href="help.php">Help</a></li><li><a href="about.php">About</a></li><li><a href="/upload">Upload</a></li></ul></div><div id="content"> <?php if ($sortby == 'name') { echo'<h2><h2 align=center><font color="#467AA7"><b>Alphabetical</b></font></h2></h2>'; } if ($sortby == 'numb') { echo'<h2><h2 align=center><font color="#467AA7"><b>Numerical</b></font></h2></h2>'; } ?> <table summary="List of fields"><tr><th></th><th>#</th><th>Name</th><th>Type</th></tr> <?php $fp = fopen('include/database.csv','r'); if (!$fp) { echo 'ERROR: Unable to open file.</table></body></html>'; exit; } $row = 1; while (!feof($fp)) { $line = fgets($fp,1024); //use 2048 if very long lines $row++; list ($numb, $name, $type1, $type2) = split ('\,', $line); if ($sortby == 'numb') $sortkey = strtolower($numb); if ($sortby == 'name') $sortkey = strtolower($name); $col[$row] = array($sortkey, $numb, $name, $type1, $type2); } fclose($fp); sort($col); reset ($col); $arrays = count($col) - 1; $loop = -1; $loopcounter = 0;/********** Function for sorting by number **********/ if ($sortby == 'numb') { echo '<p class="textcenter"><a href="index.php?:A">I</a> | <a href="index.php?:B">II</a> | <a href="index.php?:C">III</a> | <a href="index.php?">IV</a> | <a href="index.php?:E">All</a></p>'; if ($sortbyletter == 'a') { $startingnumber = 001; $endingnumber = 151; } elseif ($sortbyletter == 'b') { $startingnumber = 152; $endingnumber = 251; } elseif ($sortbyletter == 'c') { $startingnumber = 252; $endingnumber = 386; } elseif ($sortbyletter == 'd') { $startingnumber = 387; $endingnumber = 493; } elseif ($sortbyletter == 'e') { $startingnumber = 001; $endingnumber = 493; } else { $startingnumber = 001; $endingnumber = 151; } while ($loopcounter < $endingnumber) { $loopcounter++; $loop++; if ($loopcounter >= $startingnumber) { echo '<tr>';//name of pokemon is second column $nameofpoke = $col[$loop][2];//name of pokemon is lowercased $nameofpoke = strtolower($nameofpoke);//name of the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm'; $nameoffile2 = 'files/pkm/'.ucwords($nameofpoke).'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]);//remove spaces from type1 $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]);//remove new-lines from column 4 $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif';//checks if the pkm file exists if (file_exists($nameoffile) || file_exists($nameoffile2)) {//if it does... echo //1 is Poke #, 2 is Poke Name, 3 is Generation '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="'.$nameoffile.'">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr> '; } }//zipfiles elseif (file_exists("files/pkm/".$nameofpoke.".zip")) { echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="files/pkm/'.$nameofpoke.'.zip">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; } }//same thing but only if there is no file else { echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; } }}}} /********** Function for sorting by name **********/ if ($sortby == 'name') { echo '<div style="text-align:center;"><a href="index.php?name:A">A</a><a href="index.php?name:B">B</a><a href="index.php?name:C">C</a><a href="index.php?name:D">D</a><a href="index.php?name:E">E</a><a href="index.php?name:F">F</a><a href="index.php?name:G">G</a><a href="index.php?name:H">H</a><a href="index.php?name:I">I</a><a href="index.php?name:J">J</a><a href="index.php?name:K">K</a><a href="index.php?name:L">L</a><a href="index.php?name:M">M</a><a href="index.php?name:N">N</a><a href="index.php?name:O">O</a><a href="index.php?name:P">P</a><a href="index.php?name:Q">Q</a><a href="index.php?name:R">R</a><a href="index.php?name:S">S</a><a href="index.php?name:T">T</a><a href="index.php?name:U">U</a><a href="index.php?name:V">V</a><a href="index.php?name:W">W</a><a href="index.php?name:X">X</a><a href="index.php?name:Y">Y</a><a href="index.php?name:Z">Z</a> | <a href="index.php?name">All</a></div><br />'; while ($loop < $arrays) { $loop++;// Outputs the name of the pokemon and the name of the directory+nameofpokemon uncaptilized+.pkm//name of pokemon is second column $nameofpoke = $col[$loop][2];$nameofpoke = strtolower($nameofpoke);//name fo the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]); $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]); $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif'; $firstletter = $nameofpoke{0}; if ($firstletter == $sortbyletter) { echo '<tr>';//checks if the file exists $nameoffile2 = 'files/pkm/'.ucwords($nameofpoke).'.pkm'; if (file_exists($nameoffile) || file_exists($nameoffile2)) {//if it does... echo //1 is Poke #, 2 is Poke Name, 3 is Generation '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="'.$nameoffile.'">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; }}//zipfiles elseif (file_exists("files/pkm/".$nameofpoke.".zip") || file_exists("files/pkm/".ucwords($nameofpoke).".zip")) { echo'<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="files/pkm/'.$nameofpoke.'.zip">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>';}else {echo '</td></tr>'; }} else {//same thing but only if there is no file echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; }}}}} if ($sortby == 'missing') { while ($loop < $arrays) { $loop++;// Outputs the name of the pokemon and the name of the directory+nameofpokemon uncaptilized+.pkm//name of pokemon is second column $nameofpoke = $col[$loop][2]; $nameofpoke = strtolower($nameofpoke);//name fo the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]); $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]); $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif'; $firstletter = $nameofpoke{0};//checks if the file exists if (file_exists($nameoffile)) {} else{ echo '<tr>';//same thing but only if there is no file echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>';}else {echo '</td></tr>'; }}}} ?></table><br /></div> <?php include("include/sidebar.php"); ?> <div id="footer"><p> <?php $year = date("Y",time ()); if ( $year != "2008" ) {echo "© 2008 - ".$year;}else {echo "© 2008";} ?> <a href="#">Bao Trinh</a> | Last updated: <?php echo date('j F Y', getlastmod()); ?> </p> </div> </div> </body> </html> Quote Link to comment Share on other sites More sharing options...
Lamez Posted October 14, 2008 Share Posted October 14, 2008 what do you mean move tables? Like move the data in the database? Quote Link to comment Share on other sites More sharing options...
fenzo666 Posted October 14, 2008 Author Share Posted October 14, 2008 Basically I am setting up the same site in a CMS known as Drupal. I just want to move it to a new page. Quote Link to comment Share on other sites More sharing options...
Lamez Posted October 14, 2008 Share Posted October 14, 2008 so, what is the problem? Quote Link to comment Share on other sites More sharing options...
fenzo666 Posted October 15, 2008 Author Share Posted October 15, 2008 This is the table code: <table summary="List of fields"><tr><th></th><th>#</th><th>Name</th><th>Type</th></tr> <?php $fp = fopen('include/database.csv','r'); if (!$fp) { echo 'ERROR: Unable to open file.</table></body></html>'; exit; } $row = 1; while (!feof($fp)) { $line = fgets($fp,1024); //use 2048 if very long lines $row++; list ($numb, $name, $type1, $type2) = split ('\,', $line); if ($sortby == 'numb') $sortkey = strtolower($numb); if ($sortby == 'name') $sortkey = strtolower($name); $col[$row] = array($sortkey, $numb, $name, $type1, $type2); } fclose($fp); sort($col); reset ($col); $arrays = count($col) - 1; $loop = -1; $loopcounter = 0;/********** Function for sorting by number **********/ if ($sortby == 'numb') { echo '<p class="textcenter"><a href="index.php?:A">I</a> | <a href="index.php?:B">II</a> | <a href="index.php?:C">III</a> | <a href="index.php?">IV</a> | <a href="index.php?:E">All</a></p>'; if ($sortbyletter == 'a') { $startingnumber = 001; $endingnumber = 151; } elseif ($sortbyletter == 'b') { $startingnumber = 152; $endingnumber = 251; } elseif ($sortbyletter == 'c') { $startingnumber = 252; $endingnumber = 386; } elseif ($sortbyletter == 'd') { $startingnumber = 387; $endingnumber = 493; } elseif ($sortbyletter == 'e') { $startingnumber = 001; $endingnumber = 493; } else { $startingnumber = 001; $endingnumber = 151; } while ($loopcounter < $endingnumber) { $loopcounter++; $loop++; if ($loopcounter >= $startingnumber) { echo '<tr>';//name of pokemon is second column $nameofpoke = $col[$loop][2];//name of pokemon is lowercased $nameofpoke = strtolower($nameofpoke);//name of the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm'; $nameoffile2 = 'files/pkm/'.ucwords($nameofpoke).'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]);//remove spaces from type1 $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]);//remove new-lines from column 4 $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif';//checks if the pkm file exists if (file_exists($nameoffile) || file_exists($nameoffile2)) {//if it does... echo //1 is Poke #, 2 is Poke Name, 3 is Generation '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="'.$nameoffile.'">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr> '; } }//zipfiles elseif (file_exists("files/pkm/".$nameofpoke.".zip")) { echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="files/pkm/'.$nameofpoke.'.zip">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; } }//same thing but only if there is no file else { echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; } }}}} /********** Function for sorting by name **********/ if ($sortby == 'name') { echo '<div style="text-align:center;"><a href="index.php?name:A">A</a><a href="index.php?name:B">B</a><a href="index.php?name:C">C</a><a href="index.php?name:D">D</a><a href="index.php?name:E">E</a><a href="index.php?name:F">F</a><a href="index.php?name:G">G</a><a href="index.php?name:H">H</a><a href="index.php?name:I">I</a><a href="index.php?name:J">J</a><a href="index.php?name:K">K</a><a href="index.php?name:L">L</a><a href="index.php?name:M">M</a><a href="index.php?name:N">N</a><a href="index.php?name:O">O</a><a href="index.php?name:P">P</a><a href="index.php?name:Q">Q</a><a href="index.php?name:R">R</a><a href="index.php?name:S">S</a><a href="index.php?name:T">T</a><a href="index.php?name:U">U</a><a href="index.php?name:V">V</a><a href="index.php?name:W">W</a><a href="index.php?name:X">X</a><a href="index.php?name:Y">Y</a><a href="index.php?name:Z">Z</a> | <a href="index.php?name">All</a></div><br />'; while ($loop < $arrays) { $loop++;// Outputs the name of the pokemon and the name of the directory+nameofpokemon uncaptilized+.pkm//name of pokemon is second column $nameofpoke = $col[$loop][2];$nameofpoke = strtolower($nameofpoke);//name fo the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]); $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]); $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif'; $firstletter = $nameofpoke{0}; if ($firstletter == $sortbyletter) { echo '<tr>';//checks if the file exists $nameoffile2 = 'files/pkm/'.ucwords($nameofpoke).'.pkm'; if (file_exists($nameoffile) || file_exists($nameoffile2)) {//if it does... echo //1 is Poke #, 2 is Poke Name, 3 is Generation '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="'.$nameoffile.'">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; }}//zipfiles elseif (file_exists("files/pkm/".$nameofpoke.".zip") || file_exists("files/pkm/".ucwords($nameofpoke).".zip")) { echo'<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td><a href="files/pkm/'.$nameofpoke.'.zip">'.$col[$loop][2].'</a></td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>';}else {echo '</td></tr>'; }} else {//same thing but only if there is no file echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>'; } else { echo '</td></tr>'; }}}}} if ($sortby == 'missing') { while ($loop < $arrays) { $loop++;// Outputs the name of the pokemon and the name of the directory+nameofpokemon uncaptilized+.pkm//name of pokemon is second column $nameofpoke = $col[$loop][2]; $nameofpoke = strtolower($nameofpoke);//name fo the file is directory+filename $nameoffile = 'files/pkm/'.$nameofpoke.'.pkm';//type 1 is column 3 $typename1 = strtolower($col[$loop][3]); $typename1 = str_replace ( ' ', "", $typename1);//type 2 is column 4 $typename2 = strtolower($col[$loop][4]); $typename2 = str_replace ( '', "", $typename2);//img tag for type1 $typeimage = '<img alt="type icon" src="include/image/'.$typename1.'.gif" />';//url of second type $type2url = 'include/image/'.$typename2.'.gif'; $firstletter = $nameofpoke{0};//checks if the file exists if (file_exists($nameoffile)) {} else{ echo '<tr>';//same thing but only if there is no file echo '<td><img alt="pokemon icon" src="include/icons/'.$col[$loop][1].'.png" /></td><td>'.$col[$loop][1].'</td><td>'.$col[$loop][2].'</td><td>'.$typeimage; if (file_exists('include/image/'.$typename2.'.gif')) { echo '<img alt="type icon" src="include/image/'.$typename2.'.gif" /></td></tr>';}else {echo '</td></tr>'; }}}} ?></table> This is the error: ERROR: Unable to open file. # Name Type Quote Link to comment Share on other sites More sharing options...
fenzo666 Posted October 15, 2008 Author Share Posted October 15, 2008 I fixed the error but all it shows now is just the table titles :\ Quote Link to comment Share on other sites More sharing options...
Lamez Posted October 15, 2008 Share Posted October 15, 2008 sounds like you need to contact Drupal Quote Link to comment Share on other sites More sharing options...
grim1208 Posted October 15, 2008 Share Posted October 15, 2008 what exactly are you trying to do? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.