Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class Mysql {
- private $dbuser;
- private $dblocation;
- private $dbpassword;
- private $dbname;
- private $link;
- private $result=array();
- function __construct($dbname)
- {
- $settings=parse_ini_file("setting.ini",true);
- $this->dbuser=$settings["dbconf"]["users"];
- $this->dblocation=$settings["dbconf"]["location"];
- $this->dbpassword=$settings["dbconf"]["password"];
- $this->dbname=$dbname;
- $this->link=mysql_connect("127.0.0.1","root","root") or die("Mesql connection error".mysql_erroe());
- mysql_select_db($this->dbname,$this->link) or die("Could not connection ty mysql database".mysql_error());
- //$this->result=$this->request($query);
- }
- public function request($query)
- { $query=$this->toStr($query);
- $res=mysql_query($query) or die("Query failed : " . mysql_error());
- $result_arr=array();
- $p=&$result_arr;
- while ($line=mysql_fetch_array($res,MYSQL_NUM))
- {
- foreach ($line as $result )
- {
- $p[]=$result;
- }
- }
- return $result_arr;
- }
- private function toStr($val)
- {
- $str=mysql_real_escape_string($val);
- return $str;
- }
- public function close()
- {
- mysql_close($this->link);
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement