Guest User

Untitled

a guest
Jun 30th, 2018
345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.97 KB | None | 0 0
  1. <?php
  2.     $address = "localhost";
  3.     $username = "root";
  4.     $password = "root";
  5.     $database = "database";
  6.     $table = "item_db";
  7.    
  8.    
  9.     $connect = mysql_connect($address,$username,$password) or die(mysql_error());
  10.     $select_db = mysql_select_db($database,$connect) or die(mysql_error());
  11.  
  12.     $query = mysql_query("SELECT * FROM `".$table."`") or die(mysql_error());
  13.     $temp_str = "";
  14.     while($fetch = mysql_fetch_array($query)){
  15.         echo $fetch['id'].",".
  16.         $fetch['name_english'].",".
  17.         $fetch['name_japanese'].",".
  18.         $fetch['type'].",".
  19.         $fetch['price_buy'].",".
  20.         $fetch['weight'].",".
  21.         $fetch['attack'].",".
  22.         $fetch['defence'].",".
  23.         $fetch['range'].",".
  24.         $fetch['slots'].",".
  25.         $fetch['equip_jobs'].",".
  26.         $fetch['equip_upper'].",".
  27.         $fetch['equip_locations'].",".
  28.         $fetch['weapon_level'].",".
  29.         $fetch['equip_level'].",".
  30.         $fetch['refineable'].",".
  31.         $fetch['view'].",".
  32.         $fetch['script'].",".
  33.         $fetch['equip_script'].",".
  34.         $fetch['unequip_script']."<br/>";
  35.     }
  36. ?>
Add Comment
Please, Sign In to add comment