Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- url?id=1 How do i GET the id using a PHP MYSQL function?
- function item() {
- $itemid = $_GET['id'];
- $t = "items";
- $sql = mysql_query("SELECT * FROM $t WHERE id=$itemid") or die(mysql_error());
- $r = mysql_fetch_array( $sql );
- $id = $r['id'];
- $date = $r['date'];
- $title = $r['title'];
- $location = $r['location'];
- }
- <?php ### // no entry
- item(); // get item function
- ?>
- <h1>Item View</h1>
- <?php echo $id;?>
- <?php echo $date;?>
- <?php echo $title;?>
- <?php echo $location;?>
- function external_db_connect() {
- $database_hostname = 'localhost';
- $database_username = 'user';
- $database_password = 'pass';
- $database_name = 'table';
- class DatabaseConnectClass {
- public $database_hostname;
- public $database_username;
- public $database_password;
- public $database_name;
- public function databaseConnection($objDatabaseConnect) {
- $this->_database_connection =
- mysql_pconnect($this->database_hostname,
- $this->database_username,
- $this->database_password)
- or trigger_error(mysql_error(),E_USER_ERROR);
- return $this->_database_connection;
- }
- public function databaseConnectionSelect() {
- $this->_database_connection_select =
- mysql_select_db($this->database_name,
- $this->_database_connection);
- return $this->_database_connection_select;
- }
- public function databaseConnectionProcess($objDatabaseConnect) {
- $objDatabaseConnect->databaseConnection($objDatabaseConnect);
- $objDatabaseConnect->databaseConnectionSelect($objDatabaseConnect);
- }
- public function databaseConnectionMain($objDatabaseConnect) {
- $objDatabaseConnect->databaseConnectionProcess($objDatabaseConnect);
- }}
- $objDatabaseConnect = new DatabaseConnectClass();
- $objDatabaseConnect->database_hostname = $database_hostname;
- $objDatabaseConnect->database_username = $database_username;
- $objDatabaseConnect->database_password = $database_password;
- $objDatabaseConnect->database_name = $database_name;
- $objDatabaseConnect->databaseConnectionMain($objDatabaseConnect);
- }
- <?php
- function item() {
- $username="root";
- $password="";
- $database="test";
- $host="localhost";
- $itemid = $_GET['id'];
- $t = "items";
- mysql_connect($host,$username,$password);
- @mysql_select_db($database) or die( "Unable to select database");
- $sql = mysql_query("SELECT * FROM items WHERE id=$itemid") or die(mysql_error());
- echo "<h1> Item view </h1>";
- while($row = mysql_fetch_array($sql))
- {
- echo "<h1>" . $row['title'] . "</h1>";
- echo "<p>" . $row['location'] . "</p>";
- }
- mysql_close();
- }
- ?>
- <?php
- item();
- ?>
Add Comment
Please, Sign In to add comment