PHP -> MySQL Connection script

Hello! =D

Create a file, and rename it to: configuration.php
Insert this and edit:

<?php
class connection {
	private $config = array("host" => "localhost", "user" => "root", "pass" => "WRITE YOUR PASS HERE", "link" => NULL, "db" => "WRITE YOUR DB NAME HERE");

	function connect(){
        $this->config["link"] = mysql_connect($this->config["host"],$this->config["user"],$this->config["pass"]) or
        exit (mysql_error());
        mysql_select_db($this->config["db"]) or exit (mysql_error());
    }

	function disconnect(){
        mysql_close($this->config["link"]) or exit (mysql_error());
    }
	
	function query($querystring) {
		$this->num_queries++;
		$this->queryid = mysql_query($querystring,$this->config["link"]);
		$this->row   = 0;
		if (!$this->queryid) {
			die("ERROR: ".$querystring);
		}
		return $this->queryid;
	}
		
	function fetch_array($queryid=-1,$querystring="") {

		if ( isset($this->queryid) ) {
			$this->record = mysql_fetch_array($this->queryid);
		} else {
			if ( !empty($querystring) ) {
				die("Invalid query (".$this->queryid.") on: $querystring");
			} else {
				die("Invalid query ID ".$this->queryid."");
			}
		}
		return $this->record;
	}
}
?>

PHP:

Before, create a file called something and insert:

<?php include ("configuration.php"); ?>
<?php

 $userid = $_GET['userid'];
 
$connection = new connection();
$connection->connect(); 
$showdata = mysql_query( "SELECT * FROM user WHERE id='$userid'" );
 if($showdata) {
	while ($list = mysql_fetch_array($showdata)){
	echo "<table width=100% border=0 align=center>
 <tr>
  <td colspan=4 align=center><strong>$list[name] $list[lastname] INFO</strong></td>
 </tr>
 <tr><td class=add>Name</td><td>$list[name]</td></tr>
 <tr><td class=add>Lastname</td><td>$list[lastname]</td></tr>
 </table>";
	}
}
else if(!$showdata)
	$connection->disconnect();
echo "Not found!";

?>

PHP:

Now go to localhost/YOURFILENAME.php?userid=HERE A ID

 

Any issue? Reply this =)

 

what you exactly want to know?

 

I think they were demonstrating this?

 

and? what's the question?

 

It is a easy connection script to other peoples...

 

Yes! I an demonstrating that script

 

You mean remote connection?