Guest User

Untitled

a guest
Aug 22nd, 2018
357
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.46 KB | None | 0 0
  1. url?id=1 How do i GET the id using a PHP MYSQL function?
  2. function item() {
  3.  
  4. $itemid = $_GET['id'];
  5.  
  6. $t = "items";
  7. $sql = mysql_query("SELECT * FROM $t WHERE id=$itemid") or die(mysql_error());
  8. $r = mysql_fetch_array( $sql );
  9.  
  10. $id = $r['id'];
  11. $date = $r['date'];
  12. $title = $r['title'];
  13. $location = $r['location'];
  14.  
  15. }
  16.  
  17. <?php ### // no entry
  18.  
  19. item(); // get item function
  20.  
  21. ?>
  22.  
  23. <h1>Item View</h1>
  24.  
  25. <?php echo $id;?>
  26. <?php echo $date;?>
  27. <?php echo $title;?>
  28. <?php echo $location;?>
  29.  
  30. function external_db_connect() {
  31.  
  32. $database_hostname = 'localhost';
  33. $database_username = 'user';
  34. $database_password = 'pass';
  35. $database_name = 'table';
  36. class DatabaseConnectClass {
  37. public $database_hostname;
  38. public $database_username;
  39. public $database_password;
  40. public $database_name;
  41. public function databaseConnection($objDatabaseConnect) {
  42. $this->_database_connection =
  43. mysql_pconnect($this->database_hostname,
  44. $this->database_username,
  45. $this->database_password)
  46. or trigger_error(mysql_error(),E_USER_ERROR);
  47. return $this->_database_connection;
  48. }
  49. public function databaseConnectionSelect() {
  50. $this->_database_connection_select =
  51. mysql_select_db($this->database_name,
  52. $this->_database_connection);
  53. return $this->_database_connection_select;
  54. }
  55. public function databaseConnectionProcess($objDatabaseConnect) {
  56. $objDatabaseConnect->databaseConnection($objDatabaseConnect);
  57. $objDatabaseConnect->databaseConnectionSelect($objDatabaseConnect);
  58. }
  59. public function databaseConnectionMain($objDatabaseConnect) {
  60. $objDatabaseConnect->databaseConnectionProcess($objDatabaseConnect);
  61. }}
  62.  
  63. $objDatabaseConnect = new DatabaseConnectClass();
  64. $objDatabaseConnect->database_hostname = $database_hostname;
  65. $objDatabaseConnect->database_username = $database_username;
  66. $objDatabaseConnect->database_password = $database_password;
  67. $objDatabaseConnect->database_name = $database_name;
  68. $objDatabaseConnect->databaseConnectionMain($objDatabaseConnect);
  69.  
  70. }
  71.  
  72. <?php
  73. function item() {
  74.  
  75.  
  76. $username="root";
  77. $password="";
  78. $database="test";
  79. $host="localhost";
  80. $itemid = $_GET['id'];
  81.  
  82. $t = "items";
  83. mysql_connect($host,$username,$password);
  84. @mysql_select_db($database) or die( "Unable to select database");
  85. $sql = mysql_query("SELECT * FROM items WHERE id=$itemid") or die(mysql_error());
  86.  
  87.  
  88. echo "<h1> Item view </h1>";
  89. while($row = mysql_fetch_array($sql))
  90. {
  91. echo "<h1>" . $row['title'] . "</h1>";
  92. echo "<p>" . $row['location'] . "</p>";
  93. }
  94.  
  95. mysql_close();
  96. }
  97.  
  98.  
  99. ?>
  100.  
  101. <?php
  102. item();
  103. ?>
Add Comment
Please, Sign In to add comment